Microsoft Excel 2007 & 2010 Content

Introduction to Excel 2007

 

Chapter 1:  Getting Started

  • Spreadsheet Terminology
  • Exploring the Excel Window
  • Getting Help
  • Navigating Workbooks

Chapter 2:  Entering and Editing Data

  • Entering and Editing Text and Values
  • Entering and Editing Formulas
  • Working with Pictures
  • Saving and Updating Workbooks

Chapter 3:  Modifying a Worksheet

  • Moving and Copying Data
  • Moving and Copying Formulas
  • Absolute and Relative References
  • Inserting and Deleting Ranges, Rows, and Columns

Chapter 4:  Using Functions

  • Entering Functions
  • Auto Sum
  • Other Useful Functions

Chapter 5:  Formatting Worksheets

  • Formatting Text and Numbers
  • Formatting Rows and Columns
  • Conditional Formatting
  • Copying Formats and Applying Table Formats

Chapter 6:  Printing

  • Preparing to Print
  • Page Setup Options
  • Printing Worksheets

Chapter 7:  Creating Charts

  • Chart Basics
  • Modifying Charts
  • Printing Charts

Chapter 8:  Managing Large Workbooks

  • Viewing Large Worksheets
  • Printing Large Worksheets
  • Using Multiple Worksheets

Intermediate Excel 2007

Chapter 1:  Using Multiple Worksheets and Workbooks

  • Using Multiple Workbooks
  • Linking Worksheets with 3-D Formulas
  • Linking Workbooks
  • Managing Workbooks

Chapter 2:  Advanced Formatting

  • Using Special Number Formats
  • Using Functions to Format Text
  • Working with Styles
  • Working with Themes
  • Other Advanced Formatting

Chapter 3:  Outlining and Subtotals

  • Outlining and Consolidating Data
  • Creating Subtotals

Chapter 4:  Cell and Range Names

  • Creating and Using Names
  • Managing Names

Chapter 5:   Lists and Tables

  • Sorting and Filtering Lists
  • Advanced Filtering
  • Working with Tables

Chapter 6:  Web and Internet Features

  • Saving Workbooks as Web Pages
  • Using Hyperlinks
  • Distributing Workbooks

Chapter 7:  Advanced Charting

  • Chart Formatting Options
  • Combination Charts
  • Graphic Elements

Chapter 8:  Documenting and Auditing

  • Auditing Features
  • Comments in Cells and Workbooks
  • Protection

Chapter 9:  Templates and Settings

  • Application Settings
  • Built-In Templates
  • Creating and Managing Templates

Advanced Excel 2007

Chapter 1:  Advanced Functions

  • Logical Functions
  • Math and Statistical Functions
  • Financial Functions
  • Displaying and Printing Formulas

Chapter 2:  Lookups and Data Tables

  • Using Lookup Functions
  • Using Match and Index
  • Creating Data Tables

Chapter 3:  Advanced List Management

  • Validating Cell Entries
  • Exploring Database Functions

Chapter 4:  Pivot Tables and Pivot Charts

  • Working with Pivot Table
  • Rearranging Pivot Tables
  • Formatting Pivot Tables
  • Pivot Charts

Chapter 5:  Exporting and Importing

  • Exporting and Importing Text Files
  • Exporting and Importing XML Data
  • Querying External Databases
  • Querying External Databases

Chapter 6:  Analytical Options

  • Goal Seek and Solver
  • The Analysis Toolpak
  • Scenarios
  • Views

Chapter 7:  Macros and Custom Functions

  • Running and Recording a Macro
  • Working with VBA Code
  • Creating Functions

Chapter 8:  Conditional Formatting and Smart Art

  • Conditional Formatting with Graphics
  • Smart Art Graphics