Chapter 6: Building Formulas

Are you ready to start creating powerful and useful worksheets by building your own formulas? This chapter explains formulas, shows you how to build them, and shows you how to incorporate the versatile worksheet functions in Excel into your formulas. You also learn useful formula techniques such as how to sum a row or column of numbers, how to create quick formulas using the AutoSum feature, how to use range names and ranges from other workbooks in your formulas, and how to move and copy formulas.

9781118517260-co0601.tif

Understanding Excel Formulas

Build a Formula

Understanding Excel Functions

Add a Function to a Formula

Add a Row ...

Get Excel 2013 Simplified now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.