Free online assessment

Assess your Advanced Excel — Data and DAX skills for free

Bilingual Advanced Excel — Data and DAX assessment: 45 randomized questions from a bank of 100, three skill levels and 20 gap-based training modules.

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

digital solutions professional

  • 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

Excel structured tables

3-hour applied workshop to build expandable tables for analysis, including workplace practice and a skills check.

  • Identify scenarios that require the team to build expandable tables for analysis.
  • Prepare the assets and settings for “Excel structured tables”.
  • Complete a hands-on task to build expandable tables for analysis.
  • Diagnose and correct a mistake involving “Excel structured tables”.
  • Quality-check and document the results produced with “Excel structured tables”.
3 h
02
Topic M02

Structured references

3-hour applied workshop to write formulas robust to new rows, including workplace practice and a skills check.

  • Identify scenarios that require the team to write formulas robust to new rows.
  • Prepare the assets and settings for “Structured references”.
  • Complete a hands-on task to write formulas robust to new rows.
  • Diagnose and correct a mistake involving “Structured references”.
  • Quality-check and document the results produced with “Structured references”.
3 h
03
Topic M03

XLOOKUP

3-hour applied workshop to connect tables using shared identifiers, including workplace practice and a skills check.

  • Identify scenarios that require the team to connect tables using shared identifiers.
  • Prepare the assets and settings for “XLOOKUP”.
  • Complete a hands-on task to connect tables using shared identifiers.
  • Diagnose and correct a mistake involving “XLOOKUP”.
  • Quality-check and document the results produced with “XLOOKUP”.
3 h
04
Topic M04

Dynamic array functions

3-hour applied workshop to produce spill results with dynamic arrays, including workplace practice and a skills check.

  • Identify scenarios that require the team to produce spill results with dynamic arrays.
  • Prepare the assets and settings for “Dynamic array functions”.
  • Complete a hands-on task to produce spill results with dynamic arrays.
  • Diagnose and correct a mistake involving “Dynamic array functions”.
  • Quality-check and document the results produced with “Dynamic array functions”.
3 h
05
Topic M05

Data validation

3-hour applied workshop to control the values entered by users, including workplace practice and a skills check.

  • Identify scenarios that require the team to control the values entered by users.
  • Prepare the assets and settings for “Data validation”.
  • Complete a hands-on task to control the values entered by users.
  • Diagnose and correct a mistake involving “Data validation”.
  • Quality-check and document the results produced with “Data validation”.
3 h
06
Topic M06

Power Query import

3-hour applied workshop to normalize data without changing source files, including workplace practice and a skills check.

  • Identify scenarios that require the team to normalize data without changing source files.
  • Prepare the assets and settings for “Power Query import”.
  • Complete a hands-on task to normalize data without changing source files.
  • Diagnose and correct a mistake involving “Power Query import”.
  • Quality-check and document the results produced with “Power Query import”.
3 h
07
Topic M07

Merge and append queries

3-hour applied workshop to combine tables through joins or stacking, including workplace practice and a skills check.

  • Identify scenarios that require the team to combine tables through joins or stacking.
  • Prepare the assets and settings for “Merge and append queries”.
  • Complete a hands-on task to combine tables through joins or stacking.
  • Diagnose and correct a mistake involving “Merge and append queries”.
  • Quality-check and document the results produced with “Merge and append queries”.
3 h
08
Topic M08

Data cleaning and typing

3-hour applied workshop to prevent errors caused by inconsistent types, including workplace practice and a skills check.

  • Identify scenarios that require the team to prevent errors caused by inconsistent types.
  • Prepare the assets and settings for “Data cleaning and typing”.
  • Complete a hands-on task to prevent errors caused by inconsistent types.
  • Diagnose and correct a mistake involving “Data cleaning and typing”.
  • Quality-check and document the results produced with “Data cleaning and typing”.
3 h
09
Topic M09

Parameterized queries

3-hour applied workshop to make imports reusable across files, including workplace practice and a skills check.

  • Identify scenarios that require the team to make imports reusable across files.
  • Prepare the assets and settings for “Parameterized queries”.
  • Complete a hands-on task to make imports reusable across files.
  • Diagnose and correct a mistake involving “Parameterized queries”.
  • Quality-check and document the results produced with “Parameterized queries”.
3 h
10
Topic M10

Data refresh

3-hour applied workshop to refresh data through a repeatable process, including workplace practice and a skills check.

  • Identify scenarios that require the team to refresh data through a repeatable process.
  • Prepare the assets and settings for “Data refresh”.
  • Complete a hands-on task to refresh data through a repeatable process.
  • Diagnose and correct a mistake involving “Data refresh”.
  • Quality-check and document the results produced with “Data refresh”.
3 h
11
Topic M11

Excel data model

3-hour applied workshop to relate multiple tables without excessive lookups, including workplace practice and a skills check.

  • Identify scenarios that require the team to relate multiple tables without excessive lookups.
  • Prepare the assets and settings for “Excel data model”.
  • Complete a hands-on task to relate multiple tables without excessive lookups.
  • Diagnose and correct a mistake involving “Excel data model”.
  • Quality-check and document the results produced with “Excel data model”.
3 h
12
Topic M12

Fact and dimension tables

3-hour applied workshop to design an analytic model with reliable keys, including workplace practice and a skills check.

  • Identify scenarios that require the team to design an analytic model with reliable keys.
  • Prepare the assets and settings for “Fact and dimension tables”.
  • Complete a hands-on task to design an analytic model with reliable keys.
  • Diagnose and correct a mistake involving “Fact and dimension tables”.
  • Quality-check and document the results produced with “Fact and dimension tables”.
3 h
13
Topic M13

DAX measures

3-hour applied workshop to calculate dynamic measures under filters, including workplace practice and a skills check.

  • Identify scenarios that require the team to calculate dynamic measures under filters.
  • Prepare the assets and settings for “DAX measures”.
  • Complete a hands-on task to calculate dynamic measures under filters.
  • Diagnose and correct a mistake involving “DAX measures”.
  • Quality-check and document the results produced with “DAX measures”.
3 h
14
Topic M14

CALCULATE and filters

3-hour applied workshop to modify the evaluation context of results, including workplace practice and a skills check.

  • Identify scenarios that require the team to modify the evaluation context of results.
  • Prepare the assets and settings for “CALCULATE and filters”.
  • Complete a hands-on task to modify the evaluation context of results.
  • Diagnose and correct a mistake involving “CALCULATE and filters”.
  • Quality-check and document the results produced with “CALCULATE and filters”.
3 h
15
Topic M15

DAX iterators

3-hour applied workshop to evaluate expressions across the rows of a table, including workplace practice and a skills check.

  • Identify scenarios that require the team to evaluate expressions across the rows of a table.
  • Prepare the assets and settings for “DAX iterators”.
  • Complete a hands-on task to evaluate expressions across the rows of a table.
  • Diagnose and correct a mistake involving “DAX iterators”.
  • Quality-check and document the results produced with “DAX iterators”.
3 h
16
Topic M16

Date table

3-hour applied workshop to support consistent time-based comparisons, including workplace practice and a skills check.

  • Identify scenarios that require the team to support consistent time-based comparisons.
  • Prepare the assets and settings for “Date table”.
  • Complete a hands-on task to support consistent time-based comparisons.
  • Diagnose and correct a mistake involving “Date table”.
  • Quality-check and document the results produced with “Date table”.
3 h
17
Topic M17

PivotTable reporting

3-hour applied workshop to summarize measures across multiple dimensions, including workplace practice and a skills check.

  • Identify scenarios that require the team to summarize measures across multiple dimensions.
  • Prepare the assets and settings for “PivotTable reporting”.
  • Complete a hands-on task to summarize measures across multiple dimensions.
  • Diagnose and correct a mistake involving “PivotTable reporting”.
  • Quality-check and document the results produced with “PivotTable reporting”.
3 h
18
Topic M18

Calculation optimization

3-hour applied workshop to reduce needless work in large tables, including workplace practice and a skills check.

  • Identify scenarios that require the team to reduce needless work in large tables.
  • Prepare the assets and settings for “Calculation optimization”.
  • Complete a hands-on task to reduce needless work in large tables.
  • Diagnose and correct a mistake involving “Calculation optimization”.
  • Quality-check and document the results produced with “Calculation optimization”.
3 h
19
Topic M19

Reconciliation and controls

3-hour applied workshop to reconcile reported metrics with source records, including workplace practice and a skills check.

  • Identify scenarios that require the team to reconcile reported metrics with source records.
  • Prepare the assets and settings for “Reconciliation and controls”.
  • Complete a hands-on task to reconcile reported metrics with source records.
  • Diagnose and correct a mistake involving “Reconciliation and controls”.
  • Quality-check and document the results produced with “Reconciliation and controls”.
3 h
20
Topic M20

Delivery and documentation

3-hour applied workshop to document assumptions and automate updates, including workplace practice and a skills check.

  • Identify scenarios that require the team to document assumptions and automate updates.
  • Prepare the assets and settings for “Delivery and documentation”.
  • Complete a hands-on task to document assumptions and automate updates.
  • Diagnose and correct a mistake involving “Delivery and documentation”.
  • Quality-check and document the results produced with “Delivery and documentation”.
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 Advanced Excel — Data and DAX skills?

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

Take the free test