Core Formulas & Functions
What you will be able to do
- Add, count and average data with SUM, COUNT and AVERAGE
- Round numbers and work with percentages
- Make decisions with IF, AND, OR and IFS
- Find and fix formula errors
- Use named ranges
21 lessons and projects · 2 free to try. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Adding and summarising
- SUMTry it free
- AutoSumTry it free
- AVERAGE and MEDIAN
- COUNT, COUNTA and COUNTBLANK
- MIN and MAX
- SUM across sheets
Module 2: Rounding and percentages
- ROUND, ROUNDUP and ROUNDDOWN
- MROUND, CEILING and FLOOR
- Percentages and % change
- ABS
Module 3: Logic
- IF
- Comparison operators
- AND and OR
- IF with AND/OR
- Nested IF and IFS
Module 4: Errors and checking
- Common errors
- IFERROR and IFNA
- Show FormulasReal Excel
- Trace Precedents/Dependents and Evaluate FormulaReal Excel
- Named ranges
Project: sales commission calculator
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free