Description
Working with Excel lists can be a tedious job. Are you looking for ways to get more out of your data? If so, consider using tables or PivotTables. Once you start working with them, you won’t be able to live without them. They help you analyse tables and calculate totals quickly and effortlessly – and there are many more features that help you save time when working in Excel. Follow our ‘Excel: Tables and PivotTables’ course to learn more.
Objectives
After this training, you’ll know how to:
- How to add complex filters through advanced functions
- How to use basic table functions effortlessly
- What to pay attention to when creating a table
- How to use PivotTables to analyse tables quickly and efficiently all PivotTable options
- What all PivotTable options are
- How to calculate sums in no time
- How to convert numbers into percentages or other formats automatically
- How to group data effortlessly
Target Group
Everyone who regularly uses data lists in Excel and wants to analyse data.
Prerequisites
You’ve completed the course ‘Excel: Introduction’ or your proficiency level is equivalent to this course.
Content
Part 1 Tables
- What is the difference between a list and a table?
- What are the advantages of tables?
- Table options: Formatting, banded rows, banded columns, total row, converting to range …
- Sorting (Default sorting, custom sorting (e.g.: months, weekdays)
- Filters (Autofilter, Slicer)
- Adding calculated fields to a table
- (Defining a custom table style)
Part 2 PivotTables
- Using recommended PivotTables
- The different parts of a PivotTable: filter fields, row fields, column fields and values
- Layout and structure of a PivotTable: PivotTable style, calculation layout, report layout (compact, outline, tabular)
- Subtotals (activating, deleting, activating only for certain fields…)
- Viewing calculations differently: % of grand total, % of row total, …
- Grouping data: text, dates, numbers
- What is the PivotCache?
- Filtering PivotTables using Slicers (general slicers and timeline slicers)
