Excel Courses

Learn how to use Excel’s powerful features with our comprehensive courses. We cater for all versions and participants, whether they’ve been self-taught, have been using Excel simply for a while, or have no experience at all. All courses are hands-on, and you’ll learn lots of shortcuts and better ways to manage and report your Excel data.

Microsoft Excel

April 28th, 2020

  • Basics
  • Interm
  • Adv
  • Basics (Online)
  • Interm (Online)
  • Adv (Online)
  • LOOKUPs (Online)
  • PivotTables (Online)
  • Macros (Online)

Excel – Basics


Detailed Content

This is a 1-day hands-on, face-to-face session and 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.

Flexible Options

Courses are delivered in our training rooms in Albury, Shepparton and Wagga. OR, sessions can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.

See Benefits to the right for a list of services provided to all participants (depending on the course).

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

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

Upcoming Dates


  • Jun
    04

    2020

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

    ALBURY

    • $339.00 incl. GST

More Dates
Download Course Guide
Benefits

excel

Excel Basics  Overview

Excel – Intermediate


Detailed Content

This is a 1-day hands-on, face-to-face session and participants will learn how to:

  • Revise the important basics and shortcuts.
  • 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.
  • Format charts better to improve presentation.

Flexible Options

Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.

See Benefits to the right for a list of services provided to all participants (depending on the course).

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

CLASS Training Excel Basics course or experience with Excel.

Upcoming Dates


  • Jun
    09

    2020

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

    ALBURY

    • $339.00 incl. GST

More Dates
Download Course Guide

Benefits

excel

Excel Intermediate Overview

Excel – Advanced


Detailed Content

This is a 1-day hands-on, face-to-face session and 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).
  • 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.

Flexible Options

Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.

See Benefits to the right for a list of services provided to all participants (depending on the course).

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

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

Upcoming Dates


  • Jun
    17

    2020

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

    ALBURY

    • $349.00 incl. GST

More Dates
Download Course Guide

Benefits

excel

Excel Advanced Overview

Excel – Basics (Live Online)


Detailed Content

This is a 3-hour live, online session and 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.
  • 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.
  • Apply sorting and filtering techniques to view the data you want.

What You Receive During Online Session

All participants receive:

  • PDF workbook of step-by-step instructions.
  • Interactivity – you can ask and answer questions.
  • Recording of the session for on-demand reviewing later.
  • Support for your questions after the session.
  • Copies of all example files for your own work.

What You Require For Online Session

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

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

No experience with Excel is assumed. Attendees should have previous experience with a Windows PC.

Upcoming Dates


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

More Dates

Excel – Intermediate (Live Online)


Detailed Content

This is a 3-hour live, online session and participants will learn how to:

  • Revise the important basics and shortcuts.
  • 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.
  • Find duplicate data, view documents side-by-side.
  • Format charts better to improve presentation.

What You Receive During Online Session

All participants receive:

  • PDF workbook of step-by-step instructions.
  • Interactivity – you can ask and answer questions.
  • Recording of the session for on-demand reviewing later.
  • Support for your questions after the session.
  • Copies of all example files for your own work.

What You Require For Online Session

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

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

CLASS Training Excel Basics course or experience with Excel.

Upcoming Dates


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

More Dates

Excel – Advanced (Live Online)


Detailed Content

This is a 3-hour live, online session and participants will learn how to:

  • Create and work with IF functions (IF, COUNTIF, SUMIF, multiple IFs).
  • 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.
  • Use data validation to prevent data-entry errors.
  • Use conditional formatting for ‘dashboard’ reporting.
  • Apply data-entry protection to data correctly.

What You Receive During Online Session

All participants receive:

  • PDF workbook of step-by-step instructions.
  • Interactivity – you can ask and answer questions.
  • Recording of the session for on-demand reviewing later.
  • Support for your questions after the session.
  • Copies of all example files for your own work.

What You Require For Online Session

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

Bookings for this session can be made online via the ‘Book now’ links top-right (scroll up).

NOTE: Payment is required before the session to connect.

To inquire about a closed corporate program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

Some experience in using Excel is receommended.

Upcoming Dates


  • Online
    Jun
    04

    2020

    3 hours, Thu 9:00 AM AEST - Thu 12:00 PM AEST

    Online

    • Book before 2nd June (9 AM) for only $99.00 incl. GST
    • $129.00 incl. GST

More Dates

Excel – LOOKUP Formulas (Live Online)


Detailed Content

This is a 2-hour live, online session and participants will learn how to:

  • Create simple and complex LOOKUP formulas.
  • Use LOOKUPs to integrate and combine data.
  • Fix errors/issues when LOOKUP formulas don’t work.
  • Add new data and make LOOKUPs update automatically.
  • Apply LOOKUP formulas to your work.
  • Answer your questions.

What You Receive During Online Session

All participants receive:

  • PDF workbook of step-by-step instructions.
  • Interactivity – you can ask and answer questions.
  • Recording of the session for on-demand reviewing later.
  • Support for your questions after the session.
  • Copies of all example files for your own work.

What You Require For Online Session

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

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

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

Upcoming Dates


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

More Dates

Excel – PivotTables (Live Online)


Detailed Content

This is a 2-hour live, online session and participants will learn how to:

  • Create and edit pivottables.
  • Build better reports with pivottables.
  • Use advanced reporting with pivottable (KPIs, etc).
  • Drill down into pivottables.
  • Change, add data and update pivottables automatically.
  • Report on multiple sheets with pivottable reports.

What You Receive During Online Session

All participants receive:

  • PDF workbook of step-by-step instructions.
  • Interactivity – you can ask and answer questions.
  • Recording of the session for on-demand reviewing later.
  • Support for your questions after the session.
  • Copies of all example files for your own work.

What You Require For Online Session

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

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

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

Upcoming Dates


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

More Dates

Excel – Macros (Live Online)


Detailed Content

This is a 2-hour live, online session and participants will learn how to:

  • Describe a what a macro is.
  • Create simple and complex macros.
  • Edit macros, with introduction to VBA coding.
  • Hard-code macro commands.
  • Trouble-shoot and debug macros.
  • Apply macros to your work to save time.

What You Receive During Online Session

All participants receive:

  • PDF workbook of step-by-step instructions.
  • Interactivity – you can ask and answer questions.
  • Recording of the session for on-demand reviewing later.
  • Support for your questions after the session.
  • Copies of all example files for your own work.

What You Require For Online Session

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

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

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

Upcoming Dates


  • Online
    Jun
    02

    2020

    2 hours, Tue 9:00 AM AEST - Tue 11:00 AM AEST

    Online

    • $89.00 incl. GST

More Dates

Recent Reviews – Excel Courses

Learnt Easier Ways (Excel – Intermediate)

5.0 rating

April 2, 2020

Mark made the seemingly complex understandable. I learnt the easier ways of using Excel!

Callum (Project Officer)

Exactly what I needed! (Excel – Basics)

5.0 rating

April 2, 2020

The course covered exactly what I needed to know & learn!

Brad ( Sales Executive)

Great Workbook! (Excel – Basics)

5.0 rating

April 2, 2020

The workbook is great! and you get to keep it!

Garry (Public Servant)

Excellent course! (Excel – Basics)

5.0 rating

April 2, 2020

I was impressed by how very informative the course was in a relaxed environment.

Isabella (Admin)

Wonderful! (Excel – Basics)

4.0 rating

April 2, 2020

I learnt the wonderful uses of Excel, it is a very powerful program!

Libby (Farmer)

Add Your Review Here







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