Excel - Extended Package

Get all 13 of our current Excel courses at a substantial savings!

26h
Lecturer
Multiple Lecturers

Pragmatic Excel: Beyond the Basics

This package includes the following 8 intermediate level Pragmatic Excel courses:

Minimizing Errors
Six Ways to Sum
Automating Financial Statements
Logic Functions
VLOOKUP and Alternatives
Internal Control
Intermediate Pivot Tables
16h
Lecturer
Multiple Lecturers

Pragmatic Excel: Error Prompts

Do you often get stopped in your tracks by error prompts you receive while performing seemingly simple actions in your spreadsheets? If so, you’ll find this course extremely helpful. Excel expert David Ringstrom, CPA, delves into the intricacies of Excel to explain why error prompts can be ...

2h
Lecturer
Multiple Lecturers

Pragmatic Excel - Six Ways to Sum

In this comprehensive course, Excel expert David Ringstrom, CPA, explains six worksheet functions that can be used to sum data in Excel: SUM, SUBTOTAL, AGGREGATE, SUMIF, SUMIFS, and SUMPRODUCT. David covers the pros, cons, and limitations of each type of worksheet function suggests uses for ...

2h
Lecturer
David Ringstrom

Pragmatic Excel - Intro to Pivot Tables

Excel expert David Ringstrom, CPA, will guide you through the basics of creating and using pivot tables. Many users shy away from pivot tables, thinking that specialized knowledge is required. In fact, pivot tables are one of the easist and best features to use in Excel, as long as you follow a ...

2h
Lecturer
David Ringstrom

Pragmatic Excel - Advanced Pivot Tables

In this comprehensive on-demand webcast, Excel expert David Ringstrom, CPA, digs deeper into pivot tables to show you step-by-step how to manipulate your pivot table data faster and more efficiently. You’ll learn how to extract data from Microsoft Access databases and other sources, minimize ...

2h
Lecturer
David Ringstrom
$99 Pragmatic Excel - Internal Control In this useful presentation, you’ll learn from Excel expert David Ringstrom, CPA, how to implement Excel’s internal control features within your spreadsheets. He explains how a variety of Excel features— Conditional Formatting, Data Validation, and custom number formats—can be used to control... 2h Lecturer David Ringstrom$99

Step by step, Excel expert David Ringstrom, CPA, demonstrates how to create resilient and easy-to-maintain budget spreadsheets in this presentation. Among other techniques, David shows you how to separate inputs from calculations, build out a separate calculations spreadsheet, create both an ...

2h
Lecturer
David Ringstrom

Pragmatic Excel - Logic Functions

In this presentation Excel expert David Ringstrom, CPA, leads off with a brief discussion of the IF function in Microsoft Excel and then goes beyond the basics. You'll see how quickly nesting multiple IF functions together can go awry, as well as see alternatives, including IFNA, MINIFS, ...

2h
Lecturer
David Ringstrom

Pragmatic Excel - VLOOKUP and Alternatives

Are you concerned about the integrity and resilience of your spreadsheets? If so, you’ll find this on-demand course extremely helpful. In part 2 of Lookup Functions, Excel expert David Ringstrom, CPA, delves deeper into lookup functions and shares multiple troubleshooting techniques that will...

2h
Lecturer
David Ringstrom
\$99