Chapter 13. Spreadsheet Essentials

Lesson Files

Lessons > Lesson_13 > 13_Starter Budget.xls

Lessons > Lesson_13 > 13_Budget_End.numbers

Lessons > Lesson_13 > 13_Draft.png

Time

This lesson takes approximately 60 minutes to complete.

Goals

Create a basic to-do checklist and a travel budget

Work with templates in Numbers

Understand key spreadsheet terms

Convert a Microsoft Excel file into a Numbers spreadsheet

Add header rows, header columns, and footer rows

Format cell contents

Format a table using styles

Use formulas and functions to calculate cell values

Add and resize a graphic object

Size and print a spreadsheet

Save a spreadsheet as a PDF or an Excel file

Numbers is an easy-to-use spreadsheet program with a flexible, free-form canvas that you can ...

Get Apple Training Series: iWork ’09 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.