Course duration: 4,34h
VBA allows you to automate routine tasks in Excel, and it's easier to learn than you might think. In this course, Excel expert Curt Frye presents a thorough introduction to the Visual Basic for Applications programming language. Learn how to create subroutines and functions to hold code, and gain a solid grounding in the Excel object model. Explore programming techniques through real-world examples and the exercise files that accompany the course. Find out how to work with the Visual Basic Editor, add code to a macro, and create, export, and delete code modules. Go over declaring and using variables, managing variable scope, and defining arrays. Discover ways to use VBA to manage your workbooks and spreadsheets. Learn how to simplify repeating tasks with loops and debug VBA code. Practice cutting, copying, and pasting cell data, as well as running and triggering event procedures. Plus, use practical challenges to apply what you’ve learned.
Topics include:
- Identify components of objects.
- Define VBA terminology.
- Describe the steps taken when writing VBA code.
- Explain the purpose of breakpoints in VBA code.
- Review how to apply macros with VBA.
- Explore the process of searching through an Excel worksheet with VBA.
This course is in French only. If this is not a problem for you, by all means go ahead and apply.