Mac Numbers: Creating and Using Spreadsheets On Your Mac

Build spreadsheets, perform calculations, create charts and design forms with practical examples.
4.6 (112 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
409 students enrolled
$19
$80
76% off
Take This Course
  • Lectures 50
  • Length 4 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course 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.

What are the 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.

What am I going to get from this course?

  • 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

What is the target audience?

  • 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: The Basics
Using this Course
Preview
Article
02:55

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

01:23

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

01:39

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

02:11

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

02:31

Learn how to manipulate tables by moving and stretching.

Columns and Rows
Preview
01:34
Titles and Headers
01:43
Special Cell Formats
04:38
02:25

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

09:32

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.

Section 2: Using Formulas
02:12

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

02:41

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

Formula Functions
03:49
Footers
02:53
12:27

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

Section 3: Sorting, filtering and using multiple tables.
Sorting Rows
03:47
02:35

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

Using the COUNTIF Function
01:47
02:36

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

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

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

Example 6: Sales Charts
07:38
Section 6: Designing Spreadsheets
Adding Shapes
04:00
02:03

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

Adding Images
02:47
Layout and Design
03:25
Example 7: Product Sheets
09:47
Example 8: Football Squares
09:14
Section 7: Complex Formulas
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
Section 8: Exporting and Advanced Topics
Merging Cells and Wrapping
03:52
Exporting
02:34
Using iCloud to Share Numbers Documents
03:32
Example 11: Physics Experiment
13:39
08:24

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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Gary Rosenzweig, Producer and Host at MacMost, Author, Developer

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, ActionScript 3.0 Game Programming University, and Special Edition Using Director MX. He also has self-published titles such as 101 Mac Tips and The Practical Guide to Mac Security.

Gary has a computer science degree from Drexel University and a master’s degree in journalism from the University of North Carolina at Chapel Hill.

Ready to start learning?
Take This Course