´╗┐

Microsoft Excel 2013 Level 3 (Advanced Data Analysis with Microsoft Excel)


General Description

The skills and knowledge acquired in Microsoft Excel 2013 - Level 3 are sufficient to be able to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and advanced PivotTable techniques, macros, and much more.

Outcomes

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

  • modify Excel options 
  • protect data in worksheets and workbooks 
  • import data into Excel and export data from Excel 
  • use data linking to create more efficient workbooks 
  • group cells and use outlines to manipulate the worksheet 
  • create summaries in your spreadsheets using subtotals 
  • use the Data Consolidation feature to combine data from several workbooks into one 
  • create, use and modify data tables 
  • create and work with scenarios and the Scenario Manager 
  • use data linking to create more efficient workbooks 
  • construct and operate PivotTables using some of the more advanced techniques 
  • work with tables in Microsoft Excel 
  • use advanced filters to analyse data in a list 
  • use a variety of data validation techniques 
  • use a range of Information functions 
  • use a range of text functions 
  • create and use a range of controls in a worksheet 
  • share workbooks with other users 
  • create recorded macros in Excel.

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 19 reviews)

84%
of respondents recommend this course to a friend.


Click here to Read Reviews

Course Info


Schedule

  • Melbourne
  • 18/09/2019 - 18/09/2019
  • 13/11/2019 - 13/11/2019
  • Canberra
  • 9/08/2019 - 9/08/2019
  • 18/09/2019 - 18/09/2019
  • Sydney
  • 9/08/2019 - 9/08/2019
  • 5/09/2019 - 5/09/2019
  • Brisbane
  • 7/08/2019 - 7/08/2019
  • 4/09/2019 - 4/09/2019
  • Adelaide
  • 2/08/2019 - 2/08/2019
  • 12/09/2019 - 12/09/2019
  • Perth
  • 22/08/2019 - 22/08/2019
  • 20/09/2019 - 20/09/2019
  • Darwin
  • 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