Excel 365 Level 3 Functions 2 - bespoke for Orbis

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
ICT & Digital Skills
Subject
ICT & Digital Skills
Course description

Is this course for you?



You want to broaden your knowledge of Excel functions. As well as IF, this course covers functions which are new in this version of Excel, including IFS and XLOOKUP (a superior version of VLOOKUP), and dynamic arrays, which mark the biggest change to Excel formulas in 30 years.



This course includes topics from the Excel Advanced course

Training objectives

Pre-requisites


The course assumes that delegates are familiar with:
entering simple formulas, copying formulas with AutoFill and locking cells with $ signs.



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.

Learning outcomes

At the end of the course, you will be able to use XLOOKUP to perform lookups in tables of data. You will also be able to enter and edit dynamic array formulas and use the FILTER, UNIQUE and SORT functions

Additional Information

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 will be delivered through Microsoft Teams.

Please note that the provider for this session is an external trainer. Once your place has been confirmed look out for invitation to join 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.

Enquiries
Start Date
Wednesday 23 June 2021
End Date
Wednesday 23 June 2021
Closing Date
Tuesday 22 June 2021
Times
10:00 - 11:30
Maximum Places
10 
Cost
Login to view cost
Number of Sessions
1