In our day to day work environment we tend to use Excel’s great features of calculation, sorting and storing information to create efficient, functional spreadsheets. However, there are other elements within Excel that can transform spreadsheets into powerful and efficient business tools. The PivotTable is probably Excel's most powerful feature set. A PivotTable is a powerful tool to calculate, summarise, and analyse data that lets you see comparisons, patterns, and trends in your data. On completion of this half-day workshop, delegates will be familiar with using PivotTables, PivotCharts and Slicers to calculate, analyse and summarise data.
Those who are familiar with the basics of Excel but who wish to learn more about the capabilities of PivotTables. Anyone who needs to extract information from large data sets. Delegates should already be using Excel on a regular basis. They should also be familiar with creating and editing spreadsheets and with the basics of calculation and formatting.