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.
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.
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.
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.
Learn how to view only certain rows in a table based on specific criteria.
Use more than one table on a single sheet to keep your data organized when performing calculations.
Learn how to use pie charts to visualize parts of a whole.
Learn how to add independent text to a spreadsheet to help explain your data.
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.