Advanced Excel: Power Query & Power Pivots

Course Info

Date: July-04-2022

Length: 1 Week

City: Istanbul

Fees: 3,900

Type: In Classroom

the date is no longer available,
kindly check other dates from the table below

Available Dates

  • Aug-22-2022

    Istanbul

  • Sep-05-2022

    Istanbul

  • Oct-10-2022

    Istanbul

  • Oct-31-2022

    Istanbul

  • Nov-07-2022

    Istanbul

  • Nov-28-2022

    Istanbul

  • Dec-12-2022

    Istanbul

  • Dec-26-2022

    Istanbul

  • Dec-27-2022

    Istanbul

  • Jan-24-2023

    Istanbul

  • Feb-07-2023

    Istanbul

  • Mar-28-2023

    Istanbul

  • Apr-11-2023

    Istanbul

  • May-16-2023

    Istanbul

  • June-27-2023

    Istanbul

  • July-04-2023

    Istanbul

Dates in Other Venues

  • Aug-15-2022

    Madrid

  • Aug-22-2022

    Amsterdam

  • Aug-29-2022

    Paris

  • Aug-29-2022

    London

  • Aug-29-2022

    Singapore

  • Aug-29-2022

    Dubai

  • Aug-29-2022

    Barcelona

  • Aug-29-2022

    Munich

  • Sep-05-2022

    London

  • Sep-05-2022

    Singapore

  • Sep-05-2022

    Dubai

  • Sep-19-2022

    Paris

  • Sep-19-2022

    Zurich

  • Sep-19-2022

    Barcelona

  • Sep-19-2022

    Munich

  • Sep-26-2022

    Madrid

  • Sep-26-2022

    London

  • Sep-26-2022

    Amsterdam

  • Sep-26-2022

    Dubai

  • Oct-03-2022

    Dubai

  • Oct-10-2022

    Paris

  • Oct-10-2022

    Madrid

  • Oct-10-2022

    London

  • Oct-10-2022

    Zurich

  • Oct-10-2022

    Amsterdam

  • Oct-10-2022

    Singapore

  • Oct-10-2022

    Barcelona

  • Oct-10-2022

    Munich

  • Oct-31-2022

    Paris

  • Oct-31-2022

    Madrid

  • Oct-31-2022

    London

  • Oct-31-2022

    Zurich

  • Oct-31-2022

    Amsterdam

  • Oct-31-2022

    Singapore

  • Oct-31-2022

    Dubai

  • Oct-31-2022

    Barcelona

  • Oct-31-2022

    Munich

  • Nov-07-2022

    Paris

  • Nov-07-2022

    Madrid

  • Nov-07-2022

    London

  • Nov-07-2022

    Zurich

  • Nov-07-2022

    Amsterdam

  • Nov-07-2022

    Singapore

  • Nov-07-2022

    Dubai

  • Nov-07-2022

    Barcelona

  • Nov-07-2022

    Munich

  • Nov-28-2022

    Paris

  • Nov-28-2022

    Madrid

  • Nov-28-2022

    London

  • Nov-28-2022

    Zurich

  • Nov-28-2022

    Amsterdam

  • Nov-28-2022

    Singapore

  • Nov-28-2022

    Dubai

  • Nov-28-2022

    Barcelona

  • Nov-28-2022

    Munich

  • Dec-05-2022

    Zurich

  • Dec-05-2022

    Amsterdam

  • Dec-05-2022

    Dubai

  • Dec-12-2022

    Paris

  • Dec-12-2022

    Madrid

  • Dec-12-2022

    London

  • Dec-12-2022

    Singapore

  • Dec-12-2022

    Barcelona

  • Dec-12-2022

    Munich

  • Dec-26-2022

    Kuala Lumpur

  • Dec-26-2022

    Paris

  • Dec-26-2022

    Madrid

  • Dec-26-2022

    London

  • Dec-26-2022

    Zurich

  • Dec-26-2022

    Amsterdam

  • Dec-26-2022

    Singapore

  • Dec-26-2022

    Dubai

  • Dec-26-2022

    Barcelona

  • Dec-26-2022

    Munich

  • Dec-27-2022

    Paris

  • Dec-27-2022

    Madrid

  • Dec-27-2022

    London

  • Dec-27-2022

    Zurich

  • Dec-27-2022

    Amsterdam

  • Dec-27-2022

    Singapore

  • Dec-27-2022

    Dubai

  • Dec-27-2022

    Barcelona

  • Dec-27-2022

    Munich

  • Jan-03-2023

    London

  • Jan-03-2023

    Dubai

  • Jan-10-2023

    Paris

  • Jan-10-2023

    Zurich

  • Jan-10-2023

    Singapore

  • Jan-10-2023

    Barcelona

  • Jan-10-2023

    Munich

  • Jan-17-2023

    London

  • Jan-23-2023

    Kuala Lumpur

  • Jan-24-2023

    Dubai

  • Jan-31-2023

    Madrid

  • Jan-31-2023

    Amsterdam

  • Feb-07-2023

    Paris

  • Feb-07-2023

    London

  • Feb-07-2023

    Dubai

  • Feb-07-2023

    Barcelona

  • Feb-07-2023

    Munich

  • Feb-07-2023

    Munich

  • Feb-21-2023

    Madrid

  • Feb-28-2023

    Zurich

  • Feb-28-2023

    London

  • Feb-28-2023

    Dubai

  • Feb-28-2023

    Amsterdam

  • Feb-28-2023

    Singapore

  • Mar-07-2023

    Zurich

  • Mar-07-2023

    Madrid

  • Mar-07-2023

    London

  • Mar-07-2023

    Dubai

  • Mar-14-2023

    Singapore

  • Mar-21-2023

    Amsterdam

  • Mar-28-2023

    Paris

  • Mar-28-2023

    London

  • Mar-28-2023

    Dubai

  • Mar-28-2023

    Barcelona

  • Mar-28-2023

    Munich

  • Mar-28-2023

    Munich

  • Apr-04-2023

    Singapore

  • Apr-04-2023

    London

  • Apr-04-2023

    Dubai

  • Apr-11-2023

    Paris

  • Apr-11-2023

    Madrid

  • Apr-11-2023

    Amsterdam

  • Apr-11-2023

    Barcelona

  • Apr-11-2023

    Munich

  • Apr-11-2023

    Munich

  • Apr-18-2023

    Zurich

  • Apr-25-2023

    London

  • Apr-25-2023

    Dubai

  • May-02-2023

    Dubai

  • May-09-2023

    Zurich

  • May-09-2023

    London

  • May-16-2023

    Singapore

  • May-16-2023

    Paris

  • May-16-2023

    Barcelona

  • May-16-2023

    Munich

  • May-16-2023

    Munich

  • May-30-2023

    Madrid

  • May-30-2023

    London

  • May-30-2023

    Dubai

  • May-30-2023

    Amsterdam

  • June-06-2023

    Paris

  • June-06-2023

    London

  • June-06-2023

    Dubai

  • June-06-2023

    Amsterdam

  • June-06-2023

    Barcelona

  • June-06-2023

    Munich

  • June-20-2023

    Madrid

  • June-27-2023

    Singapore

  • June-27-2023

    Zurich

  • June-27-2023

    London

  • June-27-2023

    Dubai

  • July-04-2023

    Madrid

  • July-04-2023

    London

  • July-04-2023

    Dubai

  • July-11-2023

    Singapore

  • July-11-2023

    Paris

  • July-11-2023

    Amsterdam

  • July-11-2023

    Barcelona

  • July-11-2023

    Munich

  • July-18-2023

    Zurich

  • July-25-2023

    London

  • July-25-2023

    Dubai

  • Aug-08-2023

    Zurich

  • Aug-08-2023

    London

  • Aug-08-2023

    Dubai

Course Details

Course Outline

5 days course

 

Key functions to prepare data for pivot table reporting
 
  • Table format
  • Lookup functions
  • Text functions
  • Naming cells

 

Advanced techniques in creating and customizing pivot tables
 
  • Number and cell format
  • Report layout
  • Calculation in value field
  • Grouping and un-grouping fields

 

Default and customized sorting and filtering
 
  • Sorting using custom list
  • Creating calculated field
  • Filtering using slicers and timelines
  • Connecting multiple pivot tables to one set of slicers
  • Customizing reports using the GetPivotData option

 

 
Power Query: A must-have skill
 
  • Introduction to this new feature
  • Where does Power Query fit in the Power family!
  • Get and transform: Link your Excel to external other data sources
    • Excel files
    • Text files
    • Web
    • SQL
  • Creating and editing the Query
  • Get data from: Tables, files and folders
  • Power Query to clean up data
  • Practical examples:
    • UnPivotting data
    • Working with nested column headers and merged cells
    • Naming, merging, splitting and removing columns
    • Filtering rows in different ways
    • Transforming and formatting data
    • Combining queries: Merge and Append
      • The different types of joining data

 

Analyzing disparate data sources with pivot tables
 
  • Utilizing pivot table wizard
  • Using internal data model
  • Building pivot tables using external data sources

 

The new world of PowerPivot
 
  • Benefits and drawbacks of PowerPivot
  • Merging data from multiple tables without using Vlookup
  • Creating better calculations using the DAX Formulas
  • Using DAX to create calculated fields
  • Calculate and Related functions

Course Video