Description

Tired of endless lists in Excel and want to get more out of your data? How about a table, or even a pivot table? If PivotTables are still a mystery to you, wait until you start working with them: you won't want to go back. They let you analyse your tables quickly and calculate your totals in no time. Excel has so many more features that can save you a lot of time once you get started. And that's exactly what you'll learn in the course "Excel: Tables and pivot tables".

Objectives

After this Excel training you will:

• Know how to use advanced functions to apply complex filters

• Work more fluently with the basic functions of tables

• Know what to watch out for when creating a table

• Know all the options of PivotTables

• Be able to calculate your totals in no time

• Automatically convert numbers into percentages or other formats

• Group data effortlessly

Target audience

Anyone who regularly works with data lists in Excel and wants to analyse their data.

Prerequisites

You've taken the course Excel: Introduction or have an equivalent skill level.

Contents

Part 1: Tables

• Difference between a list and a table

• Benefits of tables

• Table options: formatting, banded rows/columns, total row, converting to a range

• Sorting: standard and custom (e.g. months, weekdays)

• Filters: AutoFilter, Slicer

• Adding calculated fields to a table

• (Defining your own table style)

Part 2: pivot tables

• Using Recommended PivotTables

• Parts of a pivot table: filter fields, row fields, column fields, values

• Layout and structure: style, calculation layout, report layout (compact, outline, tabular)

• Subtotals: activating, removing, specific fields

• Displaying calculations differently: % of grand total, % of row total, etc.

• Grouping data: text, dates, numbers

• What is the PivotCache?

• Filtering PivotTables with slicers (standard and timeline slicers)