Skip to main content
Metricwise

Metricwise Academy · Excel

An interactive Excel course for beginners.

Get comfortable with spreadsheets, formulas, and the shortcuts that make everyday work easier.

  • Beginner friendly
  • 13 modules
  • 83 lessons
  • Practice in your browser
Start learning for freeView curriculum

Three preview lessons, no account needed. Starter includes free modules after sign-in; Pro, Team, and Enterprise include the full course. Compare access.

Lesson preview Your first worksheet

In B2, enter a formula that adds 2 and 3.

B2fx=2+3
ABCD
1
25
3

The cell displays 5; the formula bar retains =2+3.

What you will learn

Make a worksheet feel familiar before you tackle a complicated report. This course starts with entering information, selecting cells, and moving around a sheet, then builds toward formulas and useful summaries.

  • Navigate a worksheet and select the cells you need.
  • Build formulas, copy them safely, and format results.
  • Summarize records and apply conditions to business questions.
  • Clean text so labels and identifiers are easier to work with.

Before you begin

No spreadsheet experience is required. The preview uses an interactive worksheet in your browser, so you can start without opening Excel. A keyboard is helpful for practicing the navigation lessons.

Put it into practice

Use these skills when organizing a budget, checking a sales table, cleaning a list of records, or preparing a summary for a colleague. Reliable cell selection and formulas make those everyday tasks easier to repeat.

Inside the free preview

In the preview, work inside a worksheet, meet common shortcut keys, and practice moving with the keyboard. The exercises give you a concrete action to complete, so you can connect the instruction to the result on screen.

Your learning path

The first three lessons are open to everyone. Sign in for Starter modules; full course access is included with Pro, Team, and Enterprise.

01Get comfortable in Excel10 lessons

Navigate a sheet, enter information, and select the exact cells you need.

  1. Your first worksheetFree preview
  2. Meet your shortcut keysFree preview
  3. Move with the keyboardFree preview
  4. Select a small rangeSign in
  5. Select a data blockSign in
  6. Select rows and columnsSign in
  7. Select separate areasSign in
  8. Work around gapsSign in
  9. Selection checkpointSign in
  10. Organise worksheetsSign in
02Build reliable formulas6 lessons

Calculate totals, copy formulas safely, and format results.

  1. Formula essentialsSign in
  2. Add with SUMSign in
  3. Let AutoSum suggest a rangeSign in
  4. Relative and absolute referencesSign in
  5. Fill formulas down and rightSign in
  6. Use shortcuts on real dataSign in
03Count and summarise9 lessons

Turn a column of observations into useful descriptive numbers.

  1. Count numeric entriesSign in
  2. Count filled and blank cellsSign in
  3. Find an averageSign in
  4. Find extremes and ranked valuesSign in
  5. Practise rankingSign in
  6. Find the middle with MEDIANSign in
  7. Find the most frequent valueSign in
  8. Round to a multipleSign in
  9. Round to odd or even integersSign in
04Apply business rules8 lessons

Test conditions and turn them into clear, auditable decisions.

  1. Work with TRUE and FALSESign in
  2. Choose an output with IFSign in
  3. Combine tests with AND, OR, and XORSign in
  4. Check data types with IS functionsSign in
  5. Choose among several rules with IFSSign in
  6. Map labels with SWITCHSign in
  7. Combine IF with other functionsSign in
  8. Handle errors deliberatelySign in
05Summarise matching records12 lessons

Use criteria to calculate totals and counts for specific groups.

  1. Count a matching group with COUNTIFSign in
  2. Count several conditions with COUNTIFSSign in
  3. Meet SUMIFSign in
  4. Match text with wildcardsSign in
  5. Sum one column based on anotherSign in
  6. Use several criteria with SUMIFSSign in
  7. SUM family checkpointSign in
  8. Practise SUMIFSign in
  9. Practise SUMIFSSign in
  10. Debug a conditional totalSign in
  11. Practise conditional countsSign in
  12. Counting checkpointSign in
06Clean and reshape text11 lessons

Turn messy labels and identifiers into consistent, usable fields.

  1. Clean ordinary extra spaces with TRIMSign in
  2. Measure and extract textSign in
  3. Extract from the middle with MIDSign in
  4. Practise text extractionSign in
  5. Find a case-sensitive positionSign in
  6. Search without case sensitivitySign in
  7. Combine text with CONCATSign in
  8. Join lists with TEXTJOINSign in
  9. Standardise letter caseSign in
  10. Replace text with SUBSTITUTESign in
  11. Split around a delimiterSign in
07Look up related information16 lessons

Retrieve values with modern lookups and understand formulas in older workbooks.

  1. Look up a value with XLOOKUPSign in
  2. Look in either directionSign in
  3. Use wildcards in XLOOKUPSign in
  4. Read and write VLOOKUPSign in
  5. Copy VLOOKUP safelySign in
  6. Practise VLOOKUPSign in
  7. Diagnose a lookup failureSign in
  8. Use approximate VLOOKUP for bandsSign in
  9. Look across with HLOOKUPSign in
  10. Reuse a horizontal lookupSign in
  11. Find a position with MATCHSign in
  12. Return a position with INDEXSign in
  13. Combine INDEX and MATCHSign in
  14. Practise INDEX and MATCHSign in
  15. Practise MATCH boundariesSign in
  16. Lookup checkpointSign in
08Work with dates5 lessons

Calculate elapsed days and complete periods using genuine date values.

  1. Build a date with DATESign in
  2. Use TODAY without losing reproducibilitySign in
  3. Calculate elapsed daysSign in
  4. Calculate complete years with DATEDIFSign in
  5. Date skills checkpointSign in
09Turn raw rows into reports1 lessons

Structure data, filter safely, summarise with PivotTables, and present a clear result.

  1. Create an Excel TableSign in
10Use dynamic arrays2 lessons

Return expanding lists and record subsets with modern Excel functions.

  1. Create a distinct list with UNIQUESign in
  2. Return matching rows with FILTERSign in
11Project: property operations1 lessons

Build an auditable property summary from source records.

  1. Project: property operationsSign in
12Project: hospital administration1 lessons

Summarise service activity while keeping the denominator and scope explicit.

  1. Project: hospital administrationSign in
13Project: sales performance report1 lessons

Build a paid-sales report with linked formulas, reconciled totals, and a clearly scoped region chart.

  1. Project: sales performance reportSign in

Questions, answered

Excel course questions

Do I need Microsoft Excel installed?
No installation is needed for the browser preview. Practice takes place in the embedded worksheet. The course focuses on spreadsheet concepts and Excel-style workflows you can apply to your own work.
Does the course begin with formulas?
It begins with worksheet basics and keyboard navigation. The curriculum then moves to reliable formulas, summaries, conditions, and text cleanup. Open the modules below to see the learning path.
How do I continue after the preview?
Sign in from the lesson gate to carry your preview progress into the app on the same browser and device. Your local draft stays available while you complete sign-in. Starter includes free Academy modules; Pro, Team, and Enterprise include full Academy access.
Can I return to a lesson?
Yes. Use the curriculum to revisit a preview lesson and practice again. Progress is kept in your browser when local storage is available; clearing site data can remove that local copy.

Start with one lesson

A little practice goes a long way.

Open your first worksheet and try the exercises at your own pace.

Start learning for free

Keep building your skills

SQL course

Read databases, write queries, and find the answers hidden in your tables.

Business intelligence course

Learn to model data, define useful metrics, and design charts people can understand.

Typing course

Build accuracy and confidence at the keyboard with focused, hands-on practice.

Ready to present your data? Create a chart online.