V2
Microsoft Excel Pro
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.
Stay informed
Advance with confidence
Get updates, insights, and exclusive offers to support your learning journey and career growth.
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
Course objectives
Manage worksheets and workbooks
- Import data into workbooks from external sources.
- Navigate, format, and customize worksheets and workbooks.
- Manage workbook options, properties, and versions.
Manage data cells and ranges
- Insert, format, and organize data in cells and ranges.
- Summarize data using conditional formatting and filters.
- Validate and restrict data entry in cells.
Manage tables and table data
- Create and format tables to organize data.
- Sort and filter table data efficiently.
- Use structured references to calculate and analyze table data.
Perform operations with formulas and functions
- Use basic and advanced formulas to perform calculations.
- Apply functions like VLOOKUP, HLOOKUP, and IF to analyze data.
- Troubleshoot and audit formulas for accuracy.
Create charts and objects
- Create and format charts to visualize data trends.
- Insert and format objects like images, shapes, and SmartArt.
- Use sparklines and data bars to enhance data visualization.