In this course, you will learn how to use Visual Basic for Applications (VBA) to automate tasks and procedures in Excel. VBA is a simple but powerful programming language that can be used to extend Office applications. You will learn how to utilize the objects in the Excel Object Model to emulate user actions in Excel, react dynamically to user events like entering a cell value or opening a workbook, and feel comfortable with the fundamentals of computer programming. The course will cover the following topics:
- When to use VBA and why
- VBA Programming 101
- Macros and the Visual Basic Editor
- Objects and Methods
- Variables and Data Types
- Writing Your Own Procedures
- The Workbooks and Workbook Objects
- Programming tips and tricks
By the end of the course, you will be able to write macros to accept user input, read to and write from cells and manipulate data. You will also learn to write custom functions and create user forms. The course will provide you with useful examples of problems and their solutions. You will be able to perform repetitive tasks efficiently and add new functionality to Excel applications. I hope this information helps you get started with the course. Good luck! 😊
View this Course
Certified
You have 
