DataCareerHubLearn · Practice · Progress
Explore learning
DataCareerHub
Explore learning
← Revision deskFree companion · 15 minute suggested activity

Excel: formulas and controls

A short retrieval session. Try the questions before revealing the explanations; revisit them after a few days and again in a later week.

Learn → Try → ExplainReviewed 2026-10-15
01

Recall without looking

When does COUNTIFS count orders? Why refresh a PivotTable? Why can an average of rates mislead?

Check and explain

COUNTIFS counts rows, so the source must have unique order grain. Refresh and range checks prevent stale outputs. Aggregate numerators/denominators for a population rate.

03

Transfer task

Rebuild SUMIFS and an inventory reconciliation without looking. Compare them against case controls, then introduce one duplicated row in a copy.

04

Record your next review

Write which concept you missed and one new example. Revisit after 2–3 days, then about a week; adjust the interval to your needs. This is a suggested study routine, not an automated reminder or saved score.

Make the reasoning yours.

Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.

Resume guidance and examples are for learning and preparation only. They do not guarantee interviews, a job offer or employment.

Public registration, payments and new paid enrolment remain disabled. These free resources do not grant access to protected course modules.

Learner dashboard ↗ · Ask a question ↗