## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

# Chapter 13. Building Formulas

 Formula Fundamentals Using Functions: A Preview Working with Formulas Worksheet Calculation Using Arrays Linking Workbooks Creating Conditional Tests

Formulas are the heart and soul of a spreadsheet, and Microsoft Office Excel 2007 offers a rich environment in which to build complex formulas. Armed with a few mathematical operators and rules for cell entry, you can turn a worksheet into a powerful calculator. In this chapter, we’ll cover the basics, and then we’ll look closer at using functions, defining names, building structured references, working with arrays, creating linking formulas, and constructing conditional tests.

# Formula Fundamentals

All formulas in Excel begin with an equal sign. The equal sign tells Excel that ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required