Course Overview
Microsoft Excel Pro is a comprehensive training course that prepares you to master advanced Excel® skills and take the Microsoft Excel Pro competency assessment. With hands-on simulations and real-world scenarios, you’ll learn to create and manage spreadsheets, analyze data, and automate tasks in Microsoft Excel®, equipping you for roles in business, finance, and administration, as well as the Microsoft Office Specialist (MOS) Excel associate-level certifications.
Skills Learned
- Data management: Build and manage spreadsheets for organizing and analyzing data.
- Data analysis: Use formulas, functions, and pivot tables to analyze and summarize data.
- Visualization: Create charts and graphs to present data effectively.
- Automation: Automate tasks with macros and advanced formulas.
Competency Assessment Details
- Included with the course: Microsoft Excel Pro competency assessment is integrated into the course
- Launch date: December 19, 2023
- Assessment format: Performance-based tasks that simulate real-world scenarios
- Question count: Up to 5 scenario questions
- Task count: Up to 25 tasks in the assessment
- Time limit: 50 minutes
- Score range: 200 – 2000
- Passing score: 1424
- Recommended experience: No prior experience is required; this course is designed for you, whether you are a beginner or an intermediate learner