Intro to Excel Macros Part 3
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Intro to Excel Macros Part 3 to your Wishlist.

Add to Wishlist

Intro to Excel Macros Part 3

This course continues the exploration of the Excel Macro Recorder, including how to make macro-related tasks easier.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Last updated 6/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 3 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • 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.
Description

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.
Who is the target audience?
  • Anyone interested in Excel.
  • Anyone interested in Accounting, Finance or related fields.
  • Anyone interested in Macros.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
11 Lectures
01:51:18
+
Introduction
8 Lectures 01:51:13


Recording and Viewing the Goal Seek Macro
08:44

VBA Objects, Properties, and Methods
07:50

Creating Macro Buttons; Running the Goal Seek macro
06:38

Macro Keyboard Shortcuts; Introduction to Variables
09:03

Prompting the user for Input; Testing the user's response
11:29

Excel Efficiency : Intro to Macros Part 3 Continuous Play
55:36
+
Supporting Materials
3 Lectures 00:04
Slides: Intro to Macros Part 3
00:01

Intro to Macros Part 3 Glossary/Index
00:01

Excel Efficiency Intro to Macros Part 3
00:01
+
REVIEW QUESTIONS AND FINAL EXAM
0 Lectures 00:00

REVIEW QUESTIONS: Excel Efficiency: Intro to Macros Part 3

REVIEW QUESTIONS
3 questions

FINAL EXAM: Excel Efficiency: Intro to Macros Part 3

FINAL EXAM
5 questions
About the Instructor
Illumeo Learning
4.2 Average rating
59 Reviews
598 Students
159 Courses
Condensed and Efficient Courses for Busy Professionals

Illumeo, incorporated in 2009, is revolutionizing the hide-bound world of corporate learning. Illumeo works with corporate professionals and organizations of all sizes to build the skills and capabilities that help everyone be an expert at their job.

Based in Silicon Valley, CA, Illumeo serves thousands of corporations and corporate professionals across Finance, Accounting, Human Resources, Sales and Marketing. The platform offers assessments, industry-benchmarked competency analyses, hundreds of expert-developed courses, collaborative tools, and the ability for companies to self-publish internal courses that promote institutional knowledge retention and dissemination.

Illumeo is the place for expertise management and we are dedicated to the proposition that everyone can be an expert at their job.

David Ringstrom (Illumeo)
4.0 Average rating
5 Reviews
50 Students
14 Courses

David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting firm that he started in 1991. David teaches 180 live webinars annually on Microsoft Excel, along with occasionally speaking at conferences. He is the co-author of Idiot's Guides: Introductory Accounting, and has served as the technical editor for over 30 books on accounting software. Some of his hundreds of freelance articles on spreadsheets have been published internationally. 

Experience

President : Accounting Advisors, Inc. - [1991-12 to Current]
David offers spreadsheet, database, and accounting software consulting services nationwide. He focuses on streamlining complex business processes via a combination of training, tools, and custom programming. 

Education

Bachelor of Business Administration, Accounting : J. Mack Robinson College of Business (at Georgia State University )