1 00:00:00,04 --> 00:00:02,02 - [Instructor] You can create your own formulas 2 00:00:02,02 --> 00:00:04,05 to perform Excel calculations. 3 00:00:04,05 --> 00:00:07,05 You can also use a built-in Excel function. 4 00:00:07,05 --> 00:00:09,05 To get started creating formulas, 5 00:00:09,05 --> 00:00:11,04 place your cursor inside the cell 6 00:00:11,04 --> 00:00:14,00 and you always start with an equal sign. 7 00:00:14,00 --> 00:00:16,09 This tells Excel that you're building a formula. 8 00:00:16,09 --> 00:00:18,03 You can reference a different cell 9 00:00:18,03 --> 00:00:21,00 by either clicking on it with your mouse. 10 00:00:21,00 --> 00:00:23,00 Here you can see that it's highlighted 11 00:00:23,00 --> 00:00:25,05 and cell A3 is listed in blue 12 00:00:25,05 --> 00:00:28,09 because it's going to be calculated programmatically. 13 00:00:28,09 --> 00:00:31,00 Now, I can always type my equal sign 14 00:00:31,00 --> 00:00:33,07 and just put in the value of the cell itself. 15 00:00:33,07 --> 00:00:37,00 For example, A3. 16 00:00:37,00 --> 00:00:39,04 Excel will automatically highlight it, 17 00:00:39,04 --> 00:00:41,06 which is a great visual cue for me to know 18 00:00:41,06 --> 00:00:43,09 that I've got the right cell. 19 00:00:43,09 --> 00:00:45,03 I can hit the Enter key, 20 00:00:45,03 --> 00:00:47,06 and there's my calculation. 21 00:00:47,06 --> 00:00:51,04 It doesn't matter if it's a number or if it's text. 22 00:00:51,04 --> 00:00:57,02 For example, I'll put in my word Apples, 23 00:00:57,02 --> 00:01:03,00 and now I'll ask for the value of cell B1. 24 00:01:03,00 --> 00:01:04,06 It even knows it's text. 25 00:01:04,06 --> 00:01:06,09 Remember, it's left aligned like text, 26 00:01:06,09 --> 00:01:09,04 whereas before it was right aligned. 27 00:01:09,04 --> 00:01:12,02 We can also do calculations. 28 00:01:12,02 --> 00:01:13,08 I'll put in my equal sign, 29 00:01:13,08 --> 00:01:18,00 and now I'm looking for cell A1 30 00:01:18,00 --> 00:01:20,08 minus cell A2. 31 00:01:20,08 --> 00:01:22,08 I'll hit the Enter key, 32 00:01:22,08 --> 00:01:25,04 and there's my value. 33 00:01:25,04 --> 00:01:28,09 And I can also use a built-in Excel function. 34 00:01:28,09 --> 00:01:30,03 Now this one's a little different 35 00:01:30,03 --> 00:01:32,03 because I need the name of the function, 36 00:01:32,03 --> 00:01:33,06 and then what's inside of it 37 00:01:33,06 --> 00:01:37,00 is always between an open and close parentheses. 38 00:01:37,00 --> 00:01:38,08 We still start with an equal sign. 39 00:01:38,08 --> 00:01:40,01 We always start with that, 40 00:01:40,01 --> 00:01:42,07 even if we're using an Excel function, 41 00:01:42,07 --> 00:01:46,04 and now I'm going to use the function SUM, 42 00:01:46,04 --> 00:01:47,08 so I'll type that in 43 00:01:47,08 --> 00:01:50,05 and as soon as I put in my open parentheses, 44 00:01:50,05 --> 00:01:53,09 Excel is going to open up some helper text. 45 00:01:53,09 --> 00:01:57,03 It's telling me what parameters that function needs. 46 00:01:57,03 --> 00:01:59,01 For example, I can see here 47 00:01:59,01 --> 00:02:02,02 that it needs all the numbers separated by commas, 48 00:02:02,02 --> 00:02:06,06 and it's asking for that first number because it's in bold. 49 00:02:06,06 --> 00:02:08,08 What I'm going to do is click and drag 50 00:02:08,08 --> 00:02:12,09 to select all the numbers that I want to calculate. 51 00:02:12,09 --> 00:02:15,00 That's one way that I could do it. 52 00:02:15,00 --> 00:02:17,02 I'll put in my closed parentheses, 53 00:02:17,02 --> 00:02:18,09 and the colon in between 54 00:02:18,09 --> 00:02:22,08 means that it's doing a block or a range of numbers, 55 00:02:22,08 --> 00:02:25,05 Cell A1 through A5. 56 00:02:25,05 --> 00:02:27,03 I'll hit the Enter key, 57 00:02:27,03 --> 00:02:28,09 and there's my sum. 58 00:02:28,09 --> 00:02:36,00 If I wanted to do an entire column, 59 00:02:36,00 --> 00:02:38,01 I could just click column A, 60 00:02:38,01 --> 00:02:39,05 I'll click the whole heading. 61 00:02:39,05 --> 00:02:41,09 And this one also looks a little bit different, 62 00:02:41,09 --> 00:02:43,00 as you can see. 63 00:02:43,00 --> 00:02:45,08 There's an A with a colon and another A, 64 00:02:45,08 --> 00:02:49,02 that means the entire column. 65 00:02:49,02 --> 00:02:51,05 I'll close my parentheses, hit Enter, 66 00:02:51,05 --> 00:02:53,08 and there's the value. 67 00:02:53,08 --> 00:03:02,06 And I could always just put in different numbers. 68 00:03:02,06 --> 00:03:08,02 For example, I can just SUM cell A1 and A2. 69 00:03:08,02 --> 00:03:10,03 And in fact, if I wanted to, 70 00:03:10,03 --> 00:03:12,09 I could even add a plus one to that. 71 00:03:12,09 --> 00:03:14,06 As you can see, by the helper text, 72 00:03:14,06 --> 00:03:15,09 you can keep going 73 00:03:15,09 --> 00:03:19,04 as long as those numbers are separated by commas. 74 00:03:19,04 --> 00:03:21,04 As far as the values of the cells, 75 00:03:21,04 --> 00:03:23,00 I don't need to know what they are, 76 00:03:23,00 --> 00:03:25,02 I only need to know where they are. 77 00:03:25,02 --> 00:03:28,06 So I'll close my parentheses, hit Enter, 78 00:03:28,06 --> 00:03:30,07 and there's my sum. 79 00:03:30,07 --> 00:03:33,05 If we head over to the Formulas tab, 80 00:03:33,05 --> 00:03:36,06 here's Excel's built-in function library. 81 00:03:36,06 --> 00:03:39,08 For example, we can look at all these text functions. 82 00:03:39,08 --> 00:03:42,00 We don't need to do functions on just numbers, 83 00:03:42,00 --> 00:03:45,04 we can absolutely do them based on text strings. 84 00:03:45,04 --> 00:03:47,07 If I hover my mouse over a certain function, 85 00:03:47,07 --> 00:03:50,02 it's going to tell me what it does. 86 00:03:50,02 --> 00:03:52,00 I can do calculations on dates, 87 00:03:52,00 --> 00:03:55,03 time, money, currency, everything. 88 00:03:55,03 --> 00:03:57,09 There's an extensive library. 89 00:03:57,09 --> 00:03:59,03 The most commonly used ones, 90 00:03:59,03 --> 00:04:02,08 however, are over here on the right side in the Home tab, 91 00:04:02,08 --> 00:04:05,00 and I'm going to be going over those next.