O'Reilly logo

Excel® 2013 In Depth by Bill 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

17. Using Super Formulas in Excel

Excel offers an amazing variety of formulas. This chapter covers some of the unorthodox formulas you can build in Excel. In this chapter, you discover 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

• Using a dynamic range with an offset

• Transposing relative column references to rows

• Using ROW() or COLUMN() to return an array of numbers

• Replacing thousands of formulas with one Ctrl+Shift+Enter (CSE) array formula

• Using one formula to return a whole range of answers

• Doing conditional ...

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