Excel 2008 for Mac Training Course

Highlights of the Excel 2008 for Mac Training Course

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

Excel 2008 for Mac Training Course Summary

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.

Excel 2008 for Mac Training Course Contents

Microsoft Excel for Mac 2008: Beginner

• Getting Started
  • Launching Excel 2008
  • Touring the Excel Window
  • Save vs. Save As
  • About XML
  • Opening & Closing Files
  • Getting Help
• Entering Data
  • Navigation Techniques
  • Data Entry Techniques
  • AutoFill
  • AutoComplete
  • Undo & Redo
• Changing Worksheet Layout
  • Inserting Rows, Columns & Cells
  • Deleting Rows, Columns & Cells
  • Adjusting Column Widths & Row Heights
  • Hiding Columns & Rows
  • Moving & Copying Data
  • Creating Named Ranges
  • Go To, Find and Replace
• Entering Formulas
  • Anatomy of Formula
  • AutoSum
  • Basic Functions
  • Copying Formulas
• Formatting
  • Using the Formatting Palette
  • Number Formats
  • Merging & Splitting Cells
  • Using AutoFormat
• Printing
  • Changing Margins & Page Orientation
  • Exploring Worksheet Views
  • Adding Headers & Footers
  • Adding Print Titles and a Print Area
  • Viewing & Setting Page Breaks
• Charts
  • Creating an Embedded Chart
  • Creating a Chart Sheet
  • Adding & Removing Chart Data
  • Format & Resize Charts
• Recap

Microsoft Excel 2008 for Mac: Intermediate

• Managing Workbooks
  • Creating New Workbooks from a Template
  • Rename & Move Workbook Tabs
  • Insert & Delete Worksheets
  • Copy & Paste Worksheets
  • Splitting Your Worksheet View
  • Freezing & Unfreezing Your View
• List & Data Management
  • List Guidelines
  • Sorting
  • AutoFilter
  • Advanced Filter Using Single Criteria
  • Advanced Filter Using Multiple Criteria
  • Automatic Subtotals
• Using Cell References
  • Using Relative Cell References
  • Using Absolute Cell References
  • Using Mixed Cell References
• Auditing
  • About Auditing
  • Tracing Precedents
  • Tracing Dependants
  • Tracing Errors
• Creating Web Pages from Workbooks
  • Publishing a Web Page
  • Viewing Your Published Web Page
• Using Excel with Other Applications
  • Importing Data to Excel
  • Exporting Data from Excel
  • About XML
• Customizing Excel
  • Customizing Excel’s Toolbar
  • Modifying Excel Preferences
• Using Scenarios & Watching Cells
  • Creating & Displaying Scenarios
  • Editing & Removing Scenarios
  • Summarizing Scenarios
• PivotTables & PivotCharts
  • About Pivot Tables
  • Creating a Pivot Table
  • Modifying a Pivot Table
• Recap

Microsoft Excel 2008 for Mac: Advanced

• Collaborating
  • Inserting & Deleting Comments
  • Viewing & Printing Comments
  • Protect Workbooks, Worksheets & Cells
  • Enable Workbook Security
  • Share Workbooks
  • Working with Templates
• Advanced Formulas & Functions
  • IF Functions
  • Nested IF Functions
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the DSUM Function
• Data Consolidation
  • About Data Consolidation
  • Three Dimensional Formulas
  • Data Consolidation by Position
  • Data Consolidation by Category
• SmartArt
  • About SmartArt
  • Creating a List
  • Creating a Hierarchy
  • Creating a Pyramid
  • Editing SmartArt
• Track Revisions
  • Tracking Changes
  • Accepting & Rejecting Changes
• Data Validation & Conditional Formatting
  • Working with Data Validation Rules
  • Set Conditional Formatting
  • Use Expressions in Conditional Formatting
• Reca

Excel 2008 Training Course Instructor: Deanna Reynolds

Deanna Reynolds (MCTS) is an author and technical instructor living in Suffolk, Virginia. Since 1993, Deanna has been privileged to work with students traveling many different career paths on a multitude of software programs, including the entire Microsoft Office suite, project management, desktop publishing, and database development. Throughout her career, Deanna has led hundreds of computer productivity training sessions, from beginner through advanced levels.

Most recently, Deanna’s technical training has extended beyond the classroom to include more than 10 DVD-ROM courses for KeyStone Learning Systems and two published books: Word 2007 Pocket Book (Prentice Hall) and Managing Projects with Microsoft Office Project 2007 (Microsoft Press).