Spreadsheet & Data Skills for the Workplace
Build clean, reliable spreadsheets in Microsoft Excel, from structuring data properly to formulas, lookups, PivotTables and simple charts.
- Duration
- 2 days (12 hours) or 4 × 3-hour live online sessions
- Delivery
- Live online (virtual classroom), Face-to-face in Toowoomba, In-house at your workplace
- Assessment
- Knowledge checks and a practical activity
- Outcome
- Certificate of Completion (non-accredited)
- Fee
- Contact us for pricing
Course overview
Spreadsheets are where most workplace data lives, and where most data problems start. Merged cells, hard-coded totals, five versions of the same file: small habits create big errors.
This hands-on course teaches you to build spreadsheets the way data professionals do. You will learn to structure data so it can be sorted, filtered and analysed, use the formulas that matter most, and summarise information quickly with PivotTables and charts.
Every exercise uses realistic workplace data such as rosters, client lists, incident registers and budgets, so the skills transfer directly to your role.
Who it's for
- Administration and office staff who use Excel regularly
- Coordinators who maintain rosters, registers or trackers
- Team leaders who prepare monthly reports
- Anyone who has taught themselves Excel and wants to fill the gaps
Entry requirements
- Basic familiarity with opening, saving and typing into a spreadsheet
- Access to Microsoft Excel (Microsoft 365 recommended) for online learners
- Face-to-face learners: laptops can be provided on request
What you'll learn
- Structure data as a proper table that can be sorted, filtered and analysed
- Use data validation and drop-down lists to prevent entry errors
- Write and troubleshoot common formulas including IF, SUMIFS, COUNTIFS and XLOOKUP
- Clean messy data using text functions, Flash Fill and remove-duplicates tools
- Summarise data with PivotTables and PivotCharts
- Apply conditional formatting to highlight exceptions and trends
- Protect sheets and share workbooks safely
Course modules
Module 1: Structuring data the right way
The rules that make a spreadsheet usable as a data source.
- One row per record, one column per field
- Excel Tables and structured references
- Avoiding merged cells, blank rows and hard-coded values
- Data validation and drop-down lists
Module 2: Essential formulas
The formulas that do most of the work in everyday spreadsheets.
- Relative and absolute references
- IF, IFS and logical tests
- SUMIFS, COUNTIFS and AVERAGEIFS
- XLOOKUP and an introduction to dynamic arrays
Module 3: Cleaning and preparing data
Turn exported or inherited data into something you can trust.
- TRIM, PROPER, TEXTSPLIT and text functions
- Flash Fill and Text to Columns
- Finding and removing duplicates
- Working with dates and times
Module 4: Summarising and presenting
Answer questions about your data in minutes, not hours.
- Sorting, filtering and slicers
- Building and refreshing PivotTables
- Choosing the right chart
- Conditional formatting for exceptions
Module 5: Sharing and protecting workbooks
Collaborate without breaking anything.
- Co-authoring in OneDrive and SharePoint
- Sheet and workbook protection
- Version history and recovery
- Handling personal information in spreadsheets
Assessment and certificate
Practical exercises completed in Excel throughout the course, plus a short final build task. Participants who attend all sessions and complete the exercises receive a Certificate of Completion.
Frameworks referenced
- Microsoft Excel (Microsoft 365)
- Spreadsheet data-quality good practice
Course content refers to these publicly available frameworks for educational purposes. Attain Skills College is not affiliated with or endorsed by the bodies responsible for them.
Frequently asked questions
Which version of Excel do I need?
Microsoft 365 is recommended because some newer functions such as XLOOKUP and TEXTSPLIT are not available in older versions. We will show alternatives where needed.
Does this course cover macros or VBA?
No. The course focuses on data structure, formulas and analysis. Automation is beyond the scope of this course.
Is this course nationally recognised?
No. This is a non-accredited course. You will receive an Attain Skills College Certificate of Completion.
Related courses
- Data Management2 days (12 hours)
Data Management Fundamentals
Understand how good data is created, stored, maintained and used, and why it matters to every role in a modern organisation.
- Data Management2 days (12 hours)
Reporting & Dashboards for Care Organisations
Turn operational data into clear reports and dashboards that help managers and boards make better decisions, using Excel and an introduction to Microsoft Power BI.
- Data Management2 days (12 hours)
Data & Records Management for NDIS and Care Providers
Set up and maintain the participant records, registers and evidence that NDIS and care providers rely on for quality, safety and audit readiness.