Maintenance Alert: Course purchases may experience intermittent availability between October 10-12. Thank you for your patience.
Skip to main content
Self-Study Courses

Automating Excel-Based Financial Statements Part 2

2 CPE Credits $41.00/credit hour
☆ ☆ ☆ ☆ ☆ (No Ratings Yet)

In this presentation author and Excel expert David Ringstrom, CPA shows you how to transform an automated financial statement for a single entity into a consolidated financial statement that empowers you to create both consolidated and individual financial statements for as many entities as you wish. Techniques covered include Power Query, Data Validation, and the SUMIFS worksheet function.

David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant and speaker. He has presented over 2,500 live webinars and is the author or co-author of ten books, including “Microsoft 365 Excel All-in-One for Dummies”, “Microsoft 365 Excel for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and “QuickBooks Online for Dummies”.

In his courses, David demonstrates every technique twice: first on a PowerPoint slide with numbered steps and then live in Excel for Microsoft 365 for Windows. He highlights any differences in Excel 2024, 2021, or 2019 during the session and in his detailed handouts. Attendees also receive an Excel workbook containing most of the examples he uses, making it easy to follow along and apply the techniques later. David additionally supports Excel for Mac users by answering their follow-up questions via email.

Publication Date: August 2026

Designed For
Professionals seeking to create financial reporting spreadsheets that are easier to use and have improved data integrity.

Topics Covered

  • Using Conditional Formatting to draw attention to reports that don’t balance to the source data
  • Most features and functions work in Excel for Mac as well but expect differences
  • Removing unnecessary columns from Power Query results
  • Creating a dynamic waterfall chart title that automatically reflects the report period being shown
  • Consolidating financial statement exports from two or more entities by appending queries within Power Query
  • Moving a waterfall chart to a new worksheet
  • Using SUMIF to total values for specific matching criteria
  • Adding a refinement to the SUMIFS function to allow the report to consolidate numbers or display departmental values
  • Discovering how to incorporate Check Figures and Alarms into your work
  • Switching the data source of a Power Query connection to another Excel workbook, such as an export from a different QuickBooks company or a workbook in a new location
  • Suppressing the External Data security warning on a workbook-by-workbook basis

Learning Objectives

  • Identify the character that you place between a list that you type in the Source field of the Data Validation dialog box
  • State which ribbon tab the Flash Fill command appears on in Excel
  • Identify the Excel for Microsoft 365 function that enables you to separate text into two or more cells
  • Identify on which ribbon tab the Text Box command appears
  • Identify one of the uses of Data Validation

Level
Intermediate

Instructional Method
Self-Study

NASBA Field of Study
Accounting (2 hours)

Program Prerequisites
Automating Excel-Based Financial Statements Part 1 is recommended but not required

Advance Preparation
None

Instructor

David H. Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches over 200 webinars each year. His Excel courses are based on over 30 years of consulting and teaching experience. David’s catchphrase is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. He's currently writing a book titled "Exploring Excel's Hidden Treasures". To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).
$82.00 / 2 CPE
Add to Cart
NASBA Registered Sponsor
CPAs, EAs, CTECs Approved Credentials
QAS Quality Assured
Since 1996 Trusted Provider
CCH CPELink Chat - Support
By using our chat feature, you agree that your conversation may be recorded by Wolters Kluwer and agree to our Privacy Policy.