Call us on:
    0421 780 028

Advanced Microsoft Excel 2013 training Advanced Microsoft Excel 2013 Training Courses

If you’re looking for really great Advanced Microsoft Excel 2013 training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Advanced Microsoft Excel 2013 training course, at your own premises at the same price as a standard course from elsewhere.

The JMD Training difference is clear:

  • We come to you - your Microsoft Excel 2013 training will be given on your site
  • You get to keep the manuals - Advanced Microsoft Excel 2013 training manuals are provided as PDFs
  • We can train using your own Microsoft Excel workbooks
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Visit our blog If Only I’d Known That,; we have called it that because we hear it so many times in training sessions. In fact, if only we had an extra $150 for every time someone says “If only I’d known that.” ….

For example, you may have been working on several Excel workbooks, but have now finished for the day. You want to close all open workbooks, saving the changes in each of them. With the workbooks open, hold down the Shift key and click the Close button at the top right of the Excel Title bar. A box appears asking whether you want to save changes to the active workbook. Click Yes To All to save changes to all workbooks and close them all.

Request Course Now »

Course TypeCost per day
1 to 1 training$495 + GST
2 to 3 delegates$795 + GST
4 to 5 delegates$995 + GST
6 to 8 delegates$1295 + GST

Prices are PER DAY, and NOT per-person! E.g. if there’s 6 people on the course, you pay $1295 + GST.

Other Microsoft Excel training courses

If you are new to Office 2013, you may also be interested in our Office 2013 upgrade training, workshops and floorwalking

Organisations who have benefitted from our Advanced Excel 2013 training include:

  • Australian Dental Corporation
  • Commonwealth Bank of Australia

Aims of the Advanced Excel 2013 course

This course aims to give delegates an in-depth knowledge of Excel 2013 features.

Course Objectives

On completion of the course delegates will have advanced skills in using Microsoft Excel 2013. They will be able to:

  • Link multiple workbooks
  • Print workbooks
  • Use one and two-way data tables
  • Audit a worksheet
  • Create and use PivotTables and reports
  • Use Solver, Scenario Manager and Goal Seek tools
  • Use Excel workgroup features
  • Create and use macros

 The course is of one day’s duration.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.


Familiarity with the Windows environment, and a reasonable knowledge of Excel. Prior attendance of the Intermediate Excel course would be an advantage.

Using multiple workbooks

  • Using a workspace

Printing workbooks

  • Printing and previewing multiple worksheets
  • Custom views


  • Using one-input or two-input data tables


  • Protecting and unprotecting a worksheet with a password
  • Protecting and unprotecting designated cells in a worksheet with a password


  • Adding password protection to a workbook
  • Removing password protection from a workbook

Creating a shared workbook

Tracking changes

  • Highlighting
  • Accepting
  • Rejecting


  • Sorting data by multiple columns
  • Performing custom sorts


  • Creating a single or multiple criteria query using available options
  • Using advanced query/filter options


  • Using a template
  • Editing a template

 Auditing a worksheet

  • Tracing errors
  • Tracing dependents
  • Tracing precedents
  • Adding, removing and editing worksheet comments

PivotTables and Reports

  • Creating a PivotTable report
  • Creating a PivotChart report
  • Resetting a summary function in a PivotTable report
  • Creating a PivotTable report for the World Wide Web

Data Analysis Tools

  • Goal Seek
  • Solver
  • Scenario manager

SmartArt graphics

  • Creating a SmartArt graphic
  • Formatting SmartArt
  • Changing SmartArt graphic layout
  • Changing SmartArt graphic colours 


  • Recording macros
  • Running macros
  • Editing macros

Request Course Now »

We provide Microsoft Office training courses, other IT training courses and Personal Development training courses in Sydney, CBD, North Sydney, Chatswood, St Leonard’s, Parramatta, Ryde, Macquarie Business Park, Alexandria, Mascot, Hornsby, Arndell Park, Wetherill Park, St Marys, Penrith as well as the Hills District, the Sutherland Shire and the Central Coast. We will travel further if expenses are covered.

For computer training courses London, UK, please visit our sister site,