Table of Contents

1. Read Me First
   1. Updates and More
2. Introduction
3. Numbers Quick Start
4. Meet Numbers
   1. Buy Numbers and Stay Up to Date
   2. Understand the Terminology and Interface
   3. Customize Your Environment
5. Sheets and Templates
   1. Sheet-handling Basics
   2. Built-in and Custom Templates
6. Table Basics
   1. Anatomy of a Table
   2. Creating and Controlling Tables
   3. Naming a Table
   4. Pop-up and Contextual Table Menus
   5. Rows and Columns
7. Cell Basics
   1. Select Cells
   2. Move between Cells
   3. Merge and Unmerge Cells
8. Table Formats and Styles
   1. Table-wide Formats
   2. Table Styles
9. Cell Formats
   1. Basic Cell Formats
   2. Conditional Highlighting
10. Data Input
    1. Data Entry Basics
    2. Types of Data
    3. Text Wrap in Cells
    4. Autocomplete
    5. Autofill
    6. Copy and Paste
    7. Special Data-input Formats
11. Data Formats
    1. Standard Data Formats
    2. Custom Data Formats
12. Sorting Data
    1. Sorting Order
    2. Special Sorting Issues
    3. Instant Sort Gratification
    4. Sorting with the Inspector
    5. Special Solutions for Special Issues
13. Filtering Data
    1. Quick Filters
    2. Filtering with the Inspector
14. Fun with Formulas and Functions
    1. The Function Button and Quick Calc Bar
    2. Formula-building Basics
    3. The Formula Editor
    4. Functions and Arguments
    5. The Function Browser
15. IF Statements and Logical Operators
    1. What Is Truth?
    2. Comparison Operators
    3. IF Statements
    4. Logical Operators
    5. Putting It All Together
    6. Nested IF Statements
16. Text Functions
    1. Text Terminology
    2. Basic String Manipulations
    3. Other Common Text Tasks
17. More Functions
    1. Numeric Functions
    2. Statistical Functions
    3. Reference Functions
18. Creating Charts
    1. Chart Parts and Terminology
    2. Choosing the Right Chart
    3. Creating a Chart
    4. Editing a Chart
    5. 3D Charts
    6. Interactive Charts
19. Formatting Charts
    1. Selecting Chart Elements
    2. Formatting Panes and Tabs
    3. Tweaking Text Elements
20. Adding Comments
    1. Set Comment Options
    2. Create Comments
    3. View and Edit Comments
21. Getting in Shapes
    1. Add and Edit Shapes
    2. All about Arrows
22. Tackling Text
    1. Text vs. Container
    2. Text Pane
    3. Text in Shapes and Text Boxes
    4. Bullets and Lists
    5. Paragraph and Character Styles
23. Manipulating Objects
    1. Ruler and Guide Preferences
    2. Select and Move Objects
    3. Work on the Sheet
    4. Work in the Arrange Pane
24. Color Controls
    1. Color Well
    2. Colors Window
    3. Gradient Fills
    4. Custom Fills
25. Importing, Exporting, and Sharing Files
    1. Exchange Files with Excel
    2. Import and Export Text Files
    3. Share with iCloud
26. Printing Spreadsheets
    1. The Print Process
    2. Handling Headers and Footers
27. Numbers Tutorial
    1. Table Terminology
    2. The Tutorial
28. About This Book
    1. Ebook Extras
    2. About the Author
    3. Acknowledgments
    4. About the Publisher
29. Copyright and Fine Print

Guide

1. Begin Reading