CPE Online Courses

Online CPE courses from MasterCPE are fast, convenient and affordable. Choose below from a wide selection of CPA continuing education courses to quickly complete your CPE requirements. A range of topics are available, and once you select an online course, you can study anytime, anywhere. CPE courses are downloadable PDF files that you can view on your computer or print. All grading is done online, and certificates are accessible as soon as you successfully complete a CPE course. Select CPE courses by subject, hours or price, and easily finish your CPE today!

Accounting and Auditing

Course Name CPE Price Profession Select
No course available in this category.

Computer Software

Course Name CPE Price Profession Select
Excel expert David Ringstrom, CPA, will teach you how to create dynamic financial reports-for any month of the year-on a single worksheet. Many Excel users build a worksheet for each month of the year, which can be inconvenient and tiresome to revise. Rather than using such a cumbersome method, David demonstrates how to apply the VLOOKUP, OFFSET, and SUM functions to quickly create accounting reports that allow you to toggle to any reporting period with just a couple of mouse clicks. In addition, David shares effective ways to export data from your accounting package so you can create a "set-and-forget" link to your accounting data in Excel. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 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 video.

Field of Study: Computer Software and Applications

CPE Hours: 2.0

2.0 $ 19.95 CPA Buy
In this comprehensive presentation, Excel expert David Ringstrom, CPA, demonstrates how many Excel functions and features can be used to create adaptable and easy-to-maintain budget spreadsheets. David explains how to separate inputs from calculations, build out a separate calculations spreadsheet, create both an operating and a cash flow budget, transform filtering tasks, preserve key formulas, and more. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 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 video.

Field of Study: Computer Software and Applications

CPE Hours: 2.0

2.0 $ 19.95 CPA Buy
Learn how to minimize errors in your Excel spreadsheets from Excel expert David Ringstrom, CPA. In this valuable presentation, he shares a variety of tricks and techniques you can implement to create and maintain spreadsheets that are free of errors. David demonstrates how to implement Excel features and functions, such as the Hide and Protect feature, the Conditional Formatting feature, the VLOOKUP function, the SUBTOTAL function, and others. In addition, he discusses how to preserve key formulas, perform dual lookups, audit the spreadsheets created by others, and more. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 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.

Field of Study: Computer Software and Applications

CPE Hours: 2.0

2.0 $ 19.95 CPA Buy
Excel expert David Ringstrom, CPA, takes you step-by-step through the process of creating and using macros-one of Excel's most powerful features. In this comprehensive presentation, he introduces the concept of Excel macros as well as the Visual Basic for Applications (VBA) macro. David also explains step-by-step how to use the Record Macro feature and Excel's Personal Macro Workbook. After completing this course, you'll be equipped to use macros immediately. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 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.

Field of Study: Computer Software and Applications

CPE Hours: 2.0

2.0 $ 19.95 CPA Buy
In this comprehensive on-demand webcast, you'll learn even more about how to use Excel's Record Macro feature from Excel expert David Ringstrom, CPA. He shows you how to enhance the code you've created with the Record Macro feature by adding error-handling functions, decision-making capabilities, and interactive features. In addition, David presents techniques, features, and keyboard shortcuts that will help you eliminate repetitive tasks and become more proficient utilizing Excel macros. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 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.

Field of Study: Computer Software and Applications

CPE Hours: 2.0

2.0 $ 19.95 CPA Buy
Recent research released by Microsoft shows that 80% of Excel users have yet to use pivot tables. In this presentation Excel expert David H. Ringstrom, CPA, covers the basics of creating and using Excel pivot tables. You'll quickly be able to instantly summarize lists of data into meaningful reports with just a few clicks of your mouse. As with many aspects of Excel, pivot tables have several nuances that can frustrate new users, so David will be sure to bring these to your attention so that you can use the feature effectively. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 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.

Field of Study: Computer Software and Applications

CPE Hours: 2.0

2.0 $ 19.95 CPA Buy
This presentation will empower you to take your pivot table knowledge to the next level. Excel expert David Ringstrom, CPA, takes you beyond the basics of pivot tables by demonstrating how pivot tables differ from worksheet formulas, the importance of the Refresh and Report Filter commands, how to disable the GETPIVOTDATA function, how to drill down into numbers with a simple double-click, and much more. You'll also see how to quickly transform unwieldy reports into pivot table-ready lists. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 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 video.

Field of Study: Computer Software and Applications

CPE Hours: 2.0

2.0 $ 19.95 CPA Buy
If you'd like to discover features and techniques you can use to speed up your work in Excel, this is the perfect course for you! In his jam-packed session, Excel expert David Ringstrom, CPA, explains a variety of time-saving features and shares helpful tips, such as how to filter data faster, streamline repetitive tasks, create keyboard shortcuts, access folders and workbooks easily, and more. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 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 video.

Field of Study: Computer Software and Applications

CPE Hours: 2.0

2.0 $ 19.95 CPA Buy
You'll discover even more ways to save time and effort in Excel when you take this course. In part 2 of Speed Tips, Excel expert David Ringstrom, CPA, demonstrates shortcuts that allow you to streamline repetitive tasks and redundant data entry, embed lists you use frequently, transform filtering tasks, and more. In addition, David explains the benefits associated with Excel's Text Box feature, the Personal Macro Workbook, and the Quick Analysis feature. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 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 video.

Field of Study: Computer Software and Applications

CPE Hours: 2.0

2.0 $ 19.95 CPA Buy
This informative on-demand webcast presented by Excel expert David Ringstrom, CPA, is designed to teach you how to implement Excel's powerful What-If Analysis tools. David explains how and when to make use of Excel's Scenario Manager, how to use the Data Table feature to compare calculation results based on two or three inputs, how to use Excel's Goal Seek feature to perform basic what-if analyses, and more. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 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 video.

Field of Study: Computer Software and Applications

CPE Hours: 2.0

2.0 $ 19.95 CPA Buy

Ethics

Course Name CPE Price Profession Select
No course available in this category.

Finance

Course Name CPE Price Profession Select
No course available in this category.

Business Management and Organization

Course Name CPE Price Profession Select
No course available in this category.

Personal Development

Course Name CPE Price Profession Select
No course available in this category.

Specialized Knowledge and Applications

Course Name CPE Price Profession Select
No course available in this category.

Taxation

Course Name CPE Price Profession Select
No course available in this category.

Other

Course Name CPE Price Profession Select
No course available in this category.

Start Saving on Your CPE Today!

Join MasterCPE

Confirmation

Yes   No