In this presentation, author and Excel expert David H. Ringstrom, CPA, will delve into advanced Excel techniques to enhance your data analysis skills and streamline your workflow. Attendees will learn how to effectively utilize functions like VLOOKUP and INDEX-MATCH for powerful data retrieval, automate repetitive tasks with macros, and leverage pivot tables for insightful reporting. David will also cover essential tips for data validation and error checking, ensuring your spreadsheets are not only efficient but also accurate. Join us for this informative session to unlock the full potential of Excel in your professional toolkit.

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.

Who should attend: Professionals seeking to use Microsoft Excel more effectively.

Topics typically covered:

• Calculating declining balance depreciation with the DB function.

• Defining depreciation to simplify asset management and financial planning.

• Computing variable declining balance depreciation with the VDB function.

• Creating an in-cell list by way of Excel’s Data Validation feature.

• Calculating partial year depreciation with the DATE function.

• Adjusting for partial year straight-line depreciation.

• Avoiding creating fixed asset spreadsheets from scratch by using Excel templates.

• Streamlining the decision-making process with the IFS function in Excel 2021 and Microsoft 365.

• Computing straight-line depreciation with the SLN function.

• Calculating depreciation using the units of production method.

• Streamline formula writing with by creating nicknames for repetitive values with the LET function in Microsoft 365.

• Converting a fixed asset list into an Excel Table to streamline formula writing and maintenance as well as improve data integrity.

Learning objectives:

• Demonstrate how to use the IFS function to evaluate multiple conditions efficiently, reducing the need for complex nested IF statements.

• State how to use the EDATE function to shift dates by a specified number of months while maintaining the original day of the month when possible.

• State how to use the DB function in Excel to calculate fixed declining balance depreciation.

Level: Intermediate

Instructional Method: Group Internet Based

NASBA Field of Study: Specialized Knowledge (2 hours)

Program Prerequisites: Prior experience with Microsoft Excel is recommended.

Advance Preparation: None