Excel – Brand new Lookup Functions
Overview
Exciting new features from Excel (Finally!)
In January 2020, to Microsoft customers subscribing to Office 365 and Monthly updates, Microsoft has rolled out a number of new features. These include some amazing new lookup features, XLOOKUP and XMATCH.
Attend this session to learn how to accelerate your lookups and find solutions to joining lists, tables, matrixes and more.
Supercharge your excel use and be amongst the first to have a handle on these new functions.
Learning Outcomes:
Be able to articulate and effectively use Excel’s new reference functions such as VLOOKUP, HLOOKUP and XLOOKUP and XMATCH
Suited to:
Anyone in any firm who needs to use Excel to reference more than one spreadsheet together.
You will also be provided with:
- The PowerPoint Presentation Slide deck
- A Searchable Transcript
- Any Supporting Documentation
Course syllabus
3 lessons
- Excel – Brand new Lookup FunctionsVideo
- FeedbackSurvey
- Knowledge QuizTest
Your presenter
Nick Beaugeard – CEO and Founder of HubOneHubone
HubOne is a software company which develops solutions for Accounting Firms. Nick has been in the technology industry for over 25 years working in large software vendors including Microsoft and holding executive roles at JP Morgan and National Westminster Bank. Nick also leads the Australian and New Zealand Emerging technology community of CompTIA, the world’s largest IT industry association.
Nick is technically certified across multiple software development languages, standards, practices and platforms and works predominantly in emerging technology. Nick lives on Sydney’s Northern beaches with his wife and 4 kids.