Publishers of technology books, eBooks, and videos for creative people

Home > Articles > Apple > Operating Systems

10 Tips for Getting the Most Out of Numbers

  • Print
  • + Share This
Mark Wood, author of Apple Pro Training Series: Pages, Numbers, and Keynote, shares 10 ways to harness the real power of Numbers.
Like this article? We recommend

Numbers is a spreadsheet application that benefits from tight integration with the other Apple productivity applications, Pages and Keynote. Numbers is available on OS X for Mac, iOS for the iPad and iPhone, and via web browsers.

This article provides 10 tips for Numbers, highlighting ideas and functions that will help boost your productivity, but some of the advice is also applicable to Pages and Keynote. For example, Pages and Keynote can create tables and charts similar to those created in Numbers; however, for extra control over your data, you should create tables and charts in Numbers and then copy them into Pages and Keynote as needed.

Tip 1: Think of Numbers as a freeform canvas

Numbers documents can contain multiple sheets, each of which can be used as a blank canvas on which to add tables and charts. You might have expected these features; however, users often overlook the ability to add media such as photos or video. For example, when documenting a school's science lab experiment, adding photos and video of the processes involved could make for a visually rich presentation.

Figure 1 shows an example of a father and son's efforts to research facts about World War II. The charts and tables in Numbers were copied and pasted into Pages and Keynote for class presentations. Notice the size of the spreadsheet in Numbers; it offers plenty of space for adding special features to the research documentation.

Figure 1

Figure 1. The spreadsheets in Numbers are vast. Much of the text here is set in 10 pt, and the selected photo measures 6 × 5 inches.

Other types of spreadsheets might include business fact-finding, vacation planning, and so on. By adding screen grabs of websites or photos of the products or places you're researching, you can use Numbers as a number-crunching pin-board.

Tip 2: Use multiple tables rather than a large single table

Numbers lets you add tables to a sheet with ease. Where appropriate, however, break up calculations into multiple tables to make navigating your spreadsheet easier (see Figure 2).

Figure 2

Figure 2. Organize your data into multiple tables.

Using smaller tables also helps to isolate any math problems in complex calculations. These concepts are explored further in Lesson 10, "Making Customized Calendars," in Apple Pro Training Series: Pages, Numbers, and Keynote. The lesson also explains the syntax for creating advanced formulas, which can lead to spreadsheets that work as mini-applications. The example shown in Figure 2 is a photographer's price calculator for prints. The spreadsheet can be used to choose a variety of paper types, sizes, and qualities, quickly returning a price that the photographer can quote to her clients.

Tip 3: Label that table!

It's a good habit to rename tables and charts as you create them in Numbers. Suppose you create multiple tables, as suggested in Tip 2. If you don't rename them, you'll be confronted with the default references (Table 1, Table 2, Table 3, and so on) when you try to apply formulas.

In Figure 3, the table has been renamed Price Calculator. The Inspector shows that the Table Name option is enabled. If this option were deselected, the table would still be identified in the Formula Editor as Price Calculator, but the label on the sheet would disappear.

Figure 3

Figure 3. Labeling tables and charts descriptively is a best practice.

In the same vein, when the sheet tab is clicked. a menu appears, listing all the tables and charts on that sheet. Notice in Figure 4 that the tables are labeled as Price Calculator and Paper Prices. Having descriptive labels helps you to find and jump to the required table or chart more easily than with the default table names of Table 1, Table 2, and so forth.

Figure 4

Figure 4. Here the Sheet menu lists two tables: Price Calculator and Paper Prices.

Tip 4: Change data formats as needed

Numbers will try to guess which data format to use, depending on what you type into a cell. Often Numbers will guess correctly, but sometimes you'll want to set the data format manually (see Figure 5).

Figure 5

Figure 5. Numbers automatically chooses cell data formats, but sometimes you'll need to set the format manually.

The Numbers application's guesswork can be a great time saver, too. In Figure 6, I typed Monday into cell A1 and then dragged across the adjacent columns. Numbers automatically added the remaining days of the week.

Figure 6

Figure 6. The combination of Numbers' guesswork and autofill is a great time-saver for filling in days of the week, months of the year, dates, or number sequences.

To explore formatting in more detail, see Apple Pro Training Series: Pages, Numbers, and Keynote.

Tip 5: Use interactive data formats

Numbers has five interactive data formats: Checkbox, Star Rating, Slider, Stepper, and Pop-Up Menu. Often, one of these formats will be the ideal solution for data input. For example, use Pop-Up Menu to create a custom list of items from which users can select, or use Slider to quickly apply a number value in a range of your choosing.

The example in Figure 7 comes from Lesson 9, "Making Interactive Spreadsheets," in Apple Pro Training Series: Pages, Numbers, and Keynote. A pop-up menu is configured to show all the junior grading levels for a Kempo Ju-Jitsu club. The lead instructor only has to click a student's grade, and a custom pop-menu appears.

Figure 7

Figure 7. Creating pop-up menus speeds up data input.

Staying with the Ju-Jitsu club, Figure 8 shows a range of interactive data formats in a grading assessment table. Checkboxes are used for the first five assessment criteria, but for the training bouts Star Ratings have been set for qualitative assessment.

Figure 8

Figure 8. Use the interactive data formats to make data input intuitive and more accurate.

You can apply this idea to a wide range of assessment types, and not just in education or sports—perhaps in medical or engineering assessments, etc.

Tip 6: Learn how to change cell references

For users taking their first steps with spreadsheets, setting up calculations is a great achievement. The default reference settings work well in many cases, but changing the cell references unlocks a world of possibilities.

Earlier I mentioned Lesson 10 in the book. The lesson begins with an exercise to construct a multiplication table. For the math to work correctly, the cell references have to be changed from the default settings. In Figure 9, cell F4 calculates 5 × 4. To achieve this result, the references to row 1 and column A must be preserved, as shown in Figure 10. (If you work through Lesson 10, these concepts will be clearer.)

Figure 9

Figure 9. The formula in cell F4 shows that cells F1 and A4 are being referenced. Numbers' default referencing would show cells F3 and E4 in the Formula Editor, so the default referencing wouldn't work for this multiplication table example.

Figure 10

Figure 10. Clicking a reference in the Formula Editor opens a pop-up menu in which you can change the cell referencing.

The inquiring mind will dare to imagine great things from spreadsheets. Understanding the options for referencing cells in formulas will have you moving forward by leaps and bounds.

Tip 7: Save versions to mark waypoints in your work

This tip applies to Keynote and Pages, too. All three applications automatically save your documents as you work. This feature removes the need to remember to save your work periodically, but here's one reason why you still might want to save manually. Imagine a scenario where you've reached a point of perfection; your spreadsheet, essay, or slideshow is dazzlingly brilliant, but you want to try to take things further. Choose File > Save or press Command-S to save that specific version of your document. You can save as many versions as you like (see Figure 11).

Later, if you want, you can use Revert To options to restore that point of perfection. Find the revert options by choosing File > Revert To. A window appears that looks and behaves much like OS X Yosemite's Time Machine.

Figure 11

Figure 11. Restoring a version of a Pages, Numbers, or Keynote document opens a window very much like OS X Yosemite's Time Machine.

Tip 8: Design spreadsheets on OS X to use on iOS devices for data input

The versions of Pages, Numbers, and Keynote on your Mac are heavy hitters amid the other versions of the applications on iOS and iCloud. To make the most of the portable convenience of your iPad or iPhone, and the seamless integration of Numbers across the ecosystem of Apple products, design your spreadsheet on your Mac. Save the spreadsheet to iCloud so that you can test your design on your iPad or iPhone, and then continue refining the spreadsheet on your Mac until the design also displays neatly on your iOS device (see Figure 12).

Figure 12

Figure 12. The grading spreadsheet looks almost identical on iOS and OS X. (Compare Figure 12 with Figure 8.)

Of course, you can develop spreadsheets exclusively on your iOS device, but the OS X version has additional features you may find useful.

Tip 9: Use the form options on iOS

Stepping away from the OS X version of Numbers, this tip offers a great benefit for anyone entering data on an iPad or iPhone. As Tip 8 suggests, developing your spreadsheet on a Mac is likely to be the best option, but one feature in Numbers is only found in the iOS version. As you tap the plus (+) icon to create a new sheet in the iOS version of Numbers, you get two options: New Sheet or New Form (see Figure 13).

Figure 13

Figure 13. The Form options in Numbers for iOS are accessed via the plus (+) sign adjacent to the sheets.

Forms are based on existing tables and make data entry a cinch. Figure 14 shows the Junior Register table from Figure 12 in Form view. The image was captured on an iPad Mini, and even with the smaller screen size you can see that plenty of space is available to navigate through the register.

Figure 14

Figure 14. The Form view makes data entry easy.

The interactive data formats are also available in Form view, as shown in Figure 15.

Figure 15

Figure 15. Interactive data formats are accessible in Form view.

Tip 10: Secure your data by using passwords

Spreadsheets often contain sensitive information, whether that's product pricing, personnel details, or a record of all the shopping you've done. Locking down a spreadsheet is not just prudent—it may be necessary to comply with data protection laws. Applying password protection is easy, and the same process is used for Keynote and Pages: Just choose File > Set Password, and enter your password in the required fields.

Conclusion

We've reached the end of our brief look at getting the most out of Numbers. Apple Pro Training Series: Pages, Numbers, and Keynote. explores these concepts in greater depth, with exercises based on real-world scenarios to help you consolidate your learning.

  • + Share This
  • 🔖 Save To Your Account

Peachpit Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from Peachpit and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about Peachpit products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites; develop new products and services; conduct educational research; and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email ask@peachpit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by Adobe Press. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.peachpit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020