Excel Essentials for Everyday Work

About this course

Spreadsheets are used across nearly every role, and a solid foundation saves hours of manual work. This course covers navigation, formulas, formatting and checking so you can build tidy, reliable workbooks from scratch. You'll finish with a workbook you built yourself and can reuse.

What you will be able to do

• You'll be able to navigate workbooks and use keyboard shortcuts efficiently
• You'll be able to write formulas for totals, averages and conditional results
• You'll be able to format data so it is clear and consistent
• You'll be able to sort, filter and check data for common errors

Course outline

1. Tools you'll need

   9 min · Lesson notes, example, action task · 2-question quiz

   You can learn most everyday Excel skills with the software you already have, and free alternatives cover most needs.
2. Navigating Workbooks Efficiently

   9 min · Lesson notes, example, action task · 2-question quiz

   Speed in a spreadsheet comes from knowing how to move around and select quickly. Keyboard shortcuts save more time than you'd think.
3. Formulas and Cell References

   9 min · Lesson notes, example, action task · 2-question quiz

   Formulas turn raw data into answers. Understanding relative and absolute references is the key to copying formulas safely.
4. Formatting for Clarity

   9 min · Lesson notes, example, action task · 2-question quiz

   Clear formatting helps readers understand a sheet quickly. Use consistent, purposeful formatting and avoid decoration that distracts.
5. Sorting and Filtering

   8 min · Lesson notes, example, action task · 2-question quiz

   Sorting and filtering let you find and organise data quickly. Always check that your selection includes the full table before you apply them.
6. Checking Data for Errors

   8 min · Lesson notes, example, action task · 2-question quiz

   Errors in spreadsheets can be costly. A simple checking routine catches most problems before they reach a report or a decision.
7. Careers & next steps

   8 min · Lesson notes, example, action task · 2-question quiz

   Confident spreadsheet skills are useful across administration, finance, operations and analysis. These are common job titles that rely on them.
8. Final quiz and certificate

   10 questions, pass mark 8 of 10. Pass to get your Reesby Academy certificate with a verification link.