How every course works
Simple, practical and at a steady pace.3 weeks
One session a week for three weeks, so you can practise between classes.
3 hours a session
Nine hours of teaching in total, with breaks.
Bring your own device
Learn on the device you use every day.
Hands-on teaching
Taught by a teacher with 20 years in adult education.
Which course is right for me?
Pick the line that sounds like you.Not sure? Send us a message and we will help you choose.
Tech Savvy
Foundation computing and phone skillsA friendly start with your computer and your phone. You learn by doing, at a steady pace, with a teacher beside you.
Who it is for: People who feel unsure with computers or smartphones, and anyone who wants to feel safer and more confident online.
What to bring: Your laptop or tablet and your smartphone (Android or iPhone). Bring chargers and any passwords you can remember.
Week 1: Your computer
3 hours
- Mouse, keyboard and touchpad
- Windows, apps and the desktop
- Files and folders: save it, find it
- Connecting to Wi-Fi and printing
Week 2: Your phone
3 hours
- Touch, settings and apps
- Camera, photos and backing them up
- Messages, email and video calls
- Sending a photo or a document
Week 3: Online and safe
3 hours
- Searching the web and bookmarking
- Passwords and two-step login
- Spotting common scams
- Online banking, shopping and government services such as myGov
By the end you can
- Use your computer and phone with confidence
- Save, find and share your files and photos
- Make a video call and send an email with an attachment
- Spot a common scam and keep your accounts safer
Excel foundation
Your first spreadsheetsLearn what Excel is for and build simple spreadsheets from scratch. No experience needed.
Who it is for: People who have never used Excel, or who have only opened other people's spreadsheets.
What to bring: A laptop with Excel installed (Excel 2016 or newer, Windows or Mac). Phones and tablets are not suitable.
Week 1: Getting started
3 hours
- The Excel screen and how it works
- Cells, rows, columns and worksheets
- Entering, editing and selecting data
- Saving and opening workbooks
Week 2: Formulas and formatting
3 hours
- Formatting text, numbers, dates and currency
- SUM, AVERAGE, MIN and MAX
- Copying formulas with the fill handle
- Simple cell references
Week 3: Present your work
3 hours
- Sorting and filtering a list
- Making a simple chart
- Print settings and page layout
- Build a budget or roster in class
By the end you can
- Build and format a simple spreadsheet
- Write basic formulas that add up your data
- Sort and filter a list to find what you need
- Make a chart and print it properly
Excel intermediate
Work faster and smarterMove from basic sheets to tools that save hours: logic, lookups, tables and PivotTables.
Who it is for: People who finished Excel foundation or can already write simple formulas, and want to do more with their data.
What to bring: A laptop with Excel 2021 or Microsoft 365. Older versions may not have the XLOOKUP function. Phones and tablets are not suitable.
Week 1: Smarter formulas
3 hours
- Relative and absolute cell references
- IF, COUNTIF and SUMIF
- Useful text and date functions
- Names for cells and ranges
Week 2: Tables and lookups
3 hours
- Excel tables, sorting and filtering
- XLOOKUP and VLOOKUP
- Drop-down lists with data validation
- Conditional formatting
Week 3: Summarise your data
3 hours
- PivotTables and PivotCharts
- Slicers and timelines
- Protecting your sheets
- Build a tracker in class
By the end you can
- Use logic and lookups to pull the right data
- Set up clean tables with drop-down lists
- Summarise large lists in a PivotTable
- Protect and share a workbook with confidence
Excel advanced
Automate and analyseClean up messy data, build dashboards and automate repeat jobs. Taught by someone who builds complex spreadsheets for a living.
Who it is for: Confident Excel users, including those who finished Excel intermediate, who want to analyse data and cut repeat work.
What to bring: A laptop with Microsoft 365 or Excel 2021. Windows is best for Power Query. Phones and tablets are not suitable.
Week 1: Advanced formulas
3 hours
- IFS, IFERROR and nested logic
- INDEX and MATCH
- FILTER, SORT and UNIQUE
- Checking and fixing formulas
Week 2: Get and clean data
3 hours
- Power Query: import and combine data
- Cleaning messy data without retyping
- PivotTables with calculated fields
- Grouping and summarising
Week 3: Dashboards and automation
3 hours
- Dashboards and advanced charts
- What-if tools: Goal Seek and scenarios
- Record and edit simple macros
- A final project using sample data
By the end you can
- Write advanced formulas and fix errors fast
- Import and clean data with Power Query
- Build a simple dashboard for your business
- Record a macro to automate a repeat job
Questions
Short answers to common questions.Which course should I start with?
Use the "Which course is right for me?" section above. If you are not sure, call or send a message and we will point you to the right one.
Can I skip Excel foundation?
Yes, if you can already write simple formulas, sort and filter data and make a chart. If not, start with foundation so the later courses make sense.
Which version of Excel do I need?
Foundation works on Excel 2016 or newer. Intermediate and advanced need Excel 2021 or Microsoft 365. Windows is best for the advanced course.
Do I need to bring my own device?
Yes. Every course is bring your own device. Excel courses need a laptop. Tech Savvy needs your phone and a laptop or tablet.
Can you train my staff?
Yes. We can run staff training at your workplace or build an online course for your team. Make a booking and tell us what your staff need.
How do I sign up?
Use the Sign up button on a course. It opens the booking form with your course already chosen. Bookings are Tuesday and Friday, 8:30 am to 4:30 pm.