LandingPage-Excel-Extras-New-Formula-Functions-Ondemand

Please enter your details below

Overview:

Join Roger Knowles, QA's Senior Technical Learning Specialist - End User Applications for this fantastic free session where he will impart some of his expertise on Excel's latest new functions.

This webinar will take you through some of the latest Excel Functions used when writing formulas:

• XLOOKUP / XMATCH

• SORT • FILTER

• UNIQUE

See how XLOOKUP or XMATCH can be used as an alternative to existing Excel functions like VLOOKUP or Index/Match. Using functions like SORT and UNIQUE to create quick dynamic lists of data. Using FILTER as a formula to return tables of multiple results unlike the lookup functions that only find single results.

 

Target audience

This webinar is aimed at people with some experience of working with Excel formulas for instance VLOOKUP who are interested in seeing newer functions available in the latest releases of Excel 365/Online.

Note: Your organisation licence agreement with Microsoft may not allow you to use these at work. However, if your organisation upgrades and rolls out new versions of MS Office then these functions may become available