Module 1: Excel Basics Refresher (3–4 Hours)
- Overview of Excel Interface & Ribbon
- Creating, Saving, and Opening Workbooks
- Entering & Editing Data
- Cell References (Relative, Absolute, Mixed)
- Formatting Cells, Rows, Columns
- Basic Formulas (SUM, AVERAGE, COUNT, MIN, MAX)
Module 2: Advanced Formulas & Functions (6–8 Hours)
- Text Functions: LEFT, RIGHT, MID, CONCATENATE, TRIM
- Date & Time Functions: TODAY, NOW, DATE, DATEDIF
- Logical Functions: IF, AND, OR, NOT
- Lookup & Reference: VLOOKUP, HLOOKUP, INDEX, MATCH
- Error Handling Functions: IFERROR, ISERROR
- Nested Formulas & Formula Auditing
Module 3: Data Analysis Tools (6–8 Hours)
- Sorting & Filtering Data
- Conditional Formatting (Rules & Custom Formulas)
- Data Validation & Drop-down Lists
- What-If Analysis: Goal Seek, Data Tables, Scenario Manager
- Removing Duplicates & Data Cleaning Techniques
Module 4: Charts & Visualization (4–5 Hours)
- Creating Column, Line, Pie, Bar, Area Charts
- Combo Charts & Secondary Axis
- Sparklines
- Conditional Charts
- Chart Formatting & Customization
Module 5: Pivot Tables & Pivot Charts (6–7 Hours)
- Introduction to Pivot Tables
- Grouping, Sorting, and Filtering in Pivot Tables
- Calculated Fields & Items
- Creating Pivot Charts
- Slicers & Timeline Filters
- Advanced Pivot Table Techniques
Module 6: Advanced Data Tools (5–6 Hours)
- Power Query Basics
- Importing & Transforming Data
- Consolidating Data from Multiple Sheets
- Using Tables & Structured References
- Introduction to Macros & VBA Basics
Module 7: Excel Dashboards & Reporting (5–6 Hours)
- Designing Professional Dashboards
- Interactive Elements: Slicers, Timelines, Drop-downs
- KPI Representation & Visualization
- Linking Charts, Tables & Pivot Tables
- Tips for Dynamic & Automated Reports
Module 8: Practical Assignments & Projects (4–5 Hours)
- Real-time Data Analysis Projects
- Dashboard Creation from Sample Data
- Automation using Formulas & Simple Macros
- Case Studies for Business Scenarios