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.
ICT Skills / ESCC Staff / Schools and Governors / Voluntary and Community Sector / Public Sector Partners (eg NHS, Police, Probation)
No categories found
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
Turbo charged analysing data!
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
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 firstname.lastname@example.org