🎤  Mike Thomas        |  📅  August 16, 2023   |  🕒  11 AM Eastern Time US



DESCRIPTION: 

Microsoft Excel contains almost 500 built-in worksheet functions. Strip away the ones nobody uses. Discount the ones that have a specialized use-case and you’re left with a set of functions that all Excel users should know, regardless of their job function, industry, or business sector. This webinar covers some of Excel’s most popular productivity-boosting functions.


Functions Covered: 

IF, COUNTIF, SUMIF, IFERROR, XLOOKUP (Often referred to as "VLOOKUP on steroids"), INDEX and MATCH, UNIQUE, FILTER, SORT, GETPIVOTDATA, SUBTOTAL, LEFT, RIGHT, MID and CONCATENATE, WORKDAY, EOMONTH, NETWORKDAYS


Who Should Attend: 

This training is categorized as intermediate. It is aimed at users who want to learn about the commonly-used worksheet functions in Excel.

Although the training will be delivered using the latest version of Excel, this training is relevant for users of all versions of Excel (Please note that several of the functions XLOOKUP, UNIQUE, SORT, FILTER are only available to Office 365 subscribers and users of Excel 2021)

Read more