Office 2013 Class #31: Excel Basics 13: Examples of Excel Formulas & Formula Elements

This video teaches about Formulas:
1. Formulas = Calculations we can make in the cells and other locations. (00:13 min)
2. All formulas start with an equal sign as the first character in the cell (00:13 min)
3. Formulas elements (things that can go into formulas): (00:13 min)
i. Equal signs
ii. Cell References
iii. Math operators
iv. Comparative operators
v. Numbers (if the number won't change like 12 for months in a year)
vi. Built-in functions (like SUM, SUMIFS, AVERAGE, SUMIF)
vii. Comparative operators
viii. Join Symbol: & (Ampersand)
ix. Text in double quotes (like "Revenue" or ", ")
Examples:
1. Adding a column of expenses (01:38 min)
2. Adding with one condition with SUMIFS function (01:59 min)
3. Adding with one condition with SUMIF function when the sum range and criteria range are the same. Criteria in cell (03:21 min)
Adding with one condition with SUMIF function when the sum range and criteria range are the same. Criteria typed into formula (05:20 min)
4. Joining a first and last name (Two Examples): Called a Text Formula. (06:04 min)
5. Checking whether two numbers are in balance: Called a Logical Formula. (09:53 min)

Highline Community College Busn 216 Computer Applications Class Office 2013 (Fun With Computers) taught by Michael Girvin. Excel Basics. Learn Excel, How To Excel.

[qilong]

all these videos about Excel are very useful, thank you So much!

[faizaashfaq]

Excellent video again. Just to update other viewers there is an option of =CONCATENATE() to join the first and last name.

[yanyuncheng]

Thank you very much. Your videos improved my Excel knowledge a lot and a lot. Thank you :)