While many Excel users build accounting worksheets for each month of the year, such worksheets can be cumbersome to revise. As an alternative, Excel expert David Ringstrom, CPA, explains how to use Excel functions, including VLOOKUP, OFFSET, and SUM, to quickly create accounting reports that allow you to switch to any reporting period with only two mouse clicks. In addition, David outlines how to export data from your accounting package, improve the integrity of your spreadsheets, incorporate Check Figures and Alarms into your work, and more.
Who should attend:
Practitioners who can benefit from learning how to create monthly financial statements more effectively in Excel.
This webinar is available with
NO ADDITIONAL FEE if you have an active
all access membership or
webinar membership or can be purchased for
$20.00!
| Instructor: | David Ringstrom |
| Course No: | ACT-EXCELRPT-G12018 |
| Recommended CPE: | 2.00 |
| Delivery Method: | Group Internet Based - Webinar |
| Date Offered: | 3/6/2018 10:00 AM - 12:00 PM |
| Level of Knowledge: | Intermediate |
| Prerequisites: | Experience with Excel |
| Advanced Preparation: | None |
| Registration Requirements: | Registration with GoToWebinar is required |
| Recommended Field of Study: | Accounting
Webinars - Group
|
|
|
|