1
00:00:02,130 --> 00:00:07,370
And welcome back to the class of our course with the complete introduction to Microsoft Excel, the

2
00:00:07,370 --> 00:00:16,370
use of VBA in this class, we are going to talk about what exactly is TVB and where exactly it's used,

3
00:00:16,370 --> 00:00:19,420
how it works and other stuffs, all their stuff.

4
00:00:19,790 --> 00:00:22,000
Basically, it's going to be more theoretical.

5
00:00:22,010 --> 00:00:27,760
And in the past, in the next few classes, we are going to do a little bit more of practice.

6
00:00:28,280 --> 00:00:29,450
So let's start.

7
00:00:29,750 --> 00:00:32,460
So basically, what exactly is that VBA?

8
00:00:32,900 --> 00:00:37,910
So for those who don't know, VBA stands for virtual basics for applications.

9
00:00:38,210 --> 00:00:45,530
And what we can say about it is that it's a computer programming language that has been developed by

10
00:00:45,530 --> 00:00:46,230
Microsoft.

11
00:00:46,250 --> 00:00:50,410
This is what it's used with the Excel and the VBA.

12
00:00:50,420 --> 00:00:53,600
You can create different things, such as, for example, macros.

13
00:00:53,600 --> 00:00:56,160
You can automate repetitive tasks.

14
00:00:56,180 --> 00:01:01,760
For example, let's say you have a calculation that you want to do in Excel more than once.

15
00:01:02,270 --> 00:01:05,940
So let's say you want to do it automatically each five seconds, for example.

16
00:01:05,960 --> 00:01:11,150
Well, you can do it with the use of the programming language.

17
00:01:12,680 --> 00:01:19,100
So also not only not only you can do this with operations, you can also do this with different things

18
00:01:19,100 --> 00:01:22,850
such as functions, formulas and other different things.

19
00:01:23,300 --> 00:01:27,600
Um, the programming language can be also good for generating rapport.

20
00:01:27,740 --> 00:01:31,570
Well, different reports or different conclusions.

21
00:01:31,580 --> 00:01:35,660
Let's say you have an ongoing operation, but let's say you have an application and you want to generate

22
00:01:35,900 --> 00:01:37,430
an outcome to this operation.

23
00:01:38,120 --> 00:01:41,430
You can use VBA programming language to do so.

24
00:01:42,920 --> 00:01:46,350
Now, is that would be hard to learn.

25
00:01:46,960 --> 00:01:53,900
Um, so basically it's well, it's not that complicated, but the problem with is that you should understand

26
00:01:53,900 --> 00:01:54,800
excel at first.

27
00:01:54,870 --> 00:02:00,500
Basically, if you guys have a basic knowledge of Excel, it's going to be way more easier because you

28
00:02:00,500 --> 00:02:05,700
need to understand, as I said, Microsoft Excel at first.

29
00:02:06,500 --> 00:02:12,890
Also, if you guys have a basic understanding of another programming language or you have programming,

30
00:02:12,890 --> 00:02:17,900
for example, in Python or Java or any other programming language you'll see is going to be way more

31
00:02:17,900 --> 00:02:20,300
easier to learn how to use VBA.

32
00:02:20,300 --> 00:02:25,940
But if you have no knowledge at all and you starting from scratch, well, you'll see it's maybe going

33
00:02:25,940 --> 00:02:27,230
to be a little bit more harder.

34
00:02:27,500 --> 00:02:32,310
But at the end, if you practice a lot, you will be able to work with it.

35
00:02:33,170 --> 00:02:35,120
So where exactly is used?

36
00:02:35,620 --> 00:02:41,450
So VBA is used under a different Microsoft applications and in our case we are going to use it with

37
00:02:41,450 --> 00:02:44,270
Excel because we're learning for Excel.

38
00:02:44,920 --> 00:02:53,600
Um, so basically, as I said, it's a programming language that works with different office programs.

39
00:02:54,290 --> 00:02:57,380
So it's pretty much where exactly it can be used.

40
00:02:57,390 --> 00:02:59,620
Well, it's pretty much used to create macros.

41
00:03:00,350 --> 00:03:07,880
So for example, with Excel VBA, we can automate tasks or we can automate different stuff with the

42
00:03:08,030 --> 00:03:10,120
things that we call macros.

43
00:03:11,270 --> 00:03:19,970
So not only not only this, it also enables us to do a range of cells with just a few code lines without

44
00:03:19,970 --> 00:03:26,210
necessarily having to write down a lot of formulas and creating huge applications or functions just

45
00:03:26,210 --> 00:03:28,280
to receive a certain outcome.

46
00:03:28,280 --> 00:03:31,650
At the end, you can automate everything with a few lines of code.

47
00:03:32,900 --> 00:03:34,350
So basically it's way more efficient.

48
00:03:34,880 --> 00:03:36,620
So is it worth it to learn Vehbi?

49
00:03:37,130 --> 00:03:43,550
So in my opinion, yes, it's worth it, even if it's it's not developed anymore.

50
00:03:44,120 --> 00:03:47,920
But in my opinion, it's really worth it to learn the programming language.

51
00:03:47,930 --> 00:03:48,260
Yes.

52
00:03:48,260 --> 00:03:55,070
It's not as popular as Python and far from being as popular as Python, but it's really used in the

53
00:03:55,070 --> 00:03:55,720
business world.

54
00:03:55,730 --> 00:03:59,810
So basically it's widely used for automation, especially with Excel.

55
00:03:59,810 --> 00:04:05,810
So basically, Excel is really, really popular in small and medium businesses as well as in big businesses.

56
00:04:05,810 --> 00:04:09,530
So it's really used everywhere because it's a simple program.

57
00:04:09,530 --> 00:04:13,760
It's simple to learn and it can do a lot of things with Microsoft Excel.

58
00:04:14,560 --> 00:04:21,130
And to automate your tasks with Microsoft Excel and create more advanced applications, the use of eBay

59
00:04:21,130 --> 00:04:23,510
is really well is really helpful.

60
00:04:24,790 --> 00:04:30,310
So not only it's widely used for automation, it can be very useful for anyone wanting to improve its

61
00:04:30,310 --> 00:04:31,510
knowledge and excel.

62
00:04:31,540 --> 00:04:36,610
So basically, someone who knows how it works, Excel is good, but someone who knows how to work with

63
00:04:36,610 --> 00:04:44,560
Excel but also knows how to work with Excel is even better because it means that the person who knows

64
00:04:44,560 --> 00:04:47,800
how to use VBA is able to use Excel in an efficient way.

65
00:04:48,130 --> 00:04:49,480
And sometimes it's really important.

66
00:04:49,510 --> 00:04:53,860
So basically, someone who only knows how to work with Excel will be able to create an application in,

67
00:04:53,860 --> 00:04:54,640
let's say, one week.

68
00:04:54,910 --> 00:05:01,960
But someone who is able to use VBA as well will be able to create the same application way more faster

69
00:05:02,560 --> 00:05:05,180
because it will use a coding and programming.

70
00:05:06,190 --> 00:05:10,470
So it will never go away, because, as I said, it's very popular in many businesses.

71
00:05:10,630 --> 00:05:17,980
A lot of businesses have invested a lot of money in creating kibbee structures and programs with the

72
00:05:17,980 --> 00:05:18,960
use of Excel.

73
00:05:19,240 --> 00:05:22,900
And this is why it will never basically go away.

74
00:05:22,930 --> 00:05:25,500
Well, at least not for the next few years.

75
00:05:26,440 --> 00:05:32,830
So this is why, in my opinion, it's pretty important to learn and that even if it's not as popular

76
00:05:32,830 --> 00:05:37,210
as Python, it can be really useful, especially in the professional world.

77
00:05:37,780 --> 00:05:43,500
So for now, you have a basic understanding of what exactly is VBA in a with Excel.

78
00:05:44,170 --> 00:05:47,340
Now it's going to be time to start practicing everything.

79
00:05:47,650 --> 00:05:51,160
So that's a first class guys into our next class.