-
Advanced Excel Skills for Accountants Finance & Payroll Professional 2025
Excel expert David Ringstrom, CPA, explains helpful ways to improve the integrity of your spreadsheets using Excel’s lookup functions and pivot tables. In this comprehensive presentation, David reveals alternatives to VLOOKUP, including the HLOOKUP, INDEX and MATCH, SUMIF, SUMIFS, and IFNA. You’ll also get a preview of the new XLOOKUP function, which has been added to Microsoft 365. Lookup functions are only the start, though. In many cases, you’re only a few clicks away from transforming overwhelming lists of data into meaningful reports. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Microsoft 365 (formerly known as Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Microsoft 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
-
10 Productive Excel Features for Accountants (and 3 Time wasters)
In this presentation Excel expert David H. Ringstrom, CPA cherry-picks 10 of the best features in Excel that can make accountants more productive. He’ll also share 3 common time-wasters that can frustrate accountants and heavy users of Excel. You’ll learn about two key worksheet functions, the benefits of the Table feature, pivot tables for report writing, and managing information overload by filtering. Tame unwieldy workbooks by instantly unhiding all hidden worksheets, and then deploying Excel’s Custom Views feature to enable you to hide/unhide multiple worksheets at once. You’ll see how to build in some insurance against Excel crashes, and quickly identify duplicates within a list. David will also discuss three common time wasters/frustrations in Excel. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Microsoft 365 (formerly known as Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Microsoft 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
-
The One Big Beautiful Bill (OBBB) is Now the Law. How Will It Impact the Workplace?
The “One Big Beautiful Bill,” formally known as the One Big Beautiful Bill Act (OBBBA), significantly impacts the workplace through tax cuts, changes to deductions, and potential impacts on employment and the economy. It extends or modifies elements of the Tax Cuts and Jobs Act (TCJA) and introduces new provisions like no tax on tips and overtime pay, while also impacting payroll and HR departments due to the need to track and report these changes. The “One Big Beautiful Bill” is a comprehensive piece of legislation with significant implications for the American economy and the workplace. It aims to boost the economy through tax cuts and business incentives, but it also introduces changes to federal spending programs and potentially increases the national debt, says the Committee for a Responsible Federal Budget. Both employers and employees will need to adapt to the changes introduced by this bill.
