Excel: Macros and VBA Programming
Train your employees on Excel macros: recording and editing, writing VBA code, creating user-defined functions, and debugging them.
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.
Accredited by CPD
TalentLibrary is recognized as reaching the standards and benchmarks required by the Continuing Professional Development (CPD) Certification Service.
The CPD Certification Service is the world’s leading and largest independent accreditation organization for professional development courses across all industry sectors.
Other courses in this collection
Excel: Custom Templates and Add-Ins
Train your employees on creating, saving, and managing Excel custom templates, and using Power Query, Power Pivot, and VBA add-ins effectively.
Excel: Scenario Analysis and What-If Analysis
Train your employees on Excel’s Scenario Manager, Goal Seek, Data Tables, Solver Add-In, Forecast Sheets, and Monte Carlo simulations.
Excel: Integration with Other Tools
Train your employees on linking Excel data to Word, PowerPoint, and Google Sheets, exporting to PDF, and using Power Query and APIs.
