Ultimate Excel VBA Macros Training Course

Name: Ultimate Excel VBA Macros Training Course
Rating: 4.4 (54 reviews)

The ultimate excel course to learn VBA as quickly and efficiently as possible

(54 ratings)

10,553 students

Created by Commerce Curve

Last updated 12/2020

English

English [Auto]

30-Day Money-Back Guarantee

What you'll learn

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

Requirements

Basic-Intermediate knowledge of Excel

Description

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.

Who this course is for:

Basic - Intermediate level Excel users looking to improve their skills with Excel

9 sections • 74 lectures • 4h 22m total length

Preview09:58
Preview09:11
Preview13:34
Preview09:22
Preview12:11
Offset Formula And Its Importance To Navigate In Excel Sheets
15:12
Offset Formula Interaction With Sumif And Counta
10:28

Understand VBA Modules, Procedures, Functions And Sub-Procedures
08:35
Preview06:26
Creating Sub Procedures For Common Tasks 1
07:27
Creating Sub Procedures For Common Tasks 2
13:52
VBA Object Explorer
02:45
Preview02:34
Understanding Variables and Data Types
04:16
Preview03:30
Navigate Through VBA Objects Available With Excel
04:03
Understand Objects, Methods, Properties, And Events
02:45

Dynamic Formula Editing to Automate Processes
03:07
Preview02:30
Dim and Range
05:35
Preview02:45
What Are Variables? Including Multinational Arrays And Storing Variable Values
04:51
Expression In VBA Statements
01:12
Preview05:48
Preview02:12
Statement To Refer Current Workbook And Navigate Through Sheets
02:48
Statement To Open All Workbooks
02:58
Statement To Refer To A Worksheet In Same Workbook Or In Other Workbook
01:21
Defining Variables And Their Syntax
02:22
Using For/Next Statements
03:18
Preview02:52

Workbook Objects And Related Sub Categories
02:07
Worksheet Objects And Related Sub Categories
02:25
Active Cell, Column, Rows Or String Selection Objects
02:20
Active Window Command And Related Sub Categories
01:11
Active Sheet Command And Related Sub Categories
01:29
Cell Entire Row And Columns Properties And Commands
01:22
Explanation Of Boolean Term In VBA
01:43
This Workbook Command And Related Sub Categories
01:35
VBA Error Handling And Debugging
02:20
Preview03:20
If Worksheet Function Command
01:36
On Error Command
02:04
Preview03:40
Next And Last Command
03:32
Application Command To Open Microsoft Apps
02:05
Offset Command Or Range Command In VBA, Uses, Limitations And Errors
02:53
VBA Message Box Function With Dynamic Parameters
01:39
Preview02:15

Find and Replace Function For Multiple Strings
01:20
Rename All Worksheets With Single Command Based On Pre Defined Values
01:02
Preview01:18
Print Settings Including Page Margins, Specific Triggers, And Custom Pages
01:11
Chart Object Command As A Sub Command Of Active Worksheets
00:53
Programming Charts
00:50
Generating Dynamic Results With Pivot Table Objects
02:04

Commerce Curve

Accelerate Your Career - Hands-on Finance/Accounting Courses

4.1 Instructor Rating
1,413 Reviews
67,363 Students
9 Courses

Commerce Curve is a finance educational channel for accounting and finance professionals, students, and entrepreneurs.

We post content to help you accelerate your career by teaching you the practical, hands-on skills which you don't learn in school.

Our courses include topics on accounting, finance, financial modeling, Excel and more.

Reach us at commercecurve@gmail.com

Ultimate Excel VBA Macros Training Course

What you'll learn

Requirements

Description

Who this course is for:

Course content

Part 1: Introduction to VBA7 lectures • 1hr 20min

Part 2: Understanding VBA Interface10 lectures • 56min

Generating VBA through Record Macro4 lectures • 12min

Part 4: VBA Statements14 lectures • 44min

Understand VBA Objects18 lectures • 40min

Active X Controls and Form Controls4 lectures • 8min

Customized Sub Procedures5 lectures • 9min

Customized Functions5 lectures • 6min

Other Areas of VBA7 lectures • 9min

Instructor