Macros and VBA
Introduction to Excel Macros
Automating your daily tasks is one of the quickest ways to free up your bandwidth. Macros extend the functionality of Excel, enabling you to automate certain tasks and create much more complex formulas. In this course, you’ll learn how they will save you time and are simple to execute.
Advanced 9 Lessons 90 Minutes CPD Credits
About This Course
Your time is your most valuable asset, so any feature that can offer more back in your day is worth mastering. Macros fit that category by automating the tasks you complete most often.
Across nine lessons, you’ll learn how the basics of how to program Macros in excel, including how to record, edit and delete them, along with troubleshooting issues you may face.
By the end of the course, you’ll know how to automate your most time-consuming tasks, freeing up your day for more detailed analysis.
Record VBA macros in Excel
Understand the security implications of macros
Edit and delete macros
Use absolute and relative references in your macros
Use variables in macros
Explain the benefits of using macros in Excel