EVENT DESCRIPTION
In this presentation author and Excel expert David Ringstrom, CPA, helps you expand your Excel toolbox by comparing the INDEX/MATCH functions to the XLOOKUP worksheet function in Excel 2021 and Excel for Microsoft 365. You'll also see how to transform ugly reports exported from accounting software and other platforms into analysis ready formats by using Power Query. David will also show you how to use Excel's Solver feature to identify the combination of amounts from a list, such as invoices or deposits, that add up to an amount of your choice.
David is the author of “Exploring Microsoft Excel's Hidden Treasures: Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features”. 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.
EVENT OBJECTIVE
• Using Excel's Solver feature to find the amounts that match a total, such as which checks or invoices make up a particular total.
• Filtering a cleaned-up accounts receivable aging report to display only overdue amounts.
• Contrasting the INDEX and MATCH combination to VLOOKUP or HLOOKUP.
• Using Excel's Solver feature to find the amounts that match a total, such as which checks or invoices make up a particular total.
• Matching on two or more columns of criteria at once with XLOOKUP.
• Tweaking Excel’s AutoRecover settings to raise the odds of recovering your work after an Excel crash.
• Using the MATCH function to find the position of an item in a list.
• Exploring the XLOOKUP worksheet function in Excel 2021 and Microsoft 365.
• Accessing files closed without saving as well as interim back-ups Excel makes while you're working in a workbook.
• Understanding how the VLOOKUP function allows you to look up data instead of having to manually reference individual cells.
• Enabling Excel’s Solver add-in for more complex what-if analyses.
• Using Power Query to clean up accounting reports to remove pitfalls like blank rows, merged cells, missing data, and more.
EVENT DETAILS
Company:
David H. Ringstrom, CPA
Number of Hours:
2 (Recommended)
Prerequisite:
Program Level:
Update
Knowledge Level:
Intermediate
Delivery Method:
Group Internet Based
Number Of Days:
1
Food Included:
Seminar Number:
3302
Early Cut Off Date:
05/29/2024
Phone:
Venue:
Online Group Internet Based ,
Accommodations:
,
Recommended For:
CPA (2), EA (2), Tax Preparer (2)
Approved By:
NASBA