Learn VBA from Basics
What you'll learn:
Debug and Troubleshoot code like a boss!
Make Custom Formulas/Functions on the fly
Manipulate Userforms for data entry, report generation, editing tables/databases - ALL within your control.

Requirements
The course is taught in Excel 2013. You should already have Microsoft Excel (version 2003 and up). Obviously the newer the better, but VBA works the same in all versions.
No prior programming skills are necessary. The course starts with the basics.

Description
This course covers all the concepts from scratch and then deep-dives into some advanced concepts. This Excel VBA-JETPACK course is for you if:

​You want to automate common tasks so that these can be done by others with a click of a button

You regularly refresh reports/dashboards - and it eats up a lot of your time

​You want to acquire an in-demand skill that will supercharge your career growth

The lessons in this VBA course are short and full of practical examples that will help you apply these in your work from Day 1 itself. The course is packed with short videos (and some longer ones) that will take you from a beginner level and make you an advanced VBA user

The following topics are covered in this VBA course :

Introduction to VBA Language and the VB Editor

Recording/Decoding Macros in Excel

Running Macros in Excel

Writing Your First VBA Code

Understanding Errors in VBA

Working with Cells and Ranges using VBA

Working with Worksheets/Workbooks using VBA

Using Variables in VBA

Using Object Variables in VBA

Using Message Boxes in VBA

With Statement Loop

If-Then Else Loop

Select Case Loop

Do While/Until Loop

For Next Loop

For Each Loop

Creating Custom Functions in VBA

Error Error Everywhere - How to Handle it

Using Event Procedures to run macros

Userform - Basics + Deep Dive

Using Array in VBA

Working with Charts using VBA

Show and Hide Elements using VBA

Update Charts/Dashboards with a Single Click

Creating Mouse Rollover Effect using VBA

Creating Chart Animations using VBA

Creating Add-ins using VBA

Creating an Application using VBA

Working with Files and Folders

Generating Word Reports using VBA

Generating PDF Reports using VBA By the Time You are Finished with the Course, You'll be able to:

​Write and Record Macros to automate tasks and save you a ton of time. ​

Create Powerful Custom Functions so that you don't have to deal with large complex formulas.

​Create Interactive Workbooks that can be easily be shared with colleagues.

​Quickly Update Charts and Dashboards using VBA instead of doing it manually and wasting time.

​Create Add-ins and Applications that can easily be shared with others so that everyone can do things faster.

NOTE: In case the video looks a bit blurry, you can change the video quality to 720p (by clicking on the settings gear icon on the bottom right of the video screen)

Who this course is for
You want to automate common tasks so that these can be done by others with a click of a button.
You regularly refresh reports/dashboards - and it eats up a lot of your time.
You want to acquire an in-demand skill that will supercharge your career growth.