QuickBooks/Excel Analysis: Part 2

Level: Intermediate

Available Durations:

  • 50 minutes
  • 60 minutes
  • 75 minutes
  • 90 minutes
  • 100 minutes
  • 120 minutes


In this follow-up to QuickBooks/Excel Analysis: Part 1, Excel and QuickBooks expert David Ringstrom, CPA, delves deeper into ways to analyze data from QuickBooks Desktop and QuickBooks Online. Among many other topics, David covers how to flatten multiple-column reports back into a list format for further analysis, how Excel 2016 users can visually present a summary profit and loss report in chart form by way of Waterfall charts, how users of Excel 2013 and later can implement the Bing Maps add-in to transform summary data into interactive maps, and how users of earlier versions of Excel can clean up their QuickBooks reports.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. 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.

Office 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.

Topics/Areas Typically Covered:

  • Transforming a report, such as a Profit & Loss by Class report, into a list you can then analyze with pivot tables and other tools.
  • Removing the Text number format from reports you export to Excel from QuickBooks.
  • Utilizing filtering to remove extraneous total rows and headings from your data.
  • Removing blanks and unwanted rows from reports.
  • Concatenating multiple columns of account numbers into a single column.
  • Capitalizing on the hidden Multiple Consolidation Ranges feature to summarize data into a pivot table format.
  • Undoing the Table feature within data that you’ve drilled down into from a pivot table.
  • Utilizing Text to Columns to separate accounts and subaccounts into multiple columns.
  • Converting formulas to values within an exported QuickBooks report.
  • Utilizing Bing Maps in Excel 2013 and later within supported types of workbooks.
  • Concatenating multiple address fields into a single combined field and removing duplicates.
  • Interacting with mapped data to see underlying data points.
  • Utilizing Bing Maps in Excel 2013 and later to convert data so you can map sales by city and state.
  • Correcting nuances in mapped data when Bing Maps misinterprets your data.

Learning Objectives/Why You Should Attend:

  • Identify how to use Excel’s Text to Columns feature.
  • Define the ideal data for use with creating pivot table reports.
  • Applying Trace Dependents and Trace Precedents while auditing formulas.

Target Industries:

  • Accounting and Finance
  • Business
  • Excel Users
  • Consulting
  • IT
  • Auditing
  • Human Resources
  • Marketing
  • Sales
  • Government
  • Tax

Target Job Title:

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

About the Instructor:

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra 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. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).

Pricing and Format Options:

Click here to learn about the presentation format and view pricing information.

Click here to view other topics.