Numbers '09 101

Status

Available

Released

Apr 24th, 2009

If you're in business, Numbers matters! Numbers tells the story of commerce and a scientific way of life. Put plans into action ... use Numbers '09!

Numbers '09 is an incredible application for creating spreadsheets on the Mac. With its deep formulas, integrated graphing features, and the ability to copy and past tables from web pages and other documents directly into your numbers project, Numbers '09 is your go-to app for any Mac-based spreadsheet application.

In this 5-hour title by macProVideo.com trainer Gary Atkins, you'll learn how to create formulas, format tables and cells, create intricate and descriptive charts, and work with multi-table spreadsheets. you'll even learn how to insert graphics and other media into your spreadsheets to really spice-up your display!

This is a comprehensive tutorial, but you don't need to watch the entire show. Use the detailed menus and keyword search functions to quickly find items of interest. For a full list of this tutorial's topics, check out the Table of Contents!

• Chapter 1: Numbers Basics
• 1: Intro to Numbers
• 01:59
  01. Intro
• 01:17
  02. Starting Numbers and Adding Numbers to the Dock
• 01:32
  03. Choosing a Template
• 01:36
  04. Spreadsheet Basics
• 01:04
  05. Show/Hide the Toolbar
• 00:59
  06. Show/Hide the Format Bar
• 01:55
  07. Zoom Controls
• Chapter 2: Creating a Spreadsheet
• 2: Entering Text and Numbers
• 02:39
  08. Entering Text
• 03:25
  09. Using the Autofill Option
• 02:48
  10. Entering Numbers
• 3: Creating Formulas
• 03:26
  11. Typing a Formula
• 05:37
  12. Using the Mouse to Enter a Formula
• 01:08
  13. Using the Function Button to Create a Formula
• 02:41
  14. Drag & Drop Formulas (MInimum & Maximum)
• 05:52
  15. Using the Formula Editor and Function Browser
• 03:21
  16. Editing Formulas
• 4: Formatting and Printing Spreadsheets
• 03:49
  17. Fonts, Typeface, Size, and Color
• 02:43
  18. Aligning Cell Contents
• 03:58
  19. Formatting Numbers
• 02:29
  20. Cell Borders
• 02:09
  21. Formatting a Table
• 01:06
  22. Resizing a Table
• 04:19
  23. Spell Check Menu
• 02:33
  24. Spell Check Key Commands and Right Click
• 03:10
  25. Changing Column and Row Sizes
• 02:33
  26. Viewing Documents in Print View
• 03:18
  27. Printing
• Chapter 3: Working with Charts and...
• 5: Creating and Editing Charts
• 03:36
  28. Creating a Chart Using the Menu
• 01:34
  29. Creating a Chart Using the Toolbar
• 01:28
  30. Turning on the Inspector
• 02:14
  31. Naming and Sizing Charts
• 05:51
  32. Chart Options
• 04:01
  33. Chart Y-Axis Options
• 02:11
  34. Chart X-Axis Options
• 01:47
  35. Series Options in Charts
• 6: Working with Multi-Table Spreadsheets
• 04:26
  36. Copy & Paste Tables
• 02:41
  37. Moving and Aligning Tables
• 03:02
  38. Adding Comments
• 03:55
  39. Insert/Delete Columns and Rows
• 03:38
  40. Entering Formulas Using Multiple Tables
• 03:59
  41. Copying Formulas Across Multiple Tables
• 01:54
  42. Double Checking Formulas between Multiple Tables
• 7: Formatting Documents
• 03:52
  43. Document Formatting
• 03:19
  44. Sheet Formatting
• 02:24
  45. Creating a Header & Footer
• 02:39
  46. Adding a Sheet
• 03:18
  47. Formatting Number Cells
• 02:36
  48. Formatting Time and Date Cells
• 03:09
  49. Cell Borders and Shading
• 03:39
  50. Text Formatting with the Inspector
• Chapter 4: Deeper into Spreadsheet...
• 8: Creating Tables
• 04:03
  51. Creating a Checklist from the Tables Button
• 01:48
  52. Creating a Table from the Insert Menu
• 02:06
  53. Create Header & Footer Rows
• 02:19
  54. Applying a Style to a Table
• 9: Working with Data
• 02:03
  55. Creating a Table from the Address Book
• 02:08
  56. Unhiding and Deleting Columns
• 02:07
  57. Working With Header & Footer Rows
• 02:50
  58. Sorting Data
• 03:41
  59. Searching Data
• 01:43
  60. Alternating Row Colors
• 03:04
  61. Creating Categories
• 10: Inserting Media
• 02:57
  62. Inserting a Text Box
• 02:48
  63. Inserting a Shape & Resizing
• 02:55
  64. Adding a Reflection & Shadow to a Graphic
• 01:11
  65. Inserting a Picture from iPhoto
• 02:20
  66. Resizing & Positioning a Picture (or a Graphic)
• 01:55
  67. Using Instant Alpha to Remove Background Colors
• Chapter 5: Exporting and Sharing S...
• 11: Exporting Spreadsheets
• 03:17
  68. Exporting as a PDF File
• 02:57
  69. Exporting as an Excel File
• 00:49
  70. Exporting as a CVS File
• 01:51
  71. Sharing Your File Using Mail
• 03:29
  72. Using iWork.com Part 1
• 04:32
  73. Using iWork.com Part 2
• 12: Importing a Spreadsheet
• 01:19
  74. Opening an Excel File
• 01:07
  75. Opening a CSV File
• 02:12
  76. Wrap Up