Course Outline


  • new possibilities Excelaw Business Intelligence
  • what is Power Query
  • what is PowerPivot
  • what is Power View
  • what is Power Map
  • what is Power Inquire
  • what is solver
  • installing add-ons

Power Query Add-in

  • import and transformation of file sources
  • import and transformation of Internet sources

Introduction to PowerPivot and working with data

  • overview of slicer controls
  • data filtering
  • cell formatting
  • changing data type
  • datasheet customization

Downloading data from various sources into PowerPivot

  • downloading data from databases
  • downloading data from MS Excel
  • downloading data from TXT files
  • downloading Copy-Paste data
  • creating linked tables

Create pivot tables using PowerPivot

  • creating a pivot table
  • reorganizing the pivot table
  • adding calculated measures to a pivot table
  • changing the type of pivot table functions

Create pivot charts using PowerPivot

  • creating a pivot chart
  • reorganizing a pivot chart

Refreshing data in a PowerPivot worksheet

Creating and managing relationships in PowerPivot

Introduction to DAX expressions (Data Analysis Expressions)

  • DAX overview
  • types of functions
  • operators
  • calculated columns and measures
  • Error handling

Power View Sheets


  • sorting
  • filtration
  • charts
  • maps

Solver Add-in

  • problems that can be solved with an add-on
  • tool configuration overview
  • optimization examples

Inquire add-on

  • discussion of the concept of the add-on
  • sheet design review


Knowledge of Windows and knowledge of the basics of the program Microsoft Excel.

 14 Hours

Number of participants

Price per participant

Testimonials (5)

Related Categories