In light of continuing Government advice regarding the spread of coronavirus (Covid-19) and social distancing, the majority of our face to face courses remain cancelled. Alternatively, we are pleased to offer an increasing range of online and virtual courses. Please see individual courses for details.

View Details

Excel 365 Level 3 Power Query and the Data Model

Venue
Remote Corporate Training, Not a geographical location
venue
Admin Contact
Corporate Training Mail Box (corporate.training@eastsussex.gov.uk)
Target Audience
All users
target audience
Course Types
Course
Course categories
ESCC Assessment & Care Management / ESCC Directly Provided Services / ICT Skills / ESCC Staff / Early Years and Childcare / Schools and Governors / Voluntary and Community Sector / Public Sector Partners (eg NHS, Police, Probation)
Subject
ICT Skills
Course description

Please note - this is a "remote" session, and if applying, you should note the additional information in "full details" regarding joining the session.


Is this course for you?



You are familiar with creating simple Pivot Tables from Excel data.


You want to find ways of quickly cleaning up and merging data for use in a Pivot Table, or you have data in several different tables which you want to analyse in one Pivot Table.


This course includes topics from the Excel Advanced course


Pre-requisites
The course assumes that delegates are familiar with: creating Pivot Tables in Excel.



To take part in this course, delegates will need an internet-connected device with camera and microphone, and an internet connection which can stream video in reasonable quality.

Training objectives

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.

Learning outcomes

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



  • Advantages of using the Data Model

  • View and edit data in the Model

  • 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

Additional Information

The provider for this session is an external trainer. Once your place has been confirmed look out for invitation to join the session from pmseaman@gmail.com

Accept the invitation (and be sure to check your spam folder as well in case it has slipped into that) and the session will automatically drop into your Outlook calendar. 

Delegates' email addresses as registered on the portal will be provided to the trainer for the purpose of conducting this training only.

Delegates should ensure that their work (not personal) email addresses are recorded - check and update as necessary through 'My Profile and Bookings/Change Contact Details'.

It is expected that this training will be delivered through Microsoft Teams.

Enquiries
Start Date
Thursday 24 September 2020
End Date
Thursday 24 September 2020
Closing Date
Wednesday 23 September 2020
Times
10:00 - 11:30
Maximum Places
10 
Cost
Login to view cost
Number of Sessions
1