Excel 365 Level 4; Advanced Data Handling and Analysis (Cancelled)

Reason for cancellation
East Sussex Training & Development Centre (St Mary's House), St Mary's House, St Leonard's Road
Admin Contact
Corporate Training Mail Box (corporate.training@eastsussex.gov.uk)
Target Audience
All users
target audience
Course Types
Course categories
ESCC Assessment & Care Management / ESCC Directly Provided Services / ICT & Digital Skills / ESCC Staff / Schools and Governors / Voluntary and Community Sector / Public Sector Partners (eg NHS, Police, Probation)
ICT & Digital Skills / Personal Development
Course description

Do you handle large amounts of data in the course of your work?

Do you spend a lot of time cleaning up data and preparing it for analysis?

Do you need to combine data from different data sets?

This new course covers two major Excel 365 tools which should make your job easier– Power Query and Power Pivot.

The course is for you if you are familiar with the topics covered in the Excel Analysing Data course, in particular creating and manipulating Pivot Tables, and can create worksheet formulas and use Excel functions such as IF and VLOOKUP

Training objectives

Turbo charged analysing data!

Learning outcomes

Learn how to;

  • import data from a variety of sources and be able to produce a data table suitable for use in Pivot Tables and other Excel analysis.

  • store the steps you have taken to prepare the data, and when the data changes a simple refresh will trigger Power Query to repeat the preparation process on the new data.

  • Power Query can handle many millions of rows

  • analyse data from multiple tables without relying on VLOOKUP, and to create formulas for more advanced analysis, using Power Pivot

Additional Information

Please note:

Parking around St. Mary's House is scarce due to limited parking.

Corporate Training offer a selection of teas/coffees, hot chocolate and biscuits.

A handout covering the main course topics will be provided.

If you are in Adult Social Care and require funding for this course please contact sara.lewis@eastsussex.gov.uk

Start Date
Wednesday 4 November 2020
End Date
Wednesday 4 November 2020
Closing Date
Tuesday 3 November 2020
13:30 - 16:30
Maximum Places
Login to view cost
Number of Sessions