Master all the MS Excel Macros and the basics of Excel VBA

Learn automation of tasks with Excel Macros and Excel VBA With different Excel Projects

4.13 (1619 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
139,028
students
4 hours
content
Apr 2022
last update
$74.99
regular price

What you will learn

Create plenty of small projects to learn the basics of VBA

Understand VBA programming structure and concepts

Learn the best way to write a VBA code on Excel

Understand how to use the macro recorder

Be able to autome different tasks with VBA on Excel

Enhance your current Excel projects with VBA programming

Description

Working with microsoft Excel is not always easy and learning to automate your work with the use of VBA is even harder. Indeed, VBA is a programming language that is really useful in Microsoft Excel especially if you want to be able to automate all the tasks that you want to accomplish. If you :

- Are in school and want to learn how to program With VBA

- Need to learn Excel VBA for work or task automation

- Want to start a personal project that requires you to have Excel VBA knowledge

- Simply want to learn a new skill and improve your Excel knowledge

Then you will love this course. Not only you will by the end of this course have a complete understanding of how the VBA programming language works but you will also be able to use it on a daily basis to improve the quality of the projects that you are creating on Microsoft Excel for work school or any other personal reason.


The structure of the course

The way this course has been created is to help you learn all the Basics that are around the use of VBA with Microsoft Excel. Indeed, with this course you will at first learn the power of Macros with Microsoft Excel. This will already allow to automate the majority of the task that you are currently doing on Microsoft Excel. Then, When you will understand how to properly record your own macro you will learn all the programming behind a macros and write with the use of VBA your own macros. This way you will be able to autome every task that you are doing with microsoft Excel and make every program that you create way more efficient.

Also, another really important aspect about this course is that it will help you learn by practice. In other words, for each element that you will learn you will have a lot of practice. This goes for the macro recording part as well as for the macro creation part. Also, this course has plenty of small projects that are integrated. This will allow you to be able to use all the theoritical knowledge that will will learn and put it into application with this course.


For who is this course designed

If you have a passion for Microsoft Excel and always wanted to learn how to use this program in an efficient way, then this course is definetly for you. Indeed, this course have been created in order to help everyone that start it get all the information you need to be able to work efficiently with excel. Not only you will be able to create more advanced applications by integrating VBA and macros in your spreadsheet but you will also be able to make your life way easier by automating all your tasks. Also, all the futur programs or apps that you will create with Excel will have more advanced features and will become more easier to use.

Why should I take this course

If you want to learn how to properly work with VBA programming language and Microsoft Excel then you should definetly take a look at this course. Not only you will learn all the basics of Macros but you will also learn how to effectively write your own programs directly on microsoft Excel. This will alow you to be way more effective at work since you will know how to automate the majority of the tasks that you are currently doing on microsoft Excel.

There is no risk involved in taking this course

This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days ​to get a complete refund with no questions asked. Also, if there is any concept that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.


This means that you can either learn amazing skills that can be very useful in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.

You can't lose with this type of offer !!

ENROL NOW and start learning today :)

Content

The basics

Introduction
What is Excel VBA
Understanding how an object oriented language work
Introduction to Excel for Developpers

Macro creation

Introduction to Macros Part 1
Introduction to Macros Part 2
Introduction to Macros Part 3
Introduction to Macros Part 4
Introduction to Macros Part 5
Introduction to Macros Part 6

VBA Programming

VBA Programming Part 1
VBA Programming Part 2
VBA Programming Part 3
VBA Programming Part 4
VBA Programming Part 5
VBA Programming Part 6

VBA and Details

VBA and Details Part 1
VBA and Details Part 2
VBA and Details Part 3
Conclusion

Screenshots

Master all the MS Excel Macros and the basics of Excel VBA - Screenshot_01Master all the MS Excel Macros and the basics of Excel VBA - Screenshot_02Master all the MS Excel Macros and the basics of Excel VBA - Screenshot_03Master all the MS Excel Macros and the basics of Excel VBA - Screenshot_04

Reviews

Mia
October 25, 2022
This course talks about very basic Excel VBA content. If you are a new starter and know nothing, this course would definitely help a lot. If you already have some knowledge about how to write VBA code, this one is too simple to watch.
Mustafizur
October 17, 2022
Unnecessary explanation of same thing again and again, lack of practice challenge and VBA code is not explained.
Mohammad
September 14, 2022
pembelajarannya bagus dan seru hanya saja kurang adanya ilustrasi sehingga saya masih perlu memahami nya lebih dalam dan jauh lagi. Semoga kedepannya makin bagus.
Sunil
July 15, 2022
Learned about a new thing, loved the way how he taught. But the issues with sound and subtitles is problematic in this course.
Alvaro
June 7, 2022
It's too basic, and expend too much time going around the same concepts. This whole course could be explained in less than 45 min.
Bhukya
May 31, 2022
It was a good course. Though a few repetitive tasks, it could actually be cut down to smaller length than going over 2 hours. Either way, it's a great experience.
Edwin
April 21, 2022
I am no expert in VBA or coding, and this course gave me great insight on the use of macros. I am now, doing stuff I didn't know how to do before. I'd only make a couple of suggestions: one is to check the subtitles; there are a lot of mistakes, and they can confuse foreign speakers of English. Second is to (maybe) switch the name from "Master" to "Introduction" to macros. There's great material here, though. Thank you very much for your help.
Jaganathan
March 29, 2022
This course covers the basics of the macro, good course for people who want to learn about macros. This will be helpful only for the beginners and not for professionals in macro.
Ansh
March 21, 2022
This course didn’t teach me anything new and I don’t even know VBA that clearly. But I appreciate the instructors efforts.
Harsh
March 20, 2022
Learnt about making Macros and Using VBA in EXCEL. There was some problem because of the accent of instructor rest everything was good and understandable
Ganlu
March 8, 2022
Easy to understand. However it's too basic and doesn't provide real business cases examples, not like the course title described. Suggest to tutor to avoid repeating himself.
Oscar
February 15, 2022
Muy muy regular, no ha ido a nada que desentrañe VBA, sino ciertas cositas y nunca explicando variables, sentencias, etc etc, que son indispensables para poder hacer algo decente. Siento mucho la calificación ,pero así es. Se basa en macros. Punto
Rafael
February 1, 2022
In the course you can learn few commands to use. The audio is very low. The explanation and the videos are good but missing the materials.
Sergio
February 1, 2022
No está mal el curso. Te dice bastantes cosas respecto a programación en VBA que para el día a día puede ser muy útil. Sin embargo no estaría mal profundizar en mas aspectos de la programación, como moverse de hojas, realizar tablas automáticas con unos datos...obviamente mediante texto y programación y no grabando macros. Grabar macros está bastante bien, pero hay muchas cosas que se pueden hacer de forma automática que mediante una grabación de macros no se pueden realizar.
Wresty
January 22, 2022
It is simple and easy to understand. The topics are explained well. I think the more the topic gets deeper, the more I got hooked in. I' m more eager to learn.

Coupons

DateDiscountStatus
11/6/2020100% OFF
expired
11/22/2020100% OFF
expired
11/30/2020100% OFF
expired
12/16/2020100% OFF
expired
12/27/2020100% OFF
expired
1/3/2021100% OFF
expired
1/26/2021100% OFF
expired
2/2/2021100% OFF
expired
2/11/2021100% OFF
expired
2/19/2021100% OFF
expired
3/2/2021100% OFF
expired
3/10/2021100% OFF
expired
3/22/2021100% OFF
expired
4/2/2021100% OFF
expired
4/11/2021100% OFF
expired
4/20/2021100% OFF
expired
5/2/2021100% OFF
expired
5/12/2021100% OFF
expired
5/21/2021100% OFF
expired
6/3/2021100% OFF
expired
6/22/2021100% OFF
expired
7/3/2021100% OFF
expired
8/24/2021100% OFF
expired
9/10/2021100% OFF
expired
9/18/2021100% OFF
expired
9/28/2021100% OFF
expired
10/5/2021100% OFF
expired
10/23/2021100% OFF
expired
11/6/2021100% OFF
expired
11/27/2021100% OFF
expired
12/6/2021100% OFF
expired
12/20/2021100% OFF
expired
12/28/2021100% OFF
expired
1/21/2022100% OFF
expired
2/6/2022100% OFF
expired
2/13/2022100% OFF
expired
2/24/2022100% OFF
expired
3/5/2022100% OFF
expired
3/16/2022100% OFF
expired
4/16/2022100% OFF
expired
4/28/2022100% OFF
expired
5/8/2022100% OFF
expired
5/16/2022100% OFF
expired
5/27/2022100% OFF
expired
6/5/2022100% OFF
expired
6/18/2022100% OFF
expired
6/27/2022100% OFF
expired
7/6/2022100% OFF
expired
7/16/2022100% OFF
expired
8/8/2022100% OFF
expired
8/16/2022100% OFF
expired
8/26/2022100% OFF
expired
9/5/2022100% OFF
expired
9/14/2022100% OFF
expired
9/23/2022100% OFF
expired
10/6/2022100% OFF
expired
10/21/2022100% OFF
expired
10/23/2022100% OFF
expired
11/5/2022100% OFF
expired
11/14/2022100% OFF
expired
11/23/2022100% OFF
expired

Charts

Price

Master all the MS Excel Macros and the basics of Excel VBA - Price chart

Rating

Master all the MS Excel Macros and the basics of Excel VBA - Ratings chart

Enrollment distribution

Master all the MS Excel Macros and the basics of Excel VBA - Distribution chart

Related Topics

3612808
udemy ID
11/3/2020
course created date
11/6/2020
course indexed date
Bot
course submited by