Power Query

Pobieranie i przekształcanie danych.

Oferta

Zajęcia indywidualne, kursy grupowe, szkolenia dla firm.

Program szkolenia

8h

1.   Get data

  • From Table/Range
  • From File (Excel, Text, CSV, Folder)
  • From Web

2.   Load queries

  • Automatic (New Worksheet)
  • Existing Worksheet
  • Only Create Connection
  • Pivot Table Report
  • Pivot Chart

3.   Refresh

  • Automatic
  • On demand
  • VBA

4.   Transform

  • Remove Columns, Rows
  • Split Column
  • Use First Row as Headers
  • Replace Values
  • Fill
  • Rename
  • Format
  • Date & Time
  • Mathematical & Statistical Operations
  • Column From Examples
  • Custom Column
  • Conditional Column
  • Index Column
  • Duplicate Column
  • Power Query vs. VBA macros

5.   Filter and Sort

6.   Combine queries

  • Merge
  • Append

7.   Pivot table

  • Pivot Table
  • Pivot Chart
  • Power Query – Group By
  • Power Query – Pivot Column
  • Power Query vs. Pivot Table