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