We launched a new IT training category! Check out the 140+ courses now.

Start learning with our library of video tutorials taught by experts. Get started

Numbers 3 Essential Training
Illustration by Neil Webb

Numbers 3 Essential Training

with David Rivers

Video: Welcome

(xylophone music) Hi, and welcome to Numbers Essential Training. I'm David Rivers. Numbers is a powerful spreadsheet application that gives you all the tools you need to create complex, yet stunning-looking worksheets. In this course, I'll take you through the creation process beginning with a quick tour of the template chooser and the user interface. Then it's on to some spreadsheet basics before we really start working with tables, table styles, and more complex formulas and functions.
Expand all | Collapse all
  1. 1m 40s
    1. Welcome
      1m 1s
    2. Using the exercise files
      39s
  2. 15m 23s
    1. Numbers templates
      3m 3s
    2. Exploring the user interface
      6m 53s
    3. Customizing the user interface
      5m 27s
  3. 22m 21s
    1. Creating a basic spreadsheet
      5m 18s
    2. Importing spreadsheet data
      6m 26s
    3. Saving spreadsheets
      3m 24s
    4. Working with sheets
      4m 8s
    5. Using row and columns headers
      3m 5s
  4. 44m 38s
    1. Adding a table
      5m 12s
    2. Modifying tables
      5m 15s
    3. Customizing table cells and borders
      7m 23s
    4. Working with content in table cells
      6m 16s
    5. Using controls
      5m 31s
    6. Adding images to cells
      3m 46s
    7. Working with table cells
      4m 49s
    8. Reorganizing table data
      6m 26s
  5. 15m 42s
    1. Using table styles
      4m 25s
    2. Modifying a table's style
      4m 14s
    3. Creating and deleting table styles
      3m 41s
    4. Using text styles in a table
      3m 22s
  6. 21m 40s
    1. Using formulas
      6m 39s
    2. Using functions
      6m 20s
    3. Using cell references
      3m 35s
    4. Using operators
      5m 6s
  7. 26m 41s
    1. Adding a chart
      5m 57s
    2. Modifying chart data
      2m 6s
    3. Changing a chart from one type to another
      1m 56s
    4. Formatting general chart attributes
      8m 10s
    5. Formatting 3D charts
      4m 50s
    6. Using interactive charts
      3m 42s
  8. 30m 48s
    1. Text and paragraph formatting
      4m 57s
    2. Conditional highlighting
      2m 47s
    3. Using special characters
      4m 45s
    4. Using hyperlinks
      3m 42s
    5. Autocorrect options
      4m 8s
    6. Checking spelling
      6m 31s
    7. Using Find & Replace
      3m 58s
  9. 33m 58s
    1. Using text boxes
      6m 32s
    2. Copying text to a text box
      2m 27s
    3. Working with shapes
      5m 14s
    4. Adding and arranging images
      4m 19s
    5. Masking and adjusting images
      3m 50s
    6. Using Instant Alpha
      1m 46s
    7. Adding audio and video
      9m 50s
  10. 14m 33s
    1. Designing a template
      3m 42s
    2. Providing input options
      5m 11s
    3. Creating media placeholders
      2m 50s
    4. Saving a custom template
      2m 50s
  11. 22m 49s
    1. Printing and page setup
      5m 38s
    2. Exporting to an Excel file
      5m 32s
    3. Exporting to other document formats
      5m 22s
    4. Sending a spreadsheet via email
      1m 51s
    5. Sharing spreadsheets with iCloud
      4m 26s
  12. 38s
    1. Next steps
      38s

Watch this entire course now —plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Numbers 3 Essential Training
4h 10m Beginner Jun 25, 2014

Viewers: in countries Watching now:

Numbers offers an intuitive interface and elegant organization features we've come to expect from Apple, allowing you to focus more time on analysis and presentation. David Rivers helps you learn all that you can accomplish with Numbers. First, take a quick tour of the interface and the Template Chooser, and then see how to quickly create a basic spreadsheet. He also walks through more complex features, like tables, styles, formulas and functions, charts, and formatting options, as well as the array of objects you can add to make a Numbers spreadsheet even more effective and eye-catching. Finally, learn how to share your spreadsheets with the world as printouts and emails, or through iCloud.

Topics include:
  • Creating and laying out spreadsheets
  • Importing data
  • Working with tables
  • Adding images to cells
  • Performing calculations with formulas and functions
  • Creating charts
  • Formatting text and numbers
  • Including audio, video, and shapes
  • Designing templates
  • Printing and sharing spreadsheets
Subjects:
Business Productivity Computer Skills (Mac) Spreadsheets
Software:
iWork Numbers
Author:
David Rivers

Welcome

(xylophone music) Hi, and welcome to Numbers Essential Training. I'm David Rivers. Numbers is a powerful spreadsheet application that gives you all the tools you need to create complex, yet stunning-looking worksheets. In this course, I'll take you through the creation process beginning with a quick tour of the template chooser and the user interface. Then it's on to some spreadsheet basics before we really start working with tables, table styles, and more complex formulas and functions.

Making your worksheets look good is an important part of creating professional quality spreadsheets. So, we'll work with charts and text formatting options before we explore the various types of objects we can add to a Numbers spreadsheet to really maximize that wow factor. Then, we investigate the various ways to share your documents with the world, including exporting to PDF and Excel formats, as well as working in the Cloud. With all of this and more to cover, let's get started with Numbers Essential Training.

There are currently no FAQs about Numbers 3 Essential Training.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Numbers 3 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.