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:
Start this course today and tomorrow you be be automating tedious tasks in Excel make your work more efficient and less frustrating.
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.
Questions on Excel 2016 Macro Basics
Questions taken from Assign to Shape or Picture video lecture
This lecture is an added bonus introducing you to the concept of VBA Macros.
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.