Microsoft Excel 2007 Foundations

Excel Basics

·          Creating an Excel Workbook

·          Examining the Excel Environment

·          Opening an Existing Workbook

·          Navigating a Worksheet

·          Creating a New Workbook

·          Saving a New Workbook

·          Moving Between Workbooks

·          Closing a Workbook and Exiting Excel

Working with Data

·          Entering Text and Numbers

·          Entering Simple Formulas

·          Choosing Formula Cell References Manually

·          Using AutoSum

·          Changing and Deleting Data

·          Using Undo and Redo

·          Using Find and Replace

·          Spell Checking Your Worksheet

Editing a Worksheet

·          Working with Ranges

·          Copying, Cutting, and Pasting Data

·          Copying and Moving Cells Using Drag
and Drop

·          Changing Column Width and Row Height

·          Inserting and Removing Columns and Rows

·          Copying Data and Formulas with AutoFill

Formatting a Worksheet

·          Formatting Text

·          Using the Format Cells Dialog Box

·          Formatting Values

·          Using the Format Painter Button

·          Alignment and Text Wrapping

·          Merging Cells and Centering Text

·          Adding Cell Borders

·          Applying Color and Shading to Cells

·          Applying Cell Styles

·          Hiding and Unhiding Rows and Columns

·          Freezing and Unfreezing Rows and Columns

·          Inserting and Removing Page Breaks

Page Setup and Printing

·          Adjusting Margins

·          Setting Page Orientation

·          Setting Paper Size

·          Defining a Print Area

·          Printing Worksheet Titles

·          Forcing a Worksheet to Fit

·          Inserting Headers and Footers

·          Printing a Worksheet

Formulas and Functions

·          Relative, Absolute, and Mixed References

·          Copying Formulas

·          Min, Max, Count, and Average Functions

·          The Insert Function Button

Modifying Workbooks

·          Adding and Deleting Worksheets

·          Copying, Renaming, and
Repositioning Worksheets

·          Grouping Worksheets

·          Changing Worksheet Tab
Colors

·          Using 3-D Formulas and
References