O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel Jelen

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

Chapter 20. Understanding Formulas

In this chapter

Getting the Most from This Chapter 386

Introduction to Formulas 387

Entering Your First Formula 388

Three Methods of Entering Formulas 395

Entering the Same Formula in Many Cells 398

Copying a Formula by Using the Table Tool 402

Excel’s forte is performing calculations. When you use Excel, you typically use a combination of cells with numbers and cells with formulas. After you design a spreadsheet to calculate something, you can easily change the numbers used in the assumption cells and then watch Excel instantly calculate new results.

Getting the Most from This Chapter

Don’t skip this entire chapter, because one particular trick in this chapter will save you daily frustration.

I regularly entertain ...

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