Get a month of TabletWise Pro for free! Click here to redeem 
TabletWise.com
 

Introduction to VBA Macros

Learn how to automate your spreadsheets by writing your very own the VBA code with this easy step by step introduction to VBA macros course.

Introduction to VBA Macros

Learn how to automate your spreadsheets by writing your very own the VBA code with this easy step by step introduction to VBA macros course.
24
Views
1:23:17
Share the link to this class
Copied
Signup to access the class
Access thousands of classes and millions of flashcards

What's included in the class?

 54 video lessons
 6 quizzes

About the Class

This course will teach you how to write VBA code so you can automate your spreadsheets to save you time and effort.

What is in the Course?

There are seven modules and within each module, there are a number of engaging step by step video tutorials which includes everything you need to know on how to create your very own Macros to automate your spreadsheets and ultimately to save you time. After each module, you will take a test to solidify what you have just learned.

  • Module 1: Here you will get the course outline and what will be covered in the course. You will also learn a little about me and why I am qualified to teach you VBA.
  • Module 2: You will learn exactly what is VBA, the reasons people use it and the advantages and disadvantages of VBA.
  • Module 3: You will learn to record a macro. If you are completely new to VBA then this will be your very first glimpse of VBA and understand why it is so powerful.
  • Module 4: You have recorded a macro but how do you execute it? In this section, I will show you various ways to run your macro.
  • Module 5: In order to become proficient in VBA you need to have an understanding of the visual basic editor. In this module, you will learn everything you need to know about the visual basic editor and where to store your VBA code.
  • Module 6: Learning VBA is not just about writing VBA code. You need to have an understanding of what exactly you are writing. In this module, I will explain how VBA is structured and introduce the excel object model.
  • Module 7: In this section, you will get to write your very own VBA codes. I will give you lots of examples of writing Macros to manipulate worksheet ranges, columns, and rows. I will also show you how to write your code more efficiently which means your macros will run quicker.

What you will learn from this course?

  • What is VBA and why people use it
  • How to Record Macros
  • How to eliminate manual repetitive tasks
  • How to automate your spreadsheets
  • How to write your very own VBA code to manipulate worksheets
  • How to make your VBA code more efficient
  • How to execute Macros in different ways
  • How VBA is structured with the Excel Object Model

Who should take this course?

  • Anybody who wants to automate their spreadsheets
  • You are an Excel user but want to take your skills to the next level
  • Anybody who works with data sets in Excel
  • Intermediate or advanced Excel users

Class Requirements

  • You should have intermediate Excel skills.
  • You have a PC/Mac with Excel installed on it.
  • You should desire to gain an understanding of how macros can drive efficiency.

Class Contents

Class Authors

Harjit Suman

Excel and VBA Teacher
Share the instructor profile
Copied
I am an Excel and VBA course teacher with over 10 years experience using Excel and VBA. I have taught Excel and VBA in large global organisations in a classroom environment. I am also an Excel Consultant and have provided Excel services to many small and large companies. Some of the services I have offered include writing advanced Excel...
0
Saves
24
Views
This class has not been saved

Sign Up