UEL-PQ3

New Excel - Power Pivot Dashboard creation

Form of participation
Form of training
Length of training
  • 1 day (1×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Outline

Review of Excel - Data Cleanup and Power Query and Power Pivot course material

Dashboard components and their use

Data Tables

Conditional formatting

Power Pivot

Display chart based on Power Pivot

Value curves, Mini charts

Using and linking slicers and time series

Connections, links between worksheets

Using and managing worksheet controls

Dashboard creation Workshop

Outline (PDF)

Prerequisites

Intermediate Excel skills, such as using complex, nested, conditional, multi-conditional functions.

The course also includes data cleansing, branching and writing multiple nested functions, for which knowledge of the above and/or previous intermediate Excel knowledge, if not essential, is strongly recommended.