Ultimate Excel VBA Macros Training Course | Commerce Curve

Current Status

Not Enrolled

Price

99 USD

Get Started

Take this Course

Part 1

Part 2

Part 3

Part 4

Part 5

Downloadable workbooks are located at the below link for each lesson:https://drive.google.com/drive/u/1/folders/1hfmILZhQYVUO7go6h4LB_IMSrmv2tUjq

Course Content

Expand All

Part 1: INTRODUCTION TO VBA 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

VBA And Complex Scenarios Relating To Finance Professionals

VBA And Complex Scenarios Relating To Finance Professionals

Navigate Through The VBA Interface From Excel

Introduction To Macros Interface From Developer Tab

Relationship Between Macros And VBA

Important Excel Formulas Prior Knowledge Needed For VBA

Offset Formula And Its Importance To Navigate In Excel Sheets

Offset Formula Interaction With Sumif And Counta

Understand VBA Modules, Procedures, Functions And Sub-Procedures

Part 2: UNDERSTANDING VBA INTERFACE 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Difference Between Sub Procedures And Functions

Creating Sub Procedures For Common Tasks 1

Creating Sub Procedures For Common Tasks 2

VBA Object Explorer

VBA Project Properties

Understanding Variables and Data Types

Calculations In VBA Module

Navigate Through VBA Objects Available With Excel

Understand Objects, Methods, Properties, And Events

Part 3: GENERATING VBA THROUGH RECORD MACRO 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

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

Understanding VBA Code Range Selection, Cell Navigations And Actions

Understanding The Limitations Of Record Macro Technique In Comparison With VBA

Overview of VBA Statements

Part 4: VBA STATEMENTS 18 Topics

Expand

Lesson Content

0% Complete 0/18 Steps

Dynamic Formula Editing to Automate Processes

Keyword Operator As VBA Statements

Using Constants To Make Your Code Easier To Remember

Dim And Range In VBA

Concept Of Strings And Integers

What Are Variables? Including Multinational Arrays And Storing Variable Values

Constants In VBA Statements

Expression In VBA Statements

Creating Dynamic Loops with Conditions

Using With Statements

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

Defining Variables And Their Syntax

Defining Constants And Their Syntax

Different Operators And Their Meaning

Using For/Next Statements

Using For Each/Next Statements

Using Conditional Statements Such As If, Then And Else Statements

Using Open Statement To Access Files Directly

Part 5: UNDERSTAND VBA OBJECTS 25 Topics

Expand

Lesson Content

0% Complete 0/25 Steps

Introduction To The VBA Objects

Workbook Objects And Related Sub Categories

Worksheet Objects And Related Sub Categories

Active Cell, Column, Rows Or String Selection Objects

Active Window Command And Related Sub Categories

Active Sheet Command And Related Sub Categories

Cell Entire Row And Columns Properties And Commands

Explanation Of Boolean Term In VBA

Selection Command And Related Sub Categories

This Workbook Command And Related Sub Categories

VBA Error Handling And Debugging

Immediate, Locals And Watch Window For Debugging

If Worksheet Function Command

On Error Command

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

Continuation Of Property Commands Using Period/Full Stop

Default Commands In Absence Of Selection

Next And Last Command

Application Command To Open Microsoft Apps

Offset Command Or Range Command In VBA, Uses, Limitations And Errors

1 of 2

Part 6: ACTIVEX CONTROLS AND FORM CONTROLS 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Overview Of Form, Form Controls And Activex Controls

Importance Of Activex Controls For Building Dashboards And Automate Excel Operations

Properties Of Activex Controls

Changing Properties Of Activex Control

Userforms In VBA For Data Entry And Input

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

Create A Sample Userform For Purchase Invoice

Command Button Properties Including Color Coding And Style

Part 7: CUSTOMIZED SUB PROCEDURES 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Add Values In All Worksheet In One Single Master Sheet

How To Create Custom Sub Procedures In Excel

Trim Function To Trim Whole Workbook

Convert Dynamic Range into String Data

Auto Adjust Rows And Columns Of All Workbooks

Combine All Workbooks

Rename All Worksheets Based On Cell Values

Find And Replace Accented Alphabets and Foreign Text Characters

Create Separate Excel Files Of All Worksheets And Rename Them Based On A Cell Value

Part 8: CUSTOMIZED FUNCTIONS 5 Topics Sample Lesson

Expand

Lesson Content

0% Complete 0/5 Steps

How To Create Custom Functions In Excel

Adding Comments To Functions And Limitation Of Functions At Sheet Level

Accounting Functions 1 : Depreciation Reducing Balance Method

Accounting Functions 2 : Present Value And NPV Customization

Commission Calculation

Part 9: OTHER AREAS OF VBA 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Find and Replace Function for Multiple Strings

Rename All Worksheets With Single Command Based On Pre Defined Values

Convert Excel Data Into Csv For Programming

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

Chart Object Command As A Sub Command Of Active Worksheets

Programming Charts

Generating Dynamic Results With Pivot Table Objects