Excel 2016 Macro Basics
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 Excel 2016 Macro Basics to your Wishlist.

Add to Wishlist

Excel 2016 Macro Basics

Everything you need to know to start creating macros in Excel 2016
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
Created by Tim Wright
Last updated 7/2017
English
Price: $20
30-Day Money-Back Guarantee
Includes:
  • 32 mins on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create simple to intermediate complex macros
  • Create custom macro buttons
  • Modify macros
  • Create Quick Access Toolbar buttons for macros
  • Learn how macros can be universal or specific to certain cells
  • Learn to avoid problems with macros
  • Create shortcut keys to macros
  • VBA Macro Basics
View Curriculum
Requirements
  • You should have entry level knowledge of Excel
Description

You don't have to be a programmer to start using the basics of Excel Macros. Excel makes it easy to identify your list of actions and automate them with buttons and/or shortcut keystrokes. 

This video lecture covers all the basics of Macros in Excel 2016. Topics include: 

  • Overview of macros
  • Identifying the series of commands and actions to automate 
  • Avoiding common errors in macros 
  • Creating universal and local file only macros
  • Creating shortcut keys 
  • Creating custom buttons
  • Creating Quick Access Toolbar links
  • Managing macros
  • VBA Macro Basics

Start this course today and tomorrow you be be automating tedious tasks in Excel make your work more efficient and less frustrating.

Enroll now.

Who is the target audience?
  • Anyone who wants to learn how to create macros in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction
1 Lecture 00:56
+
Macro Basics Overview
1 Lecture 02:02

This video lecture covers the question: What is an Excel Macro.

Download the included practice file to follow along. Also included is a two page Quick Reference Guide for Excel 2016. Laminating the guide is recommended.

Preview 02:02
+
Macro Basics - Create Macros
1 Lecture 17:20

This video lecture covers all the basics of Macros in Excel 2016. Topics include: overview of macros, identifying the series of commands and actions to automate, avoiding common errors in macros, creating universal and local file only macros, creating shortcut keys, creating custom buttons, creating Quick Access Toolbar links, and managing macros.

Download the included practice file to follow along. Also included is a two page Quick Reference Guide for Excel 2016. Laminating the guide is recommended.

Preview 17:20

Questions on Excel 2016 Macro Basics

Macro Basics
2 questions
+
Macro Basics - Assign to Shape or picture
1 Lecture 03:50
Macro Basics - Assign to Shape or Picture
03:50

Questions taken from Assign to Shape or Picture video lecture

Assign to Shape of picture
1 question
+
VBA Macro Basics
1 Lecture 07:44

This lecture is an added bonus introducing you to the concept of VBA Macros.

VBA Basics
07:44
+
Next steps
1 Lecture 00:36
Next Steps
00:36
About the Instructor
Tim Wright
4.9 Average rating
10 Reviews
36 Students
4 Courses
Instructional Designer at Udemy

Tim Wright has been an Instructional Designer for 10 years and an Educator for over 20 years. Mr. Wright developed and taught a nationally recognized course taught in San Francisco and New York City.

Mr. Wright has a BFA Film School degree, a Secondary Education degree, and a Masters of Science degree in Technology Education.

As a consultant, Mr. Wright's clients include the Pennsylvania Veterans Affairs Dept., the Los Angeles Fire Dept, and the National Emergency Training Center in Bethesda Maryland. 

Mr. Wright believes that anything can be learned if taught correctly.