envelope  info@ctstraining.com.au  phone  1300 246 287

 
Develop Excel spreadsheets using best practice design techniques. Create formulas, add formatting and setup for print.  We will show you several hand shortcuts along the way.  Learn through demonstration and comprehensive hands-on activities based on business scenarios.

1 Day course

Live Online* 
     4.75  (12,580 reviews)

  $440

Learn more


3 x 1 day intermediate level courses available.
 
Learn to use Excel efficiently to manage and manipulate data for analysis and reporting. Produce quality reports using conditional formatting, styles and charts. Analyse data using Excel tables and PivotTables.

1 Day course

Live Online* 
     4.8  (25,250 reviews)

  $440

Learn more


Do you just want to learn to manage data using Tables and PivotTables?
 
Tables This course focuses on the powerhouse features of Tables and PivotTables covering how you can leverage them to analyse data from multiple sources using Excel Tables, PivotTables, Slicers and the Data model.  

1 Day course

Live Online* 
     4.8  (1,550 reviews)

  $440

Learn more


Learn the tips and techniques to create business dashboards in Microsoft Excel.  Dashboards present a visual summary of important information which allows you to analyse your subject. Through hands-on exercises you will build a dashboard and learn tools of data modelling, analysis and building visuals for effective Dashboards using Microsoft Excel.

1 Day course

Live Online* 
     4.7  (1,545 reviews)

  $475

Learn more


As an advanced Excel user, you may need to perform many varied tasks.  In this course you will manage external data using tables, analyse data using advanced functions and formula auditing tools and PivotTables. 


1 Day course

Live Online* 
     4.45  (3,550 reviews)

  $440

Learn more


The Excel VBA training course provides a comprehensive coverage of examples to enable you to understand the Excel VBA language structure and write code that automates tasks in Excel, creates and sends an email from Outlook and uses speech to tell you when the task is done!

3 Day course

Live Online* 
     4.8  (1,580 reviews)

  $1495

Learn more