Tables and Pivot tables are two of Excel's most powerful features. Tables allow you to manage and analyse your data in Excel quickly and easily. Learn how to insert, sort and filter a table, and how to display a total row at the end of a table A pivot table allows you to extract the significance from a large, detailed data set. This course is designed to develop experience and confidence in using the Excel Tables and PivotTables to analyse data and produce sophisticated management reports. Discover how to perform a variety of calculations with Pivot Table Data. You will learn how to construct Pivot Tables and Charts to consolidate and summarise your data.
Users needing to manipulate and analyse data stored in Excel lists using pivot tables.
Participants must have an intermediate level knowledge and experience with Microsoft Excel.
|Event End Date||31-01-2018|
|Location||Corporate Training Solutions Australia|