Course Outline
Excel Pivot Tables are a powerful tool for summarising and filtering data allowing us to generate summary reports and data insights with just a few clicks. In this Masterclass we will explore what PivotTables are and how they are used. Starting with how to organise the data, we’ll then create and modify pivots to tell a variety of data stories, we’ll add data visualisation in the form of Pivot Charts and Conditional Formatting and finish off with creating an interactive dashboard.
Prerequisites
Confident keyboarding skills and Excel Intermediate course or equivalent skills and knowledge.
Zoom
This course will be delivered using virtual classroom via Zoom.
Zoom is easy to use video conferencing software with a simple set up. You will be able to see your trainer and classmates and interact as though you were in the same room, all from the comfort of your own home!
This is what you need to join a Zoom classroom:
. Understanding the basics of using Zoom – see our free Zoom tutorial by clicking here.
. Access to a computer, iPad/tablet or smartphone; and
. A webcam* so that you can be seen by the trainer; and
. A microphone* so that you can participate in the class and be heard by the trainer; and
. A good Internet connection.
*Please note if you have a laptop computer a webcam and microphone are usually built into the top of the screen frame. Smartphones and iPad/tablets also contain cameras and microphones.
Once you have watched our free tutorial and experimented with Zoom, if you still have questions, please contact the office on 9970 1000 or email enquiries @nbmc.nsw.edu.au for further details.
