7
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 ...
Get How to Do Everything: Microsoft Office Online 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.
