ebooks and download videos Search All  Title  Author 
Home / Nonfiction / Computers / Spreadsheets

Take Control of Numbers

| £16.66 | €18.74 | Ca$27.04 | Au$26.68
by Sharon Zardetto
What is this?DRM-EPUB | by download   add to wish list
Take Control of Numbers by Sharon Zardetto

Get serious with Numbers, Apple's powerful spreadsheet for the Mac!

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.

To view this DRM protected ebook on your desktop or laptop you will need to have Adobe Digital Editions installed. It is a free software. We also strongly recommend that you sign up for an AdobeID at the Adobe website. For more details please see FAQ 1&2. To view this ebook on an iPhone, iPad or Android mobile device you will need the Adobe Digital Editions app, or BlueFire Reader or Txtr app. These are free, too. For more details see this article.

SHARE  Share by Email  Share on Facebook  Share on Twitter  Share on Linked In  Share on Delicious
or call in the US toll free 1-888-866-9150 product ID: 703345

Ebook Details
Pages: 330
Size: 5.0 MB
Publisher: TidBITS Publishing, Inc.
Date published:   2015
ISBN: 9781457191046 (DRM-EPUB)

DRM Settings
Copying:not allowed
Printing:not allowed
Read Aloud:  not allowed

This product is listed in the following categories:

Nonfiction > Computers
Nonfiction > Computers > Reference
Nonfiction > Computers > Spreadsheets

This author has products in the following categories:

Nonfiction > Computers > Operating Systems > Macintosh
Nonfiction > Computers > Internet > Browsers
Nonfiction > Computers
Nonfiction > Computers > Reference
Nonfiction > Computers > Spreadsheets

If you find anything wrong with this product listing, perhaps the description is wrong, the author is incorrect, or it is listed in the wrong category, then please contact us. We will promptly address your feedback.

Submit 5 page SummaryWhat is this?

© 2016