10. Building a Worksheet with Excel
What You’ll Do
Understand Formulas and Referencing
Simplify a Formula with Ranges
Create Functions and Nested Functions
Use Lookup and Reference Functions
Summarize Data using Subtotals and Functions
Create Calculations in a Table
Display Parts of a Table with AutoFilter
Add Data Validation to a Worksheet
Introduction
Once you enter data in a worksheet, you’ll want to add formulas to perform calculations. Microsoft ...
Get Microsoft® Office 2007 On Demand 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.