FocusCPD

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

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

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 ...

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, 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 ...

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 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...

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 ...

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 ...