Remote training Excel PowerPivot: Use more power in Excel

  • Course types: Custom webinar
  • Duration: Half a day

Description

Are you already juggling with PivotTables in Excel? Then you will undoubtedly go wild with PowerPivot. In this session you will learn how to effortlessly merge an Excel list with an Access database. Or with a table originating from an SQL server. And not only that, this rock-solid tool has masses of new functions that enable you to analyse table data even better. Need to compile complex business reports? In this demo training session, we will be taking a closer look at how to do this.

Objectives

After this remote training, you can easily:

  • Import lists from a variety of data sources
  • Create PivotTables with data from different lists
  • Optimise a PowerPivot data model

Target Group

Anyone already familiar with PivotTables, but who would like to find out about an even more powerful analysing tool.

Prerequisites

Basic PivotTables operations (the different sections, change calculations, ...) are not new to you.

Content

1. Installing PowerPivot

  • Linking an Excel table
  • Creating a fixed table in PowerPivot
  • Importing an Excel table
  • Importing text files
  • Importing data from other data sources (Access, SQL, ODBC…)
  • Maintaining connections
  • Updating data

3. Working in the PowerPivot window

  • What are the differences compared to the Excel datasheet?
  • The different data types
  • Adding and deleting fields/columns
  • Sorting
  • Filtering

4. Optimizing the PowerPivot data model

  • Defining relationships between tables
  • Defining Date Table
  • Correctly sorting months, weekdays, ...
  • Setting standard calculations
  • Hiding columns in Excel/data model
  • Creating and using a hierarchy
  • Creating and using a perspective

5. PowerPivot PivotTables

  • Creating a PowerPivot PivotTable
  • Differences compared to an Excel PivotTable
  • Filtering a PowerPivot PivotTable using slicers

Request an offer



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

Requesting a quotation

Would you like to organize this webinar for your employees? We transform your requirements into the perfect solution.

Request

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com