Getting Started

Microsoft Excel 2007 Introduction
Learn the basics of using Microsoft Excel 2007.   Includes and explanation of columns, rows, and cells.

Quick Access Toolbar
Easily access common used commands by using the Quick Access Toolbar.  Also learn how to customize the Quick Access Toolbar.

Understanding Column and Row Headings
Learn the basics of using Microsoft Excel 2007.   Includes and explanation of columns, rows, and cells.

Saving a Spreadsheet
There is more than one way to save an Excel spreadsheet.  There are also options that can be selected to save a spreadsheet in different formats.

Formatting Cells and Data

Format Font, Size and Color
Format text in a cell by changing the font, the size, or the color. Learn to apply Bold, Italic, or Underline characteristics to text in a cell.

Modify the Appearance of Data Using Bold, Italic, and Underline
Using Bold, Italic, and Underline features allows you to highlight portions of a spreadsheet.

Modify the Alignment of Data 
There is more than one way to change the alignment of text in a single cell or a series of cells.

Fill a Cell with Color
Add visual interest to a spreadsheet by using color to fill cells.  This is a great way to draw attention to a particular cell or series of cells.

Using the Fill Handle
Use the Fill Handle to copy formulas and values to other cells.  The Fill Handle is a great time saver.  Several examples of different ways to use it are explained.

Format Data in a Cell as a Percentage
Excel 2007 offers an easy way to format data as a percentage.

Remove all Formatting
Remove all formatting from cells in an Excel 2007 spreadsheet.  The Select All option is explained.

Merge and Center
Center information above a range of cells using the Merge and Center command.

Modifying a Worksheet

Insert Columns and Rows in Excel
Insert columns and rows into an existing spreadsheet. 

Select Cells, Rows, or Columns
Learn how to select a single cell, a series of cells, a complete row or a complete column or cells.

Set the Page Margins
Choose a default margin setting or learn how to customize the size of the margins.

 

Working with Multiple Sheets

Renaming Worksheets and Moving Between Worksheets
Manage the sheets that make up your Excel 2007 workbook.  You can rename an existing worksheet.

Insert a New Worksheet
By default a workbook has three worksheets.  New worksheets can be added.

Delete an Existing Worksheet
Delete a worksheet from an Excel 2007 workbook.

Change Worksheet Tab Colors
Customize a worksheet by changing the color of the tab. 

 

Printing Excel Documents

Print Preview
Use Print Preview to see what an excel document will look like when you print it.   This gives you the chance to make changes before actually printing.

Setting Page Orientation
By default an Excel spreadsheet will be set to portrait.  It can easily be changed to landscape so that wide spreadsheets can be printed on a page.

Scale to Fit
The Scale to Fit option allows you to force the spreadsheet to print on a set number of pages.  Scale to Fit can apply to either the height or width of the document.