Microsoft Excel Pro V3 (New Version)

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.

Skills you'll learn

Create and manage Excel workbooks: Build spreadsheets, organize worksheets, import data, customize workbook settings, and prepare files for collaboration and sharing.
Work confidently with formulas and functions: Use formulas, AutoFill, logical functions, named ranges, text functions, and advanced lookup functions to calculate, organize, and transform data.
Analyze and visualize data: Create charts, tables, and conditional formatting rules that help you identify trends, communicate insights, and support decision-making.
Organize and validate data effectively: Apply formatting, data validation, sorting, filtering, Flash Fill and advanced conditional formatting techniques to improve data quality and usability.
Use advanced Excel tools: Build 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 labs: Practice 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 objectives: Practice skills aligned to Microsoft Office Specialist Excel Associate and Excel Expert certification objectives through domain practice labs and practice exams.

Stay informed

Advance with confidence

Get updates, insights, and exclusive offers to support your learning journey and career growth.

Course details

Duration: Approximately 32 hours of learning content.
Focus areas: Workbook management, data entry, formulas, functions, charts, tables, data analysis, conditional formatting, PivotTables, PivotCharts, macros, and collaboration features.
Skill-building resources: Videos, guided labs, practice labs, applied labs, Excel local labs, MOS practice exams, and competency assessments.
Recommended experience: No prior experience is required; designed for learners who want to build foundational and advanced Microsoft Excel skills.
Competency assessments: Includes competency assessments that validate Microsoft Excel skills and can lead to a CompTIA Competency Certificate (CompCert)
Certification preparation: Includes 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.

*Reference to any specific product, service, process, or method by trade name, trademark, manufacturer, or otherwise on this website is for educational purposes only and does not constitute an implied or expressed recommendation or endorsement by said third party.