Description

In this webinar Excel expert David H. Ringstrom will guide you on extracting PDFs with Power Query, exploring Power Query properties, enhancing external data security, creating Excel tables, adding total rows, filtering tables with slicers, utilizing functions such as IF, nested IF, VLOOKUP, IFNA, and MATCH, as well as INDEX/MATCH functions, XLOOKUP for horizontal lookup, automating tasks with macros, creating macro icons, applying conditional formatting for greater than scenarios, utilizing data bars, managing scenarios effectively, and summarizing Scenario Manager features.

David is the author of “Microsoft Excel 365 for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and has written or co-authored six other books. He demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Excel for Microsoft 365. David draws your attention to any differences in Excel 2021, 2019 or 2016 during the presentation and in his detailed handouts. The handouts include an Excel workbook with most of the examples he uses during his demonstrations.

Excel for Microsoft 365 is a subscription-based product that receives periodic feature updates. Conversely, perpetually licensed versions have year numbers in their names and do not receive any feature updates.