Opening Hours: 10:00am - 4:00pm

img

Advanced MS Excel

An Advanced Microsoft Excel course is designed to take users beyond the basics and into more complex functions, formulas, and tools that will allow them to manage data more effectively, analyze trends, automate tasks, and present insights with more sophistication. Below is a detailed outline of an Advanced MS Excel course content.

Course Details

Here’s a detailed course outline for Advanced Microsoft Excel, designed to take users beyond basic functionality and into more advanced features for data analysis, automation, and visualization. This course is ideal for professionals looking to master Excel and improve their productivity in handling large datasets, financial analysis, and reporting.

Detailed Course Curriculum

  • 1. Advance Number Formatting
  • 2. Advannce Conditional Formatting
  • 3. Match & Index
  • 4. Financial Functions
  • 5. Array Formulas
  • 6. PowerPivot
  • 7. PowerMap
  • 8. Power Query
  • 9. Dashboard
  • 10. Macro
  • 11. G-Suite
  • 12. Project Work