Skip to main content

Excel: Tables and PivotTables

Version: Microsoft 365
Learning format: Classroom training at your premises
Duration: 1 day (09:00-17:00)
Price for this incompany training (max 12p): € 1210 VAT excl. / Terms for incompany training.

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, Advanced filter, 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)
  • Intro to Power Pivot: Creating a PivotTable based on multiple tables
View all our trainings

Request for quotation

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?
This field is for validation purposes and should be left unchanged.