Mac Numbers: Creating and Using Spreadsheets On Your Mac
4.7 (177 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.
747 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mac Numbers: Creating and Using Spreadsheets On Your Mac to your Wishlist.

Add to Wishlist

Mac Numbers: Creating and Using Spreadsheets On Your Mac

Build spreadsheets, perform calculations, create charts and design forms with practical examples.
Bestselling
4.7 (177 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.
747 students enrolled
Created by Gary Rosenzweig
Last updated 4/2017
English
Current price: $40 Original price: $80 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Article
  • 11 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 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.
Curriculum For This Course
52 Lectures
04:09:40
+
The Basics
11 Lectures 31:24

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
2 Lectures 11:13

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
About the Instructor
Gary Rosenzweig
4.5 Average rating
1,366 Reviews
9,110 Students
8 Courses
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.