Skip to main content
Self-Study Courses

QuickBooks for CPAs (Currently Unavailable)

10 CPE Credits $23.90/credit hour
☆ ☆ ☆ ☆ ☆ (No Ratings Yet)
Prepare yourself for a successful year end! In this on-demand course, Laura Madeira will give you useful tips to efficiently close the year.
Don't miss this informative on-demand course demonstrating QuickBooks Online Accountant.
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 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 course.
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 course.
Don't miss this informative webinar demonstrating What's New in QuickBooks 2018 features. Discover features unique to your QuickBooks Accountant software as well those used by your clients with QuickBooks Pro, Premier and Enterprise. This on-demand course is always popular with accounting audiences as we try to take the guess work out of working with new features. Additionally, participants will receive a complimentary, detailed document about What's New In QuickBooks 2018.
Total: 5 courses (10 CPE hours)

Instructors

David H. Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches over 200 webinars each year. His Excel courses are based on over 30 years of consulting and teaching experience. David’s catchphrase 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. He's currently writing a book titled "Exploring Excel's Hidden Treasures". To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).

Laura Madeira

Laura Madeira is the owner of ACS, Inc., an Intuit Premier Reseller located in the greater Dallas, Texas, area. She has been selected to the Top 10 QuickBooks ProAdvisors list.

Laura is one of the original members of the elite Intuit Trainer/Writer Network. She has been a guest speaker for Intuit for many years. She was also a founding member of the Intuit Customer Advisory Council. Laura is an Advanced QuickBooks Certified, Advanced QuickBooks Online Certified, Enterprise and Point of Sale Certified. Laura is also a Sage Certified Consultant representing Sage 100 Contractor software.

She has also written several QuickBooks training books and self-paced training videos. Details can be found on her website.

Laura earned her accounting degree from Florida Atlantic University. She enjoys photography, art and camping with her sisters and their families. When Laura is not writing, she enjoys reading a good book or two.
NASBA Registered Sponsor
CPAs, EAs, CTECs Approved Credentials
QAS Quality Assured
Since 1996 Trusted Provider
CCH CPELink Chat - Support
By using our chat feature, you agree that your conversation may be recorded by Wolters Kluwer and agree to our Privacy Policy.