WEBVTT 00:00:00.000 --> 00:00:04.000 Hello everyone, welcome back to my channel. My name is Hikna. 00:00:04.000 --> 00:00:11.000 If this is your first time to see my video or channel, in this channel I discuss a lot of tutorials about Excel. 00:00:11.000 --> 00:00:18.000 A lot of people requested me to explain Excel from scratch. 00:00:18.000 --> 00:00:21.000 So in this video I will try to explain Excel from scratch. 00:00:21.000 --> 00:00:26.000 I hope this video can help you who want to learn Excel from scratch. 00:00:27.000 --> 00:00:29.000 Okay, let's get started. 00:00:29.000 --> 00:00:36.000 This is the first look when you open an Excel application on your PC or Desktop. 00:00:36.000 --> 00:00:40.000 I'm talking about Excel that is on your PC, Computer or Laptop. 00:00:40.000 --> 00:00:43.000 Not the one that is on your mobile phone, etc. 00:00:43.000 --> 00:00:48.000 A little note, I'm using Excel 2016. 00:00:48.000 --> 00:00:52.000 So if your Excel is a bit different, either older or newer. 00:00:52.000 --> 00:00:54.000 Maybe the look will be a bit different. 00:00:54.000 --> 00:00:57.000 But I'm sure the menu will be 99% the same. 00:00:57.000 --> 00:01:01.000 So let's get straight to the video. 00:01:01.000 --> 00:01:07.000 So I will explain in detail what features are in Excel, how to use Excel, 00:01:07.000 --> 00:01:11.000 the definitions in Excel, what rows are, what columns are, etc. 00:01:11.000 --> 00:01:15.000 So this is the first look when you open an Excel application. 00:01:15.000 --> 00:01:17.000 There are several templates that you can choose. 00:01:17.000 --> 00:01:24.000 For example, if you want to make a calendar, budget, etc. 00:01:24.000 --> 00:01:27.000 If you click more templates, you will get more templates. 00:01:27.000 --> 00:01:35.000 You can make a calendar, chart, daily schedule, etc. 00:01:35.000 --> 00:01:43.000 But to make the tutorial more simple, I will choose a blank workbook. 00:01:43.000 --> 00:01:46.000 A simple blank workbook. 00:01:46.000 --> 00:01:48.000 I will click this. 00:01:48.000 --> 00:01:51.000 Then a look like this will appear. 00:01:51.000 --> 00:01:57.000 Maybe I will try to zoom in a little so that the look can be bigger. 00:01:57.000 --> 00:02:00.000 So I will start with a few things. 00:02:00.000 --> 00:02:03.000 The first thing is, I want to explain first. 00:02:03.000 --> 00:02:06.000 In Excel, there are different tabs. 00:02:06.000 --> 00:02:09.000 So the tab is like this. 00:02:09.000 --> 00:02:11.000 Maybe it's a bit small on YouTube. 00:02:11.000 --> 00:02:17.000 But I read that there are Home, Insert, Page Layout, Formulas, Data, etc. 00:02:17.000 --> 00:02:18.000 This is called a tab. 00:02:18.000 --> 00:02:22.000 So in Excel, there are 8 or 9 different tabs. 00:02:22.000 --> 00:02:23.000 That's called a tab. 00:02:23.000 --> 00:02:28.000 Each tab has a menu. 00:02:28.000 --> 00:02:30.000 If you click Home, it will appear like this. 00:02:30.000 --> 00:02:33.000 If you click Insert, it will appear differently. 00:02:33.000 --> 00:02:34.000 It's called a Ribbon. 00:02:34.000 --> 00:02:37.000 In Indonesian, it's called Pita. 00:02:37.000 --> 00:02:39.000 It's a bit weird, but let's call it a Ribbon. 00:02:39.000 --> 00:02:44.000 In Excel, there are a few groups. 00:02:44.000 --> 00:02:50.000 In this group, there are Clipboard, Font, Alignment, Number, Styles, etc. 00:02:50.000 --> 00:02:52.000 So there are a lot of menus here. 00:02:52.000 --> 00:02:54.000 Maybe we will discuss them separately later. 00:02:54.000 --> 00:02:58.000 But I want to explain first the structure of Excel. 00:02:58.000 --> 00:02:59.000 So there is a tab. 00:02:59.000 --> 00:03:03.000 Then when you click the tab, there is a long ribbon. 00:03:03.000 --> 00:03:06.000 And if you look, there are different sections. 00:03:07.000 --> 00:03:09.000 That's called a group. 00:03:09.000 --> 00:03:12.000 There are a lot of buttons here that you can click. 00:03:12.000 --> 00:03:18.000 For example, if you hover the mouse, there is a small gray area. 00:03:18.000 --> 00:03:26.000 That means if you click there, it will activate the button according to each function. 00:03:26.000 --> 00:03:33.000 Next, I want to discuss what is a row, column, cell, and range. 00:03:33.000 --> 00:03:36.000 First, in Excel, there is a column. 00:03:36.000 --> 00:03:38.000 So the column is like this. 00:03:38.000 --> 00:03:39.000 There is a column. 00:03:39.000 --> 00:03:43.000 The column is from top to bottom vertically. 00:03:43.000 --> 00:03:44.000 This is called column A. 00:03:44.000 --> 00:03:47.000 There is column B, column C, column D, and so on. 00:03:47.000 --> 00:03:52.000 If you move this, it can reach the letter Z. 00:03:52.000 --> 00:03:53.000 This is the letter Z. 00:03:53.000 --> 00:03:56.000 After the letter Z, it will start again from the letter AA. 00:03:56.000 --> 00:03:58.000 So it's like that. 00:03:58.000 --> 00:03:59.000 This is called a column. 00:03:59.000 --> 00:04:02.000 So a column can be one column or four columns. 00:04:02.000 --> 00:04:03.000 A to D. 00:04:03.000 --> 00:04:07.000 The second thing you need to know is the term called a row. 00:04:07.000 --> 00:04:13.000 So this is a row that goes from left to right. 00:04:13.000 --> 00:04:15.000 This is row 1, row 2, row 3. 00:04:15.000 --> 00:04:17.000 In Excel, it's called a row. 00:04:17.000 --> 00:04:19.000 So you have to understand the term in English. 00:04:19.000 --> 00:04:25.000 Because this is what Excel uses in all languages. 00:04:25.000 --> 00:04:26.000 This is a column. 00:04:26.000 --> 00:04:28.000 This is a row. 00:04:28.000 --> 00:04:32.000 Columns always have letters. 00:04:32.000 --> 00:04:34.000 Column A, column B, column C. 00:04:34.000 --> 00:04:36.000 So there is no column 1, column 2, column 3. 00:04:36.000 --> 00:04:38.000 While rows always have numbers. 00:04:38.000 --> 00:04:43.000 So rows are rows 1, row 2, row 7, row 10, and so on. 00:04:43.000 --> 00:04:45.000 There is no row that is row A, B, C. 00:04:45.000 --> 00:04:47.000 This is for you to understand. 00:04:47.000 --> 00:04:48.000 Next. 00:04:48.000 --> 00:04:51.000 After you know columns and rows. 00:04:51.000 --> 00:04:56.000 You can also click one of the small boxes here. 00:04:56.000 --> 00:04:57.000 For example, I click here. 00:04:57.000 --> 00:05:00.000 This means I'm clicking one cell. 00:05:00.000 --> 00:05:02.000 Activating one Excel cell. 00:05:02.000 --> 00:05:04.000 The cell has a name. 00:05:04.000 --> 00:05:06.000 So the cell is what I click here. 00:05:06.000 --> 00:05:08.000 This means cell A1. 00:05:08.000 --> 00:05:11.000 Because it's a cross between column A and row 1. 00:05:11.000 --> 00:05:12.000 This is called cell A1. 00:05:12.000 --> 00:05:14.000 This also appears here, A1. 00:05:14.000 --> 00:05:18.000 If you click here, this is cell C2. 00:05:18.000 --> 00:05:20.000 It also appears here, C2. 00:05:20.000 --> 00:05:21.000 That's what's called a cell. 00:05:21.000 --> 00:05:25.000 So the cell is wherever you click one like this is a cell. 00:05:25.000 --> 00:05:30.000 One more thing you have to understand is what is called range. 00:05:30.000 --> 00:05:33.000 Range is a collection of several different cells. 00:05:33.000 --> 00:05:37.000 So if I click like this. 00:05:37.000 --> 00:05:38.000 This is called range. 00:05:38.000 --> 00:05:41.000 Because it consists of more than one cell. 00:05:41.000 --> 00:05:45.000 So this is called range. 00:05:45.000 --> 00:05:49.000 Which is called A1 to C3. 00:05:49.000 --> 00:05:51.000 So this is A1 to C3. 00:05:51.000 --> 00:05:53.000 That's what's called range. 00:05:53.000 --> 00:05:58.000 So that's more or less what a column, a row, a cell, and a range is. 00:05:58.000 --> 00:06:02.000 Next, I want to let you know that there is a sheet here. 00:06:02.000 --> 00:06:08.000 So one Excel sheet like this is called one sheet or one spreadsheet. 00:06:08.000 --> 00:06:11.000 You can click, there is a plus button below here. 00:06:11.000 --> 00:06:14.000 If you click, it opens a new spreadsheet. 00:06:14.000 --> 00:06:15.000 Let's say sheet 2. 00:06:15.000 --> 00:06:18.000 So this is called spreadsheet or sheet 1. 00:06:18.000 --> 00:06:21.000 This is another different sheet. 00:06:22.000 --> 00:06:23.000 This is called sheet 2. 00:06:23.000 --> 00:06:25.000 You can click on the right. 00:06:25.000 --> 00:06:26.000 You can rename it. 00:06:26.000 --> 00:06:28.000 For example, the name is old sheet. 00:06:28.000 --> 00:06:30.000 And also we give this one a name. 00:06:30.000 --> 00:06:31.000 For example, new sheet. 00:06:31.000 --> 00:06:33.000 That can also be. 00:06:33.000 --> 00:06:34.000 Okay. 00:06:34.000 --> 00:06:38.000 Then on the bottom right. 00:06:38.000 --> 00:06:40.000 Maybe it's a bit closed with my video. 00:06:40.000 --> 00:06:41.000 You can check. 00:06:41.000 --> 00:06:43.000 There is what is called zoom. 00:06:43.000 --> 00:06:45.000 So you can shrink this zoom. 00:06:45.000 --> 00:06:46.000 You can enlarge it. 00:06:46.000 --> 00:06:47.000 It's up to you. 00:06:48.000 --> 00:06:51.000 It can be used to make your Excel look more suitable. 00:06:51.000 --> 00:06:53.000 More in line with what you want to do. 00:06:53.000 --> 00:06:59.000 Then we will start by typing or inputting data in Excel. 00:06:59.000 --> 00:07:04.000 So for example, I want to make data. 00:07:04.000 --> 00:07:05.000 What is it? 00:07:05.000 --> 00:07:06.000 For example, fruit inventory. 00:07:06.000 --> 00:07:07.000 Fruit stock. 00:07:07.000 --> 00:07:11.000 Fresh fruit stock. 00:07:11.000 --> 00:07:12.000 For example. 00:07:13.000 --> 00:07:17.000 Then here you can write the name of the fruit. 00:07:17.000 --> 00:07:18.000 Then what else? 00:07:18.000 --> 00:07:22.000 Maybe the remaining stock. 00:07:22.000 --> 00:07:23.000 What else? 00:07:23.000 --> 00:07:24.000 Maybe the price of the unit. 00:07:24.000 --> 00:07:25.000 For example. 00:07:25.000 --> 00:07:26.000 This can be. 00:07:26.000 --> 00:07:27.000 You can see here. 00:07:27.000 --> 00:07:29.000 If you write it too long. 00:07:29.000 --> 00:07:32.000 Or the letter is longer than the width of the column. 00:07:32.000 --> 00:07:33.000 It will be cut. 00:07:33.000 --> 00:07:34.000 The name of the fruit. 00:07:34.000 --> 00:07:36.000 So the fruit name has no H. 00:07:36.000 --> 00:07:39.000 Because it is closed with the next cell. 00:07:39.000 --> 00:07:41.000 Here you don't have to worry. 00:07:41.000 --> 00:07:42.000 Because if it's like this. 00:07:42.000 --> 00:07:45.000 You can easily change the width of the column. 00:07:45.000 --> 00:07:51.000 So if you go to the line between column A and column B. 00:07:51.000 --> 00:07:54.000 Your mouse will change the pointer like this. 00:07:54.000 --> 00:07:56.000 So there is a line mark. 00:07:56.000 --> 00:07:57.000 Then there is an arrow mark. 00:07:57.000 --> 00:07:58.000 If you click it. 00:07:58.000 --> 00:07:59.000 Move it. 00:07:59.000 --> 00:08:01.000 It can move the column width. 00:08:01.000 --> 00:08:02.000 So it's up to you. 00:08:02.000 --> 00:08:04.000 You can be this long. 00:08:04.000 --> 00:08:06.000 Or just like this. 00:08:06.000 --> 00:08:07.000 And the others are the same. 00:08:07.000 --> 00:08:09.000 You can move this too. 00:08:09.000 --> 00:08:11.000 You can move this too. 00:08:11.000 --> 00:08:12.000 And so on. 00:08:12.000 --> 00:08:14.000 Or if you click. 00:08:14.000 --> 00:08:15.000 Here. 00:08:15.000 --> 00:08:16.000 You click twice. 00:08:16.000 --> 00:08:19.000 When the pointer is shaped like the arrow mark. 00:08:19.000 --> 00:08:21.000 Then it will adjust automatically. 00:08:21.000 --> 00:08:22.000 Here too automatically. 00:08:22.000 --> 00:08:23.000 And so on. 00:08:23.000 --> 00:08:24.000 Well that. 00:08:24.000 --> 00:08:26.000 To change the size of the column. 00:08:26.000 --> 00:08:27.000 The line is also the same. 00:08:27.000 --> 00:08:29.000 If you go to the mouse. 00:08:29.000 --> 00:08:31.000 Between line 2 and line 3. 00:08:31.000 --> 00:08:32.000 Will change. 00:08:32.000 --> 00:08:33.000 So like this. 00:08:33.000 --> 00:08:34.000 There is an arrow mark above and below. 00:08:34.000 --> 00:08:35.000 You can move it like this. 00:08:35.000 --> 00:08:36.000 Move it up again. 00:08:36.000 --> 00:08:37.000 And so on. 00:08:37.000 --> 00:08:38.000 Or click twice. 00:08:38.000 --> 00:08:39.000 It will also adjust. 00:08:39.000 --> 00:08:41.000 The size of the line. 00:08:41.000 --> 00:08:43.000 According to your letter. 00:08:43.000 --> 00:08:44.000 Well. 00:08:44.000 --> 00:08:46.000 One more thing I want to explain. 00:08:46.000 --> 00:08:47.000 In this video is. 00:08:47.000 --> 00:08:48.000 Example. 00:08:48.000 --> 00:08:49.000 For example here. 00:08:49.000 --> 00:08:50.000 I start writing. 00:08:50.000 --> 00:08:51.000 Apple. 00:08:51.000 --> 00:08:52.000 Orange. 00:08:52.000 --> 00:08:53.000 Then this is grapes. 00:08:53.000 --> 00:08:54.000 But maybe let's say. 00:08:54.000 --> 00:08:55.000 Typo. 00:08:55.000 --> 00:08:56.000 I forgot the U. 00:08:56.000 --> 00:08:57.000 Well. 00:08:57.000 --> 00:08:58.000 There is a name. 00:08:58.000 --> 00:08:59.000 If you click the mouse once. 00:08:59.000 --> 00:09:00.000 In that cell. 00:09:00.000 --> 00:09:01.000 It is called activating the cell. 00:09:01.000 --> 00:09:02.000 Activate the cell. 00:09:02.000 --> 00:09:03.000 A5. 00:09:03.000 --> 00:09:04.000 But if you click twice. 00:09:04.000 --> 00:09:05.000 Well this means. 00:09:05.000 --> 00:09:06.000 Appears. 00:09:06.000 --> 00:09:07.000 This means. 00:09:07.000 --> 00:09:08.000 Appears. 00:09:08.000 --> 00:09:09.000 What. 00:09:09.000 --> 00:09:10.000 Pointer that is dark. 00:09:10.000 --> 00:09:11.000 Like you. 00:09:11.000 --> 00:09:12.000 If you type on Microsoft Word. 00:09:12.000 --> 00:09:13.000 That means you are in. 00:09:13.000 --> 00:09:14.000 Mode. 00:09:14.000 --> 00:09:15.000 Change. 00:09:15.000 --> 00:09:16.000 Content. 00:09:16.000 --> 00:09:17.000 Or data from the cell. 00:09:17.000 --> 00:09:18.000 So if it's like this. 00:09:18.000 --> 00:09:19.000 You can type. 00:09:19.000 --> 00:09:20.000 Backspace. 00:09:20.000 --> 00:09:21.000 For example. 00:09:21.000 --> 00:09:22.000 Or delete. 00:09:22.000 --> 00:09:23.000 Then. 00:09:23.000 --> 00:09:24.000 Type again. 00:09:24.000 --> 00:09:25.000 So it's really grapes. 00:09:25.000 --> 00:09:26.000 So. 00:09:26.000 --> 00:09:27.000 If you click once. 00:09:27.000 --> 00:09:28.000 That means activating the cell. 00:09:28.000 --> 00:09:29.000 If you click twice. 00:09:29.000 --> 00:09:30.000 It can edit. 00:09:30.000 --> 00:09:31.000 The contents of the cell itself. 00:09:31.000 --> 00:09:32.000 That. 00:09:32.000 --> 00:09:33.000 Well. 00:09:33.000 --> 00:09:34.000 Maybe more or less. 00:09:34.000 --> 00:09:35.000 That first. 00:09:35.000 --> 00:09:36.000 If you like. 00:09:36.000 --> 00:09:37.000 With content. 00:09:37.000 --> 00:09:38.000 Which. 00:09:38.000 --> 00:09:39.000 The nature is very basic. 00:09:39.000 --> 00:09:40.000 To make you. 00:09:40.000 --> 00:09:41.000 Better understand. 00:09:41.000 --> 00:09:42.000 From the beginning like this. 00:09:42.000 --> 00:09:43.000 Please like. 00:09:43.000 --> 00:09:44.000 Comment too. 00:09:44.000 --> 00:09:45.000 If later. 00:09:45.000 --> 00:09:46.000 We want to discuss others. 00:09:46.000 --> 00:09:47.000 More detailed. 00:09:47.000 --> 00:09:48.000 For example. 00:09:48.000 --> 00:09:49.000 Or you have questions. 00:09:49.000 --> 00:09:50.000 Or want. 00:09:50.000 --> 00:09:51.000 Content like this. 00:09:51.000 --> 00:09:52.000 We continue. 00:09:52.000 --> 00:09:53.000 To discuss the details. 00:09:53.000 --> 00:09:54.000 Really from the beginning. 00:09:54.000 --> 00:09:55.000 Please comment. 00:09:55.000 --> 00:09:56.000 And. 00:09:56.000 --> 00:09:57.000 Subscribe too. 00:09:57.000 --> 00:09:58.000 So you never miss it. 00:09:58.000 --> 00:09:59.000 Content. 00:09:59.000 --> 00:10:00.000 Content. 00:10:00.000 --> 00:10:01.000 Tutorial like this. 00:10:01.000 --> 00:10:02.000 Okay. 00:10:02.000 --> 00:10:03.000 That's all. 00:10:03.000 --> 00:10:04.000 Thank you.