27.04.2026 (Monday): Advanced Excel Formulas: Complex Logical Formulas, Lookup and Reference Functions, Array Formulas, Dynamic Arrays and Statistical Functions & Hands-on exercise: Employee Performance Analyser
28.04.2026 (Tuesday): Data Analysis Tools: Sorting, Filtering and Data Validation, What-If
Analysis, Data Consolidation and Summarisation & Hands-on exercise: Strategic Sales Planning Model
29.04.2026 (Wednesday): PivotTables & Pivot Charts: Creating and Customising PivotTables, Grouping, Calculated Fields and Slicers, Pivot Charts and Interactive Reporting & Hands-on exercise: Business Intelligence Report Panel
30.04.2026 (Thursday): Visualisation & Dashboarding: Advanced Charting Techniques, Interactive Dashboards, Conditional Formatting for Visual Intelligence & Hands-on exercise: Executive KPI Dashboard
01.05.2026 (Friday): Macros & VBA Automation: Recording Macros, Editing Macros and Basic VBA Scripting, Automating Workflows and User-Defined Functions & Hands-on exercise: Automated Monthly Report Generator
02.05.2026 (Saturday): Integration & BI Applications: Integrating All Modules - End-to-End BI Workflow, Applied Business Intelligence Case Studies, Business Sales Intelligence Dashboard & Hands-on exercise: Capstone Integration Exercise