17. Using Super Formulas in Excel

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 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

• 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) formula

• Using one formula to return a whole range of answers

• Doing conditional ...

Get Microsoft Excel 2010 In Depth now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.