August 2013
Beginner
704 pages
18h 22m
English
In This Chapter
• Entering a Formula into a Cell
• Copying a Formula to Another Cell
• Troubleshooting Formulas
Excel is great for simple data entry, but its real strength is its capability to perform calculations. After you design a sheet to perform calculations, you can easily change the data and watch Excel instantly recalculate.
This chapter not only shows you how to enter a formula, but also teaches you fundamental basics, such as the difference between absolute and relative referencing, which is important when you want to copy a formula to multiple cells, and how to use a Name to refer to a cell instead of having to memorize a cell address. You’ll take the formula basics you learn here and apply them later in Chapter ...