Mastering Excel: Optimizing Financial Statements
Training
Online
*Indicative price
Original amount in USD:
$ 149
Description
-
Type
Training
-
Level
Advanced
-
Methodology
Online
-
Class hours
1h
-
Duration
1 Day
-
Virtual classes
Yes
In this webinar speaker David will explain you how to create dynamic financial statements for any month of the year on a single worksheet, He also demonstrates effective ways you can export data from your accounting package, thereby allowing you to create a "set-and-forget" link to your Excel data.
Reviews
Subjects
- Excel
- Financial
- Export
- Financial Training
- MS Excel
- Education
- Technology
- Employees
- Management
- Benefits
Teachers and trainers (1)
Event Manager
Traning Provider
Course programme
This webcast presented by Excel expert David H. Ringstrom, CPA, teaches you how to create dynamic financial statements for any month of the year on a single worksheet.
Excel users often build worksheets for each month of the year, which end up being cumbersome to revise. As an alternative, David shows you how to use Excel functions-including VLOOKUP, OFFSET, and SUMIF-to quickly create financial statements that allow you to toggle to any reporting period with only a couple of mouse clicks. He also demonstrates effective ways you can export data from your accounting package, thereby allowing you to create a "set-and-forget" link to your Excel data.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 version of Excel (formerly known as Office 365). David 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.
Microsoft 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
Additional information
Mastering Excel: Optimizing Financial Statements
*Indicative price
Original amount in USD:
$ 149