Excel Tutorial Series

Excel 2003 and 2007

Each free Excel tutorial covers either an introductory or intermediate level topic in Microsoft Excel 2003 or 2007. Each tutorial will give you a good understanding of how to use Excel and what you can accomplish with the program.

Entering Data in Excel 2003 Tutorial

This tutorial covers the basics of entering data into an Excel spreadsheet. Items covered include:

• The importance of planning your spreadsheet
• The types of data you can use in Excel
• How to enter data
• Editing cells to change data
• Widening columns

Excel 2003 Formulas Step by Step Tutorial

This step by step tutorial shows you:

• Step by step how to write a basic formula
• Using pointing to simplify writing formulas
• The importance of using cell references in formulas
• The different mathematical operators that can be used in formulas
• How to edit a formula.

Step by Step Excel 2003 Chart Tutorial

This tutorial covers all the steps necessary for creating a chart using the Chart Wizard in Microsoft Excel. The tutorial begins by discussing the best practices for entering the chart data and then walks you through each of the four screens of the Chart Wizard.

Basic Formatting in Excel 2003 - Tutorial Part 1

Part I of this two part tutorial covers:

• Using currency, percent, and comma number formatting
• changing cell colors
• adding text formatting.

Basic Formatting in Excel 2003 - Tutorial Part 2

Part II of this tutorial completes the spreadsheet started in Part I and covers:

• changing the alignment of text in cells
• bolding text
• adding range names
• adding formulas
• using the NOW function

Creating a Database File in Excel 2003

This tutorial shows you how to create a database or list in Excel to keep track of valuable information such as phone numbers, DVD collections, or a contact list of your organization's members. Excel's built in tools make it easy to create lists and filter or sort them according to the criteria needed at the time.

Excel 2003's Print Options

Use the print options in Excel to print entire spreadsheets or just selected areas. This tutorial covers how the print options can be accessed through a number of locations including the print button on the standard toolbar and several options under the file menu.

Excel IF Function Step by Step Tutorial

This tutorial is applicable for both Excel 2003 and 2007. New to the IF function? If so, and if you would like a walk through on building this valuable function one step at a time, than this tutorial is for you. Just like the title says, we build the IF function step by step - with explanations and examples included to help you out.

Basic Excel 2007 Formula Tutorial

This tutorial covers how to create basic formulas in Excel 2007. Topics covered including entering data and using cell references and pointing to simplify the process.

Excel 2007 Column Chart Tutorial

This tutorial covers creating a column chart in Microsoft Excel 2007. This tutorial includes a step by step example of creating a column chart using the commonest features in this latest version of Excel.

Excel 2007 Pie Chart Tutorial

This tutorial covers creating a pie chart in Microsoft Excel 2007. This tutorial includes a step by step example of creating a pie chart using the commonest features in this latest version of Excel.

Excel 2007 Formatting Tutorial

This tutorial covers formatting Excel 2007 spreadsheets. The topics covered include

• Adding the date and a named range
• Adding formulas
• Applying styles
• Changing data alignment in cells
• Number formatting - percent and currency
• Changing font color