Category
IT-ITes
Course Fees
₹1000.00
Advance Microsoft Excel
Course Details
Course Modules
Advanced Formulas: XLOOKUP, INDEX/MATCH, Dynamic Arrays
Data Management: Power Query, What-If Analysis, Validation
Dynamic Dashboards: Slicers, Timelines, Advanced Charting
Power Pivot & DAX: Data Modeling, Calculated Fields, Relationships
VBA & Macros: Task Automation, Scripting, Custom Functions
Course Project and Best Practices.
Course Syllabus
- This course is designed for individuals who have a strong working knowledge of basic Excel functions and are ready to unlock the full potential of the application for data analysis, reporting, and automation. We will move beyond standard formulas and charts to explore powerful tools like advanced functions, PivotTables, Power Query, and Visual Basic for Applications (VBA).
Course Reviews
Average Rating:4.6
5 Stars24
4 Stars5
3 Stars2
2 Stars0
1 Star0
Related Courses
