Chapter 11. Mastering Numbers: Tips, Techniques, and Fun

In this chapter we will cover:

  • Rearranging rows and columns
  • Hiding columns instead of deleting them
  • Adding up selected cells
  • Setting and using formulas in financial documents
  • Making documents secure and private
  • Adding pictures to cells
  • Using color coding—changing table row colors and setting cells to change color automatically
  • Using clip art and photos in charts—the unbeatable visual effect of Numbers documents

Introduction

Numbers is a spreadsheet application in iWork. If you are familiar with Excel or other spreadsheet applications, you will be able to open a Numbers document and start working in it without any difficulty. Even if you aren't comfortable with spreadsheets, it's likely that you have already used tables in word processing applications, such as Pages. Numbers isn't that different from navigating tables.

Once you have started using Numbers, you will see that the application is not only easy to use, but is also handy—and fun—for many practical tasks that have little or nothing to do with calculations.

Recipes in this chapter are primarily for occasional users of spreadsheets. But experienced users will also find the techniques described here useful, especially the recipes for how to use photos and graphics in Numbers documents.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.220.124.177