Excel 2008 for Mac Online / CBT Training Course

There have been many versions of Excel and since this one features a complete redesign from previous versions, training on how to us them is essential for both new and experienced users, which is why it is important for Mac users to take our Excel 2008 for Mac training course. Our course will teach you how to use the Open Document XML format, making it easier to share information with Windows users. Your Excel files created in a Mac are completely compatible with the Excel 2007 version that your Windows-based friends and co-workers use. Our certified instructors are leading professionals in the industry and have years of experience working with Mac applications and will teach you everything they know when taking our course.

Available Learning Formats

CD
Online
Network Deployable

Excel 2008 for Mac Training via Online

We offer our online Excel 2008 for Mac training videos that get you familiar with the program so that you can be on your way creating spreadsheets and charts that will impress all who see them. The online computer training course helps you learn faster and retain the information longer through full-motion training videos that are instructor-led and features discussions, presentations, demos and even hands-on practice activities that are fun and informative. With the Excel 2008 for Mac online training program, learning is completely up to you since you get to be in charge of when and how you want to learn.

Excel 2008 for Mac CBT Training Videos on CD / DVD

The self-study Excel 2008 for Mac CBT course also offers the wonderful combination of instructor-led schooling with self-guided, which is why we created the course so that you can learn on your own time. All learning is done directly from your computer and all you need to learn is our Excel 2008 for Mac training CD since everything else in included in the course. With the self-paced Excel 2008 for Mac computer based training videos, you get to set the pace and can learn Excel as quickly or slowly as you need.You'll get a firsthand look at Excel in action, and see it demonstrated by a certified instructor without having to take time off from work to attend workshops and classes by enrolling in our computer based training program.

Excel 2008 for Mac Training Outline:

Excel 2008 for Mac Basic

1.0 Exploring Excel

Exploring the Excel Window
The Elements Gallery
Opening and Closing Workbooks
New Blank Workbooks
Viewing Worksheets
Saving Workbooks
Exiting from Excel

2.0 Working with Cells Rows and Columns

Views of Excel
Entering Data in Excel
Column and Row Size
Selecting
Working with Cut Copy and Paste
Working with AutoFill
Inserting and Deleting Rows and Columns

3.0 Using Formulas and Functions

Understanding Formulas
Creating Formulas
Moving and Copying Formulas
Using Functions
Showing Formulas

4.0 Formatting Worksheet Data

Formatting Numbers
Merging and Splitting Cells
Aligning and Indenting Data
Borders and Fill Colors
Spell Check

5.0 Charts

Creating Charts
Editing Charts

6.0 Printing

Printing

Excel 2008 for Mac Advanced

1.0 Worksheet Editing Techniques

Renaming Worksheets
Inserting and Deleting Worksheets
Copying and Moving Worksheets
Grouping and Editing Sheets
Navigating Large Workbooks
Freezing Columns and Rows
Continuing Titles
Headers and Footers
Page Breaks

2.0 Using Excel Databases

Setting Up Your Database
Using Data Forms
Finding and Deleting with Data Forms
Sorting Records
Data Validation
Filtering Data
Creating an Outline
Displaying Subtotals

3.0 Advanced Formulas and Functions

Linking Formulas
Using Named Ranges
The If Function
Financial Functions
Hlookup Functions
Vlookup Functions

4.0 Protection

Protecting Workbooks
Protecting Worksheets

5.0 PivotTables

Creating a PivotTable
Formatting a PivotTable

6.0 PivotTables

Exporting Data as a Text File
Importing Data From a Text File