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

August 14th, 2018

  • Basics
  • Intermediate
  • Advanced
  • Excel Intermediate (Live Online)
  • Excel PivotTables (Live Online)
  • Excel Macros (Live Online)

Excel – Basics


Detailed Content

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

  • Describe Excel, its screen layout and make it easier to find buttons and functions.
  • Enter data and simple formulas.
  • Navigate with mouse and keyboard.
  • Change displays and freeze parts of spreadsheets.
  • Edit a spreadsheet (add, remove rows, columns, etc).
  • Cut, paste and copy formulas.
  • Format a spreadsheet to make it look presentable.
  • Create and edit simple charts and graphs.
  • Print or email spreadsheets and charts.
  • Use shortcuts and quick-entry techniques.
  • Save and open spreadsheets to correct drive/folder locations.
  • Use Excel to filter, sort and view data efficiently

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

  • Sep
    03

    2018

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

    ALBURY

    • $339.00 incl. GST
  • Oct
    11

    2018

    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 basics and shortcuts.
  • Make formulas update automatically when adding new data.
  • Use filters to easily see and analyse the data you want.
  • Manipulate data more easily: find duplicates, split data, etc.
  • Create cell name ranges to make formulas easier.
  • Group and outline large data to summarise it easily.
  • Use sheets, calculate across sheets and link to files.
  • Easily sort and arrange data and use SubTotals on raw data.
  • Create powerful reports with PivotTables.
  • Use styles and comments to communicate and format.
  • 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 proven experience with Excel.

Upcoming Dates

  • Sep
    10

    2018

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

    ALBURY

    • $339.00 incl. GST
  • Oct
    08

    2018

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

    WAGGA

    • $339.00 incl. GST
  • Oct
    18

    2018

    1 day, Thu 9:30 AM - Thu 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:

  • Use features to update and massage data automatically.
  • Use IF functions (IF, COUNTIF, SUMIF, multiple IFs).
  • Use and troubleshoot LOOKUP functions (V/H LOOKUP).
  • Create complex ‘nested’ formulas to extract data better.
  • Use automated database features and SUBTOTAL functions.
  • 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 proven experience with Excel.

Upcoming Dates

  • Aug
    23

    2018

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

    ALBURY

    • $349.00 incl. GST
  • Sep
    17

    2018

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

    ALBURY

    • $349.00 incl. GST
  • Oct
    15

    2018

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

    WAGGA

    • $349.00 incl. GST

More Dates
Download Course Guide
Benefits

excel

Excel Advanced Overview

Excel Intermediate (Live Online)


Detailed Content

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

  • Revise the important shortcuts.
  • Make formulas update automatically when adding new data.
  • Use filters to easily see and analyse the data you want.
  • Manipulate data more easily, split data, etc.
  • Create cell name ranges to make formulas easier.
  • Group and outline large data to summarise it easily.
  • Use sheets, calculate across sheets and link to files.
  • Easily sort and arrange data and use SubTotals on raw data.
  • Create powerful reports with PivotTables.

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 in using Excel is required nor assumed. Participants are expected to have some knowledge of and experience with a Windows PC.

Upcoming Dates

  • Online
    Sep
    26

    2018

    3 hours, Wed 8:30 AM AEST - Wed 11:30 AM AEST

    Online

    • $149.00 incl. GST

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.

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 in using Excel is required nor assumed. Participants are expected to have some knowledge of and experience with a Windows PC.

Upcoming Dates

  • Online
    Sep
    27

    2018

    2 hours, Thu 8:30 AM AEST - Thu 10:30 AM AEST

    Online

    • $89.00 incl. GST

More Dates

Excel – Macros (Live Online)


Detailed Content

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

  • Describe a macro.
  • Create simple and complex macros.
  • Edit macros, with introduction to 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

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

  • Online
    Sep
    27

    2018

    2 hours, Thu 12:30 PM AEST - Thu 2:30 PM AEST

    Online

    • $89.00 incl. GST

More Dates

  • Three Big Word Tips

    August 14th, 2018

    Think you know Word? Three great tips we use all the time.

  • Xero Big Tips

    August 14th, 2018

    Our 4 Big Xero Tips for making Xero do the work for you…

  • Manipulating Data Easily in Excel

    August 14th, 2018

    Check out the ‘magic’ of Excel’s Flash Fill feature to manipulate data.

  • Youth in the iGeneration

    August 14th, 2018

    Challenges we face from and for our youth and how to manage them in today’s tech world.

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