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

In this course Excel expert David Ringstrom, CPA, starts out by adding more error-handling capabilities to the Goal Seek macro he started in Part 3. The discussion then shifts to enhancing the accounting report clean-up macro introduced in Part 2 of the series. David shows how to build in yes/no prompts, allow the user to choose a specific file to process, and enhance code generated by Excel's Macro Recorder to create flexible macros that can deal with data sets of varying sizes. You also learn debugging techniques that are useful in resolving errors within both macros that you record or that you enhance with additional programming code.

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.
  • By-pass the filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
  • Learn the nuances of Macro-Enabled workbooks in Excel 2007 and later.
  • Learn what to do next if a Debug prompt appears.
  • See how to use Excel's Macro Recorder to create simple macros without any programming knowledge required.
  • Use the Text to Columns feature to eliminate unwanted text without retyping, or to separate text into separate columns.

Course Collections

This course is included in the following Course Collections:

Learning Objectives

  • Identify how to enhance user feedback in message boxes with icons
  • Identify the keyboard shortcut that allows you to step through programming code one line at a time.
  • Identify keyboard shortcuts for halting a running macro.

17 Reviews (50 ratings)Reviews

5
Member's Profile
More please!Disagree Neutral Agree Strongly Agree Stated learning objectives were met Stated prerequisite requirements were appropriate and sufficient Program materials were relevant and contributed to the achievement of the learning objectives Time allotted to the learning activity was appropriate Instructor(s) was effective   Course Overview CPE / CPD Quick Guide to Course Navigation Course Syllabus Progress:   93% INTRODUCTION AND OVERVIEW   6:36 Introduction; Handling Invalid Inputs Intro to Macros Part 4   7:27 Error Handling; Debugging Macros   6:08 Compile Errors; Syntax Errors   6:00 Text File Import Macro   7:37 MsgBox; GetOpenFileName   8:04 Opening the File; Optimizing Filtering   6:43 Simplifying Text To Columns; Macro Buttons; Halting Macros CONCLUSION   4:19 Additional Resources Continuous Play   52:54 Excel Efficiency : Intro to Macros Part 4 SUPPORTING MATERIALS   PDF Slides: Intro to Macros Part 4   PDF Intro to Macros Part 4 Glossary/Index   XLSX Intro to Macros Part 4-Excel 2007-2016 REVIEW & TEST   quiz REVIEW QUESTIONS
4
Member's Profile
This course best illustrates how complex the macro coding process is and the fact that you're not going to learn it in a couple of 1 hr sessions - so temper expectations. There is a host of underlying code knowledge required to move from the simple macro recorder to highly functioning complex macros. I appreciate that the author acknowledged such and provided references for those that wish to pursue the next level.
5
Member's Profile
Thanks for opening the world of VBA. I have done some basic macro work - but when anything gets big turn to Visual FoxPro (my lifelong tool of choice). VFP has been deprecated - so this course has given me a nudge to do more within Excel when the opportunity presents itself.
3
Anonymous Author
Learned a lot but was probably the most difficult of the 4 part series. There was a lot more discussion versus seeing excel in action. I'm sure this was due to the complexity.
4
Anonymous Author
Good course. Worth having to expand your understanding of the range of applications macros can have especially to round out the previous 3 macro courses.
5
Anonymous Author
This course contains more vba functions and language of the 4 courses offered. Definitely suited for someone who wants to learn more about vba.
5
Anonymous Author
Great course that helps walk through things that can cause macro to result in errors when running based on user input. Very helpful.
5
Anonymous Author
Very informative for those that want to expand Excel abilities. Presenter moves through material quickly but in depth.
5
Anonymous Author
Very helpful overview of how to use Visual Basic to customize/troubleshoot macros in Excel
5
Member's Profile
Great series! I intend to do all of David's courses available in Proformative/Illumeo
4
Anonymous Author
instructor does a great job demonstrating complex topics.
4
Member's Profile
Great intro and shown what is possible within Excel VBA
5
Member's Profile
Lots of good info on editing code behind macros.
5
Member's Profile
Comples issues explained well
4
Member's Profile
Clear instructions.
5
Anonymous Author
Great course
5
Anonymous Author
Very good.

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 .

2 QuestionsCourse Questions and Answers

User picture

All the courses are really helpful to improve excel works! All the automation using macro, VB makes coworkers stunned. Now I am interested in developing database at work. I find your Access course from other websites. Is there any plan to provide Access courses here? Please let me be a rockstar again at work!

User picture

All the courses are really helpful to improve excel works! All the automation using macro, VB makes coworkers stunned. Now I am interested in developing database at work. I find your Access course from other websites. Is there any plan to provide Access courses here? Please let me be a rockstar again at work!

Course Syllabus
INTRODUCTION AND OVERVIEW
Intro to Macros Part 4
  7:27Error Handling; Debugging Macros
  6:08Compile Errors; Syntax Errors
  6:00Text File Import Macro
  7:37 MsgBox; GetOpenFileName
  8:04Opening the File; Optimizing Filtering
  6:43Simplifying Text To Columns; Macro Buttons; Halting Macros
CONCLUSION
  4:19 Additional Resources
Continuous Play
  52:54Excel Efficiency : Intro to Macros Part 4
SUPPORTING MATERIALS
  PDFSlides: Intro to Macros Part 4
  PDFIntro to Macros Part 4 Glossary/Index
  XLSXIntro to Macros Part 4-Excel 2007-2016
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM