Excel Courses

Learn how to use Microsoft Excel’s powerful reporting and data management features with our comprehensive courses. Our face-to-face and live online Excel training courses cater for all participants, whether they’re beginners with no experience at all, have been self-taught, or are advanced power-user users. The beginners, basic, and advanced levels of our Excel tutorials can be customised to your personal and organisational needs. All courses are hands-on, and you’ll learn lots of shortcuts and better ways to manage and report your Excel data.

Have a look at the different levels of our face-to-face and online sessions below.


If needed, scroll down to see more FACE-TO-FACE and LIVE ONLINE course dates on the right:

Microsoft Excel

June 11th, 2024

  • Basics
  • Intermediate
  • Advanced
  • LOOKUPs
  • PivotTables Essentials
  • PivotTables Advanced
  • Macros

Excel – Basics


Flexible Options

This course is delivered as 1-day hands-on, face-to-face, or 3-hour, live online. Public courses are subject to availability, and courses can be delivered just for your personnel, as a closed course, either onsite in your training room, or as a live online session.


Detailed Content

Participants will learn how to:

  • Describe Excel’s screen layout and navigate the screen easily.
  • Make it easier to find and use Excel’s buttons and functions.
  • Enter data and simple formulas.
  • Navigate spreadsheets with mouse and keyboard shortcuts.
  • Edit a spreadsheet: add and remove rows and columns, adjust widths, etc.
  • Cut, paste and copy formulas.
  • Create patterns of data: dates, months, days, etc.
  • Format a spreadsheet to make it look presentable.
  • Create and edit simple charts and graphs.
  • Change displays and freeze parts of spreadsheets.
  • Print, email spreadsheets and charts, and output to PDF.
  • Use shortcuts and quick-entry techniques.
  • Save and open spreadsheets to correct drive/folder locations.
  • Apply sorting and filtering techniques to view the data you want.

The course content/outcomes can be customised/tailor-made to your requirements.


Previous Experience Recommended

No experience in using Excel is required nor assumed. Participants are expected to have some knowledge of and experience with a Windows PC.


What You Receive

All participants receive:

  • Training manual of step-by-step instructions (PDF version for live online sessions).
  • Interactivity – you can ask questions relevant to your work.
  • Recording of the session for on-demand reviewing later (live online sessions).
  • Support for your questions after the training via phone or email.
  • Copies of all student training files for ongoing practice.

What You Require For Online Session

  • Your PC/laptop/device, with internet, sound enabled and speakers.
  • A headset with microphone is recommended, and webcam optional.
  • Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.

Finally

If you require further details, or wish to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.

FACE-TO-FACE Dates


  • ALBURY
    Jun
    18

    2024

    1 day, Tue 9:30 AM - Tue 5:00 PM

    ALBURY

    Event is fullJoin waiting list
    • $389.00 incl. GST
  • ALBURY
    Jul
    24

    2024

    1 day, Wed 9:30 AM - Wed 5:00 PM

    ALBURY

    • $389.00 incl. GST

More Dates

LIVE ONLINE Dates


  • Online
    Jul
    12

    2024

    3 hours, Fri 9:30 AM AEST - Fri 12:30 PM AEST

    Online

    • $189.00 incl. GST

More Dates
Download Course Guide

excel

Excel Basics  Overview

Excel – Intermediate


Flexible Options

This course is delivered as 1-day hands-on, face-to-face, or 3-hour, live online. Public courses are subject to availability, and courses can be delivered just for your personnel, as a closed course, either onsite in your training room, or as a live online session.


Detailed Content

Participants will learn how to:

  • Revise the important basics and shortcuts.
  • Format charts better with simple dashboards to improve presentation.
  • Work with data linked to graphs/charts better.
  • Sort and manipulate data more easily: change data, split and combine data, etc.
  • Make formulas update automatically when adding new data.
  • Use cell name ranges to create formulas more easily.
  • Group and outline large data to summarise it easily.
  • Manage and copy sheets using shortcuts, calculate totals across sheets and link to files.
  • Create, edit and format powerful reports with PivotTables.
  • Add new data and make PivotTables reports update automatically.
  • Find duplicate data, view documents side-by-side.

The course content/outcomes can be customised/tailor-made to your requirements.


Previous Experience Recommended

CLASS Training Excel Basics course or experience with Excel.


What You Receive

All participants receive:

  • Training manual of step-by-step instructions (PDF version for live online sessions).
  • Interactivity – you can ask questions relevant to your work.
  • Recording of the session for on-demand reviewing later (live online sessions).
  • Support for your questions after the training via phone or email.
  • Copies of all student training files for ongoing practice.

What You Require For Online Session

  • Your PC/laptop/device, with internet, sound enabled and speakers.
  • A headset with microphone is recommended, and webcam optional.
  • Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.

Finally

If you require further details, or wish to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.

FACE-TO-FACE Dates


  • ALBURY
    Jun
    19

    2024

    1 day, Wed 9:30 AM - Wed 5:00 PM

    ALBURY

    Event is fullJoin waiting list
    • $389.00 incl. GST
  • ALBURY
    Jul
    25

    2024

    1 day, Thu 9:30 AM - Thu 5:00 PM

    ALBURY

    • $389.00 incl. GST

More Dates

LIVE ONLINE Dates


  • Online
    Jul
    19

    2024

    3 hours, Fri 9:30 AM AEST - Fri 12:30 PM AEST

    Online

    • $189.00 incl. GST

More Dates

Download Course Guide

excel

Excel Intermediate Overview

Excel – Advanced


Flexible Options

This course is delivered as 1-day hands-on, face-to-face, or 3-hour, live online. Public courses are subject to availability, and courses can be delivered just for your personnel, as a closed course, either onsite in your training room, or as a live online session.


Detailed Content

Participants will learn how to:

  • Revise some important Excel shortcuts.
  • Create and work with IF functions (IF, COUNTIF, SUMIF, multiple IFs).
  • Create and troubleshoot LOOKUP functions (V/H LOOKUP, the newer XLOOKUP).
  • Create complex ‘nested’ formulas to extract data better.
  • Add new data and have powerful formulas update automatically.
  • Use automated database features and SUBTOTAL functions.
  • Massage data automatically: convert text to numbers, change case, combine columns, etc.
  • Automate processes by creating and working with macros.
  • Edit macros and work with Visual Basic (VBA) code.
  • Use data validation to prevent data-entry errors.
  • Use conditional formatting for ‘dashboard’ reporting.
  • Apply data-entry protection to data correctly.
  • Share workbooks and work with templates.
  • Integrate data more efficiently and create live links.

The course content/outcomes can be customised/tailor-made to your requirements.


Previous Experience Recommended

CLASS Training Excel Intermediate Course or experience with Excel (creating, editing, formatting basic spreadsheets, etc).


What You Receive

All participants receive:

  • Training manual of step-by-step instructions (PDF version for live online sessions).
  • Interactivity – you can ask questions relevant to your work.
  • Recording of the session for on-demand reviewing later (live online sessions).
  • Support for your questions after the training via phone or email.
  • Copies of all student training files for ongoing practice.

What You Require For Online Session

  • Your PC/laptop/device, with internet, sound enabled and speakers.
  • A headset with microphone is recommended, and webcam optional.
  • Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.

Finally

If you require further details, or wish to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.

FACE-TO-FACE Dates


  • ALBURY
    Jun
    20

    2024

    1 day, Thu 9:30 AM - Thu 5:00 PM

    ALBURY

    • $389.00 incl. GST
  • ALBURY
    Jul
    26

    2024

    1 day, Fri 9:30 AM - Fri 5:00 PM

    ALBURY

    • $389.00 incl. GST

More Dates

LIVE ONLINE Dates


  • Online
    Jul
    29

    2024

    3 hours, Mon 9:30 AM AEST - Mon 12:30 PM AEST

    Online

    • $189.00 incl. GST

More Dates
Download Course Guide

excel

Excel Advanced Overview

Excel – LOOKUP Formulas


Flexible Options

This course is delivered as 2-hour, live online. Public courses are subject to availability, and courses can be delivered just for your personnel, as a closed course, either onsite in your training room, or as a live online session.


Detailed Content

Participants will learn how to:

  • Create simple and complex LOOKUP formulas.
  • Use the newer XLOOKUP formula and why it’s better.
  • Use LOOKUPs to integrate and combine data.
  • Fix errors/issues when LOOKUP formulas don’t work.
  • Add new data and make LOOKUPs update automatically.
  • Use LOOKUP formulas to compare lists of data.
  • Apply LOOKUP formulas to your work.
  • Answer your questions.

The course content/outcomes can be customised/tailor-made to your requirements.


Previous Experience Recommended

CLASS Training Excel Basics or Intermediate Course or experience with Excel (creating, editing, formatting basic spreadsheets, etc).


What You Receive

All participants receive:

  • Training manual of step-by-step instructions (PDF version for live online sessions).
  • Interactivity – you can ask questions relevant to your work.
  • Recording of the session for on-demand reviewing later (live online sessions).
  • Support for your questions after the training via phone or email.
  • Copies of all student training files for ongoing practice.

What You Require For Online Session

  • Your PC/laptop/device, with internet, sound enabled and speakers.
  • A headset with microphone is recommended, and webcam optional.
  • Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.

Finally

If you require further details, or wish to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.

LIVE ONLINE Dates


    No courses or sessions scheduled. Inquire via phone (02) 6041 2711 or use our Contact Us page.

More Dates

Excel – PivotTables Essentials


Flexible Options

This course is delivered as 3-hour, live online. Public courses are subject to availability, and courses can be delivered just for your personnel, as a closed course, either onsite in your training room, or as a live online session.


Detailed Content

Participants will learn how to:

  • State what types of data can be reported with pivottables.
  • Create and edit pivottables, build better reports, etc.
  • Create pivottable report dashboards.
  • Filter pivottable data with drop-downs and slicers.
  • Format pivottable data quickly and create graphs/charts from reported data easily.
  • Drill down into pivottables to see details.
  • Use advanced reporting (change calculations, include KPIs, etc).
  • Change, add new data and update pivottables to include new data automatically.
  • Apply features to your work to save time and build better reports.

The course content/outcomes can be customised/tailor-made to your requirements.


Previous Experience Recommended

CLASS Training PivotTables Essentials session or experience with Excel (creating, editing, formatting basic spreadsheets, etc).


What You Receive

All participants receive:

  • Training manual of step-by-step instructions (PDF version for live online sessions).
  • Interactivity – you can ask questions relevant to your work.
  • Recording of the session for on-demand reviewing later (live online sessions).
  • Support for your questions after the training via phone or email.
  • Copies of all student training files for ongoing practice.

What You Require For Online Session

  • Your PC/laptop/device, with internet, sound enabled and speakers.
  • A headset with microphone is recommended, and webcam optional.
  • Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.

Finally

If you require further details, or wish to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.

LIVE ONLINE Dates


  • Online
    Jul
    23

    2024

    3 hours, Tue 9:30 AM AEST - Tue 12:30 PM AEST

    Online

    • $189.00 incl. GST

More Dates

Excel – PivotTables Advanced


Flexible Options

This course is delivered as 3-hour, live online. Public courses are subject to availability, and courses can be delivered just for your personnel, as a closed course, either onsite in your training room, or as a live online session.


Detailed Content

This builds on the PivotTables Essentials session and participants will learn how to:

  • Revise the PivotTables Essentials session.
  • Report raw text data (surveys, etc) with pivottables.
  • Add extra calculated fields automatically to a pivottable.
  • Use macro ‘buttons’ to auto-update PivotTables.
  • Report data from multiple sheets using links, relationships and data-modelling pivottable reports.
  • Live connect the Excel app to spreadsheet data or proprietary databases, then create data-modelling pivottable reports and analyses.
  • Create a full dashboard using pivottables, filters, slicers, etc.
  • Apply features to your work to save time and build better reports.

The course content/outcomes can be customised/tailor-made to your requirements.


Previous Experience Recommended

CLASS Training Excel Basics or Intermediate Course or experience with Excel (creating, editing, formatting basic spreadsheets, etc).


What You Receive

All participants receive:

  • Training manual of step-by-step instructions (PDF version for live online sessions).
  • Interactivity – you can ask questions relevant to your work.
  • Recording of the session for on-demand reviewing later (live online sessions).
  • Support for your questions after the training via phone or email.
  • Copies of all student training files for ongoing practice.

What You Require For Online Session

  • Your PC/laptop/device, with internet, sound enabled and speakers.
  • A headset with microphone is recommended, and webcam optional.
  • Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.

Finally

If you require further details, or wish to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.

LIVE ONLINE Dates


  • Online
    Jul
    30

    2024

    3 hours, Tue 9:30 AM AEST - Tue 12:30 PM AEST

    Online

    • $189.00 incl. GST

More Dates

Excel – Macros


Flexible Options

This course is delivered as 2-hour, live online. Public courses are subject to availability, and courses can be delivered just for your personnel, as a closed course, either onsite in your training room, or as a live online session.


Detailed Content

Participants will learn how to:

  • Describe a what a macro is.
  • Create simple and complex macros.
  • Make macros run with buttons and keyboard shortcuts.
  • Make macros run automatically with special macro names and by activating sheet tabs.
  • Edit macros, with introduction to VBA coding.
  • Hard-code macro commands with message boxes and more.
  • Trouble-shoot and debug macros.
  • Apply macros to your work to save time.
  • Manage macros – rename/delete macros, etc.

The course content/outcomes can be customised/tailor-made to your requirements.


Previous Experience Recommended

CLASS Training Excel Basics or Intermediate Course or experience with Excel (creating, editing, formatting basic spreadsheets, etc).


What You Receive

All participants receive:

  • Training manual of step-by-step instructions (PDF version for live online sessions).
  • Interactivity – you can ask questions relevant to your work.
  • Recording of the session for on-demand reviewing later (live online sessions).
  • Support for your questions after the training via phone or email.
  • Copies of all student training files for ongoing practice.

What You Require For Online Session

  • Your PC/laptop/device, with internet, sound enabled and speakers.
  • A headset with microphone is recommended, and webcam optional.
  • Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.

Finally

If you require further details, or wish to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.

LIVE ONLINE Dates


    No courses or sessions scheduled. Inquire via phone (02) 6041 2711 or use our Contact Us page.

More Dates

Recent Reviews – All Excel Courses

Informative and enjoyable (Excel Basics)

Rated 5.0 out of 5
April 3, 2024

Francis’ delivery and knowledge of the course and the pacing was great; was an efficient use of time.

Sam - Project manager

Really Relevant (Excel Intermediate)

Rated 5.0 out of 5
April 3, 2024

How simple it was to learn the three take aways for myself, and the level of detail the instructor went into while keeping it easy to understand.

Tania - Front Desk Manager

Kept My Attention (Excel Basics)

Rated 4.0 out of 5
April 3, 2024

Very infomative, kept my attention, teacher was good and the workbook has a great breakdown on how to do everything we learnt today so that we have something to refer back to when we need.

Ruby - Library

Easy and Understandable (Excel Basics)

Rated 5.0 out of 5
April 3, 2024

The steady pace allowed me to complete so much.

Sharon - Business Admin

Very enjoyable (Excel Basics)

Rated 5.0 out of 5
April 3, 2024

I really enjoyed Mark’s teaching style. I found him both informative and entertaining.

Phil - Manager

Add Your Review Here














Ready to Work Smarter? [ Inquire Now ]
IT Training AND Courses
EDUCATE, ENHANCE & PERFORM
We are here to help you work smarter with your IT tools. Whether it's for business, work or fun, our services will increase your productivity and minimise your stress. Look around for info about our services and courses, dates, bookings, help desk, resources and more.
  • Analysis of your needs.
  • Face-to-face or live, online.
  • Our training rooms or yours.
  • Extensive training manuals.
  • Help desk support.
Our corporate video
Call (02) 6041 2711