Free online assessment

Assess your Microsoft Excel — office knowledge skills for free

45 random questions from 100 to assess knowledge and recommend a tailored learning plan. Independent knowledge assessment to guide personal preparation. No official exam or credential is provided. May help identify topics to review during personal preparation for Microsoft Office Specialist Excel (MOS), without replicating or replacing its exam.

This assessment measures knowledge and produces a practical diagnostic. Recommended modules are learning suggestions, not paid courses.

What is assessed

Questions about practical workplace skills

The assessment covers various knowledge topics with beginner, intermediate and advanced questions. Your score and topic breakdown highlight areas for review.

This is not a certification, qualification or official driver exam. For driving, always follow official provincial rules and requirements.

Who can use it

office productivity and administration

  • 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.

01
Topic M01

Environment, input and workbook structure

3-hour workshop on Excel navigation and shortcuts: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Excel navigation and shortcuts.
  • Apply “Ctrl + Space” in a focused Environment, input and workbook structure exercise.
  • Use “Excel continues the series with March, April, etc” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Excel navigation and shortcuts.
  • Produce a quality-checked deliverable demonstrating Excel navigation and shortcuts.
3 h
02
Topic M02

Data entry, series and structure

3-hour workshop on Data entry, series and structure: guided practice, realistic scenarios and skills verification.

  • 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
  • Use “Merged cells inside the data” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Data entry, series and structure.
  • Produce a quality-checked deliverable demonstrating Data entry, series and structure.
3 h
03
Topic M03

References and structured tables

3-hour workshop on References and structured tables: guided practice, realistic scenarios and skills verification.

  • Diagnose common errors related to Environment, input and workbook structure
  • Complete and quality-check a practical deliverable involving Environment, input and workbook structure
  • Use “References and structured tables” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to References and structured tables.
  • Produce a quality-checked deliverable demonstrating References and structured tables.
3 h
04
Topic M04

Calculations and presentation

3-hour workshop on Calculations, percentages and basic logic: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Calculations, percentages and basic logic.
  • Apply “=B2*(1+$F$1)” in a focused Calculations and presentation exercise.
  • Use “=240*(1-15%)” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Calculations, percentages and basic logic.
  • Produce a quality-checked deliverable demonstrating Calculations, percentages and basic logic.
3 h
05
Topic M05

Absolute and mixed references

3-hour workshop on Absolute and mixed references: guided practice, realistic scenarios and skills verification.

  • Configure files, settings and resources for reliable work in Calculations and presentation
  • Apply structured, non-destructive and repeatable methods in Calculations and presentation
  • Use “Calculations and presentation” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Absolute and mixed references.
  • Produce a quality-checked deliverable demonstrating Absolute and mixed references.
3 h
06
Topic M06

Subtotals and reliable presentation

3-hour workshop on Subtotals and reliable presentation: guided practice, realistic scenarios and skills verification.

  • Diagnose common errors related to Calculations and presentation
  • Complete and quality-check a practical deliverable involving Calculations and presentation
  • Use “Subtotals and reliable presentation” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Subtotals and reliable presentation.
  • Produce a quality-checked deliverable demonstrating Subtotals and reliable presentation.
3 h
07
Topic M07

Efficient formulas

3-hour workshop on Logical tests and conditional functions: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Logical tests and conditional functions.
  • Apply “=SUM(Sales[Amount])” in a focused Efficient formulas exercise.
  • Use “=IF(C2>=60,"Pass","Fail")” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Logical tests and conditional functions.
  • Produce a quality-checked deliverable demonstrating Logical tests and conditional functions.
3 h
08
Topic M08

SUMIFS, COUNTIFS and aggregations

3-hour workshop on SUMIFS, COUNTIFS and aggregations: guided practice, realistic scenarios and skills verification.

  • Configure files, settings and resources for reliable work in Efficient formulas
  • Apply structured, non-destructive and repeatable methods in Efficient formulas
  • Use “AND(B2>=100000,C2>=20%)” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to SUMIFS, COUNTIFS and aggregations.
  • Produce a quality-checked deliverable demonstrating SUMIFS, COUNTIFS and aggregations.
3 h
09
Topic M09

Formula auditing, errors and reliability

3-hour workshop on Formula auditing, errors and reliability: guided practice, realistic scenarios and skills verification.

  • Diagnose common errors related to Efficient formulas
  • Complete and quality-check a practical deliverable involving Efficient formulas
  • Use “Formula auditing, errors and reliability” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Formula auditing, errors and reliability.
  • Produce a quality-checked deliverable demonstrating Formula auditing, errors and reliability.
3 h
10
Topic M10

Lookup and data quality

3-hour workshop on Lookup functions and matching: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Lookup functions and matching.
  • Apply “The values are identical in both selected columns” in a focused Lookup and data quality exercise.
  • Use “Data Validation with a list” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Lookup functions and matching.
  • Produce a quality-checked deliverable demonstrating Lookup functions and matching.
3 h
11
Topic M11

Data validation, types and cleaning

3-hour workshop on Data validation, types and cleaning: guided practice, realistic scenarios and skills verification.

  • 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
  • Use “TRIM” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Data validation, types and cleaning.
  • Produce a quality-checked deliverable demonstrating Data validation, types and cleaning.
3 h
12
Topic M12

Lookup quality assurance

3-hour workshop on Lookup quality assurance: guided practice, realistic scenarios and skills verification.

  • Diagnose common errors related to Lookup and data quality
  • Complete and quality-check a practical deliverable involving Lookup and data quality
  • Use “Lookup quality assurance” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Lookup quality assurance.
  • Produce a quality-checked deliverable demonstrating Lookup quality assurance.
3 h
13
Topic M13

Analysis and communication

3-hour workshop on Pivot tables and summaries: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Pivot tables and summaries.
  • Apply “The source uses a fixed range that does not include the new rows” in a focused Analysis and communication exercise.
  • Use “At least some amounts are probably stored as text or contain non-numeric values” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Pivot tables and summaries.
  • Produce a quality-checked deliverable demonstrating Pivot tables and summaries.
3 h
14
Topic M14

Charts and interactive slicers

3-hour workshop on Charts and interactive slicers: guided practice, realistic scenarios and skills verification.

  • Configure files, settings and resources for reliable work in Analysis and communication
  • Apply structured, non-destructive and repeatable methods in Analysis and communication
  • Use “A line chart” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Charts and interactive slicers.
  • Produce a quality-checked deliverable demonstrating Charts and interactive slicers.
3 h
15
Topic M15

Refresh and communicating results

3-hour workshop on Refresh and communicating results: guided practice, realistic scenarios and skills verification.

  • Diagnose common errors related to Analysis and communication
  • Complete and quality-check a practical deliverable involving Analysis and communication
  • Use “Refresh the data before distribution” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Refresh and communicating results.
  • Produce a quality-checked deliverable demonstrating Refresh and communicating results.
3 h
16
Topic M16

Power Query and consolidation

3-hour workshop on Power Query connections and transformations: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Power Query connections and transformations.
  • Apply “Append Queries” in a focused Power Query and consolidation exercise.
  • Use “Confirm that both columns have the same data type and logical format” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Power Query connections and transformations.
  • Produce a quality-checked deliverable demonstrating Power Query connections and transformations.
3 h
17
Topic M17

Source consolidation and reliability

3-hour workshop on Source consolidation and reliability: guided practice, realistic scenarios and skills verification.

  • Apply structured, non-destructive and repeatable methods in Power Query and consolidation
  • Diagnose common errors related to Power Query and consolidation
  • Use “Connect to the folder with Power Query and apply a sample transformation” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Source consolidation and reliability.
  • Produce a quality-checked deliverable demonstrating Source consolidation and reliability.
3 h
18
Topic M18

Advanced models and automation

3-hour workshop on Dynamic arrays and modern functions: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Dynamic arrays and modern functions.
  • Apply “=FILTER(Sales,Sales[Region]="East","No results")” in a focused Advanced models and automation exercise.
  • Use “=SORT(UNIQUE(Employees[Department]))” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Dynamic arrays and modern functions.
  • Produce a quality-checked deliverable demonstrating Dynamic arrays and modern functions.
3 h
19
Topic M19

Calculation optimization and traceability

3-hour workshop on Calculation optimization and traceability: guided practice, realistic scenarios and skills verification.

  • 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
  • Use “Avoid whole-column references in heavy array calculations” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Calculation optimization and traceability.
  • Produce a quality-checked deliverable demonstrating Calculation optimization and traceability.
3 h
20
Topic M20

LET, LAMBDA functions and automation

3-hour workshop on LET, LAMBDA functions and automation: guided practice, realistic scenarios and skills verification.

  • Diagnose common errors related to Advanced models and automation
  • Complete and quality-check a practical deliverable involving Advanced models and automation
  • Use “Define a named LAMBDA function” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to LET, LAMBDA functions and automation.
  • Produce a quality-checked deliverable demonstrating LET, LAMBDA functions 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 — office knowledge skills?

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

Take the free test