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 basic formulas and spreadsheet formatting including;

  • 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
Mon 4th Feb 2019 9:30am - 4:30pm $ 144
Tuggerah, Central Coast
Enrol Now

Excel Advanced Course

This course is for people who already use Excel and would like to learn advanced functions and features of Excel;

  • 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, TRIM, CONCATENATE, IFERROR
  • Analysing lists using Filtering, Sub Totals and Pivot Tables
  • Grouping
  • Forecasting
Excel Advanced Course
Mon 4th March 2019 9:30am - 3:30pm $ 126
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

Excel 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