Skip to main content

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.

11425 Pro MicrosoftExcel CompCert

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.