Microsoft Excel training courses

EasyPC Training provides Microsoft Excel training courses in Brisbane, Gladstone and Cairns and onsite customised Microsoft Excel courses across Australia, from beginners to advanced.

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

Training Course Description

COURSE TITLE CONTENT
Microsoft Excel Essentials
Duration: 1 day
View course timetable and prices
Pre-requisites:
  • Basic computer experience, including keyboard and mouse skills
  • Familiarity with the Microsoft Windows
  • If you are not familiar with using a computer or Microsoft Windows, a 1 day course, Introduction to computers, will give you the skills to take this course.
  • Create an Excel workbook
  • Save an Excel Workbook
  • Close & Open Existing Workbooks
  • Change Worksheet Views
  • Customise Quick Access Toolbar
  • Enter Data into a Workbook
  • Use Copy and Fill handle
  • Copy Data to another Location
  • Edit Data
  • Insert & Delete Rows & Columns
  • Hide & Unhide Rows & Columns
  • Use Find and Replace
  • Use Formulas
  • Insert, Name & Delete Worksheets
  • Move and Copy Worksheets
  • Use Functions
  • Link Data
  • Apply Font Formatting
  • Apply Quick Number Formatting
  • Column Widths & Row Heights
  • Align Data in a Cell
  • Printing Worksheets
View Excel Essentials course content
Excel Effective Workbooks
Duration: 1 day
View course timetable and prices
Pre-requisites:
  • Basic experience in using Microsoft Excel
  • Knowledge of simple formulas and functions
  • Alternatively, completion of Excel Essentials training course
  • Custom Lists
  • Custom Formatting
  • Cell Styles
  • Conditional Formatting
  • Themes
  • Templates
  • Absolute Referencing
  • Names
  • Linking
  • Protect your Data
  • Data Validation
  • Populate Data using IF
  • Populate Data using VLOOKUP
  • Tables
  • Macros
  • Customise the Ribbon
View Excel Effective Workbooks course content
Excel Analysing Data
Duration: 1 day
View course timetable and prices
Pre-requisites:
  • Good experience in using Excel
  • Knowledge of basic functions and linking data
  • Alternatively, completion of Excel Effective Workbooks training course
  • Sorting
  • Filtering
  • Advanced Filtering
  • Database Functions
  • Goal Seek
  • Data Tables
  • Scenarios
  • Macros
  • Consolidation
  • Subtotals
  • Group data
  • Create a Pie Chart
  • Create a Column Chart
  • Customise Charts
  • Create a Pivot Table
  • Analyse data in Pivot Tables
  • Calculations in Pivot Tables
View Excel Analysing Data course content
Excel Advanced Functions
Duration: 1 day
View course timetable and prices
Pre-requisites:
  • Good knowledge of basic functions in Excel
  • Alternatively, completion of Excel Effective Workbooks training course
  • Data Information
  • Data Cleansing
  • Date Functions
  • Adding Numbers
  • Counting Values
  • Average Values
  • Displaying Numbers
  • Lookup Functions
  • Logical Functions
View Excel Advanced Functions course content
Excel VBA
Duration: 3 days
View course timetable and prices
Pre-requisites:
  • Good knowledge of Microsoft Excel
  • Experience with creating IF functions
  • Alternatively, completion of Excel Effective Workbooks or Advanced Functions training courses
  • 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 Excel VBA course content

Included in your computer training course

  • Use of modern computers in air-conditioned training rooms
  • Comprehensive course manual
  • Certificate of completion
  • USB with practice exercises
  • FREE after-course support for your course*
  • FREE refresher course*
  • All day refreshments

*Within 6 months of course date