Thanks for adding:

Proceed to Checkout

Continue browsing


Excel 2019 Pivot Tables

Course Outline

This half day course will revolutionise the way you do reporting in Excel. This course is intended for proficient Excel users who work with larger data sets and are looking for more efficient ways of reporting on that data. It is suitable for both people who have never used pivot tables and people who want to further their understanding. Topics include

  • how you can quickly generate useful intel from data without using formulas.
  • how to build, modify and filter pivot tables.
  • how you can create visualisations from those reports
  • how to create a stunning interactive dashboard using Pivot Charts, Slicers and a range of other Excel elements.


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 2021. 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.

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