Table of Contents

FastCourse Excel 2007
(back to Class Materials) (back to Course List)

Level 1 | Level 2 | Level 3

Level 1

• Exploring Excel 2007 

  • Presenting Excel 2007

  • Start Excel

  • Exploring the Excel Program Window

  • Using Worksheets and Workbooks

  • Mousing Around in Excel

  • Scrolling Along in a Worksheet

  • Navigating in a Worksheet

  • Working with Tabs and Ribbons

  • The Office Button

  • The Quick Access Toolbar

  • Displaying Tabs and Working with Ribbons

  • Hiding the Ribbon

  • Entering Data in Excel

  • Data Types

  • Completing Cell Entries

  • the Enter and Cancel Buttons

  • Deleting and Replacing Entries

  • Long Text Entries

  • Working with Numbers

  • Number Formats

  • Decimals and Negative Numbers

  • Understanding Save Concepts

  • The Save Command

  • Save As Options

  • Closing Workbooks

  • Exiting from Excel

• Editing, Viewing, and Printing Worksheets

  • Opening Workbooks

  • Editing Entries 

  • Replacing Entries 

  • Deleting Characters 

  • Selecting Cells and Ranges 

  • Excel Ranges 

  • Working with Cut, Copy, and Paste 

  • The Office Clipboard 

  • Moving Cells via Drag and Drop 

  • Editing Cells via Right-Dragging 

  • Using Undo and Redo 

  • Undoing Multiple Actions 

  • Clearing Cell Contents and Formats 

  • Using Auto Features 

  • Working with AutoFill 

  • AutoFill Options 

  • AutoComplete vs. AutoFill 

  • Exploring the Many Views of Excel 

  • Working in Page Layout View 

  • Zooming the View 

  • Printing Worksheets 

  • Print Preview 

  • Print the Worksheet 

  • Printing Selections 

• Working with Formulas and Functions

  • Working with Formulas and Functions

  • Using AutoSum

  • Status Bar Functions and Customization

  • Creating Formulas

  • Beginning Character in Formulas

  • Cell and Range References

  • The Language of Excel Formulas

  • Please Excuse My Dear Aunt Sally

  • Using Cell References in Formulas

  • Relative Cell References

  • Point Mode

  • Absolute Cell References

  • Mixed References

  • Using the (F4) Function Key

  • What-If Analysis

  • Modifying and Copying Formulas

  • Modifying Formulas

  • Copying Formulas

  • Displaying Formulas

  • Using Formula AutoComplete

  • Functions Defined

  • Using the Function Wizard

  • Inserting Date and Time Functions

• Changing the Appearance of Worksheets

  • Modifying Columns and Rows

  • Column Widths and Row Heights

  • Standard Column Widths and Row Heights

  • AutoFit

  • Inserting and Deleting Columns, Rows, and Cells

  • Inserting and Deleting Rows and Columns

  • Inserting and Deleting Cells

  • Hiding Columns and Rows

  • Unhiding Columns and Rows

  • Changing Vertical Alignment and Rotating Text

  • Setting Vertical Alignment

  • Rotating Text

  • Using Excel’s Find and Replace Command

  • Replacing Cell Formats

  • Using AutoCorrect

  • Expanding AutoCorrect Entries

  • Undoing AutoCorrect Entries

  • Creating and Editing AutoCorrect Entries

  • Using Excel’s Help Feature

  • The Help Box

  • Finding Help When You Need It

  • The Help Window Toolbar

  • Using Excel’s Proofing Tools

  • Spelling Checker

(back to top)

Level 2

• Discovering the Magic of Excel Charting

  • Managing Worksheets

  • Inserting and Deleting Worksheets

  • Rearranging, Renaming, and Formatting Worksheets

  • Storing Your Exercise Files

  • Creating Charts in Excel

  • Integrated Chart Engine

  • Introducing OfficeArt

  • Creating New Charts

  • Choosing the Proper Source Data

  • Chart Types

  • Column Charts and Bar Charts

  • Category Axis and Value Axis

  • Chart and Axis Titles

  • The Chart Tools

  • Moving and Sizing Embedded Charts

  • Moving Embedded Charts

  • Sizing Embedded Charts

  • Deleting Charts

  • Exploring Other Chart Types

  • Line Charts

  • Pie Charts

  • Previewing and Printing Charts

  • Modifying Existing Charts

  • Changing the Chart Type

  • Modifying Chart Elements

  • Formatting Charts

  • Applying Styles to Charts

  • Formatting Attributes Controlled by the Selected Style

  • Viewing All Available Styles for a Type

• Working with Large Worksheets

  • Sorting Worksheet Data

  • Sorting by a Single Column

  • Sorting Selected Rows

  • Sorting by Multiple Columns

  • Using Flexible Worksheet Views

  • Freezing Rows or Columns

  • Splitting the Worksheet Window

  • Printing Multipage Worksheets

  • Setting Print Format in Page Layout View

  • Page Layout Ribbon

  • Sizing Options

  • Headers and Footers

  • Setting Title Rows and Columns

  • Sheet Options

  • Working with Page Break

• Adding Graphics to Worksheets

  • Using Illustrations with Excel

  • Design Principles

  • The Illustrations Group on the Ribbon

  • Inserting Pictures and Clip Art

  • Inserting a Picture from a File

  • Inserting Clip Art

  • Moving, Sizing, and Rotating Images

  • Scaling and Cropping Images

  • Adjusting Images and Special Effects

  • Getting into Shapes

  • Inserting Shapes

  • Introducing SmartArt

  • Using SmartArt

  • Adding Text to SmartArt

  • Formatting SmartArt

• Using Templates and Protecting Workbooks

  • Using Templates

  • Template Features

  • The New Workbook Dialog Box

  • Template Storage Locations

  • Customizing Templates

  • Creating Your Own Templates

  • Modifying Custom Templates

  • Protecting Workbooks and Worksheets

  • Protecting the Workbook Structure

  • Protecting Worksheet Elements

  • Password Protection

  • Protecting Cells

  • Creating Digital Signatures

  • When to Use a Digital Signature

  • Creating a Digital Certificate

  • Creating a Digital Signature

• Managing Multiple-Sheet Workbooks

  • Using Multiple Worksheets

  • Modifying the Default Number of Sheets

  • Linking Cells and Formulas

  • Why Link Cells?

  • Linking Formulas

  • Copying Worksheets

  • The Move or Copy Dialog Box

  • Copying Formats between Worksheets

  • Naming Cells and Ranges

  • Naming Rules

  • Creating Defined Names

  • Using Defined Names

  • Modifying and Deleting Defined Names

  • Creating Hyperlinks

  • Types of Hyperlinks

  • Insert Hyperlink Dialog Box

  • Editing and Removing Hyperlinks

  • Printing Multiple-Sheet Workbooks

  • Applying Page Setup Options to Multiple Sheets

  • Printing All Sheets in a Workbook

  • Printing Selected Sheets

(back to top)

Level 3

• Creating Tables and Outlines

  • What Happened to Excel Databases?

  • Why Use a Table?

  • Working with Tables

  • Table Rows

  • Table Columns

  • Creating a Table

  • Converting a Range to a Table

  • Creating a New Blank Table

  • Renaming a Table

  • Storing Your Exercise Files

  • Header Row

  • Total Row

  • Formatting a Table

  • Adding and Deleting Rows and Columns

  • Selecting Table Rows and Columns

  • Calculated Columns

  • Converting a Table to a Range

  • Printing a Table

  • Deleting a Table

  • Understanding Structured References

  • Formulas with Structured References

  • Using Enhanced Sorting and Filtering

  • Sorts

  • Filters

  • Custom Filters

  • Using the Outline Feature

  • How Outlines Work

  • Auto Outline

  • Creating Groups Manually

  • Displaying Subtotals

  • Sorting the List

  • The Subtotal Dialog Box

• Creating PivotTables and Macros

  • Creating PivotTables

  • PivotTable Example 1

  • PivotTable Example 2

  • How PivotTables Work

  • Formatting a PivotTable

  • Changing PivotTable Fields

  • Filtering the Display of Data Items

  • Filtering a PivotTable Report

  • Editing PivotTable Calculations

  • Refreshing PivotTable Data

  • Creating PivotCharts

  • PivotChart Filter Pane

  • Formatting PivotCharts

  • Changing Macro Security

  • Security Levels

  • Recording Macros

  • Naming a Macro

  • Recording Macro Steps

  • Storing Macros

  • Saving a Workbook Containing Macros

  • Running Macros

  • Assigning Macros

  • Assigning Macros to Shortcut Keys

  • Assigning Macros to Custom Buttons

• Using Financial Functions and Data Analysis
  

  • Creating Financial Functions

  • PMT and FV Functions

  • Financial Function Syntax

  • Using Data Analysis Tools

  • Using Goal Seek

  • Using Solver

  • Scenario Manager

  • Using the Analysis ToolPak

• Auditing and Additional Functions

  • Using 3-D Cell References in Formulas

  • Why Use a 3-D Reference?

  • Creating a 3-D Reference

  • Introducing Lookup Functions

  • Lookup Function Syntax

  • How the VLOOKUP Function Works

  • Sorting a Table Array

  • Creating Formulas with the IF Function

  • IF Function Syntax

  • How the IF Function Works

  • Creating Formulas Using Criteria IF Functions

  • Function Syntax

  • How the SUMIF Function Works

  • How the COUNTIFS Function Works

  • Tracing Formulas

  • The Formula Auditing Tools

  • Tracing Precedents

  • Tracing Dependents

  • Auditing Formula Errors

  • Auditing Single Cells

  • Error Checking in Multiple Cells

  • Tracing Errors

  • Evaluating Formulas

  • Keeping Tabs in the Watch Window

• Using Advanced Formatting and Analysis Tools
  

  • Working with Grouped Worksheets

  • Grouping Worksheets

  • Ungrouping Worksheets

  • Consolidating Worksheet Data

  • Consolidation Functions

  • Types of Consolidation

  • Creating Links to Source Data

  • Working with Data Validation
    

  • Circling Invalid Data
    

  • Working with Conditional Formatting

  • Using Presets and Multiple Conditions

  • Creating a Conditional Formatting Rule

  • Formatting and Filtering with Graphics

  • Using Data Tables

  • One-Variable Data Tables

  • Two-Variable Data Tables

  • Creating Trendlines

(back to top)