Excel - Extended Package

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 encountered, and he outlines in detail what actions to take when Excel appears to go awry.

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 Conditional Formatting feature, the VLOOKUP function, the SUBTOTAL function, and others. In addition, David discusses how to preserve key formulas, perform dual lookups, audit the spreadsheets created by others, and more.

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 each. He also shares how to create more flexible formulas using the INDIRECT and OFFSET functions, and how to quickly and easily verify sums and totals.

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 spreadsheets, reduce spreadsheet maintenance, and best utilize the Table feature.

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 few simple ground rules. In no time you'll be transforming staid and/or overwhelming datasets into interactive reports with just a few mouse clicks. 

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 details behind a pivot table, as well as prevent others from doing so. You'll also see three different ways to perform calculations based on data within pivot tables, in addition to using Slicers and Timelines to filter pivot table data. The presentation concludes with a discussion of pivot charts in Excel.

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 repetitive steps in Excel by creating keyboard shortcuts, and adapt simple macros that can be recorded. In addition, David discusses several helpful Excel features, including the Table feature, PivotTable feature, Slicer feature, Linked Picture feature, the PowerPivot feature, and others.

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 users’ actions and protect your worksheets and workbooks from unauthorized changes. In addition, David explains the benefits of the VLOOKUP, SUMIF, and other Excel functions.

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 operating and a cash flow budget, transform filtering tasks, and preserve key formulas.

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 only two mouse clicks. In addition, David outlines how to export data from your accounting package, improve the integrity of your spreadsheets, incorporate Check Figures and Alarms into you work, and more.

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, SUMPRODUCT, and others. David contends that if you’re nesting more than a couple of IF functions in a single formula, there’s probably a more refined and resilient approach you can take. This presentation will empower you to craft more elegant decision-making formulas in your spreadsheets.

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 functions, including VLOOKUP, HLOOKUP, MATCH, and CHOOSE. David explains the context of when to use lookup functions, demonstrates troubleshooting techniques, and prepares you to deal with subtle issues that can prevent them from working properly.

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 enable you to work more efficiently in Excel. David’s presentation begins with an overview of the popular VLOOKUP function, contrasting it with the HLOOKUP and VLOOKUP functions. You’ll also learn how to take lookup functions further with the Data Validation and Table features and how to implement next-level lookup functions, such as MATCH/INDEX, CHOOSE, SUMIF, and SUMIFS.