Save 33% and learn more about iWork when you purchase with Take Control of Pages for only $20!
- PDF EPUB Mobi
- Mar 21, 2018
Note: On March 27, 2018, less than a week after this version of the book was published, Apple released Numbers 5 for Mac, with new features and a revised interface. We didn’t know about this release in advance, so the book doesn’t cover that version of Pages, but Sharon is working on an update to the book to bring it up to date with Numbers 5. We hope to release the revised book in April 2018.
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.
- What's New
Most of the changes from Numbers 3.5, which the first edition of this book covered, to the current version, 4.3.1, are incremental rather than major, but there are many of them. Some of these items are new to this book rather than to Numbers:
Numbers for the Mac, like the rest of Apple’s productivity suite for the Mac (which includes Pages and Keynote) is now FREE.
What used to the Quick Calc Bar at the bottom of the window is now the Smart Cell View.
The formula editor has been updated with a slightly sleeker look, and a new topic has been added to the book on how to make formulas more readable.
You can now transpose rows and columns with a simple command.
Numbers now includes the same kind of autocorrection capability available in macOS.
There’s a new section in the Importing, Exporting and Sharing Files chapter of the book about sharing and collaborating.
Numbers’ comments feature has been beefed up with threaded-conversation capability.
There are added special tips for Touch Bar users in this version of the book.
All the preexisting figures in this book have been updated to higher-res versions.
Many other smaller changes throughout the book, including tips on pie charts, pasting a single item from the clipboard in multiple, non-contiguous, cells with a single command, and details about new shapes in Numbers.
What versions and platforms does this book cover?
This book is about Numbers 4 on a Mac running High Sierra (macOS 10.13.x). It does not specifically covers Numbers in iCloud or on iOS devices. Almost all the information in the book, however, is directly applicable to Numbers for iCloud, and the fundamentals (including how to construct formulas, which charts to use for what kind of data, and filtering and sorting data) apply to the iOS version as well.
- Update Plans
March 29, 2018—Earlier this week (and much to our surprise), Apple released Numbers 5. We’re in the process of updating the book to cover the new version, and we tentatively expect it to be available before the end of April. Everyone who purchased the second edition of the book will get the update for free.
Posted by Joe Kissell
Longtime Excel users have another reason to need it: some multi-worksheet files are so complexly intertwined that the automatic recalculation of connected formulas every time you enter new data can slow things down. So, they turn off the automatic calculation feature and trigger it when they want the sheet refreshed.
But, back to Numbers. It’s unlikely your spreadsheets will be so complex that recalculation will slow things down; and, in any case, there’s no way to turn off the automatic recalculation that occurs when you enter data. But you can’t specifically trigger a recalc of cells, so those containing random numbers (from the RAND or RANDBETWEEN function) are quite static. Whether you’ve set up a bunch of random-number cells to test what will happen when real data is entered, or intend to keep the random-number formula in place to interact with data you input later, it’s important to test the results of various possibilities in your random range.
Why? What would happen if, coincidentally, all the randomly generated numbers are even, or there’s nothing under 10 or over 99, or perhaps there are no multiples of 5, and you’ve set up something where an odd number, a low or high number, or a multiple of 5 will result in flawed output? (Even if “flawed output” is nothing more than a column that’s not wide enough to display three digits.) You won’t realize there’s a problem because the random numbers are static until something else you enter forces a recalculation.
The solution I proposed in the book was to go to any cell adjacent a block of cells that include RAND or RANDBETWEEN cells and use Command-X to force Numbers to recalculate the entire table, resulting in newly generated random numbers. If there was nothing in the cell, nothing gets cut, and if there was, you can paste it right back.
Well, as of Numbers 3.6.1—and perhaps before, because this was only recently brought to my attention—this no longer works. Command-V in any cell works, but that runs the risk of accidentally pasting something that could overwrite nearby cells and really make a mess of your table. So, let me recommend the trick that everybody in the know has used all along for recalculating Numbers spreadsheets; I had ignored it because it requires using a cell specifically for the recalc trigger.
Simply format any cell to hold a checkbox: select the cell and go to the Format Inspector’s Cell tab, and then choose Checkbox from the Data Format menu. When you check or uncheck the checkbox, every formula in the document—in every cell of every table on every sheet—will be recalculated. The fact that the recalc is global in the document, really takes care of my objection to setting aside a cell in one of your tables for this purpose. You could, of course, stick it in the usually unused cell A1 where it’s easy to get at, and you could easily just delete it and set it up again if you don’t need it in the interim. But since the recalc works globally, you don’t have to keep the checkbox in any of your working tables. Make a table specifically for the checkbox—it can even be alone on its own tab. And, you can delete all but its first row and first column, making it a single-cell table (yes, an amoeba table!) and duplicate it on every tab for convenience.
Posted by Joe Kissell (Permalink)
Sharon Zardetto and Chuck Joiner discuss Sharon’s exhaustive, but far-from-exhausting, book about Apple’s Numbers. Don’t think spreadsheets can be fun? Sharon thinks different. Find out why on this episode of MacVoices.
Posted by Joe Kissell (Permalink)
Apple has posted a support document, Size limits of iWork for iCloud beta documents. Among other interesting facts provided by the document are these: the iWork for iCloud beta can share a document with as many as 100 users at a time, an iWork document can be as large as 1 GB (though a few such documents can use up your iCloud storage allocation quickly), and each image in a document (JPEG, PNG, or GIF) can be as large as 10 MB (except in IE 9 on Windows, where the limit is 5 MB). Also, in Numbers you can create as many sheets as you like, and change as many as 100,000 table cells at one time. Furthermore, tables can have as many as 255 columns, 65,536 rows, and 130,000 data-containing cells.
Posted by Joe Kissell (Permalink)
Although this ebook covers many features, it doesn’t discuss scripting with Apple’s Automator and AppleScript tools to automate repetitive tasks that would be better carried out by a script than by you. To learn more about what’s possible and get started, check out the iWork & Automation portion of the Mac OS X Automation Web site.
If you’ve never thought about creating automation on a computer before, Automator or AppleScript may be a little much to jump into, though there are helpful introductory materials on the site. For even more help, check out Take Control of Automating Your Mac, by Joe Kissell, which introduces you to the automation mindset, helps you understand a variety of common automation techniques, and helps you take those first few baby steps toward Automator or AppleScript proficiency.
Posted by Joe Kissell (Permalink)