1 00:00:01,040 --> 00:00:07,800 Hi, everyone, in this video, we are going to cover basic mathematical operations and by the end of 2 00:00:07,800 --> 00:00:14,160 this video, you will be able to appreciate the fact that Excel makes it very easy to do repetitive 3 00:00:14,160 --> 00:00:15,520 mathematical operations. 4 00:00:16,830 --> 00:00:17,430 Let's start. 5 00:00:19,040 --> 00:00:21,850 Modeselektor, I'll be working on this workbook. 6 00:00:23,210 --> 00:00:27,150 We have a table here of two columns containing numbers. 7 00:00:29,060 --> 00:00:31,480 Here are the tasks that I have to perform. 8 00:00:32,990 --> 00:00:38,930 My first task is to add the two numbers and write them some in the column by some. 9 00:00:40,990 --> 00:00:47,740 Then in the fourth column, I will add the two numbers and I will add a constant as well. 10 00:00:48,910 --> 00:00:52,600 This is the content that will be adding along with these two numbers. 11 00:00:55,300 --> 00:01:03,070 In the fifth column, we will multiply these three numbers and in the last column we will find the average 12 00:01:03,070 --> 00:01:04,350 of the three numbers. 13 00:01:06,670 --> 00:01:13,410 All in all, for these 10 rows of numbers, I have 40 cells to be filled. 14 00:01:15,100 --> 00:01:16,330 Looks like a big task. 15 00:01:17,290 --> 00:01:23,020 Even if we use a calculator, it may take us 15 minutes to do this, maybe even more. 16 00:01:23,980 --> 00:01:26,980 Don't worry in it, it won't take that long. 17 00:01:27,700 --> 00:01:28,420 Let's see how. 18 00:01:30,680 --> 00:01:38,300 First, we want to add two numbers for this, we need to write a formula because a calculation is to 19 00:01:38,300 --> 00:01:38,590 be done. 20 00:01:39,800 --> 00:01:42,080 A formula starts with an equal to Simbel. 21 00:01:44,040 --> 00:01:52,740 This symbol is Excel, that the calculation is to be done in this cell, so we rate is equal to click 22 00:01:52,740 --> 00:01:58,920 on the fossil for the plus symbol and then click on this. 23 00:02:01,440 --> 00:02:07,290 You can see that the two cells part of this formula are highlighted in colored boxes. 24 00:02:08,670 --> 00:02:14,940 Now, when I hit Enter, Excel will calculate the value from the formula and it hit. 25 00:02:17,500 --> 00:02:24,310 If you click the cell, you can see that formula is still showing the actual formula, but this certainly 26 00:02:24,320 --> 00:02:26,810 showing the calculated value of the formula. 27 00:02:28,390 --> 00:02:30,110 If you want to edit the formula. 28 00:02:30,940 --> 00:02:37,870 You can either do it in the formula bar or double click on the cell and then edit the formula. 29 00:02:40,240 --> 00:02:42,460 Now, you may have this question in mind. 30 00:02:43,420 --> 00:02:46,890 Why in the formula did we add two cells? 31 00:02:47,830 --> 00:02:53,320 Why is it A two plus B two and not five plus six? 32 00:02:55,390 --> 00:03:00,660 Well, if we write five plus six, even then we will get the same answer. 33 00:03:02,170 --> 00:03:09,500 But using cell reference that is writing A two plus B two gives us additional benefits. 34 00:03:10,930 --> 00:03:15,770 The first benefit is that this makes the cell dynamic changes. 35 00:03:17,240 --> 00:03:21,100 For example, if you update this number, 250. 36 00:03:23,720 --> 00:03:31,310 Then you need not correct your formula in your formula will add the updated content of these two cells 37 00:03:31,580 --> 00:03:40,160 and to you, the new ones that had you written five plus six initially, you would need to rectify this 38 00:03:40,160 --> 00:03:44,000 formula every time you make any changes to these two numbers. 39 00:03:45,870 --> 00:03:48,690 The second benefit is simply amazing. 40 00:03:50,360 --> 00:03:57,080 Exxon offers a functionality of extending cities and formulas from one cell to the other. 41 00:03:59,490 --> 00:04:06,570 If you go to the bottom right corner of this cell, you will see that the cursor changes to a small 42 00:04:06,810 --> 00:04:07,290 symbol. 43 00:04:09,070 --> 00:04:20,440 Click and hold and no drag don't you'll see this black border extending to the next cell, you can extend 44 00:04:20,440 --> 00:04:22,420 it as far as you like to. 45 00:04:22,840 --> 00:04:28,810 But first, let's see what happens with this one cell in this cell. 46 00:04:28,840 --> 00:04:38,830 You can see that the sum is calculated in the formula, but you see that automatically it is adding 47 00:04:39,130 --> 00:04:40,720 A3 and Betadine not. 48 00:04:42,260 --> 00:04:52,490 We entered the formula in C2 four, adding A2 and B2, but when we extended the formula, it was automatically 49 00:04:52,490 --> 00:04:54,710 updated to A3 and beat. 50 00:04:56,900 --> 00:05:04,550 The logic followed is that when you extend the formula to the next row, all these references are updated 51 00:05:04,550 --> 00:05:05,430 or the next group. 52 00:05:07,160 --> 00:05:08,500 Same holds four columns. 53 00:05:08,960 --> 00:05:13,570 If I extend the formula to the right, that is to the next column. 54 00:05:14,030 --> 00:05:19,130 All references will point to the next column in the new formula. 55 00:05:20,720 --> 00:05:23,090 Let's see this and they in the right. 56 00:05:29,970 --> 00:05:37,380 Here, the formula in today's E3, plus I thought if I extend this formula to the right. 57 00:05:40,240 --> 00:05:49,390 The new formula states Dadri plus G4, that is when they extend the formula to a decent cell, which 58 00:05:49,390 --> 00:05:54,830 has a new column number, all the cell references in the formula are changed accordingly. 59 00:05:56,410 --> 00:06:00,490 So can you see the power now to fill this entire column? 60 00:06:01,390 --> 00:06:03,460 I need not add 10 times. 61 00:06:03,700 --> 00:06:08,650 Just write the Formula One and drag it to all the other cells and it's done. 62 00:06:11,750 --> 00:06:13,570 You can see this column is very. 63 00:06:18,240 --> 00:06:21,190 For the next column, we have to add three numbers. 64 00:06:21,660 --> 00:06:24,150 Number one, number two and the constant. 65 00:06:25,150 --> 00:06:26,560 Let's state the formula for that. 66 00:06:28,200 --> 00:06:36,120 Is equal to Itou plus BE2 plus this constant. 67 00:06:39,350 --> 00:06:45,770 I would like to extend this formula to other cells in this column, but we may extend it. 68 00:06:49,430 --> 00:06:56,780 The road reference is updated for all the cells, it becomes a tree. 69 00:06:57,080 --> 00:07:02,840 We do because we try and be 13 will be 14. 70 00:07:07,310 --> 00:07:16,910 Two becoming three is OK for me here, but I do not want this 13 to increase to 14 because my constant 71 00:07:17,120 --> 00:07:19,850 stays in cell B 13 only. 72 00:07:22,580 --> 00:07:31,020 To stop this from happening, that is to stop the differences, to be updated, we can use dollar symbols. 73 00:07:31,640 --> 00:07:43,610 Let me show you how in this formula A is referenced using Collum name and Ronney, if you track the 74 00:07:43,610 --> 00:07:48,850 formula down through the name is updated rule name is the number. 75 00:07:49,280 --> 00:07:50,870 So two becomes three. 76 00:07:52,010 --> 00:07:58,350 If you put a dollar symbol, dollar symbol as the symbol that you find over the keyboard. 77 00:07:58,370 --> 00:07:59,260 Number four. 78 00:08:00,110 --> 00:08:08,750 So if you press shift and then press presto, you'll get a dollar symbol if you add a dollar symbol 79 00:08:08,750 --> 00:08:10,190 in front of the name. 80 00:08:12,320 --> 00:08:14,510 And then break down the formula. 81 00:08:19,160 --> 00:08:26,210 You will notice that that cell reference, which has a dollar symbol in front of it, will not be updated 82 00:08:26,390 --> 00:08:27,410 and will be logged. 83 00:08:29,490 --> 00:08:39,930 So if you compare the formula in to Andrew three, it becomes Edri veto becomes Vetri, but B 13, status 84 00:08:39,930 --> 00:08:40,620 B 13. 85 00:08:41,730 --> 00:08:44,540 This is because 13 was logged with their dollars and. 86 00:08:49,090 --> 00:08:52,210 Let's extend it to all the cells in this column. 87 00:08:54,450 --> 00:09:03,990 You can check it is working fine for all the things we can do the same thing for Collins, also for 88 00:09:03,990 --> 00:09:07,260 columns, then we drag the formula from left to right. 89 00:09:07,530 --> 00:09:08,670 Column names are changed. 90 00:09:09,660 --> 00:09:13,650 Putting a dollar symbol in front of column name will block it. 91 00:09:16,080 --> 00:09:23,880 So now if I extend this horizontally, you'll see that it becomes Dadri. 92 00:09:23,930 --> 00:09:27,570 Ifour becomes G4 A six becomes G six. 93 00:09:29,120 --> 00:09:33,770 I want A6 to remain as A6 and not become desex. 94 00:09:35,040 --> 00:09:38,460 So I will put a dollar symbol. 95 00:09:41,800 --> 00:09:43,780 Here in front of A6. 96 00:09:45,500 --> 00:09:51,080 This means I will be locked, so when I extend this formula horizontally. 97 00:09:53,350 --> 00:09:58,450 Here you will see J3 plus dofor plus icings. 98 00:10:03,600 --> 00:10:05,510 What if we put a dollar bill on board? 99 00:10:07,730 --> 00:10:14,150 Probably you guessed it right, if you put a dollar bill on board, the wrong name and the name board 100 00:10:14,160 --> 00:10:17,400 will not change regardless of where you move the formula. 101 00:10:20,990 --> 00:10:30,890 Now, in the next two columns, we know what to do, let's write the formula first for product, we 102 00:10:30,890 --> 00:10:32,570 will select the first number. 103 00:10:33,950 --> 00:10:42,590 The multiply symbol is the aesthetic, which can be found on number eight in the keyboard with number 104 00:10:42,590 --> 00:10:42,890 two. 105 00:10:46,150 --> 00:10:53,110 Multiplied with the number three with dollars and, well, in front of the low number. 106 00:10:59,530 --> 00:11:01,690 And in the average column. 107 00:11:04,780 --> 00:11:11,050 We need to add the three numbers first and then divide them by three to the average. 108 00:11:13,120 --> 00:11:21,850 So since we have to add the three numbers, first, we will write some in the brackets, so within bracket 109 00:11:22,420 --> 00:11:23,110 number one. 110 00:11:23,320 --> 00:11:27,340 Plus number two plus. 111 00:11:29,110 --> 00:11:31,930 This constant symbol. 112 00:11:34,740 --> 00:11:40,010 We'll close this bracket and divide this total sum that three. 113 00:11:45,880 --> 00:11:55,150 Now, in this fourth column, we can also use the sum calculated in the column B in the column, we 114 00:11:55,150 --> 00:12:01,050 already have this so we can straightaway use this value and divide it by three. 115 00:12:01,810 --> 00:12:07,300 So instead of writing this formula, we can also write is equal to the two, divided by three. 116 00:12:09,620 --> 00:12:11,670 So the formulas are written in these two cities. 117 00:12:12,570 --> 00:12:17,210 Now, here's another handy trick you can select, but this is. 118 00:12:19,550 --> 00:12:22,370 Go to the bottom right corner and double click. 119 00:12:27,360 --> 00:12:35,730 When you double click, it automatically fills it up for the entire table so you don't have to click 120 00:12:35,730 --> 00:12:39,250 and hold the bottom right corner and drag it to the entire table. 121 00:12:41,040 --> 00:12:46,350 You can just go to the bottom right corner and double click and the entire table will be. 122 00:12:49,880 --> 00:12:58,730 I hope you can now see how it increases productivity in tasks which involve repetitive calculations 123 00:13:00,380 --> 00:13:01,430 in the coming videos. 124 00:13:01,550 --> 00:13:07,820 We will see other functions, mathematical textual logical functions that are commonly used to perform 125 00:13:07,820 --> 00:13:09,140 complex tasks in.