Overview   

A pivot table summarises data from a larger source such as a database or spreadsheet and groups the data into useful information that helps the user to make educated decisions quicker.  

We are presenting this webinar in a fun and interactive format that will reveal step-by-step how to summarise and visualise your data in beautiful PivotTable dashboards. We will  be sharing secrets you can apply immediately in your day to day work, to significantly ramp up your confidence and productivity. 

Join Excel Academy's Dan Stillerman and Avi Levy on 15 March 2021 from 10:30 a.m. to 11:30 a.m. as they take you through the steps of how you can present your information in beautiful PivotTable dashboards.   

Learning objectives  

By the end of this event the attendee will: 

• Know what PivotTables are, and why and when they can be used;  

• Understand how to organise and prepare data to convert into a PivotTable;  

• Know how to build a PivotTable and PivotChart with a few simple clicks;  

• Understand how to "pivot" his/her Pivots so they tell the right story;  and 

• Understand how to format Pivots so that they look professional and impressive.  

Content 

The webinar will cover the following topics:  

• Introduction to PivotTables. 

• Purpose of PivotTables. 

• Preparing data to convert into a PivotTable. 

• How to build a PivotTable. 

• Pivoting your Pivots. 

• Formatting Pivots for a professional look. 

Obtaining your CPD certificate 

This webinar qualifies for 1 CPD hour with your professional body including: ACCA, SAICA, AAT, SAIPA, SAIBA, IAC, CIS, ICBA, LSSA, FPI, and the IBA. The SAAA CPD policy is compliant with IFAC IES7 and is recognised by all relevant professional bodies. 

All attendees are issued with a CPD certificate available in an online profile. 

About the presenter 

Dan Stillerman 

Dan Stillerman founded Excel Academy in 2014, after 4 years of working as an actuary. To date, the team has impacted tens of thousands people around the world through their fun and interactive workshop experiences. During this national  lockdown, Dan has hosted over 200 Zoom webinars, many with NGOs and communal organisations, providing a platform for information, entertainment, and for raising millions for those in desperate need. 

Avi Levy 

Avi Levy describes himself as "The Excel lover who believes in working smart (and then hard)". Avi is the Chief Operating Office of Excel Academy. He finds efficient and simple solutions to complex problems by leveraging the power of Excel and he is passionate about Inspiring people to do the same. This is the reason why he joined Excel Academy where he has the opportunity to help people become more productive and confident in their work. 

Who should attend 

  The following persons will benefit from attending this webinar: 

• Professional Accountants including: RA, CA(SA), PA(SA) and BAP(SA); 

• Bookkeepers; 

• Accounting officers; and  

• Trainee accountants.  

Price 

This webinar is free. 

Steps to register for the event:  

If you already have a profile, login and register for the webinar. 

If you don’t have a profile, create a free profile then login and register for the webinar. 

Click here to create a free profile (There is no charge to create a profile and gain access to our free Monthly Practice Management Series). 

Click here to find out about the Technical Resource Centre & CPD Subscription options. 

Additional material 

  By attending this webinar you will be provided with: 

• Summarised slide presentation. 

• Reference documents and/or course material where available. 

• You can ask questions during the webinar and you will also have access to me the presenter after the webinar.