Excel VBA: How to Write Macros Like a Professional
$0.99
This new section comes with 13 Exercises plus full solutions to help you practice and reinforce what you have learned.
Learn how to build an entire Excel VBA application from start to finish. In this brand new section you will see techniques not taught in any other Excel VBA course.
What you’ll learn
- Learn little-known techniques used by the top professionals
- Over 70 example Macros for you to use in your own projects
- Discover the best method to access a worksheet and the ones you should avoid
- Learn how to use Intellisense to help you write your code
- Learn how to supercharge your Excel experience using Loops
- How to resolve errors quickly and painfully
- Learn programming techniques you can use in any programming language
- Learn When to use “If” and when to use “Select”
- Learn the 4 Loops of Excel and when to use each one
- How to test your output before writing to a worksheet
- Discover how to protect your code against users changing the worksheet name
- Learn how to use the Compiler to check for errors before you run
- Learn the best way to use Range, Cells and Offset to access the cells
- Learn how to easily format any cell or range
- Discover how easy it is to step through the code line by line
Course content
1515 sections • 80 lectures • Total duration 4 hours 53 minutes
Introduction
GETTING STARTED
Workbooks and Worksheets
Using Variables
Ranges, Cells and Offsets
Mini Project - Fruit Sales
Debugging - How to see what your code is actually doing
If and Select
Loops
Errors
How to open workbooks and use them
Using Functions and Subs
How to Run Your Macros
Arrays
How to Copy and Filter Data