Learn to utilise Pivot Tables to summarise data and streamline the process of formatting and displaying the results. Who should enrol: the experienced Excel user who wants to go beyond the basics with a special focus on analysing large tables of data or databases using Excel's Pivot Tables. You will already be confidently preparing charts and tables and using a range of formulae and functions. More details below course dates.
PivotTable is the single most powerful tool in Excel for financial reporting, budgeting and data analysis. This can save you hours and deliver impressive results. IBM are projecting that demand for Data Visualisation alone is projected to grow by 44% and PivotTable skills specifically by 34% by 2020. So this is an Excel skill that will be very useful to know.
This class is designed for the experienced intermediate level Excel user who wants to go beyond the basics with a special focus on analysing large tables of data or databases using Excel's Pivot Tables. You will already be confidently preparing charts and tables and using a range of formulae and functions.
This course is taught in a PC suite using the school's computers.
You should already be an experienced Excel user with skills in preparing charts and tables and using a range of formulae and functions.
(09) 521 9623
info@selwyncomed.school.nz
203-245 Kohimarama Road, Kohimarama
Open Hours
Term Time: Monday - Wednesday 9:00am - 9:00pm
Thursday - Friday 9:00am - 3:00pm
School Holidays: When courses are running the office is open 9:00am - 4:00pm