Microsoft Excel Training Courses

Give your business the Edge!

Increase productivity and analyse your business data more effectively with a short course in Microsoft Excel.

Need Customised Content?

Excel Training and Excel Courses

Whether you use Excel versions 2007, 2010, 2013 or 2016 we can tailor a course for you running from 3 hours to 1 day depending on the features of Excel you wish to learn.

Book Now

Excel Basic Course

This course is for people who have no prior knowledge of Excel and need to produce reports, lists, budgets and analyse figures. Learn to use the following features of Excel;

  • Creating spreadsheets
  • Creating and modifying formulas
  • Using Functions including AutoSum, Average, Count
  • Formatting headings
  • Sort and filter lists of data
  • Creating charts
  • Printing Excel Spreadsheets
Excel Beginners Course
Tues 6th Feb 2018 9:30am - 4:30pm $ 137
Central Coast
Enrol Now

Excel Advanced Course

This course is for people who already use Excel and would like to learn spreadsheet enhancements using the following;

  • Linking worksheets
  • Relative and absolute cell referencing
  • Named ranges
  • Protecting data including formula cells and worksheets
  • Data Validation including drop down lists for data entry
  • Advanced functions such as IF, VLOOKUP, ROUND, COUNTIF, SUMIF, RANK, IFERROR
  • Analysing lists using Filtering, Sub Totals and Pivot Tables
  • Consolidating Worksheets
  • Grouping
  • Forecasting
Excel Advanced Course
Tues 21st Nov 9:30am - 3:30pm $ 120
Kincumber Central Coast
Enrol Now

Excel VBA and Macros

This course is for people who need to start Visual Basic Programming to produce Excel Macros to automate tasks in spreadsheets. Learn to;

  • Record a Macro
  • Running a Macro from the toolbar or a button
  • VBA Programming
  • Debugging a Macro
  • Running a Macro when a spreadsheets opens or closes

IT Consultant

Is there an Excel Spreadsheet that is complicated and not calculating correctly? Let us visit you onsite and show you how to demystify your files and improve business.

Training Courses

Private Tuition

Strapped for time or cannot make our group classes?

Ask us about our private tuition delivered at Bateau Bay.

We can customised a 3 hour Excel session to suit your business needs and proceed at a pace relevant to your skills and ability

Call Now