1
00:00:02,460 --> 00:00:06,510
The aim for the next two lectures is to create this dataset.

2
00:00:06,600 --> 00:00:12,900
While we do this I'm gonna show you some tips and tricks when it comes to entering, removing, or editing

3
00:00:12,900 --> 00:00:13,950
data.

4
00:00:13,950 --> 00:00:14,820
Let's get started.

5
00:00:15,240 --> 00:00:20,430
I want to input the January and February sales values for four products.

6
00:00:20,430 --> 00:00:27,150
So first off, let's start by typing in my first product which is scarf for men's, "Scarf-M".

7
00:00:27,240 --> 00:00:33,090
When I press enter the default behavior for Excel is to move one cell down.

8
00:00:33,180 --> 00:00:40,110
If I wanted to press enter but stay in the same cell, I need to press control+enter.

9
00:00:40,140 --> 00:00:44,580
Now let's say I wanted to copy this value to the cell below it.
10

10
00:00:44,580 --> 00:00:53,220
I can use control+C, go down to the cell below and press control+V or press control+Z to go back

11
00:00:53,400 --> 00:00:56,140
What I can also do is use the fill handle.

12
00:00:56,140 --> 00:01:01,320
So just go to the side of the cell until you get this bold cross and drag this down.

13
00:01:01,320 --> 00:01:05,190
What if I wanted to edit the cell contents, instead of scarf-M

14
00:01:05,200 --> 00:01:12,270
I want scar for women so scarf-W. If I start to directly type something in, so let's say by mistake

15
00:01:12,300 --> 00:01:13,720
I start typing this in.

16
00:01:13,770 --> 00:01:15,830
It overwrites the cell content.

17
00:01:15,960 --> 00:01:22,140
If I was planning to overwrite I don't need to press backspace or delete and then write. I can just

18
00:01:22,140 --> 00:01:22,880
start typing.

19
00:01:23,250 --> 00:01:28,040
If I realized that I made a mistake and I want to reset this, so go back to what I had.

20
00:01:28,200 --> 00:01:35,190
I can press escape. If it's too late and I already pressed enter I can press control+Z to go back or

21
00:01:35,190 --> 00:01:43,590
use the undo button in your quick access toolbar. To edit this content, I have two options. Either I can

22
00:01:43,590 --> 00:01:50,340
use my mouse and double click here and then just use backspace to change the last letter to W and press

23
00:01:50,340 --> 00:01:58,080
control+enter. Or, if I don't want to use the mouse I can use the F2 key to edit, press backspace, change,

24
00:01:58,290 --> 00:02:05,580
and press control+enter. Let's add headers for this, type in Jan here. To move to the next cell beside

25
00:02:05,880 --> 00:02:11,970
I can either use the right arrow key or use the tab key. Type in Feb and press the tab key.

26
00:02:12,240 --> 00:02:18,360
I just want to add two months here and add numbers to these and add two more products below.

27
00:02:18,390 --> 00:02:26,550
So best is to make the data entry experience easier for me is to highlight the area I want to add data

28
00:02:26,580 --> 00:02:29,180
first and then start typing.

29
00:02:29,340 --> 00:02:34,960
This has the advantage that when you press tab and you get to the end of your selection, when you press

30
00:02:34,970 --> 00:02:39,880
tab again you go down. And if you're on the bottom you press tab again

31
00:02:39,960 --> 00:02:40,770
you go on top.

32
00:02:40,830 --> 00:02:42,830
Let's just start inputting numbers.

33
00:02:42,840 --> 00:02:46,230
I'm going to put 100 here, press tab, 110.

34
00:02:46,230 --> 00:02:47,030
Press tab.

35
00:02:47,100 --> 00:02:52,650
I don't want to input anything here, so just press tab and just continue with inputting the rest of the

36
00:02:52,650 --> 00:02:54,050
numbers.

37
00:02:54,330 --> 00:03:01,350
Once you get to the bottom and you want to deselect this, just click anywhere outside the selection.

38
00:03:01,350 --> 00:03:07,050
Now let's also add a title here "Clothing items by type"

39
00:03:07,050 --> 00:03:11,340
So if by type starts to get cut off you can expand this.

40
00:03:11,580 --> 00:03:18,510
But if you find that this column becomes too big you can instead use wrap text.

41
00:03:18,630 --> 00:03:22,740
That's going to fit the text by increasing the size of the row.

42
00:03:22,770 --> 00:03:27,840
So if it happens to be much smaller, so if it's something like this and it still gets cut off we can

43
00:03:27,840 --> 00:03:30,630
double click on the line between the two rows

44
00:03:30,660 --> 00:03:37,320
to make this auto fit. Now this is a bit too much so I'm going to double click again to auto fit this

45
00:03:37,320 --> 00:03:38,030
back.

46
00:03:38,050 --> 00:03:45,470
Now what happens if I wanted this to be this size but I want by item to always be in the second line.

47
00:03:45,540 --> 00:03:49,790
So I actually want to add a line break inside the cell.

48
00:03:49,800 --> 00:03:52,560
I can use the shortcut key alt+enter.

49
00:03:52,650 --> 00:03:58,140
So either go into edit mode or go through your formula bar. Click on the place you want to have the line

50
00:03:58,140 --> 00:04:00,860
break and press Alt+Enter.

51
00:04:00,870 --> 00:04:04,740
This adds a second line inside the cell. In the formula bar,

52
00:04:04,770 --> 00:04:06,600
I can't see it because it's collapsed.

53
00:04:06,600 --> 00:04:12,480
I have to expand the formula bar to be able to see my full text and press enter.

54
00:04:12,490 --> 00:04:15,360
Now let's also add some basic formatting to this.

55
00:04:15,600 --> 00:04:21,380
So let's say I want this to be bold and I want to add a bottom border to this.

56
00:04:21,510 --> 00:04:25,380
Let's just click on this down arrow to see the different options we have.

57
00:04:25,380 --> 00:04:29,360
We have a standard bottom border or we have a thick bottom border.

58
00:04:29,360 --> 00:04:30,690
So I'll go with this one.

59
00:04:30,990 --> 00:04:37,080
If I wanted to apply this formatting to other cells I can use the format painter.

60
00:04:37,080 --> 00:04:42,430
What this does is it applies the entire formatting to the other cells.

61
00:04:42,450 --> 00:04:43,560
Everything that came with it.

62
00:04:43,590 --> 00:04:49,140
Also the wrap text. But in this case it doesn't matter because I just have a small text in there.

63
00:04:49,200 --> 00:04:58,390
If I wanted to apply this formatting to many cells, I can click on this and select a range of cells.

64
00:04:58,440 --> 00:05:06,450
What if I wanted to apply this to different ranges? Because notice after I apply this the paint brush disappears.

65
00:05:06,590 --> 00:05:11,710
I can't reuse it again. To be able to reuse it as many times as you want

66
00:05:11,720 --> 00:05:18,290
you have to double click on the paint brush. So double click really fast then you can apply it to different

67
00:05:18,290 --> 00:05:18,950
ranges.

68
00:05:18,950 --> 00:05:22,760
Notice that the paint brush stays with your mouse icon.

69
00:05:22,850 --> 00:05:25,580
Once you're done press escape to leave.

70
00:05:25,970 --> 00:05:27,490
Now this doesn't look so good.

71
00:05:27,500 --> 00:05:31,240
I'm gonna press control+z a few times to go back.

72
00:05:31,270 --> 00:05:38,480
Now all I want is to apply this one to February as well. The default for Excel sheets is to have

73
00:05:38,480 --> 00:05:39,960
grid lines activated.

74
00:05:40,130 --> 00:05:42,800
You can remove them for a cleaner look.

75
00:05:42,820 --> 00:05:47,350
So go to the view tab and take away the check mark beside the grid lines.

76
00:05:47,450 --> 00:05:50,690
Here we can also add our own type of borders.

77
00:05:50,690 --> 00:05:55,440
We're not restricted to the options and the colors we see directly here.

78
00:05:55,670 --> 00:05:58,530
Let's just highlight the area if we want to have the borders.

79
00:05:58,600 --> 00:06:02,200
Let's click on this and go to more borders.

80
00:06:02,210 --> 00:06:04,650
This brings up the format cells dialog box.

81
00:06:04,670 --> 00:06:11,230
We go directly to the border tab and here we can exactly select where we want to have the border.

82
00:06:11,270 --> 00:06:14,450
Now in this case I want to have light grey borders.

83
00:06:14,480 --> 00:06:20,240
Keep in mind that whenever you want to have another color or another thickness for the border you have

84
00:06:20,240 --> 00:06:25,340
to make that selection first before you start clicking in here.

85
00:06:25,340 --> 00:06:28,890
Since I want to have grey ones let's select a color first.

86
00:06:28,890 --> 00:06:36,110
Now I can either click on the side here and this is a toggle or I can click directly inside the cell

87
00:06:36,110 --> 00:06:36,800
here.

88
00:06:36,800 --> 00:06:39,540
But sometimes when you click you might get something like this.

89
00:06:39,630 --> 00:06:47,150
So it may be easier to use the toggles on the side here. Adding a border in the middle adds a border between

90
00:06:47,450 --> 00:06:48,800
my products here.

91
00:06:48,830 --> 00:06:55,130
Now I'd also like to add a border to the bottom but I want it to be a thicker border so first I have

92
00:06:55,130 --> 00:07:00,590
to change my selection from the style options here and then apply to the bottom here.

93
00:07:00,680 --> 00:07:06,500
Then click on OK. So that was basic data entry and basic formatting.

94
00:07:06,620 --> 00:07:12,890
In the next lecture let's take a look at adding simple formulas to this and also adjusting the number

95
00:07:12,890 --> 00:07:13,700
formatting.