|
|
Featured Tutorial
Featured Macro
Excel Basics #3: Formulas w Cell References
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 &
#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 &