Скачать или смотреть Excel Basics #3: Formulas w Cell References

Download file: https://excelisfun.net/files/ExcelBas...
Download file: https://people.highline.edu/mgirvin/Y...
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#3 Video topics:
1)Formulas
2)Equal sign =
3)Ampersand &
4)Formulas with Mouse
5)Formulas with Arrow Keys
6)Formulas with cell references
7)Relative Cell References
8)Change input numbers in cells and see resulting formulas update instantly (Bricklin and Frankston VisiCalc)
9)Copy formulas
10)Calculating number result formulas
11)Text formulas
12)Fill handle (Angry Rabbit) and quick formula copy
13)Join cell content and text (using quotes) in text formula using the ampersand &