Webinar Excel: PowerPivot: much more than PivotTables

  • Course types: Custom webinar
  • Duration: 1 hour

Description

Is an increasing amount of data supplied to you in a variety of formats? And do you have to first fill a string of columns with the vlookup function before you can create a PivotTable? Does this make your workbook too large and too slow? Do you find you are wasting time each time you have to set up your calculations in each PivotTable in exactly the same way? Would you like to be able to make calculations in a PivotTable that are not a default option? Or have you already heard a lot about PowerPivot, only you don't know how to apply it in Excel? If your answer to one or more of the above questions is ‘Yes’, then this introduction to PowerPivot is for you! In this webinar you will acquire an understanding of the main PowerPivot features compared to the standard PivotTables in Excel. You will be able to experience what you've missed out on for so long.

Objectives

After completing this course you will know all about the benefits of PowerPivot PivotTables compared to standard Excel PivotTables.

Target Group

Anyone who frequently creates PivotTables

Prerequisites

A sound knowledge of Excel PivotTables

Content

Part 1: Multiple tables

  • Relationships between tables
  • PivotTable based on multiple tables

Part 2: Amount of data

  • Performance when dealing with huge volumes of data

Part 3: Extra functionalities

  • Defining standard calculations
  • Hierarchies

Part 4: Amount of data

  • Reusing calculations
  • Additional options compared to Excel PivotTables

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