Excel Essentials
Start a spreadsheet safely, enter and format data, calculate and copy formulas, organise records and check your work before you hand it on.
Content last checked on 21 October 2026. Some of its sources were checked again on 19 November 2026.
About this course
- Who it is for
- Staff and managers who enter or check small spreadsheets for the council.
- How long it takes
- About 62 minutes if you read the lessons, or 64 if you listen to them, including the final assessment. An estimate from the course’s length, not yet timed with learners.
The lessons
- Find the right place and start safely
- Enter useful data and keep its meaning
- Build and read a small calculation
- Organise whole records with tables, sorts and filters
- Check the result and control the hand-off
What you will be able to do
- Find the right sheet and cell in a workbook, and check you have the right file before changing anything.
- Work in a copy when told to, so the original file stays as it was.
- Set out records one to a row, with each detail in its own column.
- Enter reference numbers, amounts and dates so Excel keeps their meaning, including leading zeros and dates that cannot be misread.
- Write a simple formula or SUM total that uses the right cells and the complete range.
- Know how a formula changes when copied, and how to keep it pointing at one cell, such as a shared rate.
- Sort and filter a whole table so that each record’s details stay together.
- Understand that a filter only hides rows, so a total may still include records you cannot see.
- Check a result against the source records and the range it uses before anyone relies on it.
- Correct a wrong result openly, or ask for review, rather than overwriting the total to hide it.
- Check who can see and change a workbook before sharing it; filters and protection do not keep anything confidential.
- Report a mistake promptly, and agree any restore with the file’s owner and the other people editing it.
The law and guidance it rests on
The sources the course’s content was checked against, each with what it asks of a council and a link to the official text.
UK General Data Protection Regulation (UK GDPR)
Personal information in a spreadsheet must be accurate, limited to what is needed and kept secure.
Microsoft Support: basic tasks in Excel
Microsoft’s own instructions for creating, entering and saving a workbook.
See Pavryn Learn for yourself
A demonstration takes you through a learner’s course and the officer’s reports.