8 Excel 2007 Tutorials

Here 8 Excel 2007 Tutorials, hosted by the University of the Incarnate Word. These Excel tutorials introduce and demonstrate many of the most important Excel features, including how to create charts, using vertical lookups, page setup, creating formulas, and using database functions. These Excel tutorials are well illustrated with screen shots, and include exercises that will help you remember what you are learning. The necessary documents for the exercises can be downloaded from here.


Excel 2007  3.37 MB, 69 pages
This presentation introduces Excel 2007’s new features, such as Quick Access Toolbar, MS Office Button, Mini Toolbar & Ribbon.

Excel 2003 & 2007 Comparison
This document explains the differences between Excel 2003 and Excel 2007 by comparing the Menus and toolbars in Excel 2003 with the Excel 2007 Button and Ribbon.

Formatting Excel Worksheets  1.26 Mb, 22 pages
This Excel tutorial teaches how to Format Excel Cells, Columns, Rows, Worksheets, and Workbooks.

Vertical Lookup in Excel  223 Kb, 4 pages
This tutorial presents the vertical look up feature available in Excel 2007.

Creating Excel Charts  535 Kb, 11 pages
This Excel Chart tutorial teaches how to create an attractive and useful chart in Excel 2007.

Page Setup and Other Functions  1.04 Mb, 16 pages
Learn how to setup Excel pages using the page break, margins, headers and footers.

Excel Database Functions  339 Kb, 7 pages
This Excel tutorial explains the database functions such as sort and auto filter.

Excel Formulas   794 Kb, 17 pages
Describes the a variety of tools available in the formula tab and how to use the formulas effectively in Excel worksheets.