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

100%
of respondents recommend this course to a friend.


Reviewd by 29 participants
« previous123456next »

Learned a lot, great course

Rating


Comment:
New functions learnt within Excel, tips for more efficient workbooks

I recommend this course.

by Robbo from Queensland Health
Date: 2021-03-16 16:56:04




Love the course

Rating


Comment:
the course as helpful in my understanding of the Vlookup and Pivot tables that I wanted to know

I recommend this course.

by Oanh from Queensland Health
Date: 2021-03-16 16:55:24




Nice course - learned a lot

Rating


Comment:
Trainor Jay was very knowledgeable and helped throughout the entire process. Learnt lots of tricks and hacks.5 Stars!

I recommend this course.

by Emi
Date: 2021-03-16 16:52:40




great course - learned alot

Rating


Comment:
good learning experience which I can now hopefully relate back to my working environment

I recommend this course.

by Jules
Date: 2021-03-11 15:37:55




Nice Course

Rating


Comment:
Very helpful for intermediate users to take the next step. Was a helpful to learn about newer features that Excel has to offer and making excel spreadsheet friendly for others to use.

I recommend this course.

by Anonymous
Date: 2020-09-18 16:38:50




Course Info


Schedule

  • Virtual Classroom AEST
  • 28/10/2021 - 28/10/2021
  • 25/11/2021 - 25/11/2021
  • 16/12/2021 - 16/12/2021
  • 3/02/2022 - 3/02/2022
  • 6/04/2022 - 6/04/2022
  • 8/06/2022 - 8/06/2022
  • 3/08/2022 - 3/08/2022

Next Step

Book Course Now
Enquire Now
Tell a Friend
Email Course Outline

Course files