Mac Numbers: Creating and Using Spreadsheets On Your Mac
4.6 (939 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,561 students enrolled

Mac Numbers: Creating and Using Spreadsheets On Your Mac

Build spreadsheets, perform calculations, create charts and design forms with practical examples.
Bestseller
4.6 (939 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,561 students enrolled
Created by Gary Rosenzweig
Last updated 9/2018
English
English [Auto-generated]
Current price: $51.99 Original price: $79.99 Discount: 35% off
3 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 1 article
  • 11 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Requirements
  • Students should have a basic familiarity with using Macs, including the mouse, keyboard, drag-and-drop, and managing files. They should have Numbers 3.6 or newer installed on their Mac from the Mac App Store.
Description

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.

Who this course is for:
  • This course will teach you the basics and many advanced techniques for creating and using spreadsheets with Numbers on your Mac. If you want to use Numbers at home or work but have no previous spreadsheet experience, this course starts at the beginning. If you have used other spreadsheet apps like Excel, this could can help you switch to Numbers.
Course content
Expand all 54 lectures 04:20:34
+ The Basics
11 lectures 31:23

Learn about the instructor and get an overview about what material will be covered in the course.

Preview 02:55

Learn how to create a new Numbers document on your Mac. Examine Apple’s built-in templates.

Preview 01:23

Learn how documents are made up of sheets, sheets are made of tables, and tables are made of cells.

Documents, Sheets, Tables, and Cells
01:39

Learn about tables and cells. Find out how to identify cells by row and column. Try entering data into cells.

Cells
02:11

Learn how to manipulate tables by moving and stretching.

Tables
02:31
Titles and Headers
01:43
Special Cell Formats
04:38

Learn how to create simple formulas to perform computations on the numbers in cells.

Preview 02:25

Create an expense report spreadsheet that keeps track of items by date, description and cost. Find out how to automatically compute the sum of the expenses.

Example 1: Business Trip Expenses
09:32
+ Using Formulas
5 lectures 24:02

Learn about how cell references in formulas are relative and will update as you move the formula to other cells.

Relative Formula References
02:12

Learn how to create formulas that refer to specific cells, even if the formula moves to another cell.

Absolute Formula References
02:41
Formula Functions
03:49
Footers
02:53

Create a spreadsheet that acts as a simple checkbook. It will keep track of checks and deposits and keep a running total.

Example 2: Simple Checkbook
12:27
+ Sorting, filtering and using multiple tables.
6 lectures 40:27
Sorting Rows
03:47

Learn how to view only certain rows in a table based on specific criteria.

Filtering Rows
02:35
Using the COUNTIF Function
01:47

Use more than one table on a single sheet to keep your data organized when performing calculations.

Multiple Tables
02:36
Example 3: Mortgage Extra Payment Calculator
15:38
Example 4: Personal Book Inventory
14:04
+ Cell Borders and Coloring
4 lectures 28:03
Borders
04:13
Cell Backgrounds
02:29
Conditional Highlighting
02:38
Example 5: Student Grade Tracker
18:43
+ Creating Charts
5 lectures 17:13
Creating Charts
01:46
Chart Settings
03:11
Multi-Column Charts
02:11

Learn how to use pie charts to visualize parts of a whole.

Pie Charts
02:27
Example 6: Sales Charts
07:38
+ Designing Spreadsheets
6 lectures 31:16
Adding Shapes
04:00

Learn how to add independent text to a spreadsheet to help explain your data.

Text Boxes
02:03
Adding Images
02:47
Layout and Design
03:25
Example 7: Product Sheets
09:47
Example 8: Football Squares
09:14
+ Complex Formulas
8 lectures 34:02
IF Statements
01:47
AND, OR, NOT
01:58
Durations
01:58
Example 9: Due Dates
07:35
The LOOKUP Function
02:49
The INDIRECT Function
04:35
Text Functions
03:05
Example 10: Chore Chart
10:15
+ Exporting and Advanced Topics
5 lectures 32:01
Merging Cells and Wrapping
03:52
Exporting
02:34
Using iCloud to Share Numbers Documents
03:32
Example 11: Physics Experiment
13:39

A more detailed look at the AND, OR and NOT functions including an example of how to use AND and OR in an IF statement.

Another Look at AND, OR, NOT
08:24
+ Numbers Updates
4 lectures 22:07

Learn about new features in 4.1:

  • Live Stock and Currency Functions
  • New Stock Portfolio template
  • Pie chart leader lines
  • Replace missing fonts


New Features in Numbers 4.1
07:24

See how more than one person can work on the same document at the same time.

Collaboration
03:49

Numbers version 5.0 is a minor update, but it does include some useful new features like Donut Charts and Improved Data importing options.

New Features in Numbers 5.0
04:58

In Numbers 5.2 (September 17, 2018) Apple adds the Smart Categories feature, which is similar to Pivot Tables in Excel and other spreadsheets.

Smart Categories (Pivot Tables) in Numbers 5.2
05:56