Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Do you build cumbersome Excel worksheets for each month of the year when it comes to financial statements?
Are you worried about the integrity and accuracy of your Excel-based statements?
Do your workbooks often result in worksheet creep – deeming them a practically unusable database or report?
If you answered yes to any of these questions, this workshop is for you.
Join Excel expert and CPA, David Ringstrom, for this workshop to create dynamic accounting reports for any month of the year on a single worksheet. As an alternative to too many worksheets, he will explain how to use Excel functions, such as OFFSET and SUMIFS, to quickly create accounting reports that can be toggled to any reporting period with only two mouse clicks. In addition, he outlines how to export data from your accounting package, improve the integrity of your spreadsheets, and how to consolidate reports from two or more departments or entities. Much of the discussion shows how to use Power Query in Excel to clean-up and combine reports from accounting software and other sources.
In this workshop training, you’ll learn how to:
Overcome common issues in exported reports:
Cut down on manual updates and tasks:
Increase the accuracy of your Excel-based reports:
David H. Ringstrom, CPA is a nationally recognized Microsoft Excel expert as well as the president and founder of Accounting Advisors, Inc. based in Atlanta, Georgia. He founded Accounting Advisors in 1991 as a consulting-services business, later he began teaching continuing education classes as well. His mission since is to offer quality training and consulting services on Microsoft Excel.
David demonstrates every technique at least twice, so you leave his trainings ready to execute. First, he’s goes over the technique on a Point slide with numbered steps, and second, in the subscription-based Microsoft 365 version of Excel. He 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.
When you leave this workshop training, you’ll be able to: