Digital basics: 7 Essential Excel skills

Microsoft Excel allows you to create spreadsheets which will save you time and allow you to work more efficiently.

To make the most of Excel you need some basic skills, such as using formula, filters, and formatting.

This course will teach you those skills and more, starting from the very beginning and assuming you have never used Excel before.

It is ideal for people preparing budgets, cashflow forecasts, and those preparing reports such as Annual Reports or funding applications.

Why take this course?

Knowing your way around Excel will allow you to:

• Save time with calculations
• Repeat and extrapolate information
• Visualise information

What will you learn?

By the end of this course you will be able to:

• Find your way around the Excel program
• Enter and manipulate information
• Share your data with others

Notes

In this course we will assume you’re using a Windows computer. You will need Excel on your computer, so you can follow along.

Our examples are based on Excel 2016.