Ruled

Module 4

Spreadsheets

Workbooks and cell references, formulas and functions including IF and VLOOKUP, and the chart, sort, filter and pivot tools.

3 topics · 23 solved problems

Module contents
  1. 01

    Workbooks, cells and references

    The structure of a workbook, entering and editing data, autofill, number formats, and the relative, absolute and mixed references that make a formula copy correctly.

    3 worked · 5 practice
  2. 02

    Formulas and functions

    Operators and precedence, the built-in function families, IF and nested IF, COUNTIF and SUMIF, VLOOKUP, and the error values and what each one means.

    4 worked · 6 practice
  3. 03

    Charts, sorting and data tools

    Choosing and building the right chart, sorting and filtering a list, conditional formatting, data validation, and pivot tables.

    2 worked · 5 practice

Syllabus coverage

  • Workbook, worksheet, cell, range and cell address
  • Entering and editing data; autofill; number formats
  • Relative, absolute and mixed references
  • Operators and order of precedence
  • Functions — statistical, mathematical, text, date, logical
  • IF and nested IF; COUNTIF, SUMIF, VLOOKUP
  • Error values
  • Charts — types, parts and creation
  • Sorting, filtering, conditional formatting, data validation, pivot tables