Tel: 1300 TO TRAIN

Email: info@advancedtraining.com.au

IT Training with Advanced Training



EXCEL 2010 Level 3 (Advanced Data Analysis with Microsoft Excel)


General Description

This course aims to provide skills and knowledge which will allow the attendee to create lookup functions, set Excel working options, enhance charts, protect worksheet data, perform advanced data operations using summarizing, PivotTables, data consolidations, and create and use macros.

Outcomes

At the completion of this course participants will be able to:

  • use a range of lookup and reference functions
  • modify Excel options
  • customise the formatting of charts in Excel
  • protect data in worksheets and workbooks
  • create summaries in your spreadsheets using subtotals
  • use the Data Consolidation feature to combine data from several workbooks into one
  • understand and create simple PivotTable reports
  • construct and operate PivotTables using some of the more advanced techniques
  • create and edit a PivotChart
  • group cells and use outlines to manipulate the worksheet
  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.




User Reviews

Good Stuff (Rating based on 159 reviews)

97%
of respondents recommend this course to a friend.


Click here to Read Reviews

Course Info


Schedule

  • Melbourne
  • 19/06/2019 - 19/06/2019
  • 18/09/2019 - 18/09/2019
  • 13/11/2019 - 13/11/2019
  • Canberra
  • 17/05/2019 - 17/05/2019
  • 5/06/2019 - 5/06/2019
  • 17/07/2019 - 17/07/2019
  • 9/08/2019 - 9/08/2019
  • 18/09/2019 - 18/09/2019
  • Sydney
  • 15/05/2019 - 15/05/2019
  • 19/06/2019 - 19/06/2019
  • 3/07/2019 - 3/07/2019
  • 9/08/2019 - 9/08/2019
  • 5/09/2019 - 5/09/2019
  • Brisbane
  • 15/05/2019 - 15/05/2019
  • 13/06/2019 - 13/06/2019
  • 5/07/2019 - 5/07/2019
  • 7/08/2019 - 7/08/2019
  • 4/09/2019 - 4/09/2019
  • Adelaide
  • 10/05/2019 - 10/05/2019
  • 21/06/2019 - 21/06/2019
  • 3/07/2019 - 3/07/2019
  • 2/08/2019 - 2/08/2019
  • 12/09/2019 - 12/09/2019
  • Perth
  • 1/05/2019 - 1/05/2019
  • 28/06/2019 - 28/06/2019
  • 24/07/2019 - 24/07/2019
  • 22/08/2019 - 22/08/2019
  • 20/09/2019 - 20/09/2019
  • Darwin
  • 17/05/2019 - 17/05/2019
  • 5/06/2019 - 5/06/2019
  • 17/07/2019 - 17/07/2019
  • 9/08/2019 - 9/08/2019
  • 18/09/2019 - 18/09/2019

Next Step

Book Course Now
Enquire Now
Tell a Friend
Email Course Outline

Course files