Excel: Databases and PivotTables

  • Duration: 1 day

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: Databases and PivotTables’ course to learn more.

Objectives

After this training, you’ll know:

  • How to use basic table functions effortlessly
  • What to pay attention to when creating a table
  • How to add complex filters through advanced functions
  • How to use PivotTables to analyse tables quickly and efficiently all PivotTable options
  • 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 Lists and tables

  • What is a list or a table?
  • Split text quickly with Flash Fill
  • Define a table
  • Choose a table style using the ribbon
  • The ‘Table Tools’ contextual tab
  • Define a custom table style
  • Format a table: banded rows, banded columns, show totals
  • Sort a table
  • Filter a table using the autofilter
  • Filter a table using the advanced filter
  • Filter a table using slicers
  • Convert a table back to a range
  • Add calculated fields to a table

Part 2 PivotTables

  • Recommended PivotTables
  • The components of a PivotTable: Filter Fields, Row Fields, Column Fields and Values
  • Create a PivotTable based on one table
  • Create a PivotTable based on several tables via a data model
  • Create relationships between different tables in the data model
  • Format a PivotTable with the ribbon: banded rows/columns, PivotTable Styles
  • Show subtotals at the top/bottom
  • Delete subtotals
  • Edit calculations: sum, count, average, min, max, distinct count
  • Format calculations: number of decimals
  • View calculations differently: % of grand total, % of row total, …
  • Group data: text, data, numbers
  • Analyse data from an external database using a PivotTable
  • Use slices to filter a PivotTable (general slicers and timeline slicers)

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

This training as in-company training?

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request