DavidRingstrom

Excel Macro Basics: Part 1- On-Demand

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

In this comprehensive webcast, Excel expert David Ringstrom, CPA, introduces you to Visual Basic for Applications (VBA) macros—one of Excel’s most powerful features.

You’ll learn how to use Excel’s Record Macro feature to automate repetitive tasks and create your own keyboard shortcuts for Excel features. In addition, David demonstrates how to manage macro security prompts, how to use Excel’s Personal Macro Workbook, and how to convert .XLS workbooks to the up-to-date .XLSX format.

After participating in Part 1 of Excel Macro Basics, you’ll be equipped to begin using macros immediately to speed up your work in Excel.

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 seeking to understand the concept of macros and gaining experience with VBA macros and the Record Macro feature.

Topics Typically Covered:

  • Convert .XLS workbooks to the up-to-date .XLSX format with just two keystrokes.
  • Decipher and manage Excel’s macro security prompts.
  • Discover how to use Excel’s Personal Macro Workbook.
  • Learn how to use Excel’s Record Macro feature to create simple macros, without having any knowledge of programming.
  • Learn the risks and frustrations of using merged cells in Excel worksheets.
  • Understand how macros are used in Excel, along with the risks and benefits associated with them.

Learning Objectives:

  • Apply Visual Basic for Applications (VBA) macros in Excel.
  • Define how to use the Record Macro feature.
  • Apply the Hide and Unhide commands in an Excel Personal Macro Workbook as needed.

This is part one 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 an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).

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.