· beginner
Excel Foundations
Make a spreadsheet calculate for you. Formulas and references, the dollar signs that decide what happens when you fill down, summarising with conditions, and looking a value up in another table.
Written in house, from the work rather than from a syllabus. Every example is one we would use ourselves, and every exercise is checked against the same engine that grades your answer.
What you’ll learn
- Write a formula that refers to cells rather than to typed-in numbers
- Decide when a reference needs a dollar sign, and what breaks without one
- Summarise a column with SUM, AVERAGE, COUNT and their relatives
- Total or count only the rows that meet a condition
- Pull a value out of another table with VLOOKUP, INDEX MATCH or XLOOKUP
- Read an error value and know which mistake produced it
Before you start
- · No spreadsheet experience needed
- · Able to find your way around a grid of rows and columns