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
- 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
- Difference between a list and a table
- Advantages of tables
- Table options: formatting, banded rows/columns, total row, converting to range
- Sorting: default and custom (e.g. months, weekdays)
- Filters: AutoFilter, Slicer
- Adding calculated fields to a table
- (Defining a custom table style)
Part 2: PivotTables
- Using recommended PivotTables
- Parts of a PivotTable: filter fields, row fields, column fields, values
- Layout and structure: style, calculation layout, report layout (compact, outline, tabular)
- Subtotals: activating, deleting, specific fields
- Viewing calculations differently: % of grand total, % of row total, etc.
- Grouping data: text, dates, numbers
- What is the PivotCache?
- Filtering PivotTables using slicers (general and timeline slicers)
