QuickBooks Online-Excel Analysis Basics (Video) (Course Id 2794)

• Who is this course for?
  This course is designed for anyone needing Continuing Professional Education (CPE), particularly CPAs and accounting professionals interested in improving their use of QuickBooks Online and Excel.

• What is this course about or what problem does this course solve?
  This course teaches how to efficiently export, clean, and analyze QuickBooks Online reports in Microsoft Excel, helping users turn raw accounting data into meaningful insights.

• How can the knowledge from this course be used?
  The knowledge can be used to enhance financial data analysis by creating PivotTables, charts, and applying conditional formatting to better interpret QuickBooks data in Excel.

• Why is this course important to a CPA or Accountant?
  This course is important because it improves the ability to analyze financial reports more effectively, leading to clearer insights and better decision-making in accounting tasks.

• When is this course relevant or timely?
  This course is relevant when working with QuickBooks Online data that needs deeper analysis or when improving efficiency and reporting capabilities using Excel.

• How is a course like this consumed or used?
  This course is consumed as a self-study video presentation with demonstrations, followed by a final exam that must be passed with a minimum score of 70% to earn CPE credit.

In this presentation, author and Excel expert David Ringstrom, CPA, shows you how to prepare and analyze QuickBooks reports more effectively using Microsoft Excel. David begins by demonstrating how to open QuickBooks sample companies, compare modern and classic report views, run the Transaction Detail by Account report, and adjust export and Protected View settings. He then walks through cleaning and navigating Transaction Detail reports in Excel, including removing merged cells, applying filters, adding Quick Access Toolbar shortcuts, converting exports into Excel Tables, and filtering data with slicers. You’ll also explore Recommended PivotTables, Recommended Charts, and the Analyze Data tool before building foundational PivotTables from scratch. The session concludes with practical conditional formatting techniques—such as greater-than rules, color scales, and data bars—to help you turn QuickBooks data into clear, actionable insights.

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 webinars, 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 presentation 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.

Video - NASBA QAS - NASBA Registry - 2794

Course Learning Objectives

• Identify which section of the Excel Options dialog box that allows you to the Protected View setting.
• State which Excel feature allows you to lock specific rows and/or columns so they remain visible while scrolling.
• Demonstrate how to add and arrange fields in a PivotTable using the PivotTable Field List.

Chapter 1 - QuickBooks Online-Excel Analysis Basics

Chapter 1 Review Questions

Key Terms