Guides to help you learn how to perform mathematical calculations on data using functions in Excel. As well as how to filter and sort data.

Links to guides that show you how to use Excel to perform simple sums on data.

Find out how to do a subtraction calculation using Microsoft Excel.

Learning how to get Microsoft Excel to work out percentages for you can save loads of time.

How to apply maths and statistical functions in Microsoft Excel

The video lesson uses example data to demonstrate Excel functions for beginners.

Filtering data in Excel

This video guide covers how to add filters to your Excel worksheet enabling you to temporarily hide data.

Sorting data in Excel

A quick start guide to sorting data in order, or by a certain criteria in Excel 2010 onwards.