Maximize Excel: QuickBooks Desktop Analysis (Video) (Course Id 2789)

• Who is this course for?
  This course is designed for individuals seeking Continuing Professional Education (CPE), particularly CPAs or accounting professionals who want to enhance their ability to analyze QuickBooks Desktop data using Microsoft Excel.

• What is this course about or what problem does this course solve?
  This course teaches participants how to analyze QuickBooks Desktop data using Microsoft 365 for Windows by exporting reports to Excel, cleaning and organizing the data, and applying tools such as PivotTables, slicers, and SUMIF functions to generate meaningful insights.

• How can the knowledge from this course be used?
  The knowledge can be used to export QuickBooks reports into Excel, connect Excel to CSV data for self-updating analysis, summarize financial data with PivotTables, and combine multiple reports to perform more comprehensive financial analysis.

• Why is this course important to a CPA or Accountant?
  This course is important because it helps CPAs and accountants improve their ability to analyze accounting data from QuickBooks using Excel, enabling them to create clearer reports, perform deeper financial analysis, and work more efficiently with client or company data.

• When is this course relevant or timely?
  This course is relevant whenever professionals need to analyze QuickBooks Desktop financial data in Excel, particularly when preparing reports, reviewing transactions, or performing financial analysis using modern Excel features such as Power Query and data connections.

• How is a course like this consumed or used?
  This course is delivered as a QAS self-study video where participants watch demonstrations of Excel techniques, review course materials and examples, and complete a final exam with a minimum passing score of 70% to earn CPE credit.

In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide you through the intricacies of analyzing QuickBooks Desktop data using Microsoft 365 for Windows. Attendees will learn how to open a QuickBooks Sample Company and export Profit & Loss data to Excel via CSV, along with best practices for opening CSV files manually. David will demonstrate self-updating connections to CSV files, minor data clean-up techniques, and utilizing SUMIF wildcards for matching data. The session will also cover creating Transaction Detail Reports, summarizing data with PivotTables, and effectively slicing QuickBooks data. Participants will discover how to customize and export reports to Excel, including merging multiple reports for comprehensive analysis. Finally, David will address Power Query properties and data connection security prompts, ensuring you leave equipped with actionable insights and the confidence to apply what you've learned.

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 - 2789

Course Learning Objectives

• Recall QuickBooks report offers the most analysis-ready format for analyazing sales transaction?
• Define the purpose of Excel's Slicer feature.
• Recall which menu the Get Data command appears on in Excel 2019 and later.

Chapter 1 - Maximize Excel: QuickBooks Desktop Analysis

Chapter 1 Review Questions

Key Terms