Microsoft Excel 2016 Level 3


General Description

The skills and knowledge acquired in Microsoft Excel 2016 Level 3 are sufficient to be able to use and operate the software at an efficient level.

Outcomes

  • Use a range of lookup and reference functions
  • Create more complex formulas and functions
  • Understand and create simple PivotTables
  • 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
  • Use the Data Consolidation feature to combine data from several workbooks into one
  • Create summaries in your spreadsheets using subtotals
  • Protect data in worksheets and workbooks
  • Create recorded macros in Excel
  • Use the macro recorder to create a variety of macros
  • Understand and create simple PivotTables

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

Perfect. It doesn't get any better (Rating based on 9 reviews)

100%
of respondents recommend this course to a friend.


Click here to Read Reviews

Course Info


Schedule

  • Melbourne
  • 18/09/2019 - 18/09/2019
  • 7/10/2019 - 7/10/2019
  • 13/11/2019 - 13/11/2019
  • Canberra
  • 18/09/2019 - 18/09/2019
  • 20/11/2019 - 20/11/2019
  • Perth
  • 20/09/2019 - 20/09/2019
  • Darwin
  • 15/10/2019 - 15/10/2019
  • 21/11/2019 - 21/11/2019

Next Step

Book Course Now
Enquire Now
Tell a Friend
Email Course Outline

Course files