Excel: Macros and VBA Programming
Duration45'
No. of mini-lessons9
ResourcesTranscript
Duration 45'
No. of mini-lessons 9
Resources Transcript
Course overview
It’s fairly universal that anything that can make work quicker and easier is considered a good thing. Macros and VBA (visual basic for applications) let employees automate tasks in Excel to save their time and effort. This is especially helpful when they’re working with large amounts of data.
This course will show them how to use macros and VBA in Excel to perform functions and automate tasks. It’ll focus on how to get started with them, how to automate basic tasks, analyze data, and create models. Each video will cover a specific function they can perform, so they can choose exactly what they want to learn, at a pace that suits them.
What's covered
Recording macros in Excel
Editing macros in VBA
Writing simple VBA code
Looping constructs
Conditional statements
Error handling
User-defined functions
Interacting with Excel objects
Debugging and testing macros
Why your teams need this course
Most people can benefit from being able to automate tasks and quickly perform functions when working with large amounts of data. This course is ideal for anyone who’s familiar with Excel and wants to use it at a more advanced level to perform certain functions. To get the best out of this course, they’ll need access to a computer and Microsoft Excel.
