Thanks for adding:

Proceed to Checkout

Continue browsing


Excel 2016 Advanced

Course Outline

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 functions of the software. Topics include

  • 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


Confident keyboarding skills and Excel Intermediate course or equivalent skills and knowledge

On Campus study during COVID-19

Additional safety measures are being taken at College Campuses to help protect everyone on site. These include:

  • Additional cleaning measures
  • Reduced class sizes to allow for social distancing
  • Provision of hand sanitiser and wipes to encourage regular hand hygiene
  • Regular wiping of frequently used surfaces

Please help with these safety measures:

  • Do not attend College if you are feeling unwell.
  • Regularly clean your hands with soap and water for 20 seconds, or an alcohol-based hand rub.
  • Practice cough etiquette (keep away from other people, cover coughs and sneezes with disposable tissues or clothing, and clean your hands.
  • Practice recommended social distancing.


This course may be fully funded under the NSW Government’s Adult & Community Education funding or Tech Savvy for Small Business Program in 2020. See ACE Community Service Obligation Funding page for details or See Tech Savvy for Small Business Program page or contact Susan Wilkinson on 9970 1000 or email to check eligibility or for further information.

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

Related Courses

Course testimonials:

  • Excellent, well structured training and Nicky is a fantastic trainer, very knowledgeable, methodical and patient.
  • Nicky is fantastic. The training teaches you to understand how excel works rather than just learning some formulas. This enables me to continue to progress and learn on my own, with the logic behind excel now understood. Fantastic.
  • Really helpful course and will definitely be doing more in the future.
  • I enjoyed the pace, great teacher who paces the information and always helpful
  • Great
  • The greatest asset in all of this is Nicky Bull. She is outstanding in every regard. Polite, pleasant and with a vast knowledge of MS Excel and how it has evolved. Lots of great, relevant and useful shortcut tips at every step. Great at gauging where everybody is at and customising course delivery to suit. I think it should be called MS Excel First Aid and would recommend a 12 month refresher reminder. I would also love to see a course designed around teaching the principles or fundamentals of good spreadsheet design. I'm sure many spreadsheets are doomed to making use of the best functionality because they are poorly designed, but we plod on with the bad design because we don't know any better. Thank you, Nicky. James Staples Complementary Medicines Group Warriewood
  • Great course; really enjoyed Nicky Bull as the trainer; now need to practice the skills learned
  • The tactics and materials covered in this course are extremely relevant and useful in my line of work. Nicky is a fabulous teacher who has an effective instructional strategy and she makes learning experience interactive & inclusive. Thanks Nicky for making a big difference in my life already!
  • Course came with a complete manual so that students can read up and continue practicing into the future. Course moved at a reasonably fast pace suited to those who've had experience using excel or are reasonably familiar with it. Plenty of opportunity to ask the helpful trainer questions.
  • Nicki Bull is a gifted teacher. She is pleasant, personable and VERY knowledgeable. Helpful to the struggler and the flyer at the same time, and still able to keep the class moving. Her enthusiasm for the subject is both delightful and infectious, helpful to learning and smooths through the less exciting parts of the day. It is a shame she does not teach more courses.

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