Skip to content

macOS: Numbers: Spreadsheets


Course
Quantity
For someone else
Jamie Pollock
Quantity
For someone else
Purchase for $39 or enter access code

Use Apple’s Numbers to make spreadsheets on a Mac, for free! With easy formulas and functions, and gorgeous charts, you don’t need to buy Microsoft Excel!

Class Description

Numbers = Excel + Easy + Pretty - Headache

If you are switching from PC to Mac, or are simply a new Mac user, you don't need to buy Microsoft Excel. Just use Apple’s free Numbers app, which is already pre-installed on all your Apple devices, including your Mac computer.

Numbers is Apple’s easy-to-use equivalent of Excel for spreadsheets, except better.

Join Apple guru Jamie Pollock as he teaches you all the ins and outs of Numbers, and walks you through all of the features and benefits of this amazing app.

Learn how to build and format a spreadsheet complete with formulas, formatting, and charts. You'll see how quickly Numbers makes it possible to create impressive tables and spreadsheets that come to life.

You can also drop your data into ready-to-use beautiful templates, then customize your data any way you like with fonts, style cell borders, and clearly labeled interactive graphs.

Take this course, and do the math: Numbers > Excel.

Instructional Level

Beginner through Advanced

Course Length

2 hours

Prerequisites

Numbers software from the App Store

Who should take this class?

Mac users who use Numbers to create spreadsheets
People switching from PC to Mac

What should you bring?

A Macintosh computer with Numbers installed

What You’ll Learn

  • Opening existing Excel documents
  • Using templates
  • Finding tools in the dynamic interface
  • Using tables
  • Entering numbers
  • Creating formulas and calculations
  • Formatting for readability
  • Creating charts
  • Adjusting page layout
  • Saving into Excel
  • Saving as a PDF
  • Exporting to iCloud
  • Additional topics by request

Watch it again later

A recording of the webinar will be added to this course in two weeks so you can review it at your convenience.

Can't make this class?

Click here to watch the videos right now!

Here is the course outline:

1. Download the Handout

Download the handout that goes with the course.

Download the handout here

2. Introduction to Apple Numbers

Learn the difference between Numbers and Excel and why Apple is superior.

Introduction to Numbers

3. Getting Started with Apple Numbers

Getting Started with Apple Numbers, start with the basics.

Built-in Templates
Creating a New Spreadsheet
Tables, Rows, Columns, and Cells
Data, Data Ranges, and Cell Content (Series and Auto-fill)

4. Formatting and Interface Exploration

Explore the Numbers Interface and formatting options. Watch these videos over and over again until you're a Numbers Pro, like Jamie!

Table Formatting
Cell and Data Formatting

5. Equations, Formulas, and Functions

Watch these videos to learn all about the difference of and using equations, formulas, and functions.

Using Equations & Formulas
Functions

6. Working with Charts and Items

Watch these videos to learn all about charts and items. Jamie will explain the difference between charts and items and how to use them both.

Charts and Items Overview
Using Chart Templates and Chart Basics

7. Numbers Pro Tips and Tricks

Watch these videos to learn about some pro tip, tricks, and detail work within Numbers.

Giving Your Spreadsheets Custom Detail
Conditional Highlighting
Saving, Sharing, Exporting, and Conclusion

8. Take the Quiz

Quiz description is "Did you watch the video or take the class live? Let us know here so that you can receive a Certificate of Achievement, an award badge, and points in the Wisdom Quest!

Completion

The following certificates are awarded when the course is completed:

Royalwise CPE Certificate
Back to top