About This Course
You will learn VBA and Macros with my unique experienced-based approach focusing on a handful of key themes. You will be effortlessly programming in a shockingly quick time frame.
Our teaching is so efficient that we don’t even allow you to learn unnecessary and confusing jargon which all other courses teach you first, so you get to experience some quick wins and find out exactly how amazing VBA/Macros can be!
During this course we will cover the following topics:
- Why VBA and Macros
- Controlling Cells, Ranges, Copy and Paste
- Controlling fonts and colouring cells
- Building Logic with IF and Select Case
- Introduction to Automation with Looping
- Constants and Variables
- The most important line in VBA you need to know
- Putting together everything so far to demonstrate Automation
What are the requirements?
You will need access to any version of Excel (2007,2010,2013, 2016, 2019, 365)
Who is this course suitable for?
Any Analytical professional who spends at least 20% of their time in Excel will greatly benefit from this course. This course feeds into our more extensive ‘Excel VBA For Professionals’ Course.
Our Promise to You
By the end of this course, you will have learned about VBA and Macros.
30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about VBA and Macros.
Course Curriculum
Section 1 - Introduction To VBA And Macros - Module 1 of VBA for Professionals | |||
Module 1 Introduction | 00:00:00 | ||
Cells And Ranges | 00:00:00 | ||
Copy And Paste | 00:00:00 | ||
Controlling Fonts And Colouring Cells | 00:00:00 | ||
Multiple Lines, Clearing And Column Widths | 00:00:00 | ||
Building Logic With If | 00:00:00 | ||
Building Logic With Select Case | 00:00:00 | ||
The Importance Of Loops | 00:00:00 | ||
Introduction To Automation | 00:00:00 | ||
Loops And Selecting Ranges | 00:00:00 | ||
Manoeuvring And Macros | 00:00:00 | ||
Constants And Variables | 00:00:00 | ||
The Most Important Line In VBA You Need To Know | 00:00:00 | ||
Putting Together Everything So Far To Demonstrate Automation | 00:00:00 |
Well narrated, very enlightening
Found this truly informative. Nice speed, enough to get you going and as was stated in the last segment, ‘My head was spinning” with the possible uses.
K. Wolf