CompTIA course

CompTIA Microsoft Excel Pro

Build practical spreadsheet and data analysis skills.Microsoft Excel Pro helps you build practical spreadsheet and data analysis skills while preparing for CompTIA competency assessments and Microsoft Office Specialist (MOS) Excel certification objectives. Choose V3 (New Version) for updated content, enhanced learning activities, local labs, and the latest learning experience, or opt for V2 (Retiring Version), available until July 30, 2027.

Version: V3

Target roleCareer builder

Choose your

exam

Microsoft Excel Pro is currently available in two versions: V3, the new version, and V2, the retiring version, available until July 30, 2027. Select a version to see its skills, details and objectives.

CompTIA Microsoft Excel Pro is a comprehensive training course that helps you build practical spreadsheet and data analysis skills through multimedia instruction, hands-on labs, local labs, and real-world projects. You'll learn how to create and manage workbooks, work with formulas and functions, analyze and visualize data, and use advanced Excel features such as PivotTables, PivotCharts, XLOOKUP, and macros. The course also helps prepare you for Microsoft Office Specialist (MOS) Excel certification objectives and validates your skills through CompTIA competency assessments.

Building your

foundational knowledge

What you'll learn in the Microsoft Excel Pro V3 (New Version) course.

Create and manage Excel workbooksBuild spreadsheets, organize worksheets, import data, customize workbook settings, and prepare files for collaboration and sharing.

Work confidently with formulas and functionsUse formulas, AutoFill, logical functions, named ranges, text functions, and advanced lookup functions to calculate, organize, and transform data.

Analyze and visualize dataCreate charts, tables, and conditional formatting rules that help you identify trends, communicate insights, and support decision-making.

Organize and validate data effectivelyApply formatting, data validation, sorting, filtering, Flash Fill and advanced conditional formatting techniques to improve data quality and usability.

Use advanced Excel toolsBuild skills with XLOOKUP, INDEX, MATCH, PivotTables, PivotCharts, what-if analysis, financial calculations, and basic macros to automate tasks and analyze larger datasets.

Apply skills through simulations and local labsPractice Microsoft Excel skills through simulated labs, guided labs, real-world scenarios, and local labs. Local labs allow you to complete assignments in Microsoft Excel and upload your work for grading.

Prepare for MOS Excel certification objectivesPractice skills aligned to Microsoft Office Specialist Excel Associate and Excel Expert certification objectives through domain practice labs and practice exams.

Course

details

Everything included in the Microsoft Excel Pro V3 (New Version) course.

DurationApproximately 32 hours of learning content

Focus areasWorkbook management, data entry, formulas, functions, charts, tables, data analysis, conditional formatting, PivotTables, PivotCharts, macros, and collaboration features

Skill-building resourcesVideos, guided labs, practice labs, applied labs, Excel local labs, MOS practice exams, and competency assessments

Recommended experienceNo prior experience is required; designed for learners who want to build foundational and advanced Microsoft Excel skills

CompCert assessmentIncludes competency assessments that validate Microsoft Excel skills and can lead to a CompTIA Competency Certificate (CompCert)

Certification preparationIncludes content aligned to Microsoft Office Specialist Excel Associate (MO-210/MO-200) and Excel Expert (MO-211/MO-201) certification objectives, along with practice labs and practice exams

Start CompTIA Microsoft Excel Pro at NEXERA Institute

Our advisors help you choose the right preparation, book your exam session and get certified with confidence.