Mac Numbers: Learn How to Work With Spreadsheets On Your Mac

Gary Rosenzweig

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
51 Videos (4h 7m)
    • Class Introduction

      1:17
    • Starting a New Document

      1:23
    • Documents, Sheets, Tables, and Cells

      1:39
    • Cells

      2:11
    • Tables

      2:31
    • Columns and Rows

      1:34
    • Titles and Headers

      1:43
    • Special Cell Formats

      4:38
    • Formula Basics

      2:25
    • Absolute Formula References

      2:41
    • Relative Formula References

      2:12
    • Example 1: Business Trip Expenses

      9:32
    • Formula Functions

      3:49
    • Footers

      2:53
    • Example 2: Simple Checkbook

      12:27
    • Sorting Rows

      3:47
    • Filtering Rows

      2:35
    • Using the COUNTIF Function

      1:47
    • Multiple Tables

      2:36
    • Example 3: Mortgage Extra Payment Calculator

      15:38
    • Example 4: Personal Book Inventory

      14:04
    • Borders

      4:13
    • Cell Backgrounds

      2:29
    • Conditional Highlighting

      2:38
    • Example 5: Student Grade Tracker

      18:43
    • Creating Charts

      1:46
    • Chart Settings

      3:11
    • Multi-Column Charts

      2:11
    • Pie Charts

      2:27
    • Example 6: Sales Charts

      7:38
    • Adding Shapes

      4:00
    • Text Boxes

      2:03
    • Adding Images

      2:47
    • Layout and Design

      3:25
    • Example 7: Product Sheets

      9:47
    • Example 8: Football Squares

      9:14
    • IF Statements

      1:47
    • AND, OR, NOT

      1:58
    • Durations

      1:58
    • Example 9: Due Dates

      7:35
    • The LOOKUP Function

      2:49
    • The INDIRECT Function

      4:35
    • Text Functions

      3:05
    • Example 10: Chore Chart

      10:15
    • Merging Cells and Wrapping

      3:52
    • Exporting

      2:34
    • Using iCloud to Share Numbers Documents

      3:32
    • Example 11: Physics Experiment

      13:39
    • Another Look at AND, OR, NOT

      8:24
    • New Features in Numbers Updates

      7:24
    • Collaboration

      3:49

About This Class

Mac Numbers is a complete course with 36 lessons and 11 practical examples taking  you from beginner to advanced level. It includes three and a half hours of video tutorials and 11 example files.

This course starts at the beginning, teaching you the basics such as creating a new document, starting with the blank template, entering numbers and performing basic calculations. You’ll then move on to create multi-table spreadsheets, perform advanced calculations, sort and filter data, create charts and more.

Whether you need to use Numbers for work, school, or a project at home, this course can get you up to speed fast. It does not assume that you have previous spreadsheet experience. However, if you have used an application like Excel in the past, you can also use this course to quickly learn the ins-and-outs of Numbers.

Gary Rosenzweig is the host and producer of MacMost.com where he has published more than 1,000 video tutorials. He has also written many mass-market computer books such as My iPad and the the MacMost Guide to Switching to the Mac.

16

Students

--

Projects

0

Reviews (0)

Gary Rosenzweig is an Internet entrepreneur, software developer, and technology writer. He runs CleverMedia, Inc., which produces websites, computer games, apps, and podcasts.

CleverMedia's largest site, MacMost.com, features more than 1,000 video tutorials for Apple enthusiasts. It includes many videos on using Macs, iPhones, and iPads. Gary has written more than 30 mass-market computer books, including the best-selling book My iPad, The MacMost Guide to Switching to the Mac, My Pages...

See full profile