Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: The Basics|
Using this CoursePreview
Learn about the instructor and get an overview about what material will be covered in the course.
Learn how to create a new Numbers document on your Mac. Examine Apple’s built-in templates.
Learn how documents are made up of sheets, sheets are made of tables, and tables are made of cells.
Learn about tables and cells. Find out how to identify cells by row and column. Try entering data into cells.
Learn how to manipulate tables by moving and stretching.
Columns and RowsPreview
Titles and Headers
Special Cell Formats
Learn how to create simple formulas to perform computations on the numbers in cells.
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|
Learn about how cell references in formulas are relative and will update as you move the formula to other cells.
Learn how to create formulas that refer to specific cells, even if the formula moves to another cell.
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.|
Learn how to view only certain rows in a table based on specific criteria.
Using the COUNTIF Function
Use more than one table on a single sheet to keep your data organized when performing calculations.
Example 3: Mortgage Extra Payment Calculator
Example 4: Personal Book Inventory
|Section 4: Cell Borders and Coloring|
Example 5: Student Grade Tracker
|Section 5: Creating Charts|
Learn how to use pie charts to visualize parts of a whole.
Example 6: Sales Charts
|Section 6: Designing Spreadsheets|
Learn how to add independent text to a spreadsheet to help explain your data.
Layout and Design
Example 7: Product Sheets
Example 8: Football Squares
|Section 7: Complex Formulas|
AND, OR, NOT
Example 9: Due Dates
The LOOKUP Function
The INDIRECT Function
Example 10: Chore Chart
|Section 8: Exporting and Advanced Topics|
Merging Cells and Wrapping
Using iCloud to Share Numbers Documents
Example 11: Physics Experiment
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.
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.