Thanks for adding:

Proceed to Checkout

Continue browsing


Excel 2016 Intermediate

Course Outline

Intermediate Microsoft Office Excel one day course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2016 Introduction. Learn data setup, formula techniques, functions, formatting and linking, sorting and filtering data. This course would suit those who have basic day to day excel skills but want to learn more advanced techniques and functions of the software. Topics will include

  • Page Setup
  • Filling Data
  • Formula Referencing
  • Formula Techniques
  • Logical Functions
  • Number Formatting Techniques
  • Conditional Formatting
  • Worksheet Techniques
  • Data Linking
  • Sorting Data
  • Filtering Data Charting Techniques

Please Bring

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


  • Confident keyboarding skills and Excel Introduction course or equivalent skills and knowledge
  • Students must have Excel 2016/2019 or Office 365 installed on their computer.


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.

Show full classes

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

Course testimonials:

  • Nicky Bull has an enthusiastic teaching style that energises us all. I enjoyed the participatory interaction and certainly picked up some new skills and techniques. Looking forward to the Advanced Excel course.
  • This course was very enjoyable - with many insights from an experienced and knowledgeable Trainer.
  • Nicky is a great teacher, easy to follow, and takes the time to address everyones concerns individually as well as keeping the class moving as a team. The content was well designed and fit the standard we were up to as intermediate excel students.
  • Nicky was such a great trainer .. I learnt way more than I expected and she made it very interesting!
  • Brilliant trainer able to answer all questions asked, highly recommend.
  • Nikki was an absolutely wonderful trainer. Made things very straight forward and easy to understand. She was very patient with every student.
  • The teacher was fabulous. Interesting, engaged and passionate about her subject. It was easy to follow and keep up. Se encouraged questions; no one was made to feel anything other than brilliantly clever for asking anything. I wasn't expecting Excel to be much fun, but it was quite enjoyable and I left feeling I had useful new skills I can use.
  • Great environment for learning, well paced, great lecturer.
  • Really enjoyed the course and found it really helpful. Trainer was fantastic and found the pace and content spot on.
  • Nicky Bull was an inspiration and a veritable mine of information. She was able to make all levels feel comfortable in her class. We all learned and enormous amount.Her knowledge of Excel is extensive.

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