Microsoft Excel

Microsoft Excel TrainingEasyPC Training provides public Microsoft Excel training courses in Brisbane, Gladstone and Cairns, and customised training for groups and individuals across Australia, from beginners to advanced, using Microsoft Excel 2010, 2013, 2016 and 2019.

Create spreadsheets to collect, analyse, share and manage information to make the most informed decisions.

 

Microsoft Excel Training Courses available

Choose from our standard Microsoft Excel training courses:

…or create your own Customised Course

Microsoft Excel Essentials

Duration: Groups: 1 day   |   Individuals: 3-4 hours

Aimed at: those who want to be able to create and edit basic spreadsheets containing simple calculations and links, and produce formatted and printable reports.

Pre-requisites:

  • Basic computer experience, including keyboard and mouse skills
  • Familiarity with Microsoft Windows
  • If you are not familiar with using a computer or Microsoft Windows, the Introduction to computers course will give you the skills to take this Excel course.


Course Overview:

  • Create, Save and Close Workbooks
  • Change Worksheet Views
  • Customise Quick Access Toolbar
  • Enter, Copy and Edit Data
  • Insert & Delete Rows & Columns
  • Hide & Unhide Rows & Columns
  • Use Find and Replace
  • Formulas, Functions & Linking Data
  • Insert, Name & Delete Worksheets
  • Move and Copy Worksheets
  • Apply Font Formatting
  • Apply Alignment & Number Formatting
  • Column Widths & Row Heights
  • Printing Worksheets

View Course Outline >>

Microsoft Excel Effective Workbooks

Duration: Groups: 1 day   |   Individuals: 3-4 hours

Aimed at: those who want to improve the quality of data and efficiency & automation of their spreadsheets using various Excel tools and functions.

Pre-requisites:

  • Basic experience in using Microsoft Excel
  • Knowledge of simple formulas and functions
  • Alternatively, completion of Excel Essentials training course


Course Overview:

  • Custom Lists
  • Custom Formats and Cell Styles
  • Conditional Formatting
  • Themes and Templates
  • Absolute Referencing
  • Define Names
  • Linking Data
  • Protect your Data
  • Data Validation
  • Populate Data using IF
  • Populate Data using VLOOKUP
  • Work with Tables
  • Record and Run Macros
  • Customise the Ribbon

View Course Outline >>

Microsoft Excel Analysing Data

Duration: Groups: 1 day   |   Individuals: 3-4 hours

Aimed at: those who want to effectively analyse their data and create professional reports in Excel.

Pre-requisites:

  • Good experience in using Excel
  • Knowledge of basic functions and linking data
  • Alternatively, completion of Excel Effective Workbooks training course


Course Overview:

  • Sorting and Filtering
  • Advanced Filtering
  • Database Functions
  • Goal Seek
  • Data Tables
  • Scenarios
  • Macros
  • Consolidation
  • Subtotals and Grouping
  • Create a Pie and Column Chart
  • Customise Charts
  • Create a Pivot Table
  • Analyse data in Pivot Tables
  • Calculations in Pivot Tables

View Course Outline >>

Microsoft Excel Advanced Functions

Duration: Groups: 1 day   |   Individuals: 3-4 hours

Aimed at: those who would like to learn more of the functions in Excel. There are over 80 functions covered in this
course.

Pre-requisites:


Course Overview:

  • Data Information
  • Data Cleansing
  • Date Functions
  • Adding Numbers
  • Counting Values
  • Average Values
  • Displaying Numbers
  • Lookup Functions
  • Logical Functions

View Course Outline >>

Microsoft Excel VBA

Duration: Groups: 3 days   |   Individuals: 1.5 days

Aimed at: those who want to be able to create real life working VBA applications within Excel to program and automate worksheet operations.

Pre-requisites:

Course Overview:

  • Understanding Excel VBA
  • Starting With Excel VBA
  • Procedures
  • Using Variables
  • Functions in VBA
  • Using Excel Objects
  • Programming Techniques
  • Creating Custom Forms
  • Programming UserForms
  • Automatic Startup
  • Error Handling

View Course Outline >>

Customised Microsoft Excel Training

Mix and Match topics from any of the levels above to create your own customised training course…

  • For full day courses, choose between 10 and 12 topics
  • For half day courses, choose between 5 and 6 topics

We will discuss your training requirements with you, and can recommend a selection of topics suitable for your specific needs.

Get a Quote for your Microsoft Excel Training