Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
0 Hour(s) 32 Minute(s)
Language
English
Taught by
Tim Wright
Rating
2 views
Course Overview
Everything you need to know to start creating macros in Excel 2016
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.
Course Content
- 6 section(s)
- 6 lecture(s)
- Section 1 Introduction
- Section 2 Macro Basics Overview
- Section 3 Macro Basics - Create Macros
- Section 4 Macro Basics - Assign to Shape or picture
- Section 5 VBA Macro Basics
- Section 6 Next steps
What You’ll 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
Skills covered in this course
Reviews
-
LLurley Brodie
Great beginners course for someone with no knowledge of Macros and VBA at all.
-
SSianne Choi
The instructor explains in detail. Even though I'm real beginner it was easy to understand. Thanks
