Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:01,190 --> 00:00:07,040
So during the next few sections we're going to be building our very own Microsoft Excel spreadsheet.
2
00:00:07,050 --> 00:00:11,850
We're going to start out which is the completely blank worksheet and we're going to build up a monthly
3
00:00:11,880 --> 00:00:13,290
budget spreadsheet.
4
00:00:13,320 --> 00:00:16,200
We're going to start out just simple take it step by step.
5
00:00:16,290 --> 00:00:20,370
We're going to do things like enter labels like our column in our real labels.
6
00:00:20,370 --> 00:00:25,890
We're going to enter some numeric values in there representing our dollar amounts are currency values.
7
00:00:25,890 --> 00:00:30,930
The harder money that we're spending each and every month on all of our bills we'll talk about building
8
00:00:30,930 --> 00:00:31,980
calculations.
9
00:00:31,980 --> 00:00:38,520
So we get things like totals for each month or each bill while talking about some other types of calculations
10
00:00:38,520 --> 00:00:39,260
as well.
11
00:00:39,300 --> 00:00:43,980
And we're going do some formatting we're going to make it look super awesome but we're going to start
12
00:00:43,980 --> 00:00:45,750
from complete scratch.
13
00:00:46,110 --> 00:00:51,510
So our first step we've got to open up a new Excel document and we're going to start to put some labels
14
00:00:51,690 --> 00:00:54,480
or headers into our spreadsheet.
15
00:00:54,480 --> 00:00:55,770
So here we go.
16
00:00:55,770 --> 00:01:03,180
So I'm back into the Excel interface and I'm looking at the new section of the backstage view or the
17
00:01:03,180 --> 00:01:04,410
file tab.
18
00:01:04,500 --> 00:01:10,700
So now inside of here I'm going to go ahead and grab a blank workbook and I'll give that a DoubleClick.
19
00:01:10,720 --> 00:01:10,960
All right.
20
00:01:10,960 --> 00:01:11,650
Here we are.
21
00:01:11,650 --> 00:01:19,900
We've done this once before we've opened up a new blank Excel document and here we are now I'm on office
22
00:01:19,900 --> 00:01:20,800
3 6 5.
23
00:01:20,800 --> 00:01:27,520
I subscribe to the monthly subscription through Microsoft to get access to the office applications Excel
24
00:01:27,520 --> 00:01:29,400
Word PowerPoint and so on.
25
00:01:29,500 --> 00:01:36,010
Now occasionally I just really want to give you a heads up if you're also a part of the Office 365 subscription
26
00:01:36,310 --> 00:01:39,760
whether you get that through a personal edition or something through work.
27
00:01:39,760 --> 00:01:48,520
Microsoft likes to push out updates now as of this recording that is February of 2019.
28
00:01:48,520 --> 00:01:51,950
This is our current release of Microsoft Excel.
29
00:01:51,970 --> 00:01:56,860
Now when you open it up your interface might look a little bit different because Microsoft pushes out
30
00:01:56,950 --> 00:01:57,760
updates.
31
00:01:57,760 --> 00:01:58,870
So nothing big.
32
00:01:58,900 --> 00:02:06,490
I've been teaching excel for years now and I teach it virtually exactly the same way I've been teaching
33
00:02:06,490 --> 00:02:14,290
ever since the early early editions of Microsoft Excel 2000 back in 95.
34
00:02:14,320 --> 00:02:16,250
Excel has been excel for years.
35
00:02:16,330 --> 00:02:19,870
Of course Microsoft has introduced new features and what not.
36
00:02:19,960 --> 00:02:24,580
And we'll get into those new features and I want to I want to talk about all the bells and whistles
37
00:02:24,580 --> 00:02:30,250
that Microsoft adds two additional versions but it's still underlying it's still excel.
38
00:02:30,310 --> 00:02:36,580
Now once again if you are on the office 3 6 5 you may occasionally when you first launch up Excel you
39
00:02:36,580 --> 00:02:42,190
may get a yellow bar at the top of your screen saying hey Microsoft got some updates ready for you do
40
00:02:42,190 --> 00:02:46,630
you want to go ahead and update and they'll give you a button right there to build update.
41
00:02:46,750 --> 00:02:51,190
And I'm not getting it right now and we may see it at some point within this course as I close and I
42
00:02:51,190 --> 00:02:56,560
reopen excel and Microsoft may be pushing out updates but just keep an eye on that instead of your own
43
00:02:56,560 --> 00:02:58,610
interface updates are great.
44
00:02:58,630 --> 00:03:01,750
Microsoft is fixing dance creating new features for you.
45
00:03:02,050 --> 00:03:03,070
It's huge.
46
00:03:03,070 --> 00:03:04,790
So all right here we are.
47
00:03:04,810 --> 00:03:11,380
So typically we start out and set a sell a one within our new worksheet and there is a one what better
48
00:03:11,380 --> 00:03:13,450
place to put a title.
49
00:03:13,630 --> 00:03:19,030
So I'm going to go ahead put a title here I'll call this monthly budget.
50
00:03:19,030 --> 00:03:21,390
This is going to be our monthly budget spreadsheet.
51
00:03:21,490 --> 00:03:27,460
And again I'm just inside a column a row one type that value an I mean hit my enter key on my keyboard
52
00:03:27,830 --> 00:03:30,050
that will haunt me out of that cell.
53
00:03:30,070 --> 00:03:30,250
All right.
54
00:03:30,280 --> 00:03:31,510
So there's my title.
55
00:03:31,540 --> 00:03:36,590
We'll worry about making that fancy looking colors and bold and all that stuff.
56
00:03:36,590 --> 00:03:37,560
We'll do that later on.
57
00:03:37,630 --> 00:03:42,980
For now we're just going to put some labels in there and start to build the basic structure of our spreadsheet.
58
00:03:43,720 --> 00:03:45,800
So I mean to drop down in the cell a three.
59
00:03:45,850 --> 00:03:51,040
And I'm going to create a column here that's going to act as the labels for all of the bills that I
60
00:03:51,040 --> 00:03:52,870
have for each of the months.
61
00:03:52,870 --> 00:03:56,070
So first thing I'm going to put in here is just a nice header.
62
00:03:56,140 --> 00:03:57,850
We'll just call it bills.
63
00:03:57,880 --> 00:04:00,100
I mean hit my enter key to drop down a cell again.
64
00:04:00,100 --> 00:04:01,660
And now I'm going to create a list.
65
00:04:01,690 --> 00:04:05,500
Nice little column here of various bills that I have for each month.
66
00:04:05,530 --> 00:04:11,170
Now you can copy me exactly if you like to hopefully you're following along with me right you copy the
67
00:04:11,170 --> 00:04:12,960
exact same stuff if you like.
68
00:04:13,330 --> 00:04:14,810
But I want to encourage you.
69
00:04:14,890 --> 00:04:20,890
One of the best best ways to learn something new is not only participate in a course like this and to
70
00:04:20,890 --> 00:04:24,250
learn but to put it to practice.
71
00:04:24,310 --> 00:04:30,520
So the sooner that you can start to put this into your own real world scenarios the better off you're
72
00:04:30,520 --> 00:04:31,540
going to be.
73
00:04:31,540 --> 00:04:34,150
So think about what bills do you have.
74
00:04:34,360 --> 00:04:35,050
Right.
75
00:04:35,080 --> 00:04:37,120
So here I'm just going to make some stuff up.
76
00:04:37,160 --> 00:04:39,140
Let me just say we got ramped.
77
00:04:39,400 --> 00:04:44,860
We got a phone we got credit cards.
78
00:04:45,470 --> 00:04:47,180
It make sure it's spelled out right.
79
00:04:47,190 --> 00:04:53,830
Credit cards hit my enter key drop down again and say we got food and let's do one more year I'm going
80
00:04:53,830 --> 00:04:55,410
to say Candy.
81
00:04:55,560 --> 00:04:56,770
Got to have candy right.
82
00:04:56,830 --> 00:04:59,600
Each and every month you get your bill for your candy.
83
00:04:59,670 --> 00:05:01,960
I mean it my energy our job down now.
84
00:05:01,990 --> 00:05:02,820
That's good.
85
00:05:02,830 --> 00:05:06,910
I'm going to call good right there of course I've got more inside there may want to put car in there.
86
00:05:06,910 --> 00:05:12,960
You got electricity gas you got garbage water you got this that and the other thing.
87
00:05:13,120 --> 00:05:13,330
Right.
88
00:05:13,330 --> 00:05:15,740
Whatever bills you have.
89
00:05:15,870 --> 00:05:16,080
Right.
90
00:05:16,150 --> 00:05:21,940
Let's go and create a list there and eventually we're going to start to put in the values for each of
91
00:05:21,940 --> 00:05:27,670
the months that we're spending on these various bills start to start to make it feel kind of bad where
92
00:05:27,670 --> 00:05:30,330
all your your money is going right.
93
00:05:30,340 --> 00:05:35,450
Hopefully it's going to Candy though right now down below that again I'm just going to stop it there.
94
00:05:35,530 --> 00:05:42,200
I'm going to put in a total eventually we're going to have a row here right here.
95
00:05:42,250 --> 00:05:49,000
That's going to give us some totals for the various months that we'll have for each of our bills.
96
00:05:49,000 --> 00:05:49,740
All right.
97
00:05:49,810 --> 00:05:52,510
So these are our real headers our real labels.
98
00:05:52,510 --> 00:05:55,490
Let's go out and continue building the structure.
99
00:05:55,510 --> 00:05:57,700
I'm going to jump up into cell B 3.
100
00:05:57,700 --> 00:06:02,610
I'm just clicking up there and I mean to put some labels up here for each of the months.
101
00:06:02,710 --> 00:06:07,000
So as of recording right now it is February of 2019.
102
00:06:07,020 --> 00:06:09,880
But I'm going to go and start this out at January.
103
00:06:09,880 --> 00:06:14,660
So I'm going to tape in Jan if you want to tape out January feel free.
104
00:06:14,650 --> 00:06:16,150
You can do that as well.
105
00:06:16,190 --> 00:06:22,210
I have a couple of a heels of my own as far as spelling is concerned my spelling is horrible.
106
00:06:22,430 --> 00:06:26,090
My kids come home from school and ask me how to spell something.
107
00:06:26,120 --> 00:06:29,330
Open up word Microsoft Word and I type it in there.
108
00:06:29,360 --> 00:06:30,740
Spell checker right.
109
00:06:31,010 --> 00:06:31,500
Awesome.
110
00:06:32,060 --> 00:06:35,710
So January February Radic Denver Mirror spell those two.
111
00:06:35,960 --> 00:06:37,270
So I'm just gonna have abbreviate.
112
00:06:37,310 --> 00:06:44,300
I'll say Jan I mean hit my tab key just to hop over to the right one so I'll tape and then tab and I'll
113
00:06:44,300 --> 00:06:45,310
tape then Ma.
114
00:06:45,410 --> 00:06:51,290
March I mean hit my it actually hit tab Q One more time I'm going to stop right there for the months
115
00:06:51,380 --> 00:06:57,260
and keep it really simple if you'd like you can continue going right the more practice you get the better
116
00:06:57,740 --> 00:07:03,500
you can go to April May June July do whatever you like you want to on Saturday you could start at whatever
117
00:07:03,500 --> 00:07:09,290
month you want again up to you but I'm going to stop right there and I'm going to put a nother total
118
00:07:09,290 --> 00:07:15,380
label remember we've got this one we've got this guy down here it's in my enter key hop out of there
119
00:07:16,190 --> 00:07:21,710
we've got that one right there because eventually we're gonna have some a row total here for each column
120
00:07:22,160 --> 00:07:29,540
but then I'm going to have one here because I want to do totals for each of the bills as well so this
121
00:07:29,540 --> 00:07:36,530
right here this is this is kind of the basic structure of a spreadsheet you've got real labels in this
122
00:07:36,530 --> 00:07:44,390
case bills you've got column labels representing some type of date now there's our basic structure our
123
00:07:44,390 --> 00:07:50,930
labels and these are just text values so if you're not following along with me step by step right now
124
00:07:51,050 --> 00:07:58,010
go ahead pause the video start to create the basic structure the labels of your Excel monthly budget
125
00:07:58,400 --> 00:08:04,970
so get that part done pause the video if you need to once you're done jump back in our next lecture
126
00:08:05,150 --> 00:08:10,450
we're going to start to talk about entering numeric values and putting some currency amounts inside
127
00:08:10,460 --> 00:08:14,870
of these months for these bills so get that done we'll jump into the next section.
12794
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.