This is the ideal course for people who regularly need to extract data and put it into a format that enables quick analysis of large amounts of information.
- Creating pivot tables and adding in data
- Creating pivot charts
- Changing the pivot table layout
- Making separate pivot tables
- Refreshing data and updating pivot tables
- Using custom calculations in a pivot table
- Grouping and ungrouping pivot table items
Improved decision making from efficient data analysis using pattern recognition. Providing a report creation tool for moving ‘unorganised’ to ‘organised’ data.