Pavryn Pavryn Ask for a demonstration

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

  1. Find the right place and start safely
  2. Enter useful data and keep its meaning
  3. Build and read a small calculation
  4. Organise whole records with tables, sorts and filters
  5. 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.

See Pavryn Learn for yourself

A demonstration takes you through a learner’s course and the officer’s reports.