Skip to content
Claim this template

Free course template · Global

Excel essentials for everyday work

A ready-made course, live deck and two surveys for office staff. AhaSlides tracks progress, completion and scores for you. 45 minutes, 6 lessons. Last reviewed 21 October 2026; not legal advice.

Claim the templatePreview the courseDownload SCORM for your LMS

Free. No credit card. Edit everything.

Course outline at a glance

  • An invented story
  • Name the parts
  • Flashcards
  • Sorting activity
  • Quiz

  • Clean data rules
  • Format for the reader
  • Spot the problem
  • Accordion
  • Tabs
  • Sorting activity
  • Checklist
  • Multi-select quiz
  • Matching quiz

  • Build a formula
  • Relative and fixed references
  • Predict the result
  • Process
  • Timeline
  • Flashcards
  • Quiz

  • Scenario
  • Scenario
  • Scenario
  • Scenario
  • Matching quiz

  • Sort and filter safely
  • Charts and print
  • Who to ask
  • Process
  • Checklist
  • Tabs
  • Quiz

  • Practice
  • Quiz

Try some questions from the course

Question 1 of 3

What is the cell address of the box where column C meets row 4?

 

The column letter comes first, then the row number, so this is C4.

Lesson 1, A messy monthly report: workbook layout, cells, rows and formatting, teaches this. See the outline

Question 2 of 3

A formula in D2 is =B2*C2. You copy it to D3. What does D3 hold?

 

A relative reference moves with the row, so the formula becomes =B3*C3.

Lesson 3, Formulas and cell references, teaches this. See the outline

Question 3 of 3

You find that a report you already sent holds the wrong figures. What do you do first?

 

Tell the people who received it, and correct the source, so nobody acts on wrong figures.

Lesson 5, Sorting, filtering, tables, charts and printing a report, and where to get help, teaches this. See the outline

Learners earn a certificate

Your organisation

Certificate of completion

This certifies that

Alex Morgan

has completed

Excel essentials for everyday work

Completed on12 October 2026
Sample certificate with a placeholder learner name.

Style 1 of 6: Coral geometric

Everyone who finishes gets a certificate with their name, the course title and the completion date. Add your own logo, colours and signer.

Three pieces that work together

Learners prepare on their own, you answer questions live, and the surveys tell you what stuck. 9 fields to fill in with your own policy, contacts and locations; each one is highlighted inside the course.

Claim the template
The Excel essentials for everyday work course as a learner first sees it

Completion is tracked for you

Learners sign in to take the course, so every start, finish and score is recorded in AhaSlides. No spreadsheet to keep.

  • Who has finished

    See who has not started, who is in progress and who has completed the course.

  • Every score

    Each learner's answers to the quizzes and activities in the course.

  • What landed

    Survey results show what people took away, and the 30-day check-in shows whether they use it.

Claim the template

6 lessons, about 45 minutes

What learners can do at the end of each lesson. Minutes are an estimate.

  • Lesson 1: A messy monthly report: workbook layout, cells, rows and formatting · 9 min

    Before you begin · An invented story · Name the parts

  • Lesson 2: Entering and formatting data cleanly · 9 min

    Clean data rules · Format for the reader · Spot the problem

  • Lesson 3: Formulas and cell references · 8 min

    Build a formula · Relative and fixed references · Predict the result

  • Lesson 4: Everyday functions and their traps: SUM, IF, COUNTIF and lookups · 8 min

    Scenario · Scenario · Scenario

  • Lesson 5: Sorting, filtering, tables, charts and printing a report, and where to get help · 8 min

    Sort and filter safely · Charts and print · Who to ask

  • Lesson 6: Final assessment · 3 min

    Practice

Claim the template

Common questions

Yes. The course, the live deck and both surveys are free. Claiming the template into your AhaSlides account is free too.

Yes. The course is self-paced and online, and the live deck lets you add a live session in the room or online.

At onboarding for office roles, before a reporting cycle, or as a skills refresher for a team.

Office staff, finance and operations support who use spreadsheets daily; run by L&D with finance or operations leads.

Record completion in your own LMS or record system, so you can show who finished the course and when.

Yes, everything. Change the wording, swap scenarios for ones from your workplace, add your logo, or remove parts that don't apply.

Your own details, each highlighted inside the course:
  • Office suite in use
  • Team workbook template
  • Data classification policy link
  • It helpdesk contact
  • Security incident route
  • LMS or record system
  • Course URL
Then edit anything else you like: wording, scenarios, your logo.
Visit the help centre (opens in a new tab)