Office Skills
Advanced Excel
Master formulas, pivot tables, VBA macros and data analysis.
2 Months
Intermediate
Offline + Hybrid
4.8 Rating
About This Course
Advanced formulas, lookup functions, pivot tables, dashboards, Power Query, and an introduction to VBA macros. Real-world business data projects.
Course Modules & Syllabus
1
Advanced Formulas
2 Weeks
LOOKUP, INDEX-MATCH, array formulas.
2
Pivot Tables
2 Weeks
Data analysis, slicers, dashboards.
3
Power Query
2 Weeks
Data cleaning and transformation.
4
Intro to VBA
2 Weeks
Macros and basic automation.
You May Also Like
Related Courses
More courses from the Office Skills category.
Ready to Enroll in Advanced Excel?
Talk to our counselors today and take the first step towards a brighter IT career.