Instructor for this course
more

In this course Excel expert David Ringstrom, CPA goes beyond the Macro Recorder concepts that he introduces in Parts 1 and 2 of this series. David first shows how to enable the Developer tab in Excel 2007 and later, which makes many macro-related tasks easier. He then introduces Excel's Goal Seek feature, which is then used as the basis for adding interactivity to recorded macros. David shows how to create a macro button, prompt the user for input, and begins the discussion of handling errors within macros, which will continue into Part 4 of this series.

David teaches from Excel 2010 but provides handouts with numbered steps that are specific to Excel 2003, Excel 2007, Excel 2010, Excel 2013, and 2016.

Topics covered:

  • Add error handling features to Excel macros to compensate for unexpected or missing data entry inputs.
  • Gain an understanding of Excel's Goal Seek feature, which is useful in simplifying what-if analyses.
  • Learn how to play back macros that you've recorded so as to automate repetitive or tedious tasks.
  • Learn what to do next if a Debug prompt appears.
  • bull; See how to enable the Developer tab in Excel 2007 and later.
  • 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 but also control user's inputs.

Course Series

This course is included in the following series:

4 CoursesExcel Efficiency: Macros

  1. Excel Efficiency: Intro to Macros Part 1
  2. Excel Efficiency: Intro to Macros Part 2
  3. Excel Efficiency: Intro to Macros Part 3
  4. Excel Efficiency: Intro to Macros Part 4

Learning Objectives

  • Identify the location of hidden macro-related features in Excel.
  • Distinguish a method in Visual Basic for Applications from objects, variables, and other concepts.
  • Identify how to safely create shortcut keys for Excel macros without overriding built-in keyboard shortcuts.

23 Reviews (63 ratings)Reviews

5
Member's Profile
I really appreciate the way the presenter provides first the concept of the lesson, then illustrated click-by-click instructions and then finally observable practice. One of my favorite presenters as in each lesson I seem to come away with at least one new trick unrelated to the primary topic.
5
Member's Profile
I really like how David organizes his courses. Detail discussion on a slide with notes and clear indication on the proper order of doing a task. This is also where he goes on any relevant tangents. Then an actual demonstration in Excel. I think this really reinforces the learning.
3
Member's Profile
A little too Techie for me but the presentation is very well done. If I had the patience to work through it all I'm sure I could get it because of the quality and detail of the program.
5
Member's Profile
Great detailed walk through for beginners on how to edit VBA for a specific function. Look forward to taking more courses that offer additional examples of useful VBA code.
4
Member's Profile
Good course - loads of potential to use these techniques to automate daily tasks. Downside - debugging first attempts at creating these macros.
5
Member's Profile
Very practical. Also like that David introduces subtopics to illustrate the material, like Goal Seek. I learned 2 new things in one video
4
Anonymous Author
Learned the purpose of developer and how to create a button. I feel I learned a few tricks to save time and idiot proof features.
5
Anonymous Author
Helpful to show how to use input boxes. Good basic information on how to break down the code language.
4
Anonymous Author
Great instructor. Thoroughly explains and demonstrates information for those inexperienced in coding.
4
Anonymous Author
Good course, really liked the information on getting started with visual basic
5
Member's Profile
The Macro's course gets better as you go deeper into it. Well Done !!
5
Member's Profile
Lots of good info on leveraging macros to automate tasks.
5
Anonymous Author
Learned about the relationship of macros to Visual Basic.
4
Anonymous Author
Good overview of the basic macro editing functions.
5
Member's Profile
Very informative and thought provoking
4
Member's Profile
Easy to follow. Clear instructions
5
Anonymous Author
Easy to comprehend concept covered
5
Member's Profile
Excellent presentation
5
Anonymous Author
Very useful guidance.
5
Member's Profile
Powerful tools here.
5
Anonymous Author
Great course
5
Member's Profile
Very good.
5
Anonymous Author
Great.

Prerequisites

Course Complexity: Intermediate

No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 ext. 106, or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
Intro to Macros Part 3
  7:58Introducing and Automating Goal Seek
  8:45Recording and Viewing the Goal Seek Macro
  7:51VBA Objects, Properties, and Methods
  6:39Creating Macro Buttons; Running the Goal Seek macro
  9:04Macro Keyboard Shortcuts; Introduction to Variables
CONCLUSION
  11:29Prompting the user for Input; Testing the user's response
Continuous Play
  55:36Excel Efficiency : Intro to Macros Part 3
SUPPORTING MATERIALS
  PDFSlides: Intro to Macros Part 3
  PDFIntro to Macros Part 3 Glossary/Index
  XLSXExcel Efficiency Intro to Macros Part 3
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM