Course Highlights
  • Create single and multi-table spreadsheets in Numbers
  • Use formulas to perform calculations
  • Create simple lists of records as spreadsheets
  • Create charts from spreadsheet data
  • Manipulate spreadsheet elements to create forms and data sheets
  • Use logical function in spreadsheets
  • Export and share spreadsheets
Curriculum

11 Topics
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

5 Topics
Relative Formula References
Absolute Formula References
Formula Functions
Footers
Example 2: Simple Checkbook

6 Topics
Sorting Rows
Filtering Rows
Using the COUNTIF Function
Multiple Tables
Example 3: Mortgage Extra Payment Calculator
Example 4: Personal Book Inventory

4 Topics
Borders
Cell Backgrounds
Conditional Highlighting
Example 5: Student Grade Tracker

5 Topics
Creating Charts
Chart Settings
Multi-Column Charts
Pie Charts
Example 6: Sales Charts

6 Topics
Adding Shapes
Text Boxes
Adding Images
Layout and Design
Example 7: Product Sheets
Example 8: Football Squares

8 Topics
IF Statements
AND OR NOT
Durations
Example 9: Due Dates
The LOOKUP Function
The INDIRECT Function
Text Functions
Example 10: Chore Chart

5 Topics
Merging Cells and Wrapping
Exporting
Using iCloud to Share Numbers Documents
Example 11: Physics Experiment
Another Look at AND OR NOT

4 Topics
New Features in Numbers 4.1
Collaboration
New Features in Numbers 5.0
Smart Categories (Pivot Tables) in Numbers 5.2

  Write a Review

Mac Numbers: Creating and Using Spreadsheets On Your Mac

Go to Paid Course