Course Highlights
- Learn to write advanced formulas and use functions such as IF, HLOOKUP
and DSUM.
- Collaborate with team members using Excel's comments, security and
data validation options.
- Save time with Excel's table and list management features, including
AutoFilter and Automatic Subtotals.
- Create and use interactive PivotTables to summarize and retrieve sets
of data on the fly.
About This Course
This Microsoft Office Excel course teaches you how to effectively use
the Excel for Mac through comprehensive lessons and engaging quizzes,
allowing the user to choose which lesson to learn. New users will be guided
through the fundamentals of the Excel 2008 for Mac interface, while experienced
users will be brought up to speed on the new navigation and functionality
of this 2008 edition.
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
| 
