The Basics
  • Using this Course
  • Introduction
  • Getting Started
  • Documents, Sheets, Tables, and Cells
  • Cells
  • Tables
  • Columns and Rows
  • Titles and Headers
  • Special Cell Formats
  • Formula Basics
  • Example 1: Business Trip Expenses
Using Formulas
  • Relative Formula References
  • Absolute Formula References
  • Formula Functions
  • Footers
  • Example 2: Simple Checkbook
Sorting, filtering and using multiple tables.
  • Sorting Rows
  • Filtering Rows
  • Using the COUNTIF Function
  • Multiple Tables
  • Example 3: Mortgage Extra Payment Calculator
  • Example 4: Personal Book Inventory
Cell Borders and Coloring
  • Borders
  • Cell Backgrounds
  • Conditional Highlighting
  • Example 5: Student Grade Tracker
Creating Charts
  • Creating Charts
  • Chart Settings
  • Multi-Column Charts
  • Pie Charts
  • Example 6: Sales Charts
Designing Spreadsheets
  • Adding Shapes
  • Text Boxes
  • Adding Images
  • Layout and Design
  • Example 7: Product Sheets
  • Example 8: Football Squares
Complex Formulas
  • IF Statements
  • AND, OR, NOT
  • Durations
  • Example 9: Due Dates
  • The LOOKUP Function
  • The INDIRECT Function
  • Text Functions
  • Example 10: Chore Chart
Exporting and Advanced Topics
  • Merging Cells and Wrapping
  • Exporting
  • Using iCloud to Share Numbers Documents
  • Example 11: Physics Experiment
  • Another Look at AND, OR, NOT
Numbers Updates
  • New Features in Numbers 4.1
  • Collaboration
  • New Features in Numbers 5.0
  • Smart Categories (Pivot Tables) in Numbers 5.2