Microsoft Excel for Mac 2008: Beginner
1.0 Getting Started
1.1 Launching Excel 2008
1.2 Touring the Excel Window
1.3 Save vs. Save As
1.4 About XML
1.5 Opening & Closing Files
1.6 Getting Help

2.0 Entering Data
2.1 Navigation Techniques
2.2 Data Entry Techniques
2.3 AutoFill
2.4 AutoComplete
2.5 Undo & Redo

3.0 Changing Worksheet Layout
3.1 Inserting Rows, Columns & Cells
3.2 Deleting Rows, Columns & Cells
3.3 Adjusting Column Widths & Row Heights
3.4 Hiding Columns & Rows
3.5 Moving & Copying Data
3.6 Creating Named Ranges
3.7 Go To, Find and Replace

4.0 Entering Formulas
4.1 Anatomy of Formula
4.2 AutoSum
4.3 Basic Functions
4.4 Copying Formulas

5.0 Formatting
5.1 Using the Formatting Palette
5.2 Number Formats
5.3 Merging & Splitting Cells
5.4 Using AutoFormat

6.0 Printing
6.1 Changing Margins & Page Orientation
6.2 Exploring Worksheet Views
6.3 Adding Headers & Footers
6.4 Adding Print Titles and a Print Area
6.5 Viewing & Setting Page Breaks

7.0 Charts
7.1 Creating an Embedded Chart
7.2 Creating a Chart Sheet
7.3 Adding & Removing Chart Data
7.4 Format & Resize Charts

8.0 Recap

Microsoft Excel for Mac 2008: Intermediate
1.0 Managing Workbooks
1.1 Creating New Workbooks from a Template
1.2 Rename & Move Workbook Tabs
1.3 Insert & Delete Worksheets
1.4 Copy & Paste Worksheets
1.5 Splitting Your Worksheet View
1.6 Freezing & Unfreezing Your View

2.0 List & Data Management
2.1 List Guidelines
2.2 Sorting
2.3 AutoFilter
2.4 Advanced Filter Using Single Criteria
2.5 Advanced Filter Using Multiple Criteria
2.6 Automatic Subtotals

3.0 Using Cell References
3.1 Using Relative Cell References
3.2 Using Absolute Cell References
3.3 Using Mixed Cell References

4.0 Auditing
4.1 About Auditing
4.2 Tracing Precedents
4.3 Tracing Dependants
4.4 Tracing Errors

5.0 Creating Web Pages from Workbooks
5.1 Publishing a Web Page
5.2 Viewing Your Published Web Page

6.0 Using Excel with Other Applications
6.1 Importing Data to Excel
6.2 Exporting Data from Excel
6.3 About XML

7.0 Customizing Excel
7.1 Customizing Excel’s Toolbar
7.2 Modifying Excel Preferences

8.0 Using Scenarios & Watching Cells
8.1 Creating & Displaying Scenarios
8.2 Editing & Removing Scenarios
8.3 Summarizing Scenarios

9.0 PivotTables & PivotCharts
9.1 About PivotTables
9.2 Creating a PivotTable
9.3 Modifying a PivotTable

10.0 Recap

Microsoft Excel for Mac 2008: Advanced
1.0 Collaborating
1.1 Inserting & Deleting Comments
1.2 Viewing & Printing Comments
1.3 Protect Workbooks, Worksheets & Cells
1.4 Enable Workbook Security
1.5 Share Workbooks
1.6 Working with Templates

2.0 Advanced Formulas & Functions
2.1 IF Functions
2.2 Nested IF Functions
2.3 Using the VLOOKUP Function
2.4 Using the HLOOKUP Function
2.5 Using the DSUM Function

3.0 Data Consolidation
3.1 About Data Consolidation
3.2 Three Dimensional Formulas
3.3 Data Consolidation by Position
3.4 Data Consolidation by Category

4.0 SmartArt
4.1 About SmartArt
4.2 Creating a List
4.3 Creating a Hierarchy
4.4 Creating a Pyramid
4.5 Editing SmartArt

5.0 Track Revisions
5.1 Tracking Changes
5.2 Accepting & Rejecting Changes

6.0 Data Validation & Conditional Formatting
6.1 Working with Data Validation Rules
6.2 Set Conditional Formatting
6.3 Use Expressions in Conditional Formatting

7.0 Recap

Entourage 2008 Level 1

Introduction
1.0 Getting Started
1.1 Launching Entourage 2008
1.2 Touring the Entourage Window
1.3 Using the Navigation Pane
1.4 Getting Help

2.0 Reading & Sending E-Mail
2.1 Creating & Sending an E-Mail Message
2.2 Using the Address Book
2.3 Saving a Message as a Draft
2.4 Adding an Attachment to an E-Mail Message
2.5 Reading Messages
2.6 Viewing Attachments

3.0 Replying To & Forwarding Messages
3.1 Reply vs. Reply to All
3.2 Forwarding a Message
3.3 Understanding Message Icons in Your Inbox

4.0 Formatting Messages
4.1 Using the Formatting Toolbar
4.2 Marking Message Importance
4.3 Using the Find Feature

5.0 Working with E-Mail Addresses
5.1 Adding & Editing a Contact
5.2 Adding a Contact from an E-Mail Message
5.3 Sending a Message from Contact View
5.4 Creating & Using Distribution Lists

6.0 Managing Mail
6.2 Emptying Your Deleted Items Folder
6.4 Move & Copy Messages to a Folder
6.5 Renaming a Folder

7.0 Printing E-Mail Messages
7.1 Using the Print Dialog Box

8.0 Customizing Entourage
8.1 Customizing Entourage’s Toolbar
8.2 Modifying Entourage Preferences

9.0 My Day
9.1 Launching My Day
9.2 Customizing My Day

Microsoft PowerPoint for Mac 2008: Beginner
1.0 Getting Started
1.1 Launching PowerPoint 2008
1.2 Touring the PowerPoint Window
1.3 Save vs. Save As
1.4 About XML
1.5 Opening & Closing Files
1.6 Getting Help

2.0 Creating a New Presentation
2.1 Creating a New Presentation from a Template
2.2 Creating a New Presentation from Scratch
2.3 Adding & Editing Text
2.4 Undo, Redo, & Repeat

3.0 Viewing Presentations
3.1 Navigating Through a Presentation
3.2 Presentation Views
3.3 Using Slide Show View

4.0 Modifying an Existing Presentation
4.1 Slide Basics
4.2 Choosing a Design Theme
4.3 Working with Text Boxes
4.4 Formatting Text
4.5 Using Bullets & Numbering
4.6 Working with Indents & Line Spacing
4.7 AutoCorrect

5.0 Preparing a Presentation for Delivery
5.1 Using Spell Check
5.2 Using the Thesaurus & Research Pane
5.3 Working with Speaker Notes
5.4 Adding a Header & Footer
5.5 Printing

6.0 Recap

Microsoft PowerPoint for Mac 2008: Intermediate
1.0 Outlines
1.1 Adding & Editing Slides in Outline View
1.2 Formatting Slide Text in Outline View
1.3 Exporting a PowerPoint Outline

2.0 Working with Pictures and Shapes
2.1 Inserting ClipArt & Pictures
2.2 Drawing AutoShapes
2.3 Grouping & Ungrouping Objects
2.4 Layering Objects

3.0 Working with Themes
3.1 Applying Themes
3.2 Creating Custom Themes

4.0 Working with Animation
4.1 Adding Entrance & Exit Animation
4.2 Adding Emphasis
4.3 Assign the Order of Animation Effects

5.0 Organizing & Enhancing Your Presentation
5.1 Duplicating & Deleting Slides
5.2 Hiding Slides
5.3 Rearranging Slides
5.4 Adding Slide Transition

6.0 Managing Presentations
6.1 Inserting Slides from Other Presentations
6.2 Using Find & Replace

7.0 Customizing PowerPoint
7.1 Customizing PowerPoint’s Toolbars
7.2 Modifying PowerPoint Preferences

8.0 Recap

Microsoft PowerPoint for Mac 2008: Advanced
1.0 Working with Tables
1.1 Adding a Table to a Slide
1.2 Navigating & Selecting in a Table
1.3 Inserting & Deleting Columns and Rows
1.4 Formatting a Table

2.0 Working with Charts
2.1 Creating a Chart
2.2 Adding & Removing Chart Data
2.3 Formatting & Resizing a Chart

3.0 WordArt & SmartArt
3.1 Inserting a WordArt Object
3.2 Editing a WordArt Object
3.3 About SmartArt
3.4 Creating a List
3.5 Creating a Hierarchy
3.6 Creating a Pyramid
3.7 Editing SmartArt

4.0 Working with Templates, Masters & Custom Layouts
4.1 Creating and Editing a Custom Template
4.2 Working with Masters
4.3 Working with Custom Layouts

5.0 Saving Presentations for the Web
5.1 Adding a Hyperlink to a Slide
5.2 Publishing a Presentation to the Web

6.0 Collaboration
6.1 Inserting Comments
6.2 Viewing Comments
6.3 Editing Comments

7.0 Advanced Presentation Delivery Options
7.1 Working with Action Buttons
7.2 Annotating a Presentation
7.3 Using Slide Timings
7.4 Slide Show Options

8.0 Recap

Microsoft Word for Mac 2008: Beginner
1.0 Getting Started
1.1 Launching Word 2008
1.2 Touring the Word Window
1.4 About XML
1.5 Opening & Closing Files
1.6 Getting Help

2.0 Creating New Documents
2.1 Starting a New Document
2.2 Editing Text
2.3 Preview & Print a Document

3.0 Editing Existing Documents
3.1 Opening a Document
3.2 Navigating a Document
3.3 Working with Multiple Page Documents

4.0 Essential Word 2008 Skills
4.1 Selecting Text
4.2 Moving & Copying Text
4.3 Undo, Redo & Repeat
4.4 AutoCorrect

5.0 Formatting Text & Paragraphs
5.1 About Basic Font Formatting
5.2 Working with Text Formatting
5.3 Working with Line & Paragraph Spacing
5.4 Using Format Painter
5.5 Adding Symbols & Special Characters

6.0 Proofing Tools
6.1 Spelling & Grammar
6.2 Using the Thesaurus & Other Research Options
6.3 Checking Character & Word Count
6.4 Working with the Custom Dictionary
6.5 Editing in Print Preview

7.0 Changing Your Page Appearance
7.1 Changing Margins & Page Orientation
7.2 Working with Page Breaks
7.3 Adding Line Numbers

8.0 Recap

Microsoft Word for Mac 2008: Intermediate
1.0 Managing Documents
1.1 Document Views
1.2 Working with Multiple Documents
1.3 Saving Your Word Document as a Web Page

2.0 Additional Editing Tools
2.1 Go To, Find & Replace
2.2 Format Painter
2.3 AutoText

3.0 Paragraph Formatting
3.1 Bullets & Numbering
3.2 Tabs & Indents
3.3 Borders & Shading
3.4 Using Styles

4.0 Introduction to Graphics
4.1 Inserting ClipArt & Pictures
4.2 Inserting Watermarks
4.3 Using the Formatting Palette with Graphics
4.4 AutoShapes
4.5 Using Captions
4.6 WordArt
4.7 Using Publishing Layout View

5.0 Document Formatting
5.1 Section Breaks
5.2 Headers & Footers
5.3 Page Backgrounds & Page Borders
5.4 Drop Caps
5.5 Columns

6.0 Tables
6.1 Creating Tables
6.2 Creating Quick Tables
6.3 Navigating & Selecting in a Table
6.4 Inserting & Deleting Columns and Rows
6.5 Sorting
6.6 Formatting Tables
6.7 Performing Calculations in a Table
6.8 Converting a Table to Text

7.0 Customing Word
7.1 Customizing Word’s Toolbars
7.2 Modifying Word Options

8.0 Recap

Microsoft Word for Mac 2008: Advanced
1.0 Document Collaboration
1.1 Working with Templates
1.2 Using Track Changes
1.3 Inserting Comments
1.4 Merge Documents

2.0 Mail Merge
2.1 The Mail Merge Process
2.2 Walking Throught the Mail Merge Process
2.3 Form Letters
2.4 Envelopes
2.5 Labels

3.0 Working with Themes
3.1 Using Themes
3.2 Creating Custom Themes

4.0 SmartArt
4.1 About SmartArt
4.2 Creating a List
4.3 Creating a Hierarchy
4.4 Creating a Pyramid
4.5 Editing SmartArt

5.0 Long or Complex Documents
5.1 Bookmarks
5.2 Footnotes & Endnotes
5.3 Tables of Content

6.0 Recap