Making the Numbers Work: An In-depth Look into Excel Formulas and Macros (Currently Unavailable)

In Part 2 of Introduction to Excel Macros, Excel expert David Ringstrom, CPA, takes you beyond the basics of using Excel’s Record Macro feature and explains how to enhance the code you’ve created by adding error-handling features and decision-making capabilities. David shares techniques and keyboard shortcuts that will help you eliminate repetitive tasks and become more proficient with Excel macros.
Sometimes your formulas can grow out of control, or, more likely, you’ve inherited spreadsheets from others that you’re to take ownership of. In this comprehensive presentation, you’ll learn from Excel expert David Ringstrom, CPA, multiple ways to make sense of complicated formulas. After this on-demand course, you’ll have many tricks at your disposal to quickly decipher even the most complex Excel formulas.
Part 3 of this series on Excel macros expands your ability to write programming code. Excel expert David Ringstrom shows you how to create a macro that can reset workbooks that have skewed scrollbars, along with a second macro that can be used to instantly unhide all worksheets in a workbook at once. David goes deeper into making decisions in programming code by contrasting If and Select Case statements. He also contrasts three ways of creating loops in Excel: For Each, Do While, and Do Until. In addition, David explains how to troubleshoot problematic loops in Excel, which in certain instances can cause Excel to crash.
Part 4 of this series on Excel macros introduces the concept of UserForms in Excel. Excel expert David Ringstrom walks you through creating custom dialog boxes that can add interactivity in Excel and can better manage a user’s actions. David first walks you through the most common controls used within UserForms. He then builds a custom printing interface that he dubbed “Plug and Print,” which allow users to pick and choose the worksheets to print from any workbook. The presentation also shows how to create a basic UserForm for prompting users to input data, including making all fields required. Finally, you’ll see how to move module sheets and UserForms between workbooks, as well as how to remove them from workbooks when no longer needed.
When you participate in this live presentation, you’ll learn from Excel expert David Ringstrom, CPA, about Excel’s six worksheet functions: SUM, SUBTOTAL, AGGREGATE, SUMIF, SUMIFS, and SUMPRODUCT. David also shares the pros, cons, limitations, and uses for each.
In this comprehensive presentation, Excel expert David Ringstrom, CPA, teaches you how to create resilient and easy-to-maintain budget spreadsheets. 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.
If you want to learn how to create and implement macros—one of Excel’s most powerful features—this presentation is designed just for you. Excel expert David Ringstrom, CPA, introduces you to the concept of Excel macros as well as to the Visual Basic for Applications (VBA) macro. He also explains how to use the Record Macro feature and Excel’s Personal Macro Workbook. After participating in this course, you’ll be prepared to begin utilizing macros immediately.
Total: 7 courses (14 CPE hours)

">
 Chat — Books Support