Analysing Data with Excel Tables and Pivot Tables
- Storing hundreds or thousands of records on an Excel sheet is great if that is all you want to do, however, when you need to analyse these records, then a thorough understanding of Excel Tables, Pivot Tables and Slicers, is essential.
- This half-day course provides learners with full support and understanding to create worksheets that meet all conditions required to produce accurate statistic to then present high level overview through reports or charts.
- This course covers how to set up conditions within a worksheet, optimising data using Excel Tables, Pivot Tables, Slicers.
- How to correctly store date, meeting required conditions
- Generate statistics on the data sets
- Present a high level overview through reports or charts
- Set up Excel spreadsheets
- How to analyse the data using Filters
- How to analyse the data using Advance Filters
- How to analyse the date using Tables and Pivot Tables