Sharon Zardetto - Take Control of Numbers, 3rd Edition

Sharon Zardetto

Welcome to Take Control of Numbers, Third Edition, version 3.0, published in September 2021 by alt concepts inc. This book was written by Sharon Zardetto and edited by Michael E. Cohen.

Want to get more out of Apples Numbers app? This books for you! Youll learn everything from the basic interface to the construction of intricate formulas; how to shuffle data around, and sort and filter it simply or with complex rules; and how to create tables and charts.

If you want to share this ebook with a friend, we ask that you do so as you would with a physical book: lend it for a quick look, but ask your friend to buy a copy for careful reading or reference. Discounted classroom and Mac user group copies are available.

Copyright 2021, Sharon Zardetto. All rights reserved.

You can access extras related to this ebook on the web (use the link in , near the endits available to only purchasers). On the ebooks Take Control Extras page, you can:

• Download any available new version of the ebook for free, or buy any subsequent edition at a discount.

• Download various formats, including PDF, EPUB, and Mobipocket. (Learn about reading on mobile devices on our Device Advice page.)

If you bought this ebook from the Take Control website, it has been added to your account, where you can download it in other formats and access any future updates. However, if you bought this ebook elsewhere, you can add it to your account manually (see .

Sometimes its difficult to keep up with Apples app updates. Within days of the original release of the second edition of this book, for instance, Numbers jumped from version 4.3 to 5.0, which we were able to accommodate with a swift update.Then there were minor Numbers updates for stability and performance improvements, tweaks to existing features, and the addition of minor but convenient features. Numbers 5.3 presented some changes and soon begat Numbers 6.0. Then, suddenly, version 10.x appeared, with quite a few changesalthough not quite worthy of such a version-number jump. It was however, worthy of a new edition of this bookand while I was working on it, Numbers was updated again, so youre reading Take Control of Numbers, Third Edition, which was written for Numbers 11.x.

The major additions to this book since the last version are:

• How to on nearly everything.

• An exploration of the color well used for assigning colors to almost anything in Numbers; it includes how to make pastel shades and add your own colors to its popover ().

• Coverage of the new, easier and yet more powerful table-sorting options ().

These are a few of the smaller helpful additions:

• Meet the new and improved version of .

• Add a color to your background when you

• Make a handy floating palette of the options in the Format inspectors Arrange section: see the end of .

• Learn how to

Let me ask you some questions:

• Are you new to spreadsheet applications?

• Are you new to Numbers, or to its latest version (11.1 as I write this)?

• Have you had time to only skim the surface of Numbers and want to be more proficient?

• Are your formula-building skills pretty much limited to SUM and AVERAGE but you want more from your data?

• Do you want to alleviate the black-and-white tedium of most spreadsheets by using color for table lines, cell backgrounds, cell contentsand more?

• Would you like to create templates for tables you design so you dont have to start from scratch every time?

• Would you like table cells to recognize the type of data youve entered and automatically format it so that, for instance, you can type 123 and get $1.23?

• Do you want to transform your data into expressive charts?

At the risk of sounding like an infomercial: If you answered yes to any of these questions, this book is for you. If you have other questions, this book is for you. If you dont even know what questions to ask, this book is for you.