Assessment 1
- Format
- Self-paced
CompTIA
Credential
Competency Certificate (CompCert)
Level
Competency Certificate (CompCert)
credential overview
About this credential
Comprehensive Microsoft Excel training covering workbook management, formulas and functions, data analysis and visualization, data validation, PivotTables, PivotCharts, XLOOKUP, what-if analysis, and basic macros.
Who this is for
Learners seeking foundational and advanced Microsoft Excel skills and preparation for MOS Excel Associate and Expert objectives.
Assessment
Exam details
Exam blueprint
Skills measured
Skills learned7 topics
- Create and manage Excel workbooks and worksheets.
- Use formulas, AutoFill, logical functions, named ranges, text functions, and advanced lookup functions.
- Create charts, tables, and conditional formatting to analyze and visualize data.
- Apply data validation, sorting, filtering, Flash Fill, and advanced conditional formatting.
- Use XLOOKUP, INDEX, MATCH, PivotTables, PivotCharts, what-if analysis, financial calculations, and basic macros.
- Apply skills through simulations and local Excel labs.
- Prepare for MOS Excel Associate and Expert certification objectives.
Before you certify
Requirements and recommended experience
None required
No prior experience required
Corporate certification enablement
Turn this pathway into a team capability plan
We can align the learning path, instructor support, practice environment and delivery schedule to your team’s roles and certification target.