Key Take Away:
In this live webinar, Excel expert David H. Ringstrom, CPA, shows you how to create dynamic accounting reports for any month of the year on a single worksheet.
Overview:
Many Excel users will build a worksheet for each month of the year, which can be cumbersome to revise. Rather than using such an unwieldy method, David explains how to utilize such functions as VLOOKUP, OFFSET, and SUM together to quickly create accounting reports that toggle to any reporting period—all with a couple of mouse clicks.
Why Should You Attend:
David will demonstrate effective ways to export data from your accounting package so you can create a “set-and-forget” link to your accounting data in Excel.
David typically teaches from Excel 2016, but he points out any differences in earlier versions of Excel. He’s also happy to demonstrate techniques in a specific version of Excel upon request. David’s detailed handouts serve as reference tools you can fall back on after participating in one of his webinars. In addition, he provides an Excel workbook that includes a majority of the examples he uses during each webinar.
Areas Covered In This Webinar:
• Create an in-cell list by way of Excel’s Data Validation feature
• Improve the integrity of spreadsheets with Excel’s VLOOKUP function
• Learn a simple design technique that greatly improves the integrity of Excel’s SUM function
• Learn why, in many cases, you should export reports intended for spreadsheet analysis to a .CSV file instead of an Excel workbook
• See how to use the Trusted Document feature in Excel 2010 and later to suppress the Data Connection security prompt
• Use Excel’s OFFSET function to dynamically reference data from one or more accounting periods
Learning Objectives:
• Apply a variety of Excel functions—all focused on helping you use Excel far more effectively
• Define the best way to export data from your accounting package that links to your accounting data in Excel
• Apply the OFFSET function to return data for a specific month within a 12-column range
Who Will Benefit:
• CFO’s
• Controllers
• Investment Analysts / Financial Analysts / Business Analysts
• Forecasting & Planning Personnel
• Mergers & Acquisitions Specialists
• Risk Managers
• Strategic Planners / Capital Expenditure Planners
• Cost Accountants / Managerial Accountants
• Practitioners who may benefit from learning how to create monthly financial statements in Excel more effectively
For more information, please visit : https://www.atozcompliance.com/trainings-webinar/banking-financial-services/accounting-taxation/excel-based-financial-reports/david-ringstrom/300147
Email: support@atozcompliance.com
Toll Free: +1- 844-414-1400
Tel: +1-516-900-5509
Level:
Intermediate
Speakers Profile:
David Ringstrom
David Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents webinars to thousands of attendees annually on Excel and other topics. He has written hundreds of freelance articles on spreadsheets, some of which have been published internationally. David's catch phrase is "Either you work Excel or it works you." His goal is to make you a smarter and more effective spreadsheet user.
