Skip to content
Attain Skills College
Data ManagementFoundation levelPathway step 2 of 5

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

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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.