Financial reporting can be fraught with repetitive tasks and often the risk of misstated numbers. In this webcast, 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. You'll see how to use Data Validation to provide a user interface for specifying a reporting period. The report itself uses functions such as OFFSET and SUMIF to extract data from accounting reports and to present the data in any format you need. You'll see how to make the report be self-updating after you save over an existing accounting export file, and also how to build in check figures and alarms to notify you if a report doesn't tie back to its source.