Microsoft Excel Training

Microsoft Excel TrainingEasyPC Training provides customised Microsoft Excel 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 make 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 Content:

  • 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 Course Outline >>

View Dates and Prices >>

Microsoft Excel Intermediate

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

Aimed at: those who wish to extend their knowledge & skills beyond building simple Microsoft Excel workbooks. The course covers more complex functions, such as IFs and LOOKUPs, and data analysis tools.

Pre-requisites:

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

  • Planning your workbook
  • Creating custom lists
  • Advanced formatting
  • Linking data
  • Absolute cell referencing
  • Using names
  • Protecting your data
  • Data validation
  • Logical functions
  • Lookup functions
  • Advanced sorting
  • Filtering data

View Course Outline >>

View Dates and Prices >>

Microsoft Excel Advanced

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

Aimed at: those who wish to improve their analysis and reporting skills and automate system processes.

Pre-requisites:

  • Sound experience in using spreadsheets
  • Knowledge of more complex functions
  • Ability to sort and filter data
  • Alternatively, completion of Excel Intermediate training course
Course Content:

  • Advanced filters
  • Database functions
  • What-if analysis
  • Data validation
  • Data tools
  • Consolidation
  • Subtotals and Grouping
  • Pivot tables
  • Macros

View Course Outline >>

View Dates and Prices >>

Customised Microsoft Excel Training

Mix and Match topics from any of the 3 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