Excel Forum
Similar Content
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Absolute and Relative Cell References in Excel
Tutorial: In this tutorial I am going to cover the difference between Absolute and Relative Cell Ref...
Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc.
Tutorial: In Excel you can store values in Defined Names.  Often people use a Defined Name to refer...



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 &





Got a Question? Ask it Here in the Forum.