1 00:00:14,720 --> 00:00:16,950 Hi, everyone, and welcome again. 2 00:00:17,960 --> 00:00:24,210 This is a very important lecture in our course, it's about cell writing and cell operations. 3 00:00:25,160 --> 00:00:34,070 The objectives are writing text and numbers, how to writing operators, how to write and combined operators, 4 00:00:34,190 --> 00:00:34,610 OK. 5 00:00:36,820 --> 00:00:48,130 Still writing in the Microsoft Excel, the cell can be written by three types Teguest Numbers, Formula, 6 00:00:48,670 --> 00:00:53,360 Teguest like welcome to Microsoft Excel. 7 00:00:53,830 --> 00:00:54,720 This is thickest. 8 00:00:55,240 --> 00:00:57,310 You can also enter a number. 9 00:00:58,740 --> 00:01:07,920 Such as four seven, five, four, seven, or you can enter formula, but if you want to enter a formula, 10 00:01:08,610 --> 00:01:12,540 you just write firstly equal sign. 11 00:01:12,840 --> 00:01:15,970 Let's get practical here. 12 00:01:16,410 --> 00:01:22,080 This is a Microsoft Excel, and I want her to write something. 13 00:01:22,710 --> 00:01:27,930 You can write text such as Smart or Excel. 14 00:01:29,660 --> 00:01:43,790 This is a text book also you can write just numbers seven, four, five, two, three, 10, whatever 15 00:01:44,420 --> 00:01:44,930 this is. 16 00:01:46,340 --> 00:01:55,520 And Amber, also you can write formula, but if you want to write a formula, firstly write equal sign 17 00:01:56,120 --> 00:01:58,370 and write whatever formula you want. 18 00:01:58,970 --> 00:02:07,790 If you want to add two numbers, you can add this number plus this number. 19 00:02:09,640 --> 00:02:23,230 So you're right, a former OK, so you can write three type of things, text number or formula, if 20 00:02:23,230 --> 00:02:27,310 you want to write the formula, you must know three things. 21 00:02:27,910 --> 00:02:37,050 First operator like plus minus multiplication division and so on. 22 00:02:37,540 --> 00:02:40,980 This is operators to make mathematical operation. 23 00:02:41,530 --> 00:02:48,720 So there is a key question and the key concept here, what is the difference between reference and constant 24 00:02:49,960 --> 00:02:51,100 on the other meaning? 25 00:02:51,460 --> 00:02:54,130 What are the difference between dynamic and static? 26 00:02:55,420 --> 00:02:56,450 Let's take example. 27 00:02:57,280 --> 00:03:07,960 Well, if you want to add two numbers, but you want to use just constants, press equals sign and the 28 00:03:07,960 --> 00:03:12,670 first constant will be two and the second constant will be. 29 00:03:14,000 --> 00:03:18,140 To there is the final result will be for OK. 30 00:03:21,580 --> 00:03:23,320 OK, this is going to stand. 31 00:03:24,460 --> 00:03:29,860 Plus, consistent, and this is fixed, static can't be changed. 32 00:03:30,670 --> 00:03:41,020 Well, let's write this formula by another way, right equals sign and select the reference for the 33 00:03:41,020 --> 00:03:43,000 first number. 34 00:03:44,330 --> 00:03:54,350 See, aid and the operation will be additions, right, plus and the second reference here will be. 35 00:03:56,890 --> 00:04:01,260 S. nine, the final result will be four. 36 00:04:01,600 --> 00:04:04,900 So what is the difference between this four and this four? 37 00:04:05,290 --> 00:04:06,360 This is a good question. 38 00:04:07,120 --> 00:04:15,100 The first four is a static can't be changed because it consists of two constants. 39 00:04:16,120 --> 00:04:21,330 However, the second formula consists of two references. 40 00:04:22,210 --> 00:04:28,580 Once you change only one reference automatically, the final result will be updated. 41 00:04:29,320 --> 00:04:40,390 So if you change this reference to three, the final result will be five, OK, and so on. 42 00:04:40,570 --> 00:04:47,320 If you change the second reference to B, then the final result will be 13. 43 00:04:50,380 --> 00:04:58,830 This is the key difference between cell reference and constant, OK, whatever I want to write one contestant 44 00:04:58,840 --> 00:05:01,170 and one cell reference. 45 00:05:01,720 --> 00:05:02,380 Let's try. 46 00:05:04,000 --> 00:05:05,230 I write equal sign. 47 00:05:06,460 --> 00:05:11,710 The first contestant will be due and the process will be addition. 48 00:05:12,220 --> 00:05:12,580 Right. 49 00:05:12,590 --> 00:05:13,240 Plus sign. 50 00:05:14,080 --> 00:05:20,830 And I want to add that second term of this equation as reference like C. 51 00:05:22,370 --> 00:05:32,780 Ed, the final result will depend on the reference if you update the reference by, for example, for 52 00:05:33,050 --> 00:05:39,820 automatically the final result will be changed. 53 00:05:40,140 --> 00:05:50,420 OK, so you can add constant and constant or you can add cell reference and reference, or you can add 54 00:05:50,420 --> 00:05:53,450 one constant and still references. 55 00:05:53,750 --> 00:05:57,470 OK, basic mathematical lubricator addition. 56 00:05:58,040 --> 00:06:01,130 The operator symbol is plus subtraction. 57 00:06:01,730 --> 00:06:05,390 That operator symbol is minus multiplication. 58 00:06:05,780 --> 00:06:09,140 That operator symbol is asterisk. 59 00:06:10,550 --> 00:06:19,050 The vision Briatore symbol is forward slash exponent, the operator symbol is power, saying you can 60 00:06:19,050 --> 00:06:29,050 write exponent by using, you can write the exponent sign power sign by using shift plastics. 61 00:06:29,300 --> 00:06:30,320 OK, ok. 62 00:06:33,460 --> 00:06:42,130 So let's take a simple example about these operations here, if I want to add variable X and variable 63 00:06:42,280 --> 00:06:45,640 Y, let's write formula. 64 00:06:48,070 --> 00:06:57,040 This is a reference plus this to reference, and the result will be 14. 65 00:07:00,680 --> 00:07:05,020 Let's subtraction for minus 10. 66 00:07:06,200 --> 00:07:08,570 The result will be minus six. 67 00:07:09,200 --> 00:07:13,970 Let's multiplication first the reference and. 68 00:07:16,240 --> 00:07:23,950 By the second reference and the result will be 40 division. 69 00:07:25,480 --> 00:07:41,410 Let's divide first a reference for Slash and the second reference point for and for the first cell reference 70 00:07:42,250 --> 00:07:44,530 and shift six. 71 00:07:45,570 --> 00:07:48,810 Power sign and the second cell reference. 72 00:07:49,740 --> 00:07:52,080 OK, this is huge, no. 73 00:07:53,170 --> 00:08:01,330 OK, OK, if you want to write the answer in the answer column, just press equals sign and reference 74 00:08:01,330 --> 00:08:06,610 to this cell or formula cell and use. 75 00:08:08,460 --> 00:08:09,090 Dreg. 76 00:08:11,810 --> 00:08:14,210 To repeat the formula. 77 00:08:15,600 --> 00:08:23,560 And now this is formula of addition, this is formula of subtraction, this is formula of multiplication. 78 00:08:23,880 --> 00:08:26,070 This is formula for division. 79 00:08:26,280 --> 00:08:28,620 And this is formula for power. 80 00:08:28,800 --> 00:08:29,930 OK, OK. 81 00:08:30,480 --> 00:08:33,330 What if I want to change these variables? 82 00:08:34,410 --> 00:08:38,040 Let's change X and see the results. 83 00:08:39,060 --> 00:08:44,880 If I want to change X by two and X will be six. 84 00:08:46,820 --> 00:08:56,180 So automatically all functions have been updated based on the entered formulas, if I want to change 85 00:08:56,180 --> 00:09:04,640 Y to be to automatically or the results have been updated based on the entered formula. 86 00:09:04,700 --> 00:09:09,940 And this is the bar of Microsoft Excel and this is the power of references. 87 00:09:10,430 --> 00:09:17,100 Once you change one reference or the reference is the final results will be updated. 88 00:09:17,540 --> 00:09:17,990 OK. 89 00:09:20,590 --> 00:09:28,810 Let's revise this lecture, we have discussed how to enter a value to excel, and this value can be 90 00:09:28,810 --> 00:09:38,350 thickest no or formula, and we have discussed the key difference between reference and consistent. 91 00:09:38,920 --> 00:09:46,720 And we have also discussed operator and we have answered this key concept of operations in Microsoft 92 00:09:46,720 --> 00:09:50,420 Excel and in and in programming in general. 93 00:09:50,650 --> 00:09:53,920 What is the difference between reference and constant? 94 00:09:55,730 --> 00:10:02,870 And we have discussed basic mathematical operators such as addition, subtraction, multiplication, 95 00:10:02,870 --> 00:10:04,370 division, exponent. 96 00:10:06,630 --> 00:10:13,990 Also, we have to take a simple example about these operations in the next lecture. 97 00:10:14,400 --> 00:10:24,750 We will discuss that sequence of these operations and how to write a combined operations and operators 98 00:10:24,930 --> 00:10:26,170 in Microsoft Excel. 99 00:10:26,490 --> 00:10:27,110 Thank you. 100 00:10:27,120 --> 00:10:28,300 If you have any questions. 101 00:10:28,590 --> 00:10:29,430 We are ready. 102 00:10:29,430 --> 00:10:30,430 Just contact us. 103 00:10:30,690 --> 00:10:31,190 Thank you. 104 00:10:31,200 --> 00:10:32,890 And see you in the next lecture. 105 00:10:33,010 --> 00:10:33,570 Goodbye.