Excel Courses

November 29th, 2017

Microsoft Excel 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.

In the course, you’ll learn how to create, edit and format a spreadsheet as well as how to create basic charts. Lots of shortcuts are covered to save time, and participants will see how easy it is manage data with Excel.

  • Basics
  • Intermediate
  • Advanced

Excel – Basics

 

Delivery & Duration

  • Face-to-face: 1 day, OR
  • Live online: 1 x 3-hour session, OR
  • Closed / Onsite (inquire)

General Outline

This course covers the ‘full range’ of the basics in Microsoft Excel. 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.

In the course, you’ll learn how to create, edit and format a spreadsheet as well as how to create basic charts. Lots of shortcuts are covered to save time, and participants will see how easy it is manage data with Excel.

This course is a great springboard into using Excel to its maximum advantage.


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, 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

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

Dates + Book Now
Download Course Guide

Benefits

excel

Excel Introduction Overview


  • Sep
    11

    2019

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

    ALBURY

    • $339.00 incl. GST
  • Oct
    03

    2019

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

    ALBURY

    • $339.00 incl. GST

Excel – Intermediate

 

Delivery & Duration

  • Face-to-face: 1 day, OR
  • Live online: 1 x 3-hour session, OR
  • Closed / Onsite (inquire)

General Outline

This course goes beyond the basics and focuses on easier and more powerful ways to ‘massage’, manipulate and report your data.

After a revision of the important basics and shortcuts, how to work with large spreadsheets more efficiently and how to analyse raw data are some of the important features covered.

Many shortcuts and time-saving techniques used in managing and working with spreadsheets are covered.


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.

Dates + Book Now
Download Course Guide

Benefits

excel

Excel Intermediate Overview


  • Sep
    18

    2019

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

    ALBURY

    • $339.00 incl. GST
  • Sep
    23

    2019

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

    WAGGA

    • $339.00 incl. GST
  • Oct
    17

    2019

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

    ALBURY

    • $339.00 incl. GST

Excel – Advanced

 

Delivery & Duration

  • Face-to-face: 1 day, OR
  • Live online: 1 x 3-hour session, OR
  • Closed / Onsite (inquire)

General Outline

Some of the more complex aspects of Excel are covered in this Advanced course—but we make it all easy and straight forward for you.

The course focuses on how to create more powerful reports from your data, how to speed that process up and automate it, and how to make it all user-friendly.

You’ll learn how powerful macros can be. And we’ll show you how to adapt it all to your work to save time and solve your problems.


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.

Dates + Book Now
Download Course Guide

Benefits

excel

Excel Advanced Overview


  • Aug
    27

    2019

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

    ALBURY

    Event is fullJoin waiting list
    • $349.00 incl. GST
  • Sep
    30

    2019

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

    WAGGA

    • $349.00 incl. GST
  • Oct
    10

    2019

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

    ALBURY

    • $349.00 incl. GST
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