1
00:00:00,510 --> 00:00:04,720
And welcome here, my name is Justin, and welcome back to another of my courses.

2
00:00:05,220 --> 00:00:10,170
So before we even start, I'd like to thank you all for joining this class about Microsoft Excel.

3
00:00:10,170 --> 00:00:15,880
And it's really an honor for me to be able to teach you about this topic in particular.

4
00:00:17,430 --> 00:00:22,950
So basically, for those of you who don't know me or don't know my background, I'm working in the field

5
00:00:22,950 --> 00:00:27,060
of management and I'm using Microsoft Excel on a daily basis.

6
00:00:27,270 --> 00:00:33,090
So if you want to check out my other courses, I think I have a few Excel courses that are online right

7
00:00:33,090 --> 00:00:33,480
now.

8
00:00:34,290 --> 00:00:38,100
So basically what we are going to talk about in this class.

9
00:00:38,100 --> 00:00:43,350
Yes, we're going to talk about Microsoft Excel, but we are going to talk more specifically about Microsoft

10
00:00:43,350 --> 00:00:44,600
Excel VBA.

11
00:00:45,300 --> 00:00:50,910
So we are going to learn in this class what exactly is Vehbi, how to use it, how to implement it with

12
00:00:50,910 --> 00:00:55,650
the normal Microsoft Excel and how to use VBA will excel, baby.

13
00:00:56,070 --> 00:01:00,270
And also how well to work with Excel, with Microsoft Excel.

14
00:01:02,250 --> 00:01:05,670
So what exactly is the goal of this course?

15
00:01:06,000 --> 00:01:11,360
So first thing that I want to teach you in this course will that I want the scores to teach you is to

16
00:01:11,370 --> 00:01:14,380
understand what exactly is Vehbi in Excel.

17
00:01:14,400 --> 00:01:19,560
So basically, we're going to talk about this programming language because we can call it a programming

18
00:01:19,560 --> 00:01:20,130
language.

19
00:01:21,090 --> 00:01:22,920
So we are going to talk about everything.

20
00:01:22,920 --> 00:01:29,100
So how it works, how to write different lines of code, how to create macros and basically how to use

21
00:01:29,100 --> 00:01:31,750
it and how to use it in your Excel spreadsheet.

22
00:01:32,490 --> 00:01:37,500
Basically, the only have the calculations or that only have Excel functions or formulas.

23
00:01:38,690 --> 00:01:42,140
And we are going to learn how to work with Excel and create macros.

24
00:01:42,150 --> 00:01:46,040
So basically, not only you will learn about it, but you are going to use it.

25
00:01:46,380 --> 00:01:52,470
So you will create your own macros and basically you are going to learn how to record macros, how to

26
00:01:52,470 --> 00:01:54,630
use them, what exactly is a macro?

27
00:01:54,810 --> 00:01:58,620
And that basically we're going to talk about all this really in depth.

28
00:01:59,610 --> 00:02:04,940
Finally, you are going to understand basic and more advanced notions about Microsoft Excel.

29
00:02:05,670 --> 00:02:11,490
So, yes, we're going to talk about Microsoft Excel Web, but we are going also to implement it into

30
00:02:11,490 --> 00:02:12,690
a normal spreadsheet.

31
00:02:12,690 --> 00:02:18,390
So basically, we're going to work with normal functions and formulas and implement those functions

32
00:02:18,390 --> 00:02:24,790
and formulas with some with some programming and basically put everything together.

33
00:02:24,810 --> 00:02:30,720
So this way, you guys will be more advanced in your use of Excel because, yes, you can do a lot of

34
00:02:30,720 --> 00:02:32,670
things just by using functions and formulas.

35
00:02:32,970 --> 00:02:40,650
But you'll see using VBA Will to really simplify your life and will make your Excel, your use of Excel

36
00:02:40,980 --> 00:02:42,240
way more efficient.

37
00:02:43,230 --> 00:02:48,530
This brings us to the part where what exactly you will be able to do by the end of this course.

38
00:02:49,410 --> 00:02:51,620
So basically by the end of the scores.

39
00:02:51,630 --> 00:02:57,920
Well, if you are a newbie in Excel, I don't know a lot about this app and you want to learn more about

40
00:02:57,940 --> 00:02:58,300
video.

41
00:02:58,650 --> 00:03:04,020
Well, by the end of the scores, you will be able to create and run your own Excel apps so you can

42
00:03:04,020 --> 00:03:08,020
create Excel applications with the user, with just functions and formulas.

43
00:03:08,370 --> 00:03:12,540
But here we are going to talk about accreting functions with the use of VBA.

44
00:03:12,900 --> 00:03:19,530
So you will be able to program in VBA with the use of Excel and create your own function formulas.

45
00:03:21,640 --> 00:03:27,440
Also, you will be able to use Microsoft Excel in a more efficient way, so you'll see, instead of

46
00:03:27,460 --> 00:03:34,270
using different for functions or different formulas or different elements that you will write down,

47
00:03:34,720 --> 00:03:37,860
you will be able to simplify everything simply by using VBA.

48
00:03:38,140 --> 00:03:42,000
And you'll see it's what it's more easier.

49
00:03:42,010 --> 00:03:43,570
It's just a bit complicated to learn.

50
00:03:43,570 --> 00:03:49,360
But once you understand the logic behind all this, you will be able to work with it in a more efficient

51
00:03:49,360 --> 00:03:49,600
way.

52
00:03:50,500 --> 00:03:54,670
And finally, you will be able to use different tricks to create different Excel projects.

53
00:03:55,150 --> 00:03:56,310
So there is a mistake right here.

54
00:03:57,040 --> 00:04:02,650
So basically you will learn different ways to use that.

55
00:04:02,650 --> 00:04:07,350
You can use VBA in an efficient way to create different projects.

56
00:04:07,420 --> 00:04:10,710
This could be personal projects, could be professional projects.

57
00:04:10,720 --> 00:04:12,280
It can be different any kind of project.

58
00:04:12,730 --> 00:04:20,470
Basically, you guys will learn how to use VBA in order to make those projects were way more efficient

59
00:04:20,800 --> 00:04:26,710
and make them way more easier to use when I'm seeing efficient, instead of writing down the hundreds

60
00:04:26,710 --> 00:04:35,140
of formulas just to perform one simple task, we are simply going to use VBA to make everything work

61
00:04:35,320 --> 00:04:35,890
perfectly.

62
00:04:37,330 --> 00:04:42,100
So besides of that, right now, you know exactly what this course will be about.

63
00:04:42,730 --> 00:04:46,030
So basically, we are really going to go in depth in Libya.

64
00:04:46,120 --> 00:04:50,080
And once again, my goal here is really to introduce you about this topic.

65
00:04:50,440 --> 00:04:54,730
So you see in this course, I'll try to cover as much as I can.

66
00:04:54,730 --> 00:05:00,910
But once again, I didn't want it to make I didn't want to make it too complicated, but really to cover

67
00:05:00,910 --> 00:05:04,200
the maximum that I can about this topic at the same time.

68
00:05:04,870 --> 00:05:10,750
So I'm pretty sure you like it because once again, you will have the opportunity to practice a lot

69
00:05:10,750 --> 00:05:11,320
inside of this.

70
00:05:12,040 --> 00:05:15,550
So that's at guys, guys, all in our next class.