QuickBooks Analysis Basic For Accountant

Welcome to myCPE

Excel Accountant: QuickBooks Detailed Analysis

Learning Objectives

To identify QuickBooks features and techniques that can be used to streamline reports for faster analysis & how to use the Text to Columns feature in Excel.
To recall how to analyze QuickBooks data by way of pivot tables in Excel.
To identify the setting that enables certain browsers to launch Excel files exported from QuickBooks Online and other sources and recall the keystroke that enables you to select two or more non-adjacent items from a Slicer.

Course Description

In this online CPE course, David shares valuable tips to help you overcome the limitations of QuickBooks internal reports. David teaches several techniques, including how to combine two reports into one, create pivot tables from QuickBooks data, access memorized QuickBooks reports, and more

Among other topics, Excel, and QuickBooks expert David Ringstrom, CPA, covers how to flatten multiple-column reports back into a list format for further analysis, and how users of Excel 2016 and later 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 in this Excel CPE course: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 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.

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 2019, Excel 2016, and so on.

This Online CPE webinar covers the following Key Topics:

Learning QuickBooks techniques that may help you avoid the need to analyze data in Excel.
Creating one-click access to memorized QuickBooks reports.
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.
Tracking customer longevity by creating a report that shows the first and last invoice dates by customer.
Revealing the undocumented DATEDIF function in Excel for determining the number of months or years between two dates.
Extending the functionality of the SUMIF function by incorporating wildcard characters within a formula.
Employing the Text to Columns feature to transform text-based dates into numeric values that Excel recognizes as dates.
Mapping sales by the city in Excel 2013 and later with Bing Maps.
Understanding how to manage the Protected View prompt in Excel 2010 and later.
Using Slicers in Excel 2013 and later to filter data within reports exported to Excel from QuickBooks.
Streamlining the process of building Waterfall charts from QuickBooks Online Profit & Loss reports by way of the SUMIF function.
Exporting customer contact lists from QuickBooks Online and QuickBooks Desktop.
Flattening the Profit and loss by the Class report to unlock the data for analysis by way of pivot tables, filtering, and other tools in Excel.
Filtering transactions from QuickBooks reports by date in any version of Excel.
Utilizing the Timeline feature in Excel 2013 and later to filter pivot tables based on date ranges.
Choosing the most analysis-ready report format from QuickBooks Desktop and QuickBooks Online.

For more information: QuickBooks | Excel CPE course.

Webinar Qualifies For

4 CPE Credit of Accounting for Certified Public Accountants (CPA-US)
4 General Credit of Accounting for Accountant/Bookkeeper/Tax Professionals
4 CPD Credit of Accounting for CPA in Canada
4 CPE Credit of Accounting for Certified Fraud Examiner (CFE)
4 CPE Credit of Accounting for Certified Government Financial Manager (CGFM)
4 CE Credit of Information Technology (inc. Excel) for Certified FP&A Professional (FP&A)
4 CPE Credit of Accounting for Iowa Licensed Public Accountant (IA-LPA)
4 CPE Credit of Accounting for Maine Licensed Public Accountant (ME-LPA)
4 CPE Credit of Accounting for Delaware Licensed Public Accountant (DE-LPA)

About Instructor

David Ringstrom, CPA (US)

President, EXCEL Accountant

I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:

Microsoft Excel
Microsoft Access
Sage 50/Peachtree Accounting
QuickBooks

Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:

National Association of Certified Valuators and Analysts
Institute of Real Estate Managers
Georgia Society of CPAs
South Carolina Society of CPAs
Georgia Government Finance Officers Association
Atlanta chapter, American Society of Women CPAs
Perimeter Chapter, Georgia Society of CPAs

I teach over 200 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.

I am the co-author of Idiot's Guide to Introductory Accounting. I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.

I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and more.

Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting

Additional Information

Duration

4 Hours

Course Level

Basic

Instructional Method

Group Internet Based

Pre-requisites

An Understanding Of QuickBooks Online Software

Advance Preparation

None

FAQ’s

Click Here to View

NASBA APPROVED

MY-CPE LLC, 1600 Highway 6 south, suite 250, sugar land, TX, 77478

MY-CPE LLC (Sponsor Id#: 143597) 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.NASBARegistry.org.

Ratings and Review

4.4

Excellent

Very Good

Average

Poor

Terrible

Wendy Diaz, CPA (US)

I thought it was a very good course and the presenter seemed to be very knowledgeable on both applications.

Rachel Nowinski, CPA (US)

This was my first webinar with My-CPE and I was impressed with ease of use, thoroughness and presentation

Mary Nicks, CPA (US)

Instructor was knowledgeable, presented information well, and content was relevant.

JLS

John L Suter, CPA (US)

Great program, great presenter

Mary Zaleski, CPA (US)

The myCPE website offers a wonderful selection of categories of CPE courses, both Free and those with a cost. Cost is minimal. Would definitely recommend this site.

4 Credits

Add to Watchlist

Subject Area

Accounting

Unlimited Access Plan

Access to 12000+ Hours of Continuing Education Approved Content Know More

Subscribe To Register

Inclusions

Continuing Education Certificates for Multiple Qualifications View
Instant Certificates
Multiple Dates
Access on Mobile, Tablet and Desktop

Didn’t received verification email? Resend Email

Live Webinars

On Demand Webinars

Virtual Conferences

Specialized Packages

Advanced Certification Programs

myCPE Shorts Trending

Preparer Course

U.S. Individual Tax Preparer Course

U.S. Business Tax Preparer Course

Exam Prep Course

EA Exam Prep Course

CFP® Review Course

Teams Subscription (Per User)

Individual Subscription

Contact Sales Team

646-688-2884

inquiry@my-cpe.com

Schedule a Call

Flat $300 Off

Flat $640 Off

Flat $1000 Off

6 Million+

100K+

"Steven was knowledgeable and thorough…”

Crystal lovejoy

"Great Customer Service”

Lori corry

"It is what it advertised to be”

Brian Carey

"Great customer service”

Steve

Get 60% Off

Get 64% Off

Get 67% Off

Verification Code