Free online assessment

Assess your Microsoft Excel skills for free

45-question technical assessment to measure real Microsoft Excel skills.

This assessment measures knowledge and produces a practical diagnostic. Modules are recommended after the test; they are not an offer of paid courses.

Start for free How does the test work?

What is assessed

Questions about practical workplace skills

The test covers different areas of the software, including beginner, intermediate and advanced questions. The score and skill-area breakdown help reveal strengths and topics to revisit.

This is not an official certification and should not be the sole factor in an employment decision.

Who can use it

data analyst

Employees and applicants.
HR professionals.
Employers, managers and team leads.

Assessment learning framework

Modules that may appear in your recommended plan

The topics below form the recommendation framework associated with this assessment. The system selects priorities using individual answers and proposes a plan to use independently with a provider of your choice. We do not deliver these courses through this website.

Topic M1

Environment, input and workbook structure

Identify the main tools and concepts used in Environment, input and workbook structure • Choose an appropriate workflow for a task involving Environment, input and workbook structure • Configure files, settings and resources for reliable work in Environment, input and workbook structure

Identify the main tools and concepts used in Environment, input and workbook structure
Choose an appropriate workflow for a task involving Environment, input and workbook structure
Configure files, settings and resources for reliable work in Environment, input and workbook structure
Apply structured, non-destructive and repeatable methods in Environment, input and workbook structure
Diagnose common errors related to Environment, input and workbook structure

3 h

Topic M2

Calculations and presentation

Identify the main tools and concepts used in Calculations and presentation • Choose an appropriate workflow for a task involving Calculations and presentation • Configure files, settings and resources for reliable work in Calculations and presentation

Identify the main tools and concepts used in Calculations and presentation
Choose an appropriate workflow for a task involving Calculations and presentation
Configure files, settings and resources for reliable work in Calculations and presentation
Apply structured, non-destructive and repeatable methods in Calculations and presentation
Diagnose common errors related to Calculations and presentation

3 h

Topic M3

Efficient formulas

Identify the main tools and concepts used in Efficient formulas • Choose an appropriate workflow for a task involving Efficient formulas • Configure files, settings and resources for reliable work in Efficient formulas

Identify the main tools and concepts used in Efficient formulas
Choose an appropriate workflow for a task involving Efficient formulas
Configure files, settings and resources for reliable work in Efficient formulas
Apply structured, non-destructive and repeatable methods in Efficient formulas
Diagnose common errors related to Efficient formulas

3 h

Topic M4

Lookup and data quality

Identify the main tools and concepts used in Lookup and data quality • Choose an appropriate workflow for a task involving Lookup and data quality • Configure files, settings and resources for reliable work in Lookup and data quality

Identify the main tools and concepts used in Lookup and data quality
Choose an appropriate workflow for a task involving Lookup and data quality
Configure files, settings and resources for reliable work in Lookup and data quality
Apply structured, non-destructive and repeatable methods in Lookup and data quality
Diagnose common errors related to Lookup and data quality

3 h

Topic M5

Analysis and communication

Identify the main tools and concepts used in Analysis and communication • Choose an appropriate workflow for a task involving Analysis and communication • Configure files, settings and resources for reliable work in Analysis and communication

Identify the main tools and concepts used in Analysis and communication
Choose an appropriate workflow for a task involving Analysis and communication
Configure files, settings and resources for reliable work in Analysis and communication
Apply structured, non-destructive and repeatable methods in Analysis and communication
Diagnose common errors related to Analysis and communication

3 h

Topic M6

Power Query and consolidation

Identify the main tools and concepts used in Power Query and consolidation • Choose an appropriate workflow for a task involving Power Query and consolidation • Configure files, settings and resources for reliable work in Power Query and consolidation

Identify the main tools and concepts used in Power Query and consolidation
Choose an appropriate workflow for a task involving Power Query and consolidation
Configure files, settings and resources for reliable work in Power Query and consolidation
Apply structured, non-destructive and repeatable methods in Power Query and consolidation
Diagnose common errors related to Power Query and consolidation

3 h

Topic M7

Advanced models and automation

Identify the main tools and concepts used in Advanced models and automation • Choose an appropriate workflow for a task involving Advanced models and automation • Configure files, settings and resources for reliable work in Advanced models and automation

Identify the main tools and concepts used in Advanced models and automation
Choose an appropriate workflow for a task involving Advanced models and automation
Configure files, settings and resources for reliable work in Advanced models and automation
Apply structured, non-destructive and repeatable methods in Advanced models and automation
Diagnose common errors related to Advanced models and automation

3 h

Assessment output

Actionable insight, not a sales pitch

The report provides an overall score, category breakdown and recommended modules. Use it to inform development discussions, document progress or complement candidate assessment.

View business use cases →

Privacy and recipients

The participant provides their email and that of the manager or authorized report recipient. The tool emails the report to those recipients according to its current process. Do not enter a third party without permission.

Review privacy information

Free assessment

Ready to assess your Microsoft Excel skills?

45 questions and a suggested development plan. No course enrollment.

Take the free test