Excel Weekend 7 - Everything you need to know about XLOOKUP - Wyn Hopkins, MVP

Описание: Wyn planted the seed for the development of XLOOKUP back in May 2016 by posting a suggestion on UserVoice for a simpler and safer version of VLOOKUP and INDEX MATCH and then campaigning for it via social media for several years

XLOOKUP is a much cooler name than his original suggestion of GETMATCH, and has even more functionality than this request. Find out how to use it fully in this session.

Wyn Hopkins, MVP (Australia).

Wyn Hopkins has been an Excel MVP since 2017. He qualified as a Chartered Accountant in 2000 with PricewaterhouseCoopers and then went on to work as a Financial Analyst with HBOS and the Barclays Group. In 2007 he emigrated to Australia and joined Access Analytic in Perth, being currently a director.

Wyn utilises advanced Excel and Power BI techniques including Power Query, Power Pivot, DAX and VBA to build applications that help companies address their reporting, automation and analysis needs. He is co-author of the book Excel Insights: A Microsoft MVP guide to the best parts of Excel.

Next talk:    • Excel Weekend 7 - Techniques for Better Fo...  

Open talks from Excel Weekend 7:    • Excel Weekend 7  

Exclusive talks from Excel Weekend 7: http://excelweekend.com/7/freepass/

Subscribe:
https://www.youtube.com/ExcelTurbo/?s...

#ExcelWeekend #EW7 #ExcelTurbo #Microsoft #Excel #MicrosoftExcel #MSExcel #Spreadsheet #Technology #Tutorial #AccessAnalytics #XLOOKUP #VLOOKUP #INDEXMATCH #MVPBuzz