Maximize Excel: QuickBooks Desktop Analysis
Presented by David H. Ringstrom, CPA
 
Event Date/Time: 02/11/26 12:00 PM Eastern
Duration: 100 minutes

 In this session, Excel and QuickBooks expert David Ringstrom, CPA, shows you how to overcome the limitations of internal reports in QuickBooks Desktop. He shares several techniques, including combining two reports into one, summarizing QuickBooks data via Excel pivot table. You'll see how to use Power Query in Excel to streamline and automate transforming QuickBooks reports into analysis ready formats.
 
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016 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.
 
Microsoft 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 2021, Excel 2019, and so on.
 
Who should attend:
Practitioners who wish to learn more about creating and combining Excel reports from QuickBooks data.
 
Topics covered:
 
• Changing the sign of numbers in Excel by using the Multiply option within Paste Special.
 
• Choosing the most analysis-ready report format from QuickBooks Desktop and QuickBooks Online.
 
• Contrasting reports exported as Excel workbooks from QuickBooks Desktop to reports exported as comma-separated values (CSV) files.
 
• Creating a 12 month P&L report from QuickBooks Desktop and then exporting to the comma-separated value (CSV) format to streamline analysis.
 
• Deleting blank rows or columns by way of shortcut menus or keyboard shortcuts.
 
• Employing the Text to Columns feature to transform text-based dates into numeric values that Excel recognizes as dates.
 
• Extending the functionality of the SUMIF function by incorporating wildcard characters within a formula.
 
• Filtering transactions by date or date range.
 
• Gaining control of long lists of data by filtering instead of sorting.
 
• Managing information overload by creating a Top 10 pivot table.
 
• Pivot charts are an adjunct to Excel’s pivot table feature, which allows you to summarize data by dragging and dropping data with your mouse. Pivot charts are much more interactive than traditional Excel charts.
 
• Revealing the undocumented DATEDIF function in Excel for determining the number of months or years between two dates.
 
Learning objectives:
• Recognize QuickBooks features and techniques to streamline reports for faster analysis in Excel.
• Identify how to summarize QuickBooks data by way of Excel pivot tables.
• Recall which command enables you to send data from the Power Query editor to a pivottable.
 
 
Level:
Intermediate

NASBA Field of Study:
Computer Software & Applications (2 hours)
 
Program Prerequisites:
Experience with QuickBooks and Excel Recommended
 
Advance Preparation:
None