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.

 4.45  (12,580 reviews)                               $395
 Duration:   1 day         Classroom       Live Online   

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.

 4.8  (25,250 reviews)                         from $429
 Duration:   1 day         Classroom       Live Online  

Learn more


Do you just want to learn to manage data using Tables and PivotTables?
Tables and PivotTables are powerhouse features of Microsoft Excel and this course will take you through the features of each and how you can leverage them to analyse data from multiple sources using Excel Tables, PivotTables, Slicers and the Data model.  

 4.8  (1505 reviews)                         from $429
 Duration:   1 day         Classroom       Live Online   

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.

 4.7  (1045 reviews)                               $475
 Classroom:    1 day 
 Live Online:   2 x 3 hr sessions 

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. 

 4.4  (2720 reviews)                               $440
 Classroom:    1 day 
 Live Online:   2 x 3 hr sessions 

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!

 4.9  (575 reviews)                               $1435
 Classroom:    3 day 
 Live Online:   6 x 3 hr sessions  (over 3 weeks)

Learn more