Excel for Mac Training | Chicago & Los Angeles

Fast Facts

Duration
1 day

Class Size
Max 12 students

Times
9.00am to 4.30pm

Computer
One per student

Training Manual
Included

Price
Quote only

Excel 2008 for Mac - Level 1

Course Outline

Course Description

This Excel Level 1 class is designed for Mac users who are new to Microsoft Excel 2008. The course is hands-on where attendees will learn to create, modify, format and print Excel spreadsheets. You will learn to use basic formulas and functions and manage large spreadsheets.Find out more about our Excel 2007 and 2010 classes.

Target Audience

This Excel 2008 class is aimed at students new to Excel who need to produce reports, budgets, lists and other spreadsheets. No prior knowledge of Microsoft 2008 Excel is required, however it would be beneficial to have a general understanding of Apple computers.

Learning Objectives

Upon successful completion of this Excel training course students will be able to:

Explore the Microsoft Excel 2008 Environment.
Create a Basic Spreadsheet.
Create Formulas to Perform Basic Calculations.
Modify a Spreadhseet.
Format the Look and Feel of a Spreadsheet.
Print Excel Spreadsheets.
Manage Large Spreadsheets.

This class is currently not offered as a public class. We can however provide a private class at our facilty or an on-site class for groups for 2 or more. Please call us for details.

Course Outline

Unit 1: Creating a Basic Spreadsheet

Explore the User Interface
Navigate and Select in Excel
Obtain Help
Enter Data and Save a Spreadsheet
Customize the Quick Access Toolbar

Unit 2: Performing Calculations

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions

Unit 3: Modifying a Worksheet

Manipulate Data
Insert and Delete Columns, Rows and Cells
Search for Data in a Spreedsheet
Spell Check a Spreadsheet

Unit 4: Formatting a Worksheet

Modify Fonts
Add Borders and Color to Cells
Change Column Width and Row Height
Apply Number Formats
Position Cell Contents
Apply Cell Styles

Unit 5: Printing Spreadsheet Contents

Print Spreadsheet Contents
Using Default Print Options
Set Print Options
Set Page Breaks

Unit 6: Managing Large Spreadsheets

Format Spreadsheet Tabs
Manage Spreadsheets in a Workbook
Manage the View of Large Spreadsheets