O'Reilly logo

Using Microsoft® Excel® 2010 by Bill Jelen, Tracy Syrstad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

5. Using Formulas

This chapter will teach you about entering and 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 introduces you to formula basics that you can later apply to Chapter 6, “Using Functions.”

The Importance of Laying Data Out Properly

Except for when using certain functions, such as VLOOKUP, Excel doesn’t really care how you lay out your data. For example, you can lay out your data as shown in Figure 5.1, with dates across the top. But if you later decide you want to use a pivot table or certain functions, your options ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required