Head First Excel > 7. Finding Functions: Mine Excel’s features on your own > Box tickets for you!

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Search

Table of Contents

Head First Excel

A Note Regarding Supplemental Files

Advance Praise for Head First Excel

Praise for other Head First books

Author of Head First Excel

How to Use This Book: Intro

1. Introduction to Formulas: Excel’s real power

2. Visual Design: Spreadsheets as art

3. References: Point in the right direction

4. Change your Point of View: Sort, zoom, and filter

5. Data Types: Make Excel value your values

6. Dates and Times: Stay on time

7. Finding Functions: Mine Excel’s features on your own

Should you rent additional parking?

You need a plan to find more functions

Excel’s help screens are loaded with tips and tricks

Here’s the convention center’s ticket database for the next month

Anatomy of a function reference

The Dataville Convention Center COO checks in...

Functions are organized by data type and discipline

Your spreadsheet shows ticket counts summarized for each date

Box tickets for you!

8. Formula Auditing: Visualize your formulas

9. Charts: Graph your data

10. What if Analysis: Alternate realities

11. Text Functions: Letters as data

12. Pivot Tables: Hardcore grouping

13. Booleans: TRUE and FALSE

14. Segmentation: Slice and dice

A. Leftovers: The Top Ten Things (we didn’t cover)

B. Install Excel’s Solver: The Solver

Index

About the Author

Box tickets for you!

Thanks to your diligent efforts, the convention center knows when it’s going to need to order more parking. You’ve saved the convention center money and made spectators happy. Now to enjoy your reward....

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial