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
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
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