Excel Explained - 10 Webinar Bundle

This bundle contains 10 of our Excel webinars at a discounted price of $1895 (a $2,950 value)! Each webinar is roughly two hours in length. Registrations include twelve months of OnDemand playback.

These webinars are entirely presented by CPA and Excel expert, David Ringstrom. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly 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 webinar.

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.

Covered Topics

Excel Explained: Introduction to Spreadsheets
We'll walk through the basics of Excel spreadsheets, providing the knowledge needed to create functional spreadsheets and manipulate large lists of data.

Excel Explained: Pivot Tables 101
We'll focus on the basics of using Excel pivot tables in this comprehensive presentation. Pivot tables empower you to easily create reports from complex data, simply by using your mouse.

Excel Explained: Filtering and Slicing Data
We'll discuss a number of techniques you can use to quickly sift through large amounts of data and stave off information overload. He contrasts the Table and Filter features, explains how to filter data in pivot tables, and shares several helpful shortcuts.

Excel Explained: Minimize Spreadsheet Errors
You will learn a variety of tricks and techniques you can use to improve the integrity of your Excel spreadsheets. You’ll also discover methods for auditing the spreadsheets created by others.

Excel Explained: Creating Interactive Spreadsheets
You will learn how to implement multiple techniques to create spreadsheets that are interactive, accurate, and user friendly.

Excel Explained: Speed Tips
This webinar will empower you to quickly accomplish tasks that might currently be taking you several minutes or even hours to complete.

Excel Explained: Automating Financial Statements
David shows you step-by-step how to create dynamic accounting reports for any month of the year on a single worksheet. As an alternative to building cumbersome worksheets for each month of the year, David explains how to use Excel functions, such as VLOOKUP, OFFSET, and SUM, to quickly create accounting reports that can be toggled to any reporting period with only two mouse clicks.

Excel Explained: Payroll Analysis
Even if you don't work with payroll data, you’ll benefit from learning how many Excel features and functions can improve the accuracy and efficiency of payroll-related tasks as the techniques are equally applicable to many other types of spreadsheets as well.

Excel Explained: Charts
David shares a variety of tricks and techniques you can use to create and automate Excel charts in this informative session. He covers several helpful features Excel offers, including the Recommended Charts feature, the Sparkline feature, and the PivotChart feature.

Excel Explained: Auditing Spreadsheets
David shares techniques you can use to verify the integrity of even the most complicated Excel workbooks. David demonstrates Excel’s formula auditing and error-checking tools, as well as how to verify which cells contain formulas versus values.

Who Should Attend?

Practitioners who review and audit Excel spreadsheets created by others, or those who wish to improve the integrity of their own spreadsheets.

Great explanation, slide presentation, and actual demonstration. Loved that there was an excel spreadsheet so we could follow along and do the work alongside of you.

I thought the presentation was very good. It provided me with a lot of tips and techniques that will be useful for future research projects. I work with Excel a lot for these research projects and the information I learned from this webinar will facilitate my work.