### Excel - Extended Package

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

26h
Lecturer
Multiple Lecturers
$520$2054

### Pragmatic Excel: The Basics

This package includes the following 4 Introductory level Pragmatic Excel courses:

• Error Prompts
• Introduction to Lookup Functions
• Table Features
• Introduction to Pivot Tables

8h
Lecturer
Multiple Lecturers
$199$1592

### 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
$396$1592

### Pragmatic Excel - Pivot Tables Package

Many users shy away from pivot tables, thinking that specialized knowledge is required. In fact, pivot tables are one of the easiest and best features to use in Excel, as long as you follow a few simple ground rules. In no time you'll be transforming staid and/or overwhelming data sets into ...

6h
Lecturer
Multiple Lecturers
$149$297

### 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
$99$199

### Pragmatic Excel - Minimizing Errors

You’ll discover a variety of techniques and tricks you can use to create spreadsheets that are free of errors in this comprehensive on-demand webcast. Excel expert David Ringstrom, CPA, demonstrates how to implement Excel features and functions, such as hide and protect features, the ...

2h
Lecturer
David Ringstrom
$99$199

### 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
$99$199

### Pragmatic Excel - Table Feature

In this comprehensive course, Excel expert David Ringstrom, CPA, provides a top-to-bottom overview of the Table feature. This valuable feature can transform the way you use Excel and increase your effectiveness. David discusses numerous opportunities to vastly improve the integrity of ...

2h
Lecturer
David Ringstrom
$99$199

### 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
$99$199

### Pragmatic Excel - Intermediate Pivot Tables

In this presentation Excel expert David Ringstrom, CPA, takes you beyond the basics of pivot tables, which are a report writing feature in Microsoft Excel. You'll see how to transform unwieldy reports into pivot table-ready lists. David will then show how you can drill down into the ...

2h
Lecturer
David Ringstrom
$99$199

### 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$199

### 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$199

### Pragmatic Excel - Budget Spreadsheets

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
$99$199

### Pragmatic Excel - Automating Financial Statements

As an alternative to building cumbersome accounting worksheets for each month of the year, Excel expert David Ringstrom, CPA, explains how to use Excel functions, including VLOOKUP, OFFSET, and SUM, to quickly create accounting reports that allow you to switch to any reporting period with ...

2h
Lecturer
David Ringstrom
$99$199

### 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
$99$199

### Pragmatic Excel - Introduction to Lookup Functions

Are you looking for functions within Excel that allow you to rapidly develop accurate spreadsheets as well as look up information, such as pay rates, item prices, and accounting results? In this comprehensive course, Excel expert David Ringstrom, CPA, introduces you to several of these ...

2h
Lecturer
David Ringstrom
$99$199

### 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$199