Agile Excel: Intro to Macros - Part 3 (Video) (Course Id 1463)

• Who is this course for?
  This course is intended for CPAs and other professionals seeking Continuing Professional Education (CPE), especially those who have completed Parts 1 and 2 of the macros series or have prior experience with Excel programming.

• What is this course about or what problem does this course solve?
  This course focuses on teaching Excel users how to write more advanced macros, including how to manage workbook scrollbars, unhide all worksheets, and implement decision-making and looping structures in code.

• How can the knowledge from this course be used?
  The skills learned in this course can be applied to automate and streamline repetitive Excel tasks, troubleshoot complex macros, and enhance productivity through customized Excel solutions.

• Why is this course important to a CPA, Accountant, or IRS Enrolled Agent?
  It helps accounting professionals leverage Excel automation to reduce manual errors and increase efficiency in spreadsheet management, which is essential in data-intensive environments.

• When is this course relevant or timely?
  This course is particularly timely for professionals looking to improve their Excel programming skills using modern techniques demonstrated with Excel 2016, and it's also applicable to versions 2013, 2010, and 2007.

• How is a course like this consumed or used?
  This video-based course is consumed via QAS self-study, with demonstrations in both slides and Excel, supplemented by handouts and an example workbook, and completed by passing a final exam.

This is the ideal presentation for those who wish to expand their ability to write programming code. Excel expert David Ringstrom shows you how to create a macro that can reset workbooks that have skewed scrollbars, as well as 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 comparing 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.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast. 

Video - NASBA QAS - NASBA Registry - 1463

Course Learning Objectives

Chapter 1 - Agile Excel: Intro to Macros - Part 3

Chapter 1 Review Questions

Glossary - Key Terms