Instructor for this course
more
Enrolled:
113
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.

16 Reviews (53 ratings)Reviews

5
Member's Profile
Powerful tools here.
5
Anonymous Author
Learned about the relationship of macros to Visual Basic.
5
Anonymous Author
Easy to comprehend concept covered
5
Anonymous Author
Helpful to show how to use input boxes. Good basic information on how to break down the code language.
5
Anonymous Author
Great.
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
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.
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
Lots of good info on leveraging macros to automate tasks.
5
Member's Profile
Very good.
5
Member's Profile
Very informative and thought provoking
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
The Macro's course gets better as you go deeper into it. Well Done !!
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
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.

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