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 29. Using Super Formulas in Excel

In this chapter

Using 3D Formulas to Spear Through Many Worksheets 824

Combining Multiple Formulas into One Formula 828

Calculating a Cell Reference in the Formula by Using the INDIRECT Function 830

Assigning a Formula to a Name 833

Replacing Multiple Formulas with One CSE Formula 838

Excel offers an amazing variety of formulas. This chapter covers some of the unorthodox formulas that you can build in Excel. In this chapter, you will learn about the following:

  • Using a formula to add the same cell across many sheets
  • Using a formula to reference the previous sheet
  • Editing multiple formulas into one
  • Assigning a formula to a name
  • Letting data determine the cell reference to use with the INDIRECT function ...

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