And welcome back to the class of our course with the complete introduction to Microsoft Excel, the
use of VBA in this class, we are going to talk about what exactly is TVB and where exactly it's used,
how it works and other stuffs, all their stuff.
Basically, it's going to be more theoretical.
And in the past, in the next few classes, we are going to do a little bit more of practice.
So let's start.
So basically, what exactly is that VBA?
So for those who don't know, VBA stands for virtual basics for applications.
And what we can say about it is that it's a computer programming language that has been developed by
Microsoft.
This is what it's used with the Excel and the VBA.
You can create different things, such as, for example, macros.
You can automate repetitive tasks.
For example, let's say you have a calculation that you want to do in Excel more than once.
So let's say you want to do it automatically each five seconds, for example.
Well, you can do it with the use of the programming language.
So also not only not only you can do this with operations, you can also do this with different things
such as functions, formulas and other different things.
Um, the programming language can be also good for generating rapport.
Well, different reports or different conclusions.
Let's say you have an ongoing operation, but let's say you have an application and you want to generate
an outcome to this operation.
You can use VBA programming language to do so.
Now, is that would be hard to learn.
Um, so basically it's well, it's not that complicated, but the problem with is that you should understand
excel at first.
Basically, if you guys have a basic knowledge of Excel, it's going to be way more easier because you
need to understand, as I said, Microsoft Excel at first.
Also, if you guys have a basic understanding of another programming language or you have programming,
for example, in Python or Java or any other programming language you'll see is going to be way more
easier to learn how to use VBA.
But if you have no knowledge at all and you starting from scratch, well, you'll see it's maybe going
to be a little bit more harder.
But at the end, if you practice a lot, you will be able to work with it.
So where exactly is used?
So VBA is used under a different Microsoft applications and in our case we are going to use it with
Excel because we're learning for Excel.
Um, so basically, as I said, it's a programming language that works with different office programs.
So it's pretty much where exactly it can be used.
Well, it's pretty much used to create macros.
So for example, with Excel VBA, we can automate tasks or we can automate different stuff with the
things that we call macros.
So not only not only this, it also enables us to do a range of cells with just a few code lines without
necessarily having to write down a lot of formulas and creating huge applications or functions just
to receive a certain outcome.
At the end, you can automate everything with a few lines of code.
So basically it's way more efficient.
So is it worth it to learn Vehbi?
So in my opinion, yes, it's worth it, even if it's it's not developed anymore.
But in my opinion, it's really worth it to learn the programming language.
Yes.
It's not as popular as Python and far from being as popular as Python, but it's really used in the
business world.
So basically it's widely used for automation, especially with Excel.
So basically, Excel is really, really popular in small and medium businesses as well as in big businesses.
So it's really used everywhere because it's a simple program.
It's simple to learn and it can do a lot of things with Microsoft Excel.
And to automate your tasks with Microsoft Excel and create more advanced applications, the use of eBay
is really well is really helpful.
So not only it's widely used for automation, it can be very useful for anyone wanting to improve its
knowledge and excel.
So basically, someone who knows how it works, Excel is good, but someone who knows how to work with
Excel but also knows how to work with Excel is even better because it means that the person who knows
how to use VBA is able to use Excel in an efficient way.
And sometimes it's really important.
So basically, someone who only knows how to work with Excel will be able to create an application in,
let's say, one week.
But someone who is able to use VBA as well will be able to create the same application way more faster
because it will use a coding and programming.
So it will never go away, because, as I said, it's very popular in many businesses.
A lot of businesses have invested a lot of money in creating kibbee structures and programs with the
use of Excel.
And this is why it will never basically go away.
Well, at least not for the next few years.
So this is why, in my opinion, it's pretty important to learn and that even if it's not as popular
as Python, it can be really useful, especially in the professional world.
So for now, you have a basic understanding of what exactly is VBA in a with Excel.
Now it's going to be time to start practicing everything.
So that's a first class guys into our next class.