Module 1: Advanced Formulas and Functions

• Nested Formulas and Functions
• Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
• Array Formulas and Advanced IF Statements

Module 2: Data Validation and Validation Rules

• Setting up Data Validation
• Creating Custom Validation Rules
• Using Data Validation for Data Entry

Module 3: Advanced Data Analysis with PivotTables

• Creating PivotTables from Complex Datasets
• Grouping and Filtering Data in PivotTables
• Calculated Fields and Items in PivotTables

Module 4: Power Query and Data Cleaning

• Introduction to Power Query
• Importing and Transforming Data with Power Query
• Cleaning and Shaping Data for Analysis

Module 5: Power Pivot and Data Modeling

• Building Data Models with Power Pivot
• Creating Relationships between Tables
• Measures and Calculated Columns

Module 6: Advanced Charting Techniques

• Creating Dynamic Charts
• Using Sparklines for Data Visualization
• Combo Charts and Trendlines

Module 7: Excel Macros and VBA (Visual Basic for Applications)

• Introduction to Excel Macros
• Recording and Editing Macros
• Writing Basic VBA Code for Automation

Module 8: Advanced Conditional Formatting

• Custom Rules and Formulas for Conditional Formatting
• Data Bars, Color Scales, and Icon Sets
• Using Conditional Formatting for Data Analysis

Module 9: Excel Dashboards and Data Visualization

• Designing Interactive Dashboards
• Incorporating Slicers for Dashboard Interactivity
• Dynamic Charts and Graphs in Dashboards

Module 10: Excel Power Map and 3D Mapping

• Visualizing Geographical Data with Power Map
• Creating 3D Maps in Excel
• Customizing and Analyzing Maps

Module 11: Financial and Statistical Functions

• Advanced Financial Functions (IRR, NPV, PMT)
• Statistical Functions (AVERAGEIF, COUNTIF, etc.)
• Using Data Analysis ToolPak

Module 12: Excel Scenario Manager and Solver

• Creating and Managing Scenarios
• Using Solver for Optimization Problems
• Goal Seek and What-If Analysis

Module 13: Excel Tips and Productivity Hacks

• Keyboard Shortcuts and Time-Saving Techniques
• Excel Productivity Add-Ins
• Tips for Efficient Data Entry and Navigation

Module 14: Collaborative Excel Workbooks

• Sharing and Protecting Workbooks
• Tracking Changes and Comments
• Co-authoring and Version Control

Module 15: Excel Project: Real-world Application

• Applying Advanced Excel Techniques to Solve a Practical Problem
• Collaborative Project Development
• Project Presentation and Showcase

Module 16: Career Development with Advanced Excel Skills

• Building a Portfolio of Excel Projects
• Job Search Strategies for Excel Professionals
• Continuous Learning and Professional Development