
Excel - Extended Package
Get all 13 of our current Excel courses at a substantial savings!
Get all 13 of our current Excel courses at a substantial savings!
This package includes the following 4 Introductory level Pragmatic Excel courses:
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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...
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 ...
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 ...
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, ...
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 ...
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...