home.aspx

 
.

EXCEL EXPLAINED: AUTOMATING FINANCIAL STATEMENTS

September 02, 2020 | (1:30 pm - 3:30 pm)
USA (United States of America)
SHARESHARESHARE
In this insightful session, Excel expert David Ringstrom, CPA, shows you step-by-step how to create dynamic accounting reports for any month of the year on a single worksheet. As an alternative to building cumbersome worksheets for each month of the year, David explains how to use Excel functions, such as VLOOKUP, OFFSET, and SUM, 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 incorporate Check Figures and Alarms into you work.