DavidRingstrom

Excel Macro Basics: Part 2 – On-Demand

Original Recording Date: April 28th, 2017
Duration: 100 minutes

In Part 2 of Excel Macro Basics, Excel expert David H. Ringstrom, CPA, guides you beyond the basics of Excel’s Record Macro feature. He demonstrates how to enhance the code you’ve created by adding error-handling features, interactive features, and decision-making capabilities.

In addition, David explains how to:

  • Filter based on cell contents.
  • Simplify what-if analysis with Excel’s Goal Seek feature.
  • Play back recorded macros to eliminate repetitive tasks.
  • Create simple macros with the Record Macro feature… and more.

David demonstrates every technique at least twice, first on a PowerPoint slide with numbered steps, and second in Excel 2016. He’ll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation, as well as in his detailed handouts.

Who Should Attend:

Practitioners who would like to expand their knowledge of using Excel macros to speed up their work in Excel.

Topics Typically Covered:

  • Add error-handling features to Excel macros to compensate for unexpected or missing data entry inputs.
  • Bypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
  • Discover how to enable the Developer menu in Excel 2007 and later.
  • Gain an understanding of Excel’s Goal Seek feature, which is useful in simplifying what-if analyses.
  • Learn how to play back macros you’ve recorded so as to eliminate repetitive or tedious tasks.
  • Learn how to use Excel’s Record Macro feature to create simple macros, without having any knowledge of programming.
  • Learn the nuances of the Excel Macro-Enabled Workbook in versions 2007 and later.
  • Learn what to do if a Debug prompt appears.
  • Understand the nuances of assigning keyboard shortcuts to macros in Excel and avoid superseding shortcuts for built-in features.
  • Use form controls to simplify data entry as well as to control the input of other users.

Learning Objectives:

  • Recall what to do if a Debug prompt appears.
  • Apply Excel’s Goal Seek feature.
  • Define the benefits of adding error-handling features to macros.

This is part two of a two-part webinar series. To register for both parts together at a discounted price, please click here.

Course Reviews

100% of attendees said they would recommend this course to others.

“Very informative.”

“Instructor is awesome.”

Faculty - David Ringstrom


About the Presenter

David H. Ringstrom, CPA, is the owner and founder of Accounting Advisors, Inc., a spreadsheet consulting firm. Mr. Ringstrom is an author and nationally recognized instructor who teaches scores of webinars each year and provides Microsoft Excel training and consulting services nationwide. Mr. Ringstrom’s Excel courses are based on 25 years of consulting and teaching experience.

Group Discounts

icon-groupIf you add more people from your organization, the registration fee for each person will be discounted as described below. The discount will be automatically applied during checkout.

2-4

$74
25% Off

5-9

$66
33% Off

10+

$49
50% Off

On-Demand

icon-webinar-smShortly after you register, we will email you a link to view the webinar recording and a PDF of the presentation materials. You will be able to view the webinar recording as many times as you wish for up to 1 year.  If you have any questions, please contact us.

Access Everywhere

Access the recorded webinar at any time on your computer, tablet, or smartphone.

Money-Back Guarantee

If you’re not satisfied with the course, we will promptly refund your money.

All-Access Membership

icon-membershipJoin our all-access membership program to participate in this webinar and any live or recorded webinar for a flat annual fee.

Learn More

FAQs

Any questions?  Please view our FAQs page or contact us.

$99

Group Discounts

icon-groupIf you add more people from your organization, the registration fee for each person will be discounted as described below. The discount will be automatically applied during checkout.

2-4

$74
25% Off

5-9

$66
33% Off

10+

$49
50% Off

On-Demand

icon-webinar-smShortly after you register, we will email you a link to view the webinar recording and a PDF of the presentation materials. You will be able to view the webinar recording as many times as you wish for up to 1 year.  If you have any questions, please contact us.

Access Everywhere

Access the recorded webinar at any time on your computer, tablet, or smartphone.

Money-Back Guarantee

If you’re not satisfied with the course, we will promptly refund your money.

All-Access Membership

icon-membershipJoin our all-access membership program to participate in this webinar and any live or recorded webinar for a flat annual fee.

Learn More

FAQs

Any questions?  Please view our FAQs page or contact us.