Excel Database Management and PivotTables

Prerequisites:

Skills equivalent to our Excel Intermediate course level, mainly the basic concepts about databases (lists): sorting, filters, ..

Purpose of this training:

Important decisions are often made based on the available figures. How can we analyze these figures? PivotTables allow us to get a structural view on our abundance of information. This course will teach you some techniques to be able to better interpret your figures.

Content:

Introduction

  • What is a PivotTable?
  • Parts of a PivotTable
  • Sample database and guidelines for a database

Create and modify

  • Method for creation
  • Rearranging the parts
  • Refresh data
  • Extended options

Format

  • Field settings
  • Modify functions
  • Custom styles

Types of PivotTables

  • Aligned PivotTable
  • PivotTable with filters
  • Sorted PivotTable
  • A top PivotTable
  • PivotTable with grouped items
  • PivotTable with detail
  • PivotTable with a calculated field
  • PivotTable with calculated item
  • PivotTable in percentage
  • PivotTable with a running total
  • PivotTable on different pages

Pivot charts

  • Method
  • Examples

Functions

  • The function GetPivotData
  • Examples

Pivots based on multiple tables

  • Linking tables
  • Making a pivot based on more than one table

Slicers and timeline

  • How to use a slicer?
  • Linking a slicer on more than one pivot
  • Using a timeline

Practical information

Date:

1 day: 28 May 2020

Hours:

from 9h30 till 17h00

Location:

Campus Drie Eiken - Building M - room M.306

Teacher:

Bit by Bit

Language of the course:

English

Docop-points:

This course counts for 0,7 docop-points.

Registration:

Via Sisa Selfservice. Log in with your student account.