Quickbooks/Excel Report Speed Tips

Wolters Kluwer throughout the year, offers a variety of tax and professional development webinars vital to ensuring you maintain your skills and knowledge. Convenient and online. All registered attendees may also view a recorded version of the webinar for 30 days. Plus receive an official Wolters Kluwer Certificate in order to track your professional development credits.

Wolters Kluwer Online Professional Development Events

Wolters Kluwer throughout the year, offers a variety of tax and professional development webinars vital to ensuring you maintain your skills and knowledge.

Convenient and online. All registered attendees may also view a recorded version of the webinar for 30 days. Plus receive an official Wolters Kluwer Certificate in order to track your professional development credits.

All sessions are recorded and made available as a Webinar On Demand for those who did not attend the live event. These WODs are visible only via our Intelliconnect platform.



Part 1, Nov 7:

In this session, Excel and QuickBooks expert David Ringstrom, CPA, shows you how to overcome the limitations of internal reports in QuickBooks. He shares several techniques, including combining two reports into one, summarizing QuickBooks data via Excel pivot tables, creating one-click access to QuickBooks reports, and much more.


David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. He draws your attention to any differences in Excel 2016, 2013, or 2010 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.

 

More specifically, this webinar will cover: 

  • Learning QuickBooks techniques that may help you avoid the need to analyze data in Excel
  • Learning why, in many cases, you should export reports intended for spreadsheet analysis to a .CSV file instead of an Excel workbook
  • Using a wildcard character with SUMIF to summarize data based on a partial match
  • Creating one-click access to memorized QuickBooks reports
  • Bypassing filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click
  • Learning how to use the undocumented DATEDIF worksheet function
  • Using Excel's PivotTable feature to quickly identify anomalies within QuickBooks data
  • Making minor changes within QuickBooks that can result in less manual effort in Excel
  • Tracing customer longevity by creating a report that shows first and last invoice dates by customer



Part 2, Nov 21:

In Part 2 of this series, Excel expert David Ringstrom, CPA will show you how to flatten multiple column reports, such as the Profit & Loss By Class report, back into a list format that can be used for analyzing data further with pivot tables, slicers, and so on. Excel 2016 users will learn how to visually present a summary profit and loss report in chart form by way of the Waterfall Chart feature, while users of earlier versions of Excel will still learn tricks for cleaning up their QuickBooks reports.

The session also will cover how those using Excel 2013 and later can use the Bing Maps feature to transform summary data into interactive maps. If you’re using Excel 2010 or earlier, you won’t be able to use the Waterfall Chart or Bing Maps features, but this jam-packed presentation demonstrates plenty of techniques that can be implemented in those versions of Excel. Techniques are equally applicable to reports exported from both QuickBooks Online and QuickBooks Desktop.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 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.

 

More specifically, this webinar will cover: 

  • Transforming a report, such as the Profit & Loss By Class report, into a list you can in turn 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 the Bing Maps feature in Excel 2013 and later to convert data in order to map sales by city and state
  • Correcting nuances in mapped data when Bing Maps misinterprets your data


Target Audience

This webinar series will be of interest to any practitioners who wish to learn more about creating and combining Excel reports from QuickBooks data.

Professional Development Credits

Wolters Kluwer Canadian professional development programs are designed to meet the continuing education requirements of a variety of professional associations. These requirements do vary by association and region. Please consult your provincial association to ensure this webinar meets the continuing professional development standards for your specific situation.