Excel 365 Pivot Tables Advanced – Power Query & The Data Model

  • Available
  • 9th Oct 24
  • 9.30am-12.30pm
  • Remote Via MS Teams
    Remote via MS Teams
  • £40for members £for non-members

Overview

At the end of the course, you will understand the Excel data model. You will be able to import data into Power Query and use tools to clean it up before saving the data in the Data Model. You will be able to refresh your query when the data changes, and know how to create relationships between data tables, so you can build a Pivot Table using fields from multiple tables.

This course will enable you to

Understand Excel data flow

See how Excel’s data handling and analysis tools fit together

Get and Transform data

Import data from different sources
Load data into Power Query

Power Query

Use Power Query tools to clean, merge, split and transform your data
Merge data from multiple files in the same folder
Load the data into the Excel Data model
Refresh a query to automatically process changed data

The Data Model

Learn the advantages of using the Data Model
View and edit data in the Model
Understand the importance of key fields

Pivot Tables

Create a Pivot Table using data in the Data Model
Use data from multiple tables
Create relationships between tables

Refresh Data

Refresh a Pivot Table and workbook queries

Who is the Course aimed at

Delegates who want to find ways of quickly cleaning up and merging data for use in a Pivot Table, or have data in several different tables which they want to analyse in one Pivot Table.  Delegates must be familiar with creating simple Pivot Tables from Excel data.

Excel 365 Pivot Tables Advanced – Power Query & The Data Model

  • Available
  • 9th Oct 24
  • 9.30am-12.30pm
  • Remote Via MS Teams
    Remote via MS Teams
  • £40for members £for non-members
Book

Other occurances of this programmes

Can't make this training?

Get notified when this
course is on next.

Get notified of next event