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