VBA and Macros

Approved by CFA Institute, this awesome online course will teach you to Implement VBA and Macros on Excel.
  • Lectures 67
  • Video 8 Hours
  • Skill level all level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

Course Description

CFA Institute, USA has approved this program, offered by Corporate Bridge, for 3 CE credit hours. If you are a CFA Institute member, CE credit for your participation in this program will be automatically recorded in your CE tracking tool.  

This Program on VBA & Macros is well structured and strategically designed comprehensive online training program for learning Microsoft Excel VBA & Macros. It is full of real world examples & useful theory. The aim of this program is to make a beginner an expert in VBA.

When we have to make repetitive reports, dashboards or slides, when the work on excel sheet gets complex and repetitive, the most important solution would be to automate the worksheets and save a lot of time.By using Excel VBA, we can automate several areas of data analysis, reporting and modeling work. VBA & Macros Program is important for those who:

  • Want to apply the VBA Programming language to make their excel spreadsheets more powerful
  • Looks forward to automate their repetitive excel spreadsheets, reports or dashboard
  • Want VBA to help them use Excel better

</p>

This program includes introduction to VBA & macros like Understanding VBA Language, Objects Dealing with Constants, Objects Dealing with Variables, Data Filter Template etc. This program will also teach you how to make Income statement using macros, looping, how to make graphs& charts using macros bar chart& pie chart, Creating user Form using VBA & Macros etc

What are the requirements?

  • This Course starts from the scratch and covers the advanced level. Any one can take this course. This course is equally useful for an expert and a beginner. No Prior Requirements, go for this course.

What am I going to get from this course?

  • Over 67 lectures and 8 hours of content!
  • To learn to create your own shortcuts using VBA & Macros and work more effectively
  • Most Importantly, To Make you awesome in VBAs & Macros with study materials of Highest standard

What is the target audience?

  • Any Individual who is interested in learning VBA & Marcos
  • Financial Analysts, Students, Professionals, Research Analysts, Professors, Lecturers, Readers etc.

Curriculum

Section 1: VBA Macros - Overview
03:38
VBA Macros - Overview
Section 2: Introduction to VBA and Macros
02:40
Learn why VBAs and Macros can be important for automation
10:17
This lecture discusses the VBAs Macros most used application
06:31
This lecture discusses the VBAs Macros most used application
08:33
This lecture quickly revises the first Macros that we developed
05:52
Excel Worksheet is an object, cell in a worksheet is an object, range of cells is an object, font of a cell is an object, a command button is an object, and a text box is an object and more. In order to view the VBA objects, you can insert a number of objects or controls into the worksheet, and click the command button to go into the code window. In this lecture, learn how to deal with constants
08:31
Excel Worksheet is an object, cell in a worksheet is an object, range of cells is an object, font of a cell is an object, a command button is an object, and a text box is an object and more. In order to view the VBA objects, you can insert a number of objects or controls into the worksheet, and click the command button to go into the code window. In this lecture, learn how to deal with constants
05:02
Excel Worksheet is an object, cell in a worksheet is an object, range of cells is an object, font of a cell is an object, a command button is an object, and a text box is an object and more. In order to view the VBA objects, you can insert a number of objects or controls into the worksheet, and click the command button to go into the code window. In this lecture, learn how to deal with constants
07:04
Excel Worksheet is an object, cell in a worksheet is an object, range of cells is an object, font of a cell is an object, a command button is an object, and a text box is an object and more. In order to view the VBA objects, you can insert a number of objects or controls into the worksheet, and click the command button to go into the code window. In this lecture, learn how to deal with variables
06:08
In this lecture learn the Object dealing along with IF Statements
04:39
In this lecture learn the Object dealing along with IF Statements - continued
02:19
In this lecture learn the Object dealing along with IF Statements - continued
04:16
In this lecture we deal with the Data Output Assignment
10:22
In this lecture we show the solution to the Data Output Assignment
02:46
Here we give a short introduction to coding using VBA language
04:16
In these series of lectures understand how VBA Macros can be used to Filter Data. In this lecture we provide you with a short template 1
05:11
In these series of lectures understand how VBA Macros can be used to Filter Data. In this lecture we provide you with a short template 2
01:53
In these series of lectures understand how VBA Macros can be used to Filter Data. In this lecture we continue with the previous example
04:07
In these series of lectures understand how VBA Macros can be used to Filter Data. In this lecture we see how the output sheet can be made
02:42
In these series of lectures understand how VBA Macros can be used to Filter Data. In this lecture we see how the output sheet can be made - continued
05:41
In these series of lectures understand how VBA Macros can be used to Filter Data. In this lecture we see how the output sheet can be made - continued
Section 3: Income statement using Macro
09:57
In this section, we look at how Macros can be used to automate and highlight some important aspects of Financial Statements - Income Statement - Part 1
05:25
In this section, we look at how Macros can be used to automate and highlight some important aspects of Financial Statements - Income Statement - Part 2
09:17
In this section, we look at how Macros can be used to automate and highlight some important aspects of Financial Statements - Income Statement - Part 3
07:02
In this section, we look at how Macros can be used to automate and highlight some important aspects of Financial Statements - Income Statement - Part 4
05:24
In this section, we look at how Macros can be used to automate and highlight some important aspects of Financial Statements - Income Statement - Part 5
02:00
In this section, we look at how Macros can be used to automate and highlight some important aspects of Financial Statements - Income Statement - Part 6 & 7
Section 4:  Looping with Example 1
11:06
Learn how to create Macros for a Looping Example 1 - Part 1
11:13
Learn how to create Macros for a Looping Example 1 - continued - Part 2
12:26
Learn how to create Macros for a Looping Example 1 - continued - Part 3
Section 5: Looping with Example 2
07:55
Learn how to create Macros for a Looping Example 2 - Part 1
06:03
Learn how to create Macros for a Looping Example 2 - continued - Part 2
03:57
Learn how to create Macros for a Looping Example 2 - continued - Part 3
Section 6: Graph and Chart using marcos - Bar chat
08:13
Learn how to make Graphs & Charts using Macros - Bar Chart - Part 1
06:51
Learn how to make Graphs & Charts using Macros - Bar Chart - Part 2
06:28
Learn how to make Graphs & Charts using Macros - Bar Chart - Part 3
Section 7: Graph and Chart using marcos - Pie chat
08:22
Learn how to make Graphs & Charts using Macros - Pie Chart - Part 1
07:45
Learn how to make Graphs & Charts using Macros - Pie Chart - Part 1
Section 8: Reference and adding sheets or different using Macro
07:46
In these series of video lectures, learn how to reference and add sheets - Part 1
07:56
In these series of video lectures, learn how to reference and add sheets - Part 2
11:33
In these series of video lectures, learn how to reference and add sheets - Part 3
09:11
In these series of video lectures, learn how to reference and add sheets - Part 4
04:16
In these series of video lectures, learn how to reference and add sheets - Part 5
09:29
In these series of video lectures, learn how to reference and add sheets - Part 6
09:03
In these series of video lectures, learn how to reference and add sheets - Part 7
07:18
In these series of video lectures, learn how to reference and add sheets - Part 8
09:16
In these series of video lectures, learn how to reference and add sheets - Part 9
Section 9:  User Form using VBA & Macros
04:25
Learn how to create user forms using Macros 
12:24
Learn how to insert text box in User Forms user forms using Macros 
02:10
Learn how to insert multiple text box in User Forms using Macros 
Section 10: Radio buttons using VBA & Macros
07:49
Learn how to insert Radio Buttons using Macros - Part 1
08:49
Learn how to insert Radio Buttons using Macros - Part 2
Section 11: Combo box using VBA & Macros
08:51
Learn how to insert Combo Box using Macros - Part 1
13:30
Learn how to insert Combo Box using Macros - Part 2
Section 12: List box using VBA & Macros
08:33
Learn how to insert List Box using Macros - Part 1
07:58
Learn how to insert List Box using Macros - Part 2
07:31
Learn how to insert List Box using Macros - Part 3
Section 13: Check Box using VBA & Macros
10:05
Learn how to use Check Box using VBAs Macros 
Section 14:  Solve a sum using VBA & Macro
07:54
In this section, we try to Solve a mathematical question using Macros - part 1
06:19
In this section, we try to Solve a mathematical question using Macros - part 2
08:26
In this section, we try to Solve a mathematical question using Macros - part 3
10:45
In this section, we try to Solve a mathematical question using Macros - part 4
07:34
In this section, we try to Solve a mathematical question using Macros - part 5
10:31
In this section, we try to Solve a mathematical question using Macros - part 6
07:18
In this section, we try to Solve a mathematical question using Macros - part 7
06:49
In this section, we try to Solve a mathematical question using Macros - part 8
Section 15: Concluding Lecture
04:03
Concluding Lecture

Instructor Biography

eduCBA Academy for Investment Banking Training , Global Online Training Experts in Investment Banking

eduCBA is globally recognized training firm, providing blend of instructor-led and online Investment Banking and Other Financial training programs such as Excel, Advanced Excel, VBAs, Macros, Equity Research, Wealth Management, Technical Analysis, Investment Banking, Private Equity, Fundamental Analysis, Investment Research, Credit Research etc and preparatory courses like CFA Level I & II and FRM Level I & II, Campus Placement Training for students in Finance domain etc.

eduCBA Online training Learning Management System provides access to high end excel videos, valuation tutorials, online tests, downloadable templates and models that are prepared by Research Analysts & Investment Bankers.

Reviews

Average Rating
2.2
Details
  1. 5 Stars
    1
  2. 4 Stars
    0
  3. 3 Stars
    2
  4. 2 Stars
    4
  5. 1 Stars
    3
    • Nan Zhong

    really bad course

    need refund

    • Andrei Itkis

    inefficient use of time

    Long-winded, disorganized, hard to follow, not interactive. They seem to have simply recorded a seminar without any editing or redoing any parts that were poorly done.

    • Ben Smith

    Difficult to follow

    The course instructor spoke too fast for the content, video and audio quality was poor, subject matter was very unstructured and lacked appropriate introductions. Overall a poor course in my opinion and one that forced me to spend money on an alternative course from another instructor.

    • Alex Cardoza

    Poor value course stick with YouTube

    The overall course quality was poor. The flow of the course i.e. the movement from one lecture to the next was abysmal at times, some lectures and sections cut off without completion and thus went unexplained. This is not to say that I did not learn anything because I did, and there were times that I found it helpful, however, would I recommend someone to pay for this course? No. The reason for this is the quality of it compared to the free videos that are available on YouTube is poor. The free YouTube videos offer far better quality for free so why would you pay for something that is substandard or recommend something that is inferior to the free products available? So my advice is stay away from this course if you don't want to waste your money on something that you can get for a far better price for a far better standard.

    • Tuan Le

    Very hard to listen and unorganized

    The author is very unorganized in some lectures. There is no continuity. And it is difficult to understand what he is saying sometimes

Show more reviews

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

5,900,000

Hours of video content

22,000,000

Course enrollment

6,500,000

Students

Ready to start learning?
Preview this course