WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login

All in One Excel VBA Bundle (35 Courses with Projects)

This Excel VBA Certification Training is a bundle of 35 courses with 120+ hours of video tutorials and Lifetime Access.

In this course, you would not only learn a single skill or two; rather this single course will teach you how to master Excel and VBA. Topics include basic and advanced excel, basic and advanced VBA, creating dashboard, data analysis, excel for finance, marketing and HR and Tableau Training

BESTSELLER
4.9 (1,353 ratings)

 

1

Basic Excel Training

2

Advanced Excel Training

3

Basic & Advanced VBA Course

4

Excel Dashboard Course

5

Data Analysis in Excel

+

View More

Offer ends in: Only seats are left with this price


TAKE THIS BUNDLE
Offer

* One Time Payment & Get Lifetime Access
Home » All in One Excel VBA Bundle (35 Courses with Projects)

What you get in this All in One Excel VBA Bundle?

Online Classes
Technical Support
Mobile App Access
Case Studies

Skills you will master

Online Excel VBA Certification Course Overview

Bundle No. of Courses Hours Actual Price
Microsoft Power BI Training (6 Courses) 6 29+
Basic Excel Training 3 12+
Excel Advanced Training (14 Courses, 19+ Projects) 14 19
VBA Training (3 Courses, 12+ Projects) 3 12
Excel Dashboard Training 9+ 45+
Excel Data Analysis Training (12 Courses, 4+ Projects) 12 4
Excel Training (18 Courses, 8+ Projects) 18 8
Excel Training (18 Courses, 8+ Projects) 18 8
Excel for Power User Course 1 5+
Excel for Finance Training (15 Courses, 4+ projects) 15 4
Excel for Marketing Training (4 Courses, 12+ Projects) 4 12
Excel for HR Training (5 Courses, 8+ Projects) 5 8
Tableau Certification Training Course 4 6
Total 35+ 120+

Excel VBA Training Certification Course Details

Now let’s have a look at the course description –

Sr. No.  Course Name No. of Courses  No. of Hours Course Description
1 Basic Excel Training 3 12 We will start with a brief overview. And then you will learn about the interface and how MS Excel works. Then, we will take a case study and then, you will learn how to do data entry, how you can populate the case study into the excel. Next, we will talk about formulas, formatting, updating a calculation, finding percentages, conditional formatting, if function in excel, count if, sum if in excel etc. You will also learn about the pie chart, graphs & chart, sorts, filter function, pivot table, freeze & split, presentation, print, shortcuts, and finally common errors.
2 Advanced Excel Training 16 67 Once you have understood the basics of MS Excel, this module will help you go deep. First, we will show you a few practice files that would contain various excel functions. Then, we will talk about data functions, what if analysis, arrays, functions for working with text, pivot table, data filtering, pivot table formatting, using macros in the pivot table, DAX in Power Pivot, names & dynamic range and many such functions and formulas.
3 Basic & Advanced VBA Course 6 35 In this Excel VBA training module, you will learn the basics of VBA and Macros. We will start with a brief introduction to VBA and Macro. Then, we will talk about the first macro, what is the VBA environment, macros with if condition, and data filter. Finally, you will learn about charting using VBA and user-form. In this module, we will start with a brief overview of VBA. Then, we will talk about the user-form in terms of EMI, looping, and last row and column. Next, you will look at the referencing sheets, user-defined function, calculator of the update now, writing formulas, and calculator of EMI calculations. Then, we will discuss arrays, sort EMI button, EMI Calculator – create a graph, print using VBA, and finally, EMI calculator of the print report and the email report. You need to watch 67 videos to cover this module.
4 Excel Dashboard Course 9 45 In this Excel VBA Certification course, you will learn about the creation of excel dashboard, how to use formulas and formatting. You will also understand the types of filters, graph & formatting, demographics, how to create the compensation button, and import access & export access.
5 Data Analysis in Excel 11 37 we will talk about data simulation, goal-seek, table simulations, data validation & macro filters, and finally, Monte Carlo simulations.  Also you would understand about excel reports, power excel heat maps,  statistical tools and business intelligence using Tableau.
6 MS Excel Training Course 6 65 This is the first module of this Excel VBA Certification course which covers both Basic and Advanced excel functions, tools and features. We will start with Ribbons Quick Access Toolbar and Excel HELP function. Then, we will take a case study and we will learn about data entry, populating the case study in Excel, calculations, formulas, formatting, how to update a calculation, and understanding the percentages absolute references. You will also learn the conditional formatting, IF function, Count-If, Sum-If, Charts & Graphs, Sorts & Filters, Pivot Tables, Freeze & Split, Presentation, Print, Short-cuts, and lastly, common errors.
7 Excel For Power User Course 1 5 We will begin with a brief introduction to the power excel training. Then, you will learn about function, pivot tables, evaluate, date format & time format, statement & VLookUp, future value function, business & database information, data comparison & filter, and finally, pivot chart & power view.
8 Excel For Finance Course 15 51 In this Excel VBA Certification course, we will start with a brief overview. Then, we will learn about future value, SI, CI, PV, Nper rate, the value of an investment with multiple cash flows, calculating the rate of return, analyzing loans & payments, and bond valuation.
9 Excel For Marketing Course 12 45  You will learn about the sales productivity excel dashboard, pivot table, pivot chart, slicer, and we will also show you a few reference files to practise the marketing related functions in Excel.
10 Excel For HR Training 6 34 First, we will start with a reference file that will offer you a brief about the creation of HR dashboard & analytics. Then, gradually, you will learn about data introduction, index & tab designing, employee front face, the pivot data list, MOM headcount, departmental & location analysis, tenure wise analysis, age-wise analysis, employee demo & quality circles, time sheet late marks analysis, full & final analysis, training analysis, job rating analysis, HR update, and lastly a summary of all that you learn.
11 Tableau Certification Training Course 1 5 The course on Tableau in this Excel VBA Course is for you to understand the application of this sophisticated data tool Tableau and its use in Business Intelligence and data visualization.
Total Number (Unique) 35+ 120+

Certificate of Completion for Excel VBA Course

Online-Excel-VBA-Course

Which tangible skills you will learn in this course?

You would learn many, many micro-skills in this excel VBA training course. Let’s look at the most significant ones below –

  • Microsoft Excel (Basic & Advanced): In this Excel VBA course, you will learn everything you need to know about Microsoft Excel (both basics and advanced). You would learn everything from feeding data into an excel sheet to creating excel reports.
  • Analytics: You would learn how to create dashboards and analytics. Very few Certification courses on VBA Excel offer this. You will also learn the detailed analytics of HR at a basic and at an advanced level.
  • Building a basic project management tool: You would also learn to build a project management tool using TreeView and ListView. Which course would offer you so much value all at once?
  • Automation: You will learn a basic course on automation in this module. And it will help you MS Excel VBA in more advanced way.

There are also other skills you will learn in this giant Excel VBA Certification course. Jump in.

Pre-Requisites of this Excel VBA Course

  • Willingness to learn this comprehensive Excel VBA Certification course: You may need a bit or piece from this whole course. If you’re not interested in the entire course, you can choose one of your preferred courses individually. But to get the best value out of this comprehensive course, you need to be willing to commit a chunk of time during the week or in the weekend to go through this Excel VBA course and practice at your own pace.
  • A basic sense of logical reasoning: You don’t need earth-shattering knowledge to do this Excel VBA training course. You need to have a sense of logic and also a fundamental knowledge of maths. And that’s all you need to do this entire course (though a little bit of finance knowledge will also help).

Target Audience for Excel VBA Course

  • Students who would be interested in learning Excel VBA: If you’re a student and you would want to know the nitty-gritty of Excel VBA, this is the right course for you.
  • Professionals who would want to learn Excel VBA: No matter what profession you’re in, if you are interested in VBA Excel, this is the best course in the market you would ever find.
  • Entrepreneurs: As an entrepreneur, if you want to learn VBA Excel, there can be no better course on VBA Excel than this one.

FAQs – General Questions

Why should I do this Excel VBA training course?

You shouldn’t do this course only if you’re not interested in VBA Excel. If you’re interested in learning VBA Excel, there’s no better course in the market than this.

Do I need a special qualification to do this Excel VBA course?

All you need is a basic logical reasoning and a sense of maths. And you would also need the willingness to go through a giant course and try the lessons at your own pace.

I’m from philosophy background. Would it be useful for me?

It depends. If you feel that you would be able to use this Excel VBA training for any professional or personal project, you can definitely do this course.

Where do Learners Come From?

WallStreetMojo’s Accounting course has been taken by professional globally. Some of the top places that our learners come from include New York, San Francisco, Bay Area, New York, New Jersey, Houston, Seattle, Toronto, London, Berlin, UK, Dubai, Riyadh, UAE, Singapore, Australia, New Zealand, Hong Kong, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many.

Can I see Demo Videos?

Yes, you can view the demo videos above.

What are the Payment Options?

You can pay by Credit Card, Debit Card or Net Banking from all the leading banks. Additional payment options include pay by PayPal and 2checkout.

Sample Preview of Full Access Bundle

  • Data Simulation

    Data Simulation

    9:53
  • Monte Carlo Simulations

    Monte Carlo Simulations

    5:35
  • Future Value Function

    Future Value Function

    4:22
  • Percentages and Absolute References

    Percentages and Absolute References

    6:33
  • HC Analysis

    HC Analysis

    8:08
  • Paste Special

    Paste Special

    5:13

Career Benefits

  • You will reach a higher rung in your company: After doing this course, you would get promotion quite easily. If you do the work, this Excel VBA Course will deliver the results.
  • You will be able to handle any VBA related needs in your organization: And this is no small feat. You would be considered as an expert on VBA in your organization.

Course Reviews

Courses Reviews

Candy Chan Hui Ping

As a regular user of Excel, both for professional and personal purposes, I found this to be a great refresher Excel VBA course to prepare for more advanced ones. Some lessons (such as the module on Shortcuts) have also helped me to use this tool more efficiently on a day to day basis. Keep up the great work.
Linked

Courses Reviews

Gerald Lynn Henthorn

I’m not mathematically inclined, and have avoided Excel in the past. This Excel VBA training platform made it easy to learn the system. And, the individual lesson titles of excel course will make it easy to go back over techniques when I need to. I appreciate having had the opportunity to take this excel comprehensive course, and will probably refer back to it quite often. However, I am very familiar with other MS office programs.
Google+

Courses Reviews

Fredric C

Pivot table is a built in feature in excel. This Excel VBA Certification course helped me how to add this feature. Understood how to import data, inserting functions, test connection, change column names, creating a pivot chart with various variables, difference between pivot table and power chart, how to create two pivot charts for the same data, how to create four pivot chats for the same data. Simply awesome course how to create pivot table.
Linked

Courses Reviews

Varun Tripathi

It is an Excellent Excel VBA training course. It includes all skills that required while working in a job. All lessons are easily explained. The best thing about this course is the Practice files that are provided after each lesson. I consider myself a pro with excel after doing this Excel VBA training course. I am thankful to the creator of this course. This Excel VBA course is one of the best tool available on the internet to learn excel both at beginner and also at an advanced level.
Linked

Courses Reviews

Puran Rathore

The Excel VBA Course is advanced in its true essence. It covers all the important functions used in excel to enhance your MS excel skills. I enjoyed it very much because the teaching methodology is very simple and engaging. Anyone who is starting out in their career should take this Excel VBA course. I highly recommend this course for its ease of use and great teaching method. It is a short package for getting extraordinary results in terms of productivity in preparing reports.
Linked

Courses Reviews

Saurabh Kesari

This is one of the most engrossing and value addition Excel VBA Certification course. I have done 3 courses in total and found it to be very engaging. The way dash boards are created are amazing and simple. More over this might be  very much useful course for students and professionals alike as both can use this in the project reports and report to higher management respectively.Thumbs up!
Linked

MS EXCEL TRAINING COURSE

8 Shares
Share
Tweet
Share
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

OFFER FOR YOU

*Offer is valid only for next 20 min

Leaving so soon?

Get Additional 10% OFF on


Take this Bundle
Book Your One Instructor : One Learner Free Class
CoursesNo. of Hours
Basic Microsoft Excel Training4h 8m
MS Excel 2010 Training Course: Advanced8h 37m
Microsoft Excel Basic Training | Excel 2013 Courses Online | Beginners4h 22m
Microsoft Excel 2013 - Advanced11h 06m
Microsoft Excel 2016 - Beginners4h 03m
Microsoft Excel 2016 - Advanced5h 11m
Visual Basic for Excel - Beginners Guide3h 1m
Visual Basic for Microsoft Excel - Advanced7h 58m
Project - Creating Interactive Dashboards using VBA2h 25m
Project on VBA Macros - Create a Login-Logout Tracker3h 4m
Project - Creation of Basic CRM by using Microsoft Excel VBA and SQL Express3h 56m
Project on VBA - Project Management Tool with TreeView and ListView2h 25m
Power Excel Training5h 27m
Microsoft Excel Reports8h 35m
Microsoft Excel Charts and SmartArt Graphics6h 52m
Financial Functions In Excel - Microsoft Excel 2013 Course2h 4m
Project - Building Dynamic Heat Map in Microsoft Excel 20161h 17m
Project on VBA Macros - Automation using Loop0h 49m
Project on Excel VBA - Attendance Register using Microsoft Excel VBA3h 1m
Project - Sales Productivity Dashboard6h 57m
Project - Advanced Sales Productivity Dashboard7h 17m
Project on Excel VBA - Restaurant Billing System using Microsoft Excel VBA3h 6m
Project - Interactive Dashboards using Microsoft Excel VBA2h 4m
Microsoft Excel for Business Professionals and Managers1h 26m
Microsoft Excel Course - Beginners3h 8m
Microsoft Excel - Advanced6h 06m
Gantt Chart Tutorials1h
Business Intelligence using Microsoft Excel5h 1m
Pivot Table for Beginners1h 29m
Microsoft Excel for Data Analyst2h 39m
Advanced Excel 2016 - Some Important Features3h 26m
Microsoft Excel Solver Tutorial1h 23m
Date and Time Functions Microsoft Excel Training2h 39m
Microsoft Excel for Financial Analysis1h 26m
Microsoft Excel 20169h 14m
VBAs and Macros - Beginners to Beyond3h 22m
VBAs and Macros - Advanced7h 56m
Business Intelligence with Tableau5h 47m
Mastering Microsoft Excel Date and Time2h 54m
Project - Analysis with Pivot Tables4h 6m
Power Pivot in Microsoft Excel 20163h 34m
Shortcuts in Microsoft Excel0h 43m
Graphs & Charts in Microsoft Excel 20133h 3m
Statistical Tools in Microsoft Excel1h 14m
Project - Microsoft Excel Simulations Training2h 18m
Comprehensive VBA and Macros Training11h 8m
Project - Microsoft Excel Dashboard Training6h 6m
Project - Creating Sales Dashboard using Microsoft Excel1h 35m
Project - HR Dashboard using Excel6h 5m
Project - Advanced HR Dashboard7h 8m
Project - Business Barcodes using VBA1h 07m
Macros and VBAs Features and Concepts6h 06m
Project on VBA - Project Schedule Indexes2h 57m
Project on VBA - Financial Modeling using VBA3h 9m
Pivot Tables Hands-on!2h 22m
Power Pivot and DAX 20190h 55m
Power BI - Beginners to Pro10h 55m
Microsoft Power BI Tutorial4h 37m
Data Analysis and Visualization with Microsoft Power BI9h 39m
Tableau5h 19m
Projects on BI Tools and Tableau Analytics5h 48m
Tableau Features Hands-on!5h 47m
Analytics using Tableau9h 03m
Projects on R and Tableau - Customer Analytics2h 11m
Projects on R and Tableau - Pricing Analytics2h 02m
Project on Tableau - Super Store Business Requirements1h 18m
Project on Tableau - Fatal Accidental Drugs Overdose Analysis1h 27m
Project on Tableau - Retail Store Business Analysis0h 06m
Sale Performance Case Study using Microsoft Power BI2h 28m
Project on Power BI - Market Place Analysis1h 19m
Power BI Project - Creating a Manager Performance Report1h 56m
TAKE THIS BUNDLE
OFFER FOR YOU

*Offer is valid only for next 20 min

Leaving so soon?

Get Additional 10% OFF on



Take this Bundle
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?