Short Course Description
A professional program designed for advanced Excel users. Students learn financial functions, pivot tables, data modeling, Power Query, data analysis, dashboards, and basic automation using formulas and macros.
Target Audience
-Accountants & finance professionals
-Data analysts & operations staff
-MBA & BBA students
-Business owners
-Anyone who uses Excel heavily for decision-making
What Students Will Learn
-Lookup functions (VLOOKUP, XLOOKUP, INDEX/MATCH)
-PivotTables & PivotCharts
-Advanced IF, logical + text functions
-Power Query for data cleaning
-Creating professional business dashboards
-What-if analysis, sensitivity analysis
-Automating tasks with macros (intro to VBA)
-Real business case studies (CRM, finance, HR)
