Numbers '09 101 Tutorial & DVD Training - Download Numbers tutorials & Learn Core Numbers '09 tips & tricks

Overview
Topics
Trainer
Reviews
Requirements
How It Works

Your Subscription Includes

24-hour, unrestricted Online Tutorial Library access
25% discount on all HD Tutorial Downloads
1. Subscribe to DPV
2. View unlimited tutorials in your web browser
3. Add Tutorials to your cart
  * A 25% discount will be applied to your order
4. Download HD Tutorials to your computer

How Do We Compare?	designProVideo.com	Lynda.com	VTC.com
Monthly Subscription Fee	$25	$25	$30
24-Hour Full Online Library Access	Yes	Yes	Yes
HD Tutorial Downloads View tutorials offline	Yes	No	No
Sync Tutorials to iPhone & iPod Touch *	Yes	No	No
* only purchased downloads can be synced at this time

The Difference Is In The Quality

HD Tutorial Downloads use standard HD Video Resolutions.

Online Tutorials are formated to display in the web browser.

The Benefits Of An HD Tutorial Download
Keep HD Tutorial Downloads forever!
View offline, anytime (Mac / PC)
Sync to iPhone/iPod Touch (Mac Only)

Aspect Ratio	HD Tutorial Download Resolution	Online Tutorial Resolution
16 : 9	1600 X 900, 1280 X 720	960 X 540
4 : 3	1024 X 768	768 X 576

Preview 1

Preview 2

Preview 3

Recent Reviews

"Great I can now make my own templates . The instruction was very helpful best I have used."

REG / Mar 20th

"Very Good tutorial. I want there was more about functions so hope can find in next tuorial more about functions."

Kim Koskinen / Oct 3rd

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!

$19.50
$25.00/mth
Download & View Offline
Full HD quality

24-hour library access
Over 423 hours of training

Chapter 1: Numbers Basics

Section 1: Intro to Numbers

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

Chapter 2: Creating a Spreadsheet

Section 2: Entering Text and Numbers

08. Entering Text
09. Using the Autofill Option
10. Entering Numbers

Section 3: Creating Formulas

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

Section 4: Formatting and Printing Spreadsheets

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

Chapter 3: Working with Charts and Tables

Section 5: Creating and Editing Charts

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

Section 6: Working with Multi-Table Spreadsheets

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

Section 7: Formatting Documents

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

Chapter 4: Deeper into Spreadsheets

Section 8: Creating Tables

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

Section 9: Working with Data

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

Section 10: Inserting Media

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

Chapter 5: Exporting and Sharing Spreadsheets

Section 11: Exporting Spreadsheets

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

Section 12: Importing a Spreadsheet

74. Opening an Excel File
75. Opening a CSV File
76. Wrap Up

Gary Atkins

“By Martin Sitter

Early in 2008, I was chatting with my good friend David Blumberg, when I mentioned how badly we needed to find the world's best Sibelius trainer, for macProVideo.com. "No problem," said David, "I know just the person for you!"

David introduced me to Toronto-based composer and professional educator, Gary Atkins ... the rest, as they say, is history.

Gary Atkins is a composer, guitarist, keyboardist, arranger, orchestrator, copyist, and computer specialist who has worked in Theatre, Television, Film and Multimedia. Gary co-wrote the music for the CTV series Creepy Canada with Martin Deller. He has assisted and acted as copyist for some of Canada’s award-winning composers (John Welsman, Paul Hoffert and Glenn Morley).

Currently, Gary is the Technology Co-ordinator for the Royal Conservatory of Music (Toronto) and teaches Music Technology at Humber College. As a Sibelius “Ambassador,” Gary travels to trade shows and educator conferences across the continent to demonstrate the Sibelius software for teachers and other educators. He is highly regarded as a trainer, and has been sought after by awarding composers such as Joe Sealy (Jazz Pianist), Glenn Morley (Genie Award winner), David Blumberg (Stevie Wonder, Herbie Hancock, American Idol), Yves Frulla (Celine Dion Band: Keyboard Player), Clarence McDonald (James Taylor, Aretha Franklin, Barbara Streisand) and others to provide training for individual users and groups in how to use Sibelius and other software.

Gary is a great example of the incredible trainers we hire here at macProVideo.com, and we're incredibly pleased to present his videos to you!

”

Have you watched this Tutorial? Add Your Review

"Great I can now make my own templates . The instruction was very helpful best I have used."

- REG / Mar 20th

"Very Good tutorial. I want there was more about functions so hope can find in next tuorial more about functions."

- Kim Koskinen / Oct 3rd

"This makes numbers so easy to use, excellent tutorial."

- jamie / Jul 23rd

"This one is really amazing! Open doors for the minds! Thanks a lot! Cheers!"

- Sender / Jun 15th

"I enjoyed the well-paced and detailed organization of the Numbers '09 101. It's obvious that Gary Atkins is aware that the viewer is a Mac-user and, perhaps, a visual learner like me and most of my students. I often use the techniques showm on the DVD tutorial(s) to teach my Grade 7-10 students and/or produce written instruction booklets for both students and faculty. Well Done! Thanks Fernando Toronto, ON, Canada"

- Fernando Gonçalves / May 12th

N.E.D. Tutorial-Video Player

All tutorials may be played via a modern web browser using N.E.D.web.
Our N.E.D. tutorial-video player is required to download and play HD Tutorials.