Excel

Lookup Functions

Every Excel user knows that VLOOKUP is a tricky function to manage, but there are alternatives few people are aware of. This session will explore the other lookup functions on offer including HLOOKUP, INDEX, MATCH and for Microsoft 365 users XLOOKUP. We look at the pros and cons of each so that you can confidently use the right one for your particular circumstances. Intermediate level.

Events

Date
Apr 9, 2024
Time
2:00 PM

You must be logged in to access these events.

login or register

Related Courses

FAQ's

You can view the system in your local time by going to My Account > Edit Profile (Or click the timezone in the top bar > edit profile), once here you'll see a dropdown called timezone. If you change this to your timezone the platform will reflect this.
If you go to the My Account area, you will see all the learning events you’ve attended. You can download the related handouts for as long as you maintain your subscription. You can watch recordings of all events for up to 30 days after the event.
If you go to the My Account area, you will see all the learning events you’ve attended. You can access the recording of any session you attended for 30 days afterwards.
They will be emailed to you automatically and are accessbile via the certificates tab on the My Account page.
Any courses or modules which are CPD accredited are clearly indicated
There may be an issue with your choice of speaker, please check your settings in Zoom.
Yes – our courses are designed to be accessed using any mobile device
On your Login page, hit the Forgotten Password button. Follow the instructions on the next Reset Password screen and you’re done!
Duration
60 Mins
Facilitator
David Millard
Recommendation
100%
of Users who said they'd recommend this course.
On Demand
Please login to access On Demand content. login
Login / Register
in order to access events you must have an Account.
Login / Register