Search for Learning and Development Services and Pathways

Course Type
2 courses found

Page 1 of 1

Code: ESC/21/336 Excel 365 Level 2 Functions 1

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'.


The training is expected to be delivered through Microsoft Teams.

Is this course for you?


You can enter simple formulas in a workbook, and wish to extend your skills using functions to perform tasks such as: finding the average of a set of data; counting data entries which match specified conditions; looking up data entries in a table.
This course includes topics from the Excel Performing Calculations and the Excel Advanced Calculations courses

 

Essential Information
Session Session Date Session Time Session Venue Map
1 09 July 2021 10:00 - 11:30 Remote Corporate Training Map

Code: ESC/21/362 Excel 365 Level 3 Power Query and the Data Model - Orbis bespoke

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.

Essential Information
Session Session Date Session Time Session Venue Map
1 09 July 2021 14:00 - 15:30 Remote Corporate Training Map