MS Excel Level-II is an intermediate level course. It builds on your foundational skills and takes you into the world of professional data analysis, automation, and reporting. This level focuses on mastering powerful tools like advanced formulas, PivotTables, Power Query, and dashboards to help you work smarter, faster, and more effectively.
You will learn how to:
- Apply advanced formulas and logical functions for complex analysis
- Clean, transform, and combine data using Power Query
- Create insightful reports with basic and advanced PivotTables
- Visualize trends with interactive charts and conditional formatting
- Build dynamic dashboards that tell clear data stories
By completing MS Excel Level-II, you will be able to handle large datasets, automate repetitive tasks, and deliver professional reports and dashboards. These skills are highly valued in business, finance, sales, and analytics roles, and will give you a competitive advantage in both jobs and freelancing.
Curriculum
- 5 Sections
- 8 Lessons
- 8 Weeks
- Data ManagementUnder this section students will learn data management. Students will work on date-time data, text data and numeric data.2
- Data Visualization2
- Pivot Tables2
- Power Query1
- Dashboard Development1