book

iWork® '09 For Dummies®

Name: iWork® '09 For Dummies®
Author: Jesse Feiler
ISBN: 9780470433720

by Jesse Feiler

May 2009

Beginner to intermediate

384 pages

7h 36m

English

For Dummies

Read now

Unlock full access

Copyright
About the Author
Author's Acknowledgments
Publisher's Acknowledgments
1. Introduction
How This Book Is OrganizedIcons Used in This BookWhere to Download the Example Files
I. Introducing iWork '09
1. Starting Out with iWork '09
1.1. Living the Suite Life1.1.1. Official business1.1.2. One piece at a time1.1.2.1. Pages1.1.2.2. Numbers1.1.2.3. Keynote1.2. The Big Difference1.2.1. It's all about communication1.2.2. Do it once, do it right, and reuse it1.2.2.1. Customizing with themes and templates1.2.2.2. Reusing parts of documents1.2.2.3. Sharing styles1.2.2.4. Letting your Mac do the work
2. Working Effectively
2.1. The Menu System2.1.1. The Application menu in Pages, Numbers, and Keynote2.1.2. The File menu2.1.3. The Edit menu2.1.4. The Insert menu2.1.5. The Slide menu (Keynote)2.1.6. The Table menu (Numbers)2.1.7. The Format menu2.1.7.1. Formatting fonts with menu commands2.1.7.2. Formatting text with menu commands2.1.8. The Arrange menu2.1.9. The View menu2.1.10. The Play menu (Keynote)2.1.11. The Windows menu2.1.12. The Share menu2.2. Shortcuts2.3. Standard Elements2.3.1. The iWork window2.3.2. The iWork Toolbar2.3.3. Colors window2.3.3.1. Coloring a selected object using the Colors window2.3.3.2. Coloring a nonselected object using the Colors window2.3.3.3. Saving a color in your color palette2.3.3.4. Coloring a selected object using the palette2.3.3.5. Coloring a nonselected object using the palette2.3.3.6. Copying a color from the screen2.3.3.7. Setting opacity2.3.3.8. Advanced color management2.3.4. The Fonts window2.3.4.1. Selecting fonts2.3.4.2. Previewing fonts2.3.4.3. Setting basic effects2.3.4.4. Applying text shadows2.3.4.5. Customizing typography2.3.4.6. Managing collections
3. Tooling around the Toolbar
3.1. Looking at the Toolbar3.1.1. The toolbar buttons on the left side3.1.2. The toolbar buttons in the center3.1.3. The toolbar buttons on the right side3.2. Using the Toolbar View Button to Customize the Window3.3. Creating Shapes3.3.1. Inserting a predrawn shape from the toolbar3.3.2. Inserting a predrawn shape with the mouse3.3.3. Inserting a shape from the menu bar3.3.4. Editing a shape3.3.5. Editing a shape's geometry3.4. Creating Tables and Charts3.4.1. Creating a table3.4.2. Creating charts3.5. Including Comments3.6. Customizing the Toolbar
4. Inspecting the Inspectors
4.1. Using Inspectors4.2. Formatting Text with Text Inspector4.2.1. Colors & Alignment settings4.2.2. Spacing settings4.3. Formatting Graphics with Graphic Inspector4.3.1. Filling an object with color4.3.2. Creating a gradient fill4.3.3. Placing an image inside a graphic4.3.4. Using a tinted image fill4.3.5. Choosing stroke settings4.4. Adding Images to Your Documents4.4.1. Masking images with shapes4.4.2. Checking and setting positions with Metrics inspector4.4.3. Adjusting images4.5. Using Media Browser4.6. Adjusting Table Settings4.6.1. Setting cell and table properties4.6.2. Setting formats and formulas for cells4.6.3. Setting a conditional format4.6.4. Setting a formula4.7. Adjusting Chart Settings4.8. Managing Links4.9. Setting QuickTime Options

II. Turning the Page with Pages
5. Getting to Know Pages
5.1. Two Faces of Pages Documents5.1.1. Word processing documents5.1.2. Page layout documents5.1.3. Text boxes5.1.4. Document types5.2. Choosing Basic Templates5.2.1. Word processing templates5.2.2. Page layout templates5.3. Creating a Document5.3.1. From a template5.3.2. From a default template5.3.3. From scratch5.4. Setting Pages Preferences for All Documents5.4.1. General preferences5.4.2. Rulers preferences5.4.3. Auto-Correction preferences5.4.3.1. Basic Auto-Correction preferences5.4.3.2. Modifying auto-detected email and Web addresses5.4.3.3. Setting symbol and text substitution5.5. Saving Your Work5.6. Creating a Template from a Document
6. Editing Word Processing Documents
6.1. Managing Paragraphs6.1.1. Setting vertical spacing6.1.2. Setting indents with an inspector6.1.3. Setting indents with the ruler6.1.4. Setting tabs6.1.5. Setting pagination6.2. Using Headers and Footers6.2.1. Constructing a header6.2.2. Moving headers and footers6.2.3. Using section headers and footers6.3. Using the Sections Menu to Add and Reuse Sections6.4. Navigating through a Document
7. Editing Page Layout Documents
7.1. Analyzing the Templates7.2. Starting with a Simple Template7.3. Modifying the Title7.4. Changing the Image7.5. Setting the Main Text7.6. Automatically Inserting Your Phone Number in the Flyer7.6.1.7.6.1.1. Creating a Me card in Address Book7.6.1.2. Using the Merge or Sender field7.7. Changing the Info on the Tear-Off Tabs
8. Using Text Boxes
8.1. Creating a Simple Text Box8.1.1. Creating the text box8.1.2. Modifying the text box8.1.3. Customizing the text box8.1.4. Wrapping around the text box8.1.4.1. Setting how the text box causes wrapping8.1.4.2. Setting how the text box causes text fitting8.2. Creating an Inline Text Box for a Word Processing Document8.3. Flowing Text between Text Boxes8.3.1. Creating a text flow link8.3.2. Joining two text boxes8.4. Adding Objects to Text Boxes
9. Fine-Tuning Your Pages Documents
9.1. Using the Format Bar9.2. Formatting Text with Styles9.2.1. Showing the Styles drawer9.2.2. Using the Styles drawer controls9.2.3. Handling style changes9.2.4. Changing style on a one-time basis9.2.5. Managing styles9.3. Searching for Text9.4. Navigating with Thumbnails
10. Improving Your Documents
10.1. Using Comments10.1.1. Showing and hiding the Comments pane10.1.2. Creating a comment10.1.3. Printing a comment10.2. Tracking Changes10.2.1. Setting up Track Changes preferences10.2.2. Starting and stopping Track Changes10.2.3. Viewing (and not viewing) changes10.2.4. Pausing Track Changes10.2.5. Accepting and rejecting changes10.2.6. Printing a clean copy without changes
11. Advanced Word Processing Techniques
11.1. Working with Sections for Improved Formatting of Long Documents11.1.1. Adding a section to a document11.1.2. Rearranging sections11.2. Formatting Your Document and Sections11.2.1. Setting document information11.2.2. Setting document margins11.2.3. Setting multiple columns11.2.4. Paginating your document11.3. Creating and Updating Tables of Contents
III. Counting on Numbers
12. Getting to Know Numbers
12.1. Taming the Spreadsheet Jungle with Tables12.1.1. Adding tables to spreadsheets12.1.2. Working with tables12.1.2.1. Selecting tables12.1.2.2. Moving and resizing tables12.1.2.3. Selecting table cells12.2. Creating a Numbers Document12.2.1. Creating the document12.2.2. Exploring the Travel Planner document12.2.2.1. Sheet12.2.2.2. Toolbar12.2.2.3. Format bar12.2.2.4. Sheets pane12.2.2.5. Styles pane12.2.2.6. Instant calculation results
13. Creating and Editing Numbers Documents
13.1. Creating Sheets and Tables13.1.1. Creating sheets13.1.2. Creating tables13.2. Working with Headers13.2.1. Adjusting the number of header rows and columns in a table13.2.2. Formatting headers and creating a new style13.3. Formatting Cells13.3.1. Using basic formats for cells13.3.2. Using special formats for cells
14. Using Formulas and Functions
14.1. Starting to Use Formulas14.1.1. Using a formula to summarize data14.1.2. Creating formulas using the SUM function and a range of cells14.1.3. Creating formulas by selecting individual cells14.1.4. Editing formulas14.1.5. Refining cell references14.1.6. Creating a multisheet and multitable summary14.1.7. Using the format bar with formulas14.1.8. Using Formula List14.2. Working with Functions14.3. Using Lookup Functions
15. Working with Charts
15.1. Creating a Chart15.1.1. Describing a chart15.1.2. Creating a chart from scratch15.1.3. Creating a chart from a table15.1.4. Creating a chart from part of a table15.1.5. Modifying a chart's data15.1.6. Moving charts and tables15.1.7. Evaluating your charts15.2. Using Chart Inspector15.2.1. Changing chart types15.2.2. Changing chart colors15.2.3. Formatting chart titles, legends, and bar formats15.2.4. Setting axes, labels, ticks, and grids15.2.5. Adjusting series in Chart inspector
16. Formatting and Printing Numbers Documents
16.1. Formatting Multiple Charts on a Single Sheet16.1.1. Formatting charts on a single sheet16.1.2. Print charts on a single sheet16.2. Sorting and Reorganizing Data16.2.1. Sorting data with the Reorganize dialog16.2.2. Using data categories16.2.3. Finding data
IV. Presenting Keynote
17. Getting to Know Keynote
17.1. Creating Effective Presentations17.1.1. Making your presentations effective17.1.2. Using documents that move17.1.3. Working on a small scale17.2. Introducing the Keynote Themes17.3. Slide Masters Provide Consistency and Save Time17.3.1. Creating your presentation title17.3.2. Structuring your presentation17.3.3. Providing bulleted content17.3.4. Using a Q&Amp;A slide17.4. Creating Handouts, Outlines, and Notes
18. Creating a Keynote Presentation
18.1. Exploring the Keynote Window18.1.1. The Navigator18.1.2. Slide outlines18.1.3. Master slides18.1.4. The light table18.1.5. Presenter notes18.1.6. Comments18.2. Creating Your Own Keynote Presentation
19. Presenting a Keynote Presentation
19.1. Choosing Your Presentation Options19.2. Setting Presentation Preferences19.2.1. Setting preferences for two displays19.2.2. Slideshow preferences19.2.3. Presenter Display preferences19.2.4. Remote preferences
20. Improving Your Keynote Presentation
20.1. Creating Different Types of Presentations20.1.1. Reviewing the slide masters20.1.2. Planning your presentation20.2. Adding Motion to Your Presentation20.2.1. Adding a movie to a slide20.2.2. Adding a transition between slides20.2.3. Adding builds within slides20.3. Adding Sound to Your Presentation20.3.1. Recording a slideshow20.3.2. Using the recorded slideshow20.3.3. Adding an iTunes song
V. The Part of Tens
21. Ten Ways to Share Content
21.1. Sharing Content with MobileMe21.2. Sharing Content with People on Your Network21.3. Sharing Content on iWeb21.4. Sharing Content Using Send To21.5. Using Media from iPhoto, iTunes, and iMovie21.6. Using PDF Files as Images21.7. Adding Hyperlinks to iWork Documents21.8. Moving Data from Other Applications into iWork
22. Ten Ways to Let iWork Do the Work for You
22.1. Finding and Browsing the Pages AppleScript Dictionary22.2. Creating a Script22.2.1. Counting tables on a Pages page22.2.2. Adding a table to a Pages document22.2.3. Retrieving properties about a table in Pages22.2.4. Setting properties for a table in Pages (version 1)22.2.5. Setting properties for a table in Pages (version 2)22.3. Using Automator with Keynote22.4. Using Automator with Images22.5. Using Automator with Multiple Files22.6. Looping Around Automator
A. Using iWork.com
A.1. Logging On to iWork.comA.2. Sharing Documents with iWork.comA.3. Viewing Your Shared DocumentsA.4. Inviting People to View Shared DocumentsA.5. Adding Document NotesA.6. Adding comments to document objects
B. Chapter Guide to iWork Techniques

Content preview from iWork® '09 For Dummies®

Chapter 14. Using Formulas and Functions

In This Chapter

Creating formulas
Using summary formulas
Working with functions
Using a lookup function

One of the most important features of any spreadsheet is the ability to place formulas into cells. Other spreadsheets, such as Microsoft Excel, offer functions and formulas — often the same ones you find in Numbers. Spreadsheet users expect to find a SUM function along with a TODAY function and all the other functions that they're accustomed to, particularly if they switch back and forth between spreadsheet applications or if they're sharing their documents. What sets Numbers apart is the ease with which you can create and manage formulas along with the large number of templates that implement sophisticated uses of formulas and functions.

Starting to Use Formulas

Formulas can contain specific values (called constants and sometimes literals); they also can contain references to cells in the spreadsheet. If a formula contains a reference to a cell, every time that cell's value is updated, the formula is reevaluated. A formula can contain a reference to a cell that itself contains a formula. There is no limit to the number of formulas in the chain of formulas for a given cell. Whenever the first value in the chain is changed, every formula is reevaluated. The only limitation to this chain of formulas is that it has to be a single path. You can't create what is called a circular reference, a formula that relies on evaluating a previous cell that contains ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780470433720Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

iWork® '09 For Dummies®

by Jesse Feiler

Chapter 14. Using Formulas and Functions

Starting to Use Formulas

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.