• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

Numbers offers intuitive organization features, allowing users to focus more on analysis and presentation. In Numbers '09 Essential Training, David Rivers explores the important features of this spreadsheet application and introduces the new tools for formula development and charting. He walks through the new functionality of charts, tables, and templates, and shows how to make spreadsheets effective and eye-catching. Exercise files accompany the course.

Course Numbers \'09 Essential Training Author David Rivers SKU ISBN Release Date 2009-06-05 Duration 3.53 hrs / 71 tutorials Work files Yes Price $ 49.95 Retail price $ 99.95 Language Tags iWork

1. Getting Started with Numbers Launching Numbers and exploring templates 02:24 Exploring the user interface 02:45 Customizing the user interface 02:08 2. Working with Spreadsheets Creating and opening spreadsheets 01:12 Importing spreadsheets 01:48 Saving and exporting spreadsheets 02:39 Working with sheets 03:00 Laying out sheets 03:07 Headers, footers, and page numbering 03:50 3. Working with Tables Adding tables 02:43 Modifying tables 02:39 Working with content in table cells 04:55 Using controls 05:00 Working with rows and columns 04:59 Table headers and footers 05:24 Auto-filling table cells 03:50 Working with table cells 03:17 Using table categories 04:18 Reorganizing table data 03:07 Defining reusable tables 03:38 Copying tables 02:48 Using Address Book data 02:04 4. Working with Table Styles Using table styles 02:03 Overriding table styles 01:51 Redefining a table's style 02:31 Copying and pasting table styles 02:46 Creating, renaming, and deleting table styles 03:41 Using the default table style 01:12 5. Using Formulas and Functions Using formulas 03:47 Using the Formula bar and Formula Editor 03:52 Using cell references 03:25 Using functions 04:15 Using Formula List view 03:05 6. Working with Charts Adding a chart 02:42 Creating a mixed chart 02:33 Modifying chart data 02:23

Adding data to a chart from multiple tables 02:20 Changing a chart from one type to another 02:19 Formatting general chart attributes 04:56 Using trend lines and error bars 05:21 Creating a two-axis chart with different value scales 02:34 Formatting 3D charts 05:15 Linking charts to Pages and Keynote 02:25 7. Working with Text and Numbers Adding, removing, and selecting text 03:24 Formatting text 04:11 Formatting numbers 06:53 Conditional formatting 03:28 Using special characters 03:57 Using hyperlinks 02:33 Checking spelling 04:58 Find and Replace 03:32 8. Working with Objects Using text boxes 05:09 Copying text to a text box 02:26 Paragraph formatting 03:14 Creating bulleted and numbered lists 03:50 Working with shapes 04:29 Adding and adjusting images 02:46 Masking objects 03:50 Using Instant Alpha 02:00 Inserting media files 03:37 Aligning and layering objects 06:04 9. Sharing Spreadsheets Printing a sheet 04:08 Password-protecting and emailing spreadsheets 03:36 Sharing spreadsheets with iWork.com 04:02 10. Creating Spreadsheet Templates Designing a template 05:26 Creating initial spreadsheet content 02:54 Creating media placeholders 02:33 Saving a custom template 01:44 Conclusion Goodbye 00:18