Microsoft 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

May 22nd, 2018

  • Basics
  • Intermediate
  • Advanced
  • PivotTables
  • Macros

Excel – Basics


Detailed Content

By the end of this course, participants will be able 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

  • Jul
    05

    2018

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

    ALBURY

    • $339.00 incl. GST
  • Aug
    03

    2018

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

    ALBURY

    • $339.00 incl. GST

More Dates
Download Course Guide

Benefits

excel

Excel Basics  Overview

Excel – Intermediate


Detailed Content

By the end of this course, participants will be able 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.

Note: The online version of the course does not cover all of the above outcomes.


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

  • Jul
    12

    2018

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

    ALBURY

    • $339.00 incl. GST
  • Aug
    09

    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

By the end of this course, participants will be able to:

  • Use features to update and massage data automatically.
  • Use text formulas/functions (LEFT, UPPER, etc).
  • Use IF functions (IF, OR/AND IF, COUNTIF, SUMIF, multiple IFs).
  • Use Lookup functions (V/H LOOKUP).
  • Use complex ‘nested’ formulas to extract data better.
  • Use automated database features and SUBTOTAL functions.
  • Create, edit and troubleshoot macros and VBA.
  • 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.

Note: The online version of the course does not cover all of the above outcomes.


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

  • Jun
    27

    2018

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

    ALBURY

    • $349.00 incl. GST
  • Jul
    26

    2018

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

    ALBURY

    • $349.00 incl. GST
  • Aug
    23

    2018

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

    ALBURY

    • $349.00 incl. GST

More Dates
Download Course Guide
Benefits

excel

Excel Advanced Overview

Excel – PivotTables


Detailed Content

By the end of this course, participants will be able to:

  • Create and edit pivottables.
  • Build better reports with pivottables.
  • Advanced reporting with pivottable (KPIs, etc).
  • Drill down into pivottables.
  • Change, add data and update pivottables automatically.

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

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

More Dates
Benefits

Excel – Macros


Detailed Content

By the end of this course, participants will be able 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.

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

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

More Dates
Benefits

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