Intro to Excel Macros Part 1
4.3 (2 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.
29 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Intro to Excel Macros Part 1

This course explains how Excel's Macro Recorder can automate simple repetitive tasks in your daily work.
4.3 (2 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.
29 students enrolled
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 4 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Discover what an Excel macro is.
  • Recognize how to unhide and hide the Personal Macro Workbook in Excel as needed.
  • Identify actions to take when you make a mistake while recording a macro.
View Curriculum
Requirements
  • No advanced preparation or prerequisites are needed for this course.
Description

In this course Excel expert David Ringstrom, CPA, helps you get started with Excel's Macro Recorder. Most users are unaware of the automation possibilities that macros present, and so this course is designed to show you how to automate simple repetitive tasks in your daily work. The course focuses on Excel's Macro Recorder and storing macros in the Personal Macro Workbook for future use. You'll also learn how to create a shortcut on Excel's Quick Access Toolbar for one click access to your most frequently used macros.

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 in this Excel macros for beginers course include:

  • Learn what a macro is in Excel.
  • Use Excel's Macro Recorder to create simple macros without any programming knowledge required.
  • Determine when to use Relative References when using Excel’s Macro recorder.
  • Recover from making mistakes when recording macros.
  • Understand the nuances of Excel’s Personal Macro Workbook and why you may wish to use it.
  • Create an icon on your Quick Access Toolbar so that you can launch frequently used macros with a mouse click or keyboard shortcut.
Who is the target audience?
  • Anyone interested in Excel's Macro Recorder and storing macros in the Personal Macro Workbook for future use.
  • Anyone in the Finance and Accounting Field.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
11 Lectures
01:51:06
+
Getting Started
7 Lectures 01:50:58

Automating Center Across Selection
07:52

Running a Macro, Creating a Shortcut
11:31

Personal Macro Workbook; Deleting Macros
10:19

Macro Recorder Shortcut; Contact Info Macro
08:06

Relative References in Macros; Closing Comments
04:44

Excel Efficiency : Intro to Macros Part 1
58:14
+
Supporting Materials
4 Lectures 00:08
Slides: Intro to Macros Part 1
00:02

Intro to Macros Part 1 Glossary/Index
00:02

Excel Efficiency Intro to Macros Part 1-Excel 2003
00:02

Excel Efficiency Intro to Macros Part 1-Excel 2007-2016
00:02
+
REVIEW AND TEST
0 Lectures 00:00

Excel Efficiency: Intro to Macros Part 1

REVIEW QUESTIONS
3 questions

Excel Efficiency: Intro to Macros Part 1

FINAL EXAM
5 questions
About the Instructor
Illumeo Learning
4.2 Average rating
67 Reviews
619 Students
165 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
49 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 )