Following government advice, ESCC have made the decision to postpone or cancel some face to face training.
This decision has been made in light of the national concerns about the spread of the coronavirus (COVID - 19). Please see individual courses for more information.

View Details

Excel 365 Level 4; Advanced Data Handling and Analysis

Venue
East Sussex Training & Development Centre (St Mary's House), St Mary's House, St Leonard's Road
venue
Admin Contact
Corporate Training Mail Box (corporate.training@eastsussex.gov.uk)
Target Audience
No targets found
target audience
Course Types
Course
Course categories
ICT Skills / ESCC Staff / Schools and Governors / Voluntary and Community Sector / Public Sector Partners (eg NHS, Police, Probation)
Subject
No categories found
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

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