iWork Numbers 09 Introduction

Provided by WWP Training Ltd

Aims
This course is designed for new users of iWork Numbers. The course will cover all topics required create spreadsheets from setup, creating formulas, charting and also formatting and printing.

Prerequisites
Basic Mac Navigation is required.

Visit

Objectives
On completion of this course delegates will be able to:

Create and use iWork Numbers '09 Spreadsheets
Create Formulas and Tables
Create Charts
Format and Print Numbers Worksheets

Course Content

Numbers Basics

Launching Numbers

Exploring Templates Options

The user interface

File Management

Importing and Exporting Spreadsheets

Sheet Management

Customising the user interface

Working with Constant Values
Entering and Editing Text
Formatting Numbers and Dates
Conditional Formatting
Entering Special Characters

Using Formulas and Functions
Using the Formula bar and Formula Editor
Using cell references
Manipulating functions
Accessing Formula List view

Table Management
Adding tables and Table Contents
Using Table controls and Using Auto-fill capabilities
Working with rows, columns and cells
Table headers and footers
Table categories
Sorting table data
Creating reusable tables
Copying tables
Table Style Default Table Style
Using Address Book data

Working with Charts
Adding charts
Changing chart types
Modifying chart data
Adding data to a chart from multiple tables
Using Multiple-axis charts
Chart attributes
Adding trend lines and error bars
Formatting 3D charts
Linking charts to Keynote/ Pages

Working with Objects
Manipulating text boxes
Creating bulleted & numbered lists and paragraph formatting
Managing Shapes
Manipulating images
Masking objects
Instant Alpha Tool
Aligning and layering objects
Adding media files

Spreadsheet Sharing

Password-protecting and emailing spreadsheets

Creating Spreadsheet Templates
Creating and saving templates
Creating Media Placeholders

Creating Spreadsheet Templates
Creating and saving templates

Proofing Tools
Using Spell Checker
Find and Replace tool

Printing Tools
Printing Options
Headers, Footers and Page numbering
Page Breaks