Take Control of Numbers
Take Control of Numbers


This book is no longer available for sale.

Take Control of Numbers

Last updated on 2017-03-07

About the Book

Apple’s Numbers has become a grown-up spreadsheet (and it’s free on every Mac sold since October 2013!), but many of us still haven’t learned even the basics, much less been able to take advantage of its surprisingly deep collection of features.

With the advice in this 330-page ebook, you’ll learn to input, calculate, sort, filter, format, and chart your data with ease, as author Sharon Zardetto guides you through the basics all the way to power-user features like conditional highlighting, custom data formats, and star ratings. Richly illustrated with hundreds of annotated screenshots, the ebook also includes a hands-on example spreadsheet you can use to try what you’re learning, plus a special tutorial chapter that helps you put it all together. Of course, you can also treat the book as a reference, using the Quick Start to focus on a topic of interest.

The book covers Numbers 3.5, which works on any Mac running OS X 10.10 Yosemite.

You’ll learn how to...

Handle the basics:

  • Input data into a table.
  • Choose the best chart type for your data.
  • Add, modify, and position shapes, such as arrows, comments, and text boxes.
  • Import/export from Excel, text, CSV, and older versions of Numbers.
  • Set up page numbers and other header/footer information for printing.

See what you want to see:

  • Know what to expect when you sort by column.
  • Hide and show columns.
  • Merge and unmerge cells.
  • Create rules that filter data to display only specific rows.
  • Set up and view interactive charts.

Make formulas:

  • Work fluidly in the formula editor to create formulas.
  • Make formulas from the tear-off tokens on the Quick Calc bar.
  • Nimbly use various types of cell references in formulas.
  • Understand how to use IF, TRUE, and FALSE in formulas.
  • Take charge of logical operators (AND, OR, NOT) in formulas.
  • Concatenate and break apart text.
  • Strip extra spaces out of data.
  • Find medians, modes, ranks, percentiles, and more.

Create clever formulas that can:

  • Calculate a sales discount based on whether a total is over or under a certain amount.
  • Sort seemingly unsortable data, such as items described as Poor, Good, or Excellent.
  • Take a column of cells, with each cell containing a full name, and move all the last names into a different column.

Apply formatting:

  • Add and remove grid lines and cell borders.
  • Work with a cell’s background fill.
  • Format a chart so it looks fabulous.
  • Set up conditional highlighting that appears only when data meets certain criteria.
  • Ensure accurate data entry with cell formats like sliders, menus, and checkboxes.
  • Use and create templates.
  • Format faster with character, paragraph, list, shape, and table styles.

About the Author

Table of Contents

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

About the Publisher

This book is published on Leanpub by Take Control Books

With its Take Control series of ebooks, alt concepts inc. covers a wide range of technology topics, with a special emphasis on Apple products and services. Our catalog comprises over 100 titles, and we’ve sold hundreds of thousands of ebooks in the process of providing expert advice and technical know-how to tens of thousands of readers around the world. Join us today!

The Leanpub 45-day 100% Happiness Guarantee

Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

See full terms...

Write and Publish on Leanpub

Authors, publishers and universities use Leanpub to publish amazing in-progress and completed books and courses, just like this one. You can use Leanpub to write, publish and sell your book or course as well! Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks. Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. It really is that easy.

Learn more about writing on Leanpub