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.
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.
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
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.