Free online assessment

Assess your Microsoft Excel — advanced analysis skills for free

Free 45-question assessment drawn from a 100-question bank, followed by personalized training recommendations. Knowledge assessment tool, not affiliated with certifying bodies. Does not replace any required training or official qualification. May help identify topics to review during personal preparation for Microsoft Office Specialist Excel Expert, 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

advanced Excel 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.

01
Topic M01

Multidimensional lookups

3-hour applied workshop covering multidimensional lookups: diagnostic, guided practice and skill checks.

  • Identify the role of “XLOOKUP” in a workplace scenario.
  • Identify the role of “XMATCH” in a workplace scenario.
  • Identify the role of “INDEX and MATCH” in a workplace scenario.
  • Apply the practice used to look up a value and return a nonadjacent column.
  • Verify and justify the choice of “XMATCH” to return the relative position of a lookup item.
3 h
02
Topic M02

Dynamic arrays

3-hour applied workshop covering dynamic arrays: diagnostic, guided practice and skill checks.

  • Identify the role of “FILTER” in a workplace scenario.
  • Identify the role of “UNIQUE” in a workplace scenario.
  • Identify the role of “SORT” in a workplace scenario.
  • Apply the practice used to dynamically return rows matching a criterion.
  • Verify and justify the choice of “UNIQUE” to extract a list of values without duplicates.
3 h
03
Topic M03

Named formulas

3-hour applied workshop covering named formulas: diagnostic, guided practice and skill checks.

  • Identify the role of “LET” in a workplace scenario.
  • Identify the role of “LAMBDA” in a workplace scenario.
  • Identify the role of “Name Manager” in a workplace scenario.
  • Apply the practice used to name intermediate values in a complex formula.
  • Verify and justify the choice of “LAMBDA” to create a reusable function without a VBA macro.
3 h
04
Topic M04

References and reliable models

3-hour applied workshop covering references and reliable models: diagnostic, guided practice and skill checks.

  • Identify the role of “Structured reference” in a workplace scenario.
  • Identify the role of “Mixed reference” in a workplace scenario.
  • Identify the role of “Dynamic range” in a workplace scenario.
  • Apply the practice used to reference a table column by its name.
  • Verify and justify the choice of “Mixed reference” to lock only the row or column during copying.
3 h
05
Topic M05

Conditional aggregations

3-hour applied workshop covering conditional aggregations: diagnostic, guided practice and skill checks.

  • Identify the role of “SUMIFS” in a workplace scenario.
  • Identify the role of “COUNTIFS” in a workplace scenario.
  • Identify the role of “AVERAGEIFS” in a workplace scenario.
  • Apply the practice used to sum values meeting multiple conditions.
  • Verify and justify the choice of “COUNTIFS” to count rows meeting multiple criteria.
3 h
06
Topic M06

Error handling

3-hour applied workshop covering error handling: diagnostic, guided practice and skill checks.

  • Identify the role of “IFERROR” in a workplace scenario.
  • Identify the role of “ISNA” in a workplace scenario.
  • Identify the role of “Evaluate Formula” in a workplace scenario.
  • Apply the practice used to return a fallback value when a formula fails.
  • Verify and justify the choice of “ISNA” to specifically test a missing-match error.
3 h
07
Topic M07

Dates and periods

3-hour applied workshop covering dates and periods: diagnostic, guided practice and skill checks.

  • Identify the role of “EOMONTH” in a workplace scenario.
  • Identify the role of “NETWORKDAYS” in a workplace scenario.
  • Identify the role of “YEARFRAC” in a workplace scenario.
  • Apply the practice used to calculate the last date of a target month.
  • Verify and justify the choice of “NETWORKDAYS” to count working days between two dates.
3 h
08
Topic M08

Text and cleansing

3-hour applied workshop covering text and cleansing: diagnostic, guided practice and skill checks.

  • Identify the role of “TRIM” in a workplace scenario.
  • Identify the role of “SUBSTITUTE” in a workplace scenario.
  • Identify the role of “TEXTJOIN” in a workplace scenario.
  • Apply the practice used to remove excess spaces from text.
  • Verify and justify the choice of “SUBSTITUTE” to replace a specific fragment in a string.
3 h
09
Topic M09

Input quality control

3-hour applied workshop covering input quality control: diagnostic, guided practice and skill checks.

  • Identify the role of “Data validation” in a workplace scenario.
  • Identify the role of “Drop-down list” in a workplace scenario.
  • Identify the role of “Custom error alert” in a workplace scenario.
  • Apply the practice used to restrict entered values using a rule.
  • Verify and justify the choice of “Drop-down list” to provide a controlled selection of values.
3 h
10
Topic M10

PivotTables

3-hour applied workshop covering pivottables: diagnostic, guided practice and skill checks.

  • Identify the role of “Calculated field” in a workplace scenario.
  • Identify the role of “Slicer” in a workplace scenario.
  • Identify the role of “Timeline” in a workplace scenario.
  • Apply the practice used to create a calculation in a classic PivotTable.
  • Verify and justify the choice of “Slicer” to visually filter PivotTable items.
3 h
11
Topic M11

Power Pivot modeling

3-hour applied workshop covering power pivot modeling: diagnostic, guided practice and skill checks.

  • Identify the role of “Data Model” in a workplace scenario.
  • Identify the role of “Table relationship” in a workplace scenario.
  • Identify the role of “DAX measure” in a workplace scenario.
  • Apply the practice used to connect multiple tables for combined analysis.
  • Verify and justify the choice of “Table relationship” to associate rows across tables using keys.
3 h
12
Topic M12

Advanced Power Query

3-hour applied workshop covering advanced power query: diagnostic, guided practice and skill checks.

  • Identify the role of “Merge queries” in a workplace scenario.
  • Identify the role of “Append queries” in a workplace scenario.
  • Identify the role of “Applied step” in a workplace scenario.
  • Apply the practice used to join two tables using key columns.
  • Verify and justify the choice of “Append queries” to stack rows from compatible sources.
3 h
13
Topic M13

Power Query M language

3-hour applied workshop covering power query m language: diagnostic, guided practice and skill checks.

  • Identify the role of “Table.TransformColumns” in a workplace scenario.
  • Identify the role of “Table.Group” in a workplace scenario.
  • Identify the role of “Power Query parameter” in a workplace scenario.
  • Apply the practice used to apply a transformation to selected columns.
  • Verify and justify the choice of “Table.Group” to aggregate rows by keys in Power Query.
3 h
14
Topic M14

What-if analysis

3-hour applied workshop covering what-if analysis: diagnostic, guided practice and skill checks.

  • Identify the role of “Goal Seek” in a workplace scenario.
  • Identify the role of “Data Table” in a workplace scenario.
  • Identify the role of “Solver” in a workplace scenario.
  • Apply the practice used to find the input needed to reach a target result.
  • Verify and justify the choice of “Data Table” to compare results automatically across several assumptions.
3 h
15
Topic M15

Financial modeling

3-hour applied workshop covering financial modeling: diagnostic, guided practice and skill checks.

  • Identify the role of “NPV” in a workplace scenario.
  • Identify the role of “IRR” in a workplace scenario.
  • Identify the role of “PMT” in a workplace scenario.
  • Apply the practice used to discount a series of financial cash flows using a rate.
  • Verify and justify the choice of “IRR” to calculate internal return for periodic cash flows.
3 h
16
Topic M16

Dashboards

3-hour applied workshop covering dashboards: diagnostic, guided practice and skill checks.

  • Identify the role of “KPI” in a workplace scenario.
  • Identify the role of “Combo chart” in a workplace scenario.
  • Identify the role of “Conditional formatting” in a workplace scenario.
  • Apply the practice used to present a metric tied to a business target.
  • Verify and justify the choice of “Combo chart” to compare series with different meanings or scales.
3 h
17
Topic M17

Model protection

3-hour applied workshop covering model protection: diagnostic, guided practice and skill checks.

  • Identify the role of “Sheet protection” in a workplace scenario.
  • Identify the role of “Cell locking” in a workplace scenario.
  • Identify the role of “Version control” in a workplace scenario.
  • Apply the practice used to restrict editing of cells on a worksheet.
  • Verify and justify the choice of “Cell locking” to separate editable inputs from protected formulas.
3 h
18
Topic M18

Calculation auditing

3-hour applied workshop covering calculation auditing: diagnostic, guided practice and skill checks.

  • Identify the role of “Trace precedents” in a workplace scenario.
  • Identify the role of “Trace dependents” in a workplace scenario.
  • Identify the role of “Consistency check” in a workplace scenario.
  • Apply the practice used to show cells referenced by a formula.
  • Verify and justify the choice of “Trace dependents” to identify formulas using a selected cell.
3 h
19
Topic M19

Office automation

3-hour applied workshop covering office automation: diagnostic, guided practice and skill checks.

  • Identify the role of “Macro recorder” in a workplace scenario.
  • Identify the role of “Office Scripts” in a workplace scenario.
  • Identify the role of “Run button” in a workplace scenario.
  • Apply the practice used to record repetitive actions as a macro.
  • Verify and justify the choice of “Office Scripts” to automate supported Excel operations with scripts.
3 h
20
Topic M20

Model delivery

3-hour applied workshop covering model delivery: diagnostic, guided practice and skill checks.

  • Identify the role of “User guide” in a workplace scenario.
  • Identify the role of “Regression test” in a workplace scenario.
  • Identify the role of “Source audit” in a workplace scenario.
  • Apply the practice used to document workbook inputs and expected outputs.
  • Verify and justify the choice of “Regression test” to verify changes do not break earlier calculations.
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 — advanced analysis skills?

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

Take the free test