Скачать или смотреть Slaying Excel Dragons Book #11: Comprehensive Excel Formula Creation Guide (Formula Types, Elements)

Download files: https://people.highline.edu/mgirvin/E...
Learn Excel from beginning to end. Complete Lessons about Excel.
This video series accompanies the published book, Slaying Excel Dragons, ISBN 9781615470006
Chapter 5: Formulas & Functions -- Pages 119 - 143
Topics:
1) How To Create Formulas
2) 5 types of formulas:
1. Calculating formulas that calculate a number answer (like adding)
2. Lookup formulas that look up an item in a table (like looking up a tax rate or customer phone number).
3. Text formulas that deliver a word to a cell or create labels for reports (like an income statement label).
4. Logical formulas that give you a logical value, either TRUE or FALSE (like formulas that say whether two accounts are in balance)
5. Array formulas are advanced formulas that act on arrays (ranges) instead of individual cell references.
3) 9 Formula Elements (sorts of things that we put into formulas):
1. Equal sign (starts all formulas)
2. Cell references (also defined names, sheet references, workbook references)
3. Math operators (plus, subtract, multiply, and so on)
4. Numbers (if the number will not change; for example, 12 months, 24 hours)
5. Built-in functions (AVERAGE, SUM, COUNTIF, DOLLAR, PMT, and so forth)
6. Comparative operators (equal, greater than, greater than or equal to, less than, less than or equal to, Not)
7. The ampersand join symbol (&) (Shift + 7)
8. Text within quotation marks (for example, "For the Month Ended")
9. Array constants (for example, {1,2,3})

Excel. Excel Basics. Excel intermediate. Excel How To. Learn Excel. Excel 2010.