O'Reilly logo

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

Take Control of Numbers, 2nd Edition

Book Description

Work quickly, confidently, and effectively in Apple's Numbers app!

There are many benefits to using Apple's Numbers app, chief among them that it is now free for all Mac users! If you've ever wanted to add to your knowledge of Numbers--whether you're new to spreadsheet programs in general, new to Numbers, or simply new to this latest version of Numbers--this book gives you detailed information about how to get the most out of this powerful app.

Following the advice of author Sharon Zardetto, you'll learn how to input, calculate, sort, filter, format, and chart your data with ease. Taking you from the basics, all the way through complex formulas, charting, and other power-user features, this book will expand your understanding of what Numbers can do.

This book will show you how to:

  • Get started with Numbers: Learn about Numbers' terminology and interface, sheets and templates, table basics, and cell basics. For those new to spreadsheets, learn about the anatomy of a table and data entry basics. For those new to Numbers, but comfortable with spreadsheets, learn about working with sheets and tabs, the template chooser, and pop-up and contextual table menus.
  • Work more efficiently: Customize your environment, utilize built-in and custom templates, speed up your work with autocomplete, autofill, and text substitution, make custom templates, use table styles, paragraph styles, and define a default text box.
  • Use formulas and functions: Find out about formula-building basics, cell references, and functions and arguments. Explore the formula editor and the Function Browser, and use quick calculation tokens.
  • Polish your formatting: Explore your formatting options, standardize the look of components in tables and sheets with styles, use rulers and ruler guides, add graphical elements (shapes and text boxes), and use color controls for everything from text to cell borders to shapes.
  • Visualize data with charts: Learn the basics of chart parts and terminology, how to choose the right chart, how to create a chart, and how to work with 3D charts and interactive charts.
  • Work with other people: Share, collaborate, and add comments to your work with other Numbers users. Find out how to import, export, and share files when others are not using Numbers.

Table of Contents

  1. Read Me First
    1. Updates and More
    2. What’s New in Version 2.1
    3. What Was New in the Second Edition
  2. Introduction
  3. Numbers Quick Start
  4. About Numbers
    1. Get Numbers and Stay Up to Date
    2. Learn Terminology and the Interface
    3. Customize Your Environment
  5. Work with Sheets and Templates
    1. Manage Sheets and Tabs
    2. Use Built-in and Custom Templates
  6. Review Table Basics
    1. Anatomy of a Table
    2. Create and Control Tables
    3. Use Pop-Up and Contextual Table Menus
    4. Name a Table
    5. Manipulate Rows and Columns
  7. Master Cell Basics
    1. Select Cells
    2. Move Between Cells
    3. Move Within a Block of Cells
    4. Move a Cell or Its Data
    5. Merge and Unmerge Cells
  8. Use Table Formats and Styles
    1. Apply Table Formats
    2. Use Table Styles
  9. Learn About Cell Formats
    1. Apply Basic Cell Formats
    2. Create Conditional Highlighting
  10. Control Data Input
    1. Learn Data Entry Basics
    2. Understand Automatic Data Formats
    3. Use Text Wrap in Cells
    4. Speed Data Entry with Autocomplete
    5. Speed Data Entry with Autofill
    6. Explore Copy and Paste Options
  11. Learn About Data Formats
    1. Review Standard Data Formats
    2. Create Custom Data Formats
  12. Use Special Data‑Input Options
    1. Create Checkboxes
    2. Set Up Star Ratings
    3. Define Sliders and Steppers
    4. Build Pop-Up Menus
  13. Sort Data
    1. Understand Sorting Order
    2. Sort with Column Menus
    3. Sort with the Inspector
    4. Master Unsorting and Unsortables
    5. Deal with Special Sorting Issues
  14. Filter Data
    1. Use Quick Filters
    2. Filter with the Inspector
  15. Handle Formulas and Functions
    1. Save Time with Quick Calculations
    2. Learn Formula-Building Basics
    3. Work in the Formula Editor
    4. Understand Functions and Arguments
    5. Explore the Function Browser
  16. Master IF Statements and Logical Operators
    1. What Is Truth?
    2. Review Comparison Operators
    3. Construct IF Statements
    4. Learn About Logical Operators
    5. Put It All Together
    6. Construct Nested IF Statements
  17. Work with Text Functions
    1. Know Your Text Terminology
    2. Learn Basic String Manipulations
    3. Master Other Common Text Tasks
  18. Create Charts
    1. Learn Chart Parts and Terminology
    2. Choose the Right Chart
    3. Create a Chart
    4. Edit Chart Data
    5. Design 3D Charts
    6. Make Interactive Charts
  19. Format Charts
    1. Select Chart Elements
    2. Explore the Formatting Tabs
    3. Tweak Text Elements
  20. Add Comments
    1. Set Comment Options
    2. Handle Comments and Replies
  21. Work with Shapes and Images
    1. “Draw” Shapes
    2. Create Image Galleries
  22. Tackle Text
    1. What’s a Text Container?
    2. Tour the Text Tab
    3. Put Text in Shapes and Text Boxes
    4. Create Bullet and Ordered Lists
    5. Type in Shorthand with Text Substitution
    6. Use Paragraph and Character Styles
    7. Search for Text
    8. Search for and Replace Fonts
  23. Manipulate Objects
    1. Set Ruler and Guide Preferences
    2. Select and Move Objects
    3. Work on the Sheet
    4. Work in the Arrange Tab
  24. Conquer Color Controls
    1. Meet the Color Well
    2. Create Colors in the Colors Window
    3. Design Gradient Fills
    4. Customize Color Palettes
  25. Import, Export, and Share Files
    1. Exchange Files with Excel
    2. Convert Delimited Files
    3. Share and Collaborate
  26. Print Spreadsheets
    1. Print Your Sheets
    2. Hone Headers and Footers
  27. About This Book
    1. Ebook Extras
    2. About the Author
    3. Acknowledgments
    4. About the Publisher
    5. Credits
    6. Copyright and Fine Print