Administrative & Office Skills · BEGINNER
Spreadsheet Essentials for Office Work
Build tidy tables, keep labels and units clear and check basic spreadsheet results against the source.
What you’ll be able to do
- Create a table with one record per row and consistent column headings.
- Use basic formulas and check calculations against small manual examples.
- Sort and filter complete records without separating related fields.
- Choose a simple summary and chart that match the question being asked.
- Prepare a readable, appropriately shared copy with clear version information.
Your course, step by step
- Build a reliable data table
- Calculate and check totals
- Sort, filter and protect record relationships
- Summarise and chart responsibly
- Share a checked spreadsheet
How completion works
Pass the practice question in every lesson first, then pass four assessment sets in order. Each set has 10 distinct questions and requires at least 80% (8 out of 10). All four must be passed; a high score in one cannot compensate for another. It is open-book and must be your own work. This automated assessment checks course understanding; it does not independently verify identity or workplace competence.
Each set attempt has its own 15-minute window. Starting an attempt counts even if you abandon it. Wait 15 minutes from the start before a retake; after every third attempt of the same set wait 24 hours. Passed sets stay saved. A live attempt can be resumed. Retakes and learning remain free.
About this course
A spreadsheet becomes more reliable when the table’s meaning is clear before calculations begin. This course introduces practical organisation of rows, columns, labels and basic results for everyday office tasks. You will practise keeping units consistent and checking whether a displayed total answers the intended question.
A formula does not automatically make a sheet accurate. The inputs, range and definition of a value still matter. Fictional practice lets you explore mistakes without exposing real customer, learner or financial records. Use a small manual check to understand a result and investigate a discrepancy rather than change a number only to make it look right. This is introductory spreadsheet practice, not an audited accounting system or a guarantee that every future workbook is correct.
Who this course is for
Adults beginning everyday spreadsheet work with lists, quantities and simple summaries.
A practical example
Create a fictional materials table with item, unit, requested quantity and supplied quantity. Keep packs separate from individual items unless you explicitly convert them using a stated pack size. A total of ten packs is not the same as ten individual units.
Check one row manually and compare it with the spreadsheet result. If a summary is wrong, inspect the source values and included range. Add a note where an input is missing rather than treating an empty cell as a verified zero. Explain what the final total does and does not represent.
Try your own fictional version, then enrol to work through the lessons, practice and assessments. Use this unmarked example to explore the skill before working through the course activities.
Continue building the skill
- Data Entry and Record Quality · Optional certificate R99
- Workplace Number Skills · Optional certificate R49