← Back to courses
LEARNING TOPIC

Excel for the Workplace

Turn everyday spreadsheet work into clear, useful decisions.

6 topics Beginner to intermediate Online
LEARNING OUTCOME

Create accurate worksheets, dashboards and simple reports.

Free starter lessons
YOUR FREE STARTER LESSON

What you will explore

A clear introduction to the ideas covered in this subject, with a free lesson to get you started.

01Excel fundamentalsTOPIC
02Formulas and functionsTOPIC
03Sorting and filteringTOPIC
04Charts and visual reportsTOPIC
05Lookup functionsTOPIC
06PivotTables and practiceTOPIC
START HERE — FREE LESSON

Keep formulas transparent

A spreadsheet formula begins with an equals sign. A simple total such as =SUM(B2:B10) adds values in a range. Keep raw data separate from calculated totals so errors are easier to find.

CHECK YOUR UNDERSTANDING

Which formula adds cells B2 through B10?