Thanks for adding:

Proceed to Checkout

Continue browsing


Excel 2016 Advanced

Advanced Microsoft Office Excel course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2016 Intermediate. Learn functions, labels and names, data consoildation, pivot tables and macros. This course would suit those who have intermediate excel skills but want to learn more advanced techniques and funtions of the software.

Course Outline

  • Lookup functions
  • Labels and Names
  • Protecting Data
  • Data Consolidation
  • PivotTables
  • Solver
  • Recorded Macros


Students must have prior knowledge of the following:

  • Entering and Editing Data
  • Data formatting options
  • Worksheet formatting options
  • Page setup options
  • Moving and copying data
  • Creating simple formulas
  • Working with any of Excel’s functions (eg. =SUM, =AVERAGE, =LOOKUP)
  • Using “AutoFill” when copying formulas
  • Headers and Footers
  • Basic Charts
  • Auto Fill Options

Please Bring

  • USB stick to class. Around 4gb storage is sufficent.
  • Notepad and pen

This course has no current classes. Please the waiting list.

Related Courses

Course testimonials:

  • Really helpful course and will definitely be doing more in the future.
  • Thoroughly enjoyed it and learnt so much. Nicky was amazing.
  • The trainer was so flexible, helpful and pleasant and knew her stuff!!

Contact us

Narrabeen Annex: 1525 Pittwater Road,
North Narrabeen NSW 2101
Office Hours: 8.30am to 4.30pm, Mon to Fri

Brookvale Campus: Level 1, 14 William St, Brookvale NSW 2100
Office Hours: 8.30am to 4.30pm, Mon to Thur

Post: NBCC Reply Paid 1966, Dee Why NSW 2099

Phone: 02 9970 1000

Registered Training Organisation Code 90113