Excel PowerPivot: Module 2 - Functions for powerful data analysis

  • Duration: 1 day

Description

Excel's strong data analysis tool PowerPivot? Get to know it better during our training course ‘Excel PowerPivot – Functions’!

You may already have noticed that PowerPivot contains a lot of new functions. Some of these functions are fairly intuitive to use, but for most you may need the help of a PowerPivot expert, using explicit examples to show you the true power of these functions in combination with PivotTables.

Sign up now for the course ‘Excel PowerPivot – Functions’ and optimize your knowledge.

Objectives

Are you struggling with the functions in PowerPivot?

Register now, to:

  • Acquire an understanding of the different types of functions in PowerPivot
  • Know how to implement the functions for your own analysis solutions

Anyone who is already familiar with PowerPivot and wants to learn more about and know how to use the functions.

Prerequisites

It is important to have completed the course ‘Excel PowerPivot – Module 1: Introduction’.

Content

Context

  • Row Context
  • Filter Context
  • Query Context

General functions

  • Blank
  • Calculate
  • Countrows
  • Hasonevalue
  • Switch
  • Summarize

Filter functions

  • All
  • AllExcept
  • Earlier
  • Filter
  • Lookupvalue
  • Rankx
  • TopN
  • Values

Date and Time Intelligence functions

  • DateAdd
  • Datesbetween
  • DatesInPeriod
  • Datesytd/Datesmtd/Datesqtd
  • Endofmonth/Endofquarter/Endofyear
  • Firstdate/lastdate
  • Firstnonblank/Lastnonblank
  • Nextday/Nextmonth/Nextquarter/Nextyear
  • Previousday/Previousmonth/Previousquarter/Previousyear
  • SamePeriodLastYear
  • Startofmonth/Startofquarter/Startofyear
  • Totalytd/Totalmtd/Totalqtd

KPI (Key Performance Indicators)

  • Creating a KPI in PowerPivot

Cube functions (optional)

  • Convert data from PivotTables to functions

Working with multiple date fields (optional)

  • Multiple relationships between a table and the date table
  • Multiple date tables

Retrieving information from the model in Excel

  • Evaluate

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 and/or with adapted content? We transform your requirements into the perfect solution.

Request