Skip Main Navigation
Page Content

Save This Event

Event Saved

Excel Agility: Speed Tips for QuickBooks/Excel Reports

Aurora Training Advantage

Wednesday, June 7, 2017 from 1:00 PM to 2:40 PM (EDT)

Excel Agility: Speed Tips for QuickBooks/Excel Reports

Registration Information

Registration Type Sales End Price Fee Quantity
Webinar Attendee + Recording (Best Value)   more info Jun 7, 2017 $298.00 $0.00
Live Webinar Attendee   more info Jun 7, 2017 $219.00 $0.00
Recording On-Demand(CPE N/A) Jun 7, 2017 $219.00 $0.00
Additional Attendee Jun 7, 2017 $49.00 $0.00

Share Excel Agility: Speed Tips for QuickBooks/Excel Reports

Event Details

Live Webinar or Recording

June 7, 2017

1:00 - 2:40 pm Eastern

CPE: 2.0 (Live Only)

  

When you participate in this live presentation, you’ll learn from Excel and QuickBooks expert David Ringstrom, CPA, how to overcome the limitations of internal reports in QuickBooks. He outlines several techniques, including how to combine two reports into one as well as create an Excel pivot table from QuickBooks data. David also explains how to: avoid the need to analyze data in Excel after applying a few QuickBooks techniques, use a wildcard character to summarize data based on a partial match, make minor changes within QuickBooks to reduce manual effort in Excel, and more.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016 and QuickBooks 2016. He’ll draw to your attention any differences in earlier versions of the software as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Topics Typically Covered:

  • Learning QuickBooks techniques that may help you avoid the need to analyze data in Excel.
  • Learning how to use the undocumented DATEDIF worksheet function.
  • Using a wildcard character with SUMIF to summarize data based on a partial match.
  • Learning why, in many cases, you should export reports intended for spreadsheet analysis to a .CSV file instead of an Excel workbook.
  • Bypassing filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
  • 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.
  • Tracking customer longevity by creating a report that shows first and last invoice dates by customer.
  • Creating one-click access to memorized QuickBooks reports.

Learning Objectives:

  • Recognize QuickBooks features and techniques to streamline reports for faster analysis in Excel.
  • Summarize QuickBooks data by way of Excel pivot tables.
  • Recall how to filter based on cell contents with a single keystroke or mouse click. 

 
Guest Speaker: David Ringstrom

David H. Ringstrom, CPA owns Accounting Advisors, Inc., a spreadsheet and database consulting firm that he started in 1991. In addition to teaching scores of webinars each year on Excel and other topics, David has written hundreds of freelance articles on spreadsheets. He has served as the technical editor for dozens of books on accounting software, and his first book will be published February 2016. David’s company provides training and consulting services nationwide.

 

Level: Intermediate

Format: Live Webcast

Field of Study: Computer Software & Applications (2 hours)

Program Prerequisites: Excel and Quickbooks Experience

Advanced Preparation: None

 

Aurora Training Advantage is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:  

www.learningmarket.org 

For more information regarding administrative policies such as complaint and refund, and cancellation please contact our offices at training@auroratrainingadvantage.com

 

 

Have questions about Excel Agility: Speed Tips for QuickBooks/Excel Reports? Contact Aurora Training Advantage

Save This Event

Event Saved

When

Excel Agility: Speed Tips for QuickBooks/Excel Reports
Class Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.