Ultimate Excel VBA Macros Training Course

The ultimate excel course to learn VBA as quickly and efficiently as possible
Instructor:
Commerce Curve
737 students enrolled
English [Auto]
Students will learn how to optimize their time usage of Excel to automate their manual processes and gain time in their daily workflow.
Basic programming

This course is designed for the non-programming Excel user, to help them learn how to use the VBA portion of Excel. Learning how to write VBA code will allow Excel users to automate many tasks in Excel, saving them time in the long run. This course provides the information necessary for someone who has no knowledge of programming to learn the basics of programming while at the same time learning how to create useful macros with VBA in Excel.

Part 1: Introduction to VBA

1
Introduction to VBA: VBA And Complex Scenarios Relating To Finance Professionals

An introduction to VBA, an its applicable uses for finance professionals

2
Navigate Through The VBA Interface From Excel

In this lesson we will look at how to navigate through the visual basic for applications window

3
Introduction To Macros Interface From Developer Tab

In this lesson we will look at what macros are, and how to access the macros window from the developer tab

4
Relationship Between Macros And VBA

In this lesson we explain what the relationship is between macros and VBA

5
Important Excel Formulas Prior Knowledge Needed For VBA

A brief overview of pre-requisite knowledge to ensure the student is properly prepared for the course material ahead.

6
Offset Formula And Its Importance To Navigate In Excel Sheets

In this lesson the student will learn about the offset formula and its usefulness.

7
Offset Formula Interaction With Sumif And Counta

This lesson goes further in detail regarding the offset function and its interaction between functions such as SUMIF and CountA.

Part 2: Understanding VBA Interface

1
Understand VBA Modules, Procedures, Functions And Sub-Procedures

In this lesson, we will look at what VBA modules and sub-procedures are.

2
Difference Between Sub Procedures And Functions

This lesson will look at the differences between functions and sub-procedures.

3
Creating Sub Procedures For Common Tasks 1

In this lesson we will look at how we can create subprocedures for basic tasks.

4
Creating Sub Procedures For Common Tasks 2

In this lesson we will look at how we can create subprocedures for basic tasks.

5
VBA Object Explorer

This lesson will explain the VBA object explorer and how to use it

6
VBA Project Properties

This lesson will describe properties and their contents.

7
Understanding Variables and Data Types

This lesson will explain the data types and how variables work in VBA.

8
Calculations In VBA Module

This lesson will explain calculations in VBA with some examples.

9
Navigate Through VBA Objects Available With Excel

In this lesson we will look at the hierarchy of VBA and where objects lie within this hierarchy.

10
Understand Objects, Methods, Properties, And Events

This lesson we will explain more about objects and how they work.

Generating VBA through Record Macro

1
Assigning Macro To A Shape In Excel For Easy Navigation Between VBA Codes

This lesson will teach students how to create a shape and record the actions with the record macro command

2
Understanding VBA Code Range Selection, Cell Navigations And Actions

This lesson will help students to understand how range and selecting works in VBA.

3
Understanding The Limitations Of Record Macro Technique In Comparison With VBA

This lesson will outline the weaknesses of the record macro and why it is only an entry level tool

4
Overview of VBA Statements

This lesson will outline what statements are, and the different types of statements.

Part 4: VBA Statements

1
Dynamic Formula Editing to Automate Processes

This lesson will teach you some programming tools that will make your code more efficient, and allow you to get away with writing fewer lines of code while achieving the same result.

2
Keyword Operator As VBA Statements

In this lesson the student will learn about keywords within VBA, and the different types of keyword operators. Additionally, there is a lesson regarding constants located in the resources for additional information.

3
Dim and Range

This lesson will explain defining variables and the range command

4
Concept Of Strings And Integers

This lesson will describe the data types of strings and integers

5
What Are Variables? Including Multinational Arrays And Storing Variable Values

This lesson discusses variables and arrays

6
Expression In VBA Statements

This lesson discusses VBA expressions

7
Creating Dynamic Loops with Conditions

This lesson discusses how to create conditional dynamic loops, tools that allow one to iterate through data and / or objects

8
Using With Statements

This lesson will describe with statements and how they function

9
Statement To Refer Current Workbook And Navigate Through Sheets

This lesson will describe how to refer to the currently open workbook as well as how to navigate through sheets with VBA

10
Statement To Open All Workbooks

This lesson will walk through a sub on how to open all workbooks

11
Statement To Refer To A Worksheet In Same Workbook Or In Other Workbook

This lesson shows how to refer to a worksheet within the same workbook the macro is created in

12
Defining Variables And Their Syntax

This lesson will go over a variables and how to define them. Additionally, there are resources downloadable in this lesson to better understand operators and constants.

13
Using For/Next Statements

This lesson will go over how a for next loop works

14
Using For Each/Next Statements

This lesson will go over how the for each next loop works

Understand VBA Objects

1
Workbook Objects And Related Sub Categories

In this lesson students will learn about the workbook object. There is also an introduction to VBA objects article located in the resources section.

2
Worksheet Objects And Related Sub Categories

This lesson will describe worksheets as objects and how to think about them

3
Active Cell, Column, Rows Or String Selection Objects

In this lesson we will learn about the active cell column and row commands

4
Active Window Command And Related Sub Categories

This lesson will discuss the active window command and its associated properties that you can reference

5
Active Sheet Command And Related Sub Categories

This lesson will describe the active sheet command and its associated properties related to its sub categories

6
Cell Entire Row And Columns Properties And Commands

This lesson will show you how to utilize a couple features of the columns and rows properties of the worksheet object

7
Explanation Of Boolean Term In VBA

This lesson will explain boolean values and how they work. There is also additional material on the select command included in the resources.

8
This Workbook Command And Related Sub Categories

In this lesson we will look at the 'this workbook' command; to learn how to reference the current workbook that the macro you are creating is running in

9
VBA Error Handling And Debugging

This lesson will introduce the concept of error handling, and its uses

10
Immediate, Locals And Watch Window For Debugging

This lesson will illustrate the uses of the local, immediate and watch windows that are available in VBA to help one debug their code

11
If Worksheet Function Command

This lesson will discuss the if worksheet command and how/when to use it

12
On Error Command

This lesson will discuss the on error command and what it is capable of doing

13
For Each And If Command, And Other Conditional Commands For Automating

This lesson impresses upon students the usefulness of for each and if commands in the process of automating tasks. There is also a lesson resource regarding default commands in absence of selection in the resources section.

14
Next And Last Command

This lesson discusses the next and last commands with regard to iterating through objects

15
Application Command To Open Microsoft Apps
16
Offset Command Or Range Command In VBA, Uses, Limitations And Errors

This lesson will demonstrate the offset command, as well as the range command and the uses, limitations and differences between the two.

17
VBA Message Box Function With Dynamic Parameters

In this lesson we will show the message box function, how it works and an example of how to use it.

18
VBA Input Box Function For Entering Commands

This lesson shows how to create an input box and its uses. Additionally, regular expressions and utilizing different patterns has been added into the resource section.

Active X Controls and Form Controls

1
Overview Of Form, Form Controls And Activex Controls

This lesson will teach you about the different userform tools that you can use to create your own userform

2
Userforms In VBA For Data Entry And Input

In this lesson we will learn about userforms and how to crate them for entering data

3
User Forms And Link With Developer Form Control And Active X Controls

This lesson will discuss linking developer control objects to their modules

4
Create A Sample Userform For Purchase Invoice

This lesson goes over creating a userform for data input from scratch using a purchase invoice as an example

Customized Sub Procedures

1
How To Create Custom Sub Procedures In Excel

This lesson will talk about how to structure custom sub procedures; attached in the resources is also a trim function example

2
Convert Dynamic Range into String Data

This lesson will look at convering a dynamic range selected with an input box and turning these cells into string data. There are two additional resources attached regarding auto adjusting rows and columns as well as learning how to combine all workbooks with VBA

3
Rename All Worksheets Based On Cell Values

This lesson will show you how to rename all worksheets based on cell values in VBA

4
Add Values In All Worksheet In One Single Master Sheet

This lesson will teach you how to add all values in a worksheet into another sheet

5
Find And Replace Accented Alphabets and Foreign Text Characters

This lesson will teach you how to find and replace different types of characters with the RegEx function

Customized Functions

1
How To Create Custom Functions In Excel

This lesson will teach you how to create custom functions with VBA

2
Adding Comments To Functions And Limitation Of Functions At Sheet Level

This lesson will teach you different ways to comment out functions and the limitations of functions at the sheet level

3
Accounting Functions 1 : Depreciation Reducing Balance Method

This lesson will look at using the DDB function in VBA

4
Accounting Functions 2 : Present Value And NPV Customization

This lesson will look at the PV and NPV functions in VBA

5
Commission Calculation

This lesson will show you how to create a commission calculating function

Other Areas of VBA

1
Find and Replace Function For Multiple Strings

This lesson will teach you how to create a find and replace function for multiple strings

2
Rename All Worksheets With Single Command Based On Pre Defined Values

This lesson will discuss how to rename all worksheets based on predefined values

3
Convert Excel Data Into Csv For Programming

This lesson will look at creating a sub that will save your sheet as a csv file

4
Print Settings Including Page Margins, Specific Triggers, And Custom Pages

This lesson looks at using a variety of print setting properties

5
Chart Object Command As A Sub Command Of Active Worksheets

This lesson looks at the chart object as a sub command of active worksheets

6
Programming Charts
7
Generating Dynamic Results With Pivot Table Objects

This lesson will go over creating a pivot table with VBA

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!

Be the first to add a review.

Please, login to leave a review
8d593426618be2b6ff1b16f8d5203f1b
Course available for 2 days
30-Day Money-Back Guarantee

Includes

4 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW