Financial reporting continues to involve repetitive workflows and carries ongoing risks of errors and misstatements. In this 2026 webcast, Excel expert David Ringstrom, CPA, will demonstrate how to build and utilize financial reporting templates—both as workbooks and worksheets—that serve as clean, reusable starting points. You’ll also learn how to generate automated financial statements directly from general ledger data using pivot tables, and then refine those reports with Slicer and Timeline filters. Each reporting period, you’ll simply replace the underlying general ledger data, and your Excel-based reports will refresh automatically.
 
David demonstrates every technique at least twice: first on a PowerPoint slide with numbered instructions, and then live in Microsoft 365 (subscription). During the session, he highlights key differences in perpetual Excel versions (Excel 2021, 2019, 2016, 2013, and earlier). Attendees also receive detailed reference handouts and an Excel workbook containing the majority of the live examples.
 
Microsoft 365 is a subscription product that receives continuous feature updates—often monthly. In contrast, perpetual license versions of Excel (for example, Excel 2021, 2019, 2016) have fixed feature sets that do not change after installation.

• Using Power Query to extract, transform, and load data from text files, accounting systems, and other data sources.
• Adding rows to a blank pivot table to build instant financial reports.
• Applying a consistent style to charts using chart templates.
• Combining VLOOKUP and MATCH to summarize income statement data for waterfall visualizations.
• Enhancing plain number lists with Data Bars conditional formatting.
• Filtering pivot tables with Slicers (Excel 2010 and later).
• Filtering pivot tables by date ranges using the Timeline feature (Excel 2013 and later).
• Reducing pivot table output to show fewer rows/columns for cleaner reporting.
• Visualizing financial statements using the Waterfall chart (Excel 2016 and later).
• Using Icon Sets conditional formatting to provide visual context in financial lists.

• This webcast helps you reduce repetitive financial reporting work and minimize errors by using template-driven Excel models.
• You’ll learn how to refresh reports automatically from general ledger data using PivotTables, Slicers, and Timelines.
• The session improves both speed and accuracy in month-end/quarter-end reporting workflows.
• Ideal for finance and accounting users who want cleaner, faster, and more reliable spreadsheet-based financial statements. Accountants.

• Accountants
• CPAs
• CFOs
• Controllers
• Income Tax Preparers
• Enrolled Agents
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Excel Users
• Marketers
• Government Personnel

During the Q&A session following the live event, ask a question and get a direct response from our expert speaker.

Important Notice for Our “Live” Attendees: If you have enrolled in the “Live Webinar,” you will get your instruction kit before 24 hours of the live class.

For Recorded and E-transcript Participants: If you have signed up for the “Recorded” class or for the “E-transcript,” you will get access to the “Recording link” or the “PDF” within 24-48 hours of the live class.

SPEAKER

David H. Ringstrom, CPA,

ALL WEBINARS

Acclaimed Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors, Inc. based in Atlanta, Georgia. David founded Accounting Advisors in 1991 as a consulting-services business, but in 2009, he began teaching for continuing education providers as well. His mission since then has been to offer quality training on Excel and additional accounting software via live webcasts, on-demand self-study webcasts, and in-house engagements. More than 24 providers, located throughout the country as well as overseas, now look to David for their Excel and accounting software training needs.

David’s Excel courses cover the gamut of the software’s features and functions to provide CPAs as well as accounting and financial professionals the knowledge they need to work more efficiently and effectively in Excel. David is known for saying, “Either you work Excel, or it works you.” Based on this belief, he focuses on teaching users what they don’t know but should know about Excel.

His comprehensive yet easy to understand presentations cover Excel 2016, 2013, 2010, and 2007. David’s webcasts are fast paced, and he welcomes attendees’ questions. In addition, his detailed handouts and slides serve as handy reference tools students can fall back on after participating in his webcasts or taking his self-study courses.

Why You Should Subscribe to Our Unlimited Webinar?

Unlimited Live and On-Demand Courses

Watch all live or recorded webinars (up to 120 minutes long). Get instant access to a library of more than 500 high quality courses presented by best-in-class presenters.

CEUs: CPE, SHRM and HRCI Credits

Fulfil your recertification requirements by earning CEUs from CPE, SHRM and HRCI.

Free Access to Course Materials

Each program comes with Additional Course Materials, which you can download and read anytime.

Additional Discounts

Get flat 20% discount on Premium Product Category like, Long Hour Webinars.

SUBSCRIBE NOW