O'Reilly logo

How to Do Everything: Microsoft Office Online by Marty Matthews, Carole Matthews

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

7

Image

Using Formulas, Functions, and Tables and Organizing Data

HOW TO…

  Reference cells

  Work with formulas

  Use functions

  Work with tables

  Organize data with worksheets

Excel enables you to perform powerful calculations easily using formulas and functions. Formulas are mathematical statements that follow a set of rules and use a specific syntax. In this chapter you will learn how to reference and locate cells used in formulas, and how to build and work with formulas. Functions—readymade formulas that you can use to get quick results for specific applications, such as figuring out loan payments—are also covered. Tables, though available ...

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