Description:

This course teaches you to create a dynamic and automated template, generate reports, and gain insights from your data.

Description:

Microsoft has updated Excel’s Power Query tool – first released in 2010 – with many new features. Power Query offers the ability to access, link, and clean data to prepare it for reporting. In this se ...

Description:

In this somewhat whimsical online CPE presentation Excel expert David H. Ringstrom, CPA will share with you several Excel features that can be used for good or bad. The more that we understand what's ...

Description:

This course provides an overview of the basic setup and formatting options in Microsoft Excel.

Description:

This course covers the five most important Excel Shortcuts to help boost your productivity.

Description:

This course covers the five most important Excel Shortcuts to help boost your productivity.

Description:

In Part 1 of this two-part webinar series, you’ll learn how to use features and techniques that will improve your speed and efficiency in Excel. Upon completion of this course, you will be able to: Re ...

Description:

In Part 2 of this two-part webinar series, you’ll learn about even more ways to work efficiently in Excel. You’ll learn how to streamline repetitive tasks and identify additional time-saving Excel fea ...

Description:

In this practical webinar, you will learn techniques you can use to verify the integrity of even the most complicated Excel spreadsheets from Excel expert, David Ringstrom, CPA. You will learn how to ...

Description:

Auditing excel spreadsheets improves the integrity of the calculations and data in workbooks. In this webinar, you will learn techniques to verify the integrity of even the most complicated Excel work ...

Description:

In this webinar, Excel expert David Ringstrom, CPA, shares a variety of techniques you can use to verify the integrity of even the most complicated Excel workbooks. You’ll learn how to use Excel’s for ...

Description:

Upon successful completion of this course, you will be able to: Identify the structural basics of Excel worksheets and workbook List basic data-analysis techniques Manage Excel’s green error-checking ...

Description:

Description:

There are many features and functions available in Excel that you can use to improve the accuracy and efficiency of payroll production. In this practical webinar, Excel expert, David Ringstrom, CPA, d ...

Description:

There are many features and functions available in Excel that you can use to improve the accuracy and efficiency of payroll production. In this practical webinar, Excel expert, David Ringstrom, CPA, d ...

Description:

There are many features and functions available in Excel that you can use to improve the accuracy and efficiency of payroll production. In this comprehensive webinar, Excel expert David Ringstrom, CPA ...

Description:

There are many features and functions available in Excel that you can use to improve the accuracy and efficiency of payroll production. In this comprehensive webinar, Excel expert David Ringstrom, CPA ...

Description:

There are many features and functions available in Excel that you can use to improve the accuracy and efficiency of payroll production. In this practical webinar, Excel expert, David Ringstrom, CPA, d ...

Description:

In this fast-paced session, Excel and QuickBooks expert David H. Ringstrom shows you how to overcome the limitations of QuickBooks internal reports. Many times it can feel like your QuickBooks data is ...

Description:

Description:

Excel Time Value of Money Functions for CPAs uses practical examples to provide an overall understanding of time value of money concepts and to illustrate time value of money functions in Microsoft Ex ...

Description:

This course explores Excel Time Value of Money Functions for CPAs​.

Description:

Excel is the de facto budgeting and forecasting tool for most professionals, yet many don’t leverage its numerous built-in tools. Learn Excel features such as FORECAST, FORECAST.ETS, TREND, Forecast S ...

Description:

Excel is the de facto budgeting and forecasting tool for most professionals, yet many who use Excel for these tasks do not take advantage of numerous built-in tools that can be beneficial for these ta ...

Description:

The learning objective of this class is to teach financial advisors tips in Excel, including some intermediate and advanced tasks. Instructor Jim Cline, who has trained thousands of CPAs, financial ex ...

Description:

This course is designed to help intermediate Excel users enhance their efficiency through practical, time-saving techniques. Covering a wide range of topics from data formatting and formula shortcuts ...

Description:

Excel is the default program for many financial professionals--and highly effective--if used correctly. It can be used for everything from simple tabular analysis to creating in-depth aggregate pivot ...

Description:

This course was updated on 3/25/2017. This course is designed for the intermediate users of Excel 2010 and 2016 who are looking to improve their productivity and to learn new Excel skills. The course ...

Description:

This course covers the tips, tools and some techniques for Excel 2007. The features discussed are geared toward ones that a CPA needs to know. Watch your efficiency and productivity increase. This is ...

Description:

This course is designed for intermediate users of Excel 2010 and 2013 who are looking to improve their productivity and to learn new Excel skills. The course covers some basics, along with advanced ti ...

Description:

Watch your efficiency and productivity increase with this vital course. Discussed in depth are the Excel features CPAs need to know such as selecting and navigating through data; copying, moving, and ...

Description:

This course covers the five most important Excel Shortcuts to help boost your productivity.

Description:

This course covers the five most important Excel Shortcuts to help boost your productivity.

Description:

This course covers Selected Excel Shortcuts, Conditional Summing Basics, Remove Duplicates, Lookup Basics with VLOOKUP, and Advanced VLOOKUP.

Description:

This course covers selected Excel shortcuts including Conditional Summing Basics, Remove Duplicates, Lookup Basics with VLOOKUP, and Advanced VLOOKUP.

Description:

This course covers Selected Excel Shortcuts, Conditional Summing Basics, Remove Duplicates, Lookup Basics with VLOOKUP, and Advanced VLOOKUP.

Description:

This course covers selected Excel shortcuts including Conditional Summing Basics, Remove Duplicates, Lookup Basics with VLOOKUP, and Advanced VLOOKUP.

Description:

Learn how to rapidly master several fundamental functions of Excel including IFERROR, IF, List Comparisons, and more.

Description:

This course provides guidance to rapidly master several fundamental functions of Excel including IFERROR, IF, List Comparisons, and more.

Description:

Learn how to rapidly master several fundamental functions of Excel including IFERROR, IF, List Comparisons, and more.

Description:

This course provides guidance to rapidly master several fundamental functions of Excel including IFERROR, IF, List Comparisons, and more.

Description:

This course covers a number of key Excel functions and shortcuts to enable you to design better workbooks.

Description:

This course covers a number of key Excel functions and shortcuts to enable you to design better workbooks.

Description:

This course covers a number of key Excel functions and shortcuts to enable you to design better workbooks.

Description:

This course covers a number of key Excel functions and shortcuts to enable you to design better workbooks.

Description:

Learn tips for optimizing frequently occurring performance obstructions in Microsoft Excel through data validation, error checking, and reporting.

Description:

This course offers tips for optimizing frequently occurring performance obstructions in Excel through data validation, error checking, and reporting.

Description:

Learn tips for optimizing frequently occurring performance obstructions in Microsoft Excel through data validation, error checking, and reporting.

Description:

This course offers tips for optimizing frequently occurring performance obstructions in Excel through data validation, error checking, and reporting.

Description:

The first course in the Excel University series builds the foundations needed to create reliable recurring-use workbooks.