Module 1: Advanced Excel Fundamentals

• Review of Basic Excel Functions and Features
• Understanding Excel Data Types
• Best Practices for Data Organization and Management
• Formatting for Professional Reports

Module 2: Advanced Excel Functions and Formulas

• Logical Functions: IF, AND, OR, and Nested Functions
• Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP
• Text Functions: CONCATENATE, LEFT, RIGHT, MID, LEN, TRIM, TEXT
• Date and Time Functions: TODAY, NOW, DATE, NETWORKDAYS, EOMONTH
• Array Formulas and Dynamic Arrays
• Error Handling: IFERROR, ISERROR

Module 3: Data Analysis in Excel

• Data Sorting and Filtering Techniques
• Advanced Conditional Formatting
• Data Validation and Drop-Down Lists
• Pivot Tables and Pivot Charts
  • Customizing Fields and Filters
  • Grouping and Calculating with Pivot Tables
• Advanced Charting Techniques

Module 4: Automation with Excel Macros

• Introduction to Macros
• Recording and Running Macros
• Editing VBA Code for Custom Automation
• Automating Repetitive Tasks with Macros

Module 5: Excel Power Query

• Introduction to Power Query
• Connecting and Importing Data from Multiple Sources
• Data Transformation and Cleaning
• Merging and Appending Data
• Creating Data Models in Power Query

Module 6: Introduction to Power BI

• What is Power BI and Its Importance?
• Power BI Components: Desktop, Service, and Mobile
• Power BI vs. Excel: Key Differences

Module 7: Data Loading and Modeling in Power BI

• Importing Data from Excel, Databases, and Other Sources
• Understanding Data Types and Relationships
• Creating Calculated Columns and Measures
• Introduction to DAX (Data Analysis Expressions)
  • Basic DAX Functions for Data Manipulation

Module 8: Data Visualization in Power BI

• Creating Interactive Dashboards
• Designing and Customizing Reports
• Using Visualizations: Bar Charts, Line Charts, Pie Charts, Maps, etc.
• Slicers and Filters for Dynamic Reporting
• Formatting Tips for Professional Dashboards

Module 9: Advanced DAX and Analytics in Power BI

• Advanced DAX Functions: Time Intelligence, Iterators, and Aggregations
• Creating KPIs and Custom Metrics
• Understanding Relationships and Hierarchies in Data Models
• Optimizing DAX Queries for Performance

Module 10: Power BI Service and Sharing Reports

• Publishing Reports to Power BI Service
• Creating Workspaces and Collaborating with Teams
• Setting Up Row-Level Security (RLS)
• Scheduling Data Refreshes and Automating Updates
• Exporting and Sharing Dashboards

Module 11: Integration of Excel and Power BI

• Importing Excel Data into Power BI
• Using Power Pivot and Power Query for Combined Analysis
• Linking Power BI Reports Back to Excel

Module 12: Advanced Analytics and Power BI AI Tools

• Forecasting and Trend Analysis
• Decomposition Tree and Key Influencers Visuals
• Introduction to Power BI AI Features (Q&A and Insights)