Mac Numbers

Build spreadsheets, perform calculations, create charts and design forms with practical examples.

Last updated 2022-01-10 | 4.7

- Create single and multi-table spreadsheets in Numbers
- Use formulas to perform calculations
- Create simple lists of records as spreadsheets

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

9 sections • 54 lectures

The Basics 11 lectures

Using this Course Preview 00:52

Introduction Preview 02:55

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

Getting Started Preview 01:23

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

Documents, Sheets, Tables, and Cells Preview 01:39

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

Cells Preview 02:11

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

Tables Preview 02:31

Learn how to manipulate tables by moving and stretching.

Columns and Rows Preview 01:34

Titles and Headers Preview 01:43

Special Cell Formats Preview 04:38

Formula Basics Preview 02:25

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

Example 1: Business Trip Expenses Preview 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.