Instructor for this course
more
Enrolled:
116
Duration: 1 Hour
Level: Intermediate
Access This Course: Instant Access to Course Library

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.

This course is part of a series of courses:

Excel Efficiency : Intro to Macros Part 1
Excel Efficiency : Intro to Macros Part 2
Excel Efficiency : Intro to Macros Part 3 (This Course)
Excel Efficiency : Intro to Macros Part 4

Course Collections

This course is included in the following Course Collections:

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.

17 Reviews (54 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.
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.
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.
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
Powerful tools here.
5
Member's Profile
Very good.
5
Anonymous Author
Great.

Prerequisites

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