1. Home
  2. Computing & Technology
  3. Spreadsheets

Spreadsheet Lesson Plans

Spreadsheet Lesson Plans contain step by step examples that can be used as lessons for a wide range of age groups. Topics covered include creating and using spreadsheets, functions, graphing, formatting and creating formulas.
On What Day Was I Born?
Ever wonder "On what day was I born? Excel can help you find out. Use it to find what day of the week you were born on.
Basic Excel 2007 Spreadsheet Tutorial
This tutorial covers creating a basic spreadsheet in Excel 2007. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.
Basic Excel 2003 Spreadsheet Tutorial
This tutorial covers creating a basic spreadsheet in Excel 2003. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.
Excel Rolling Dice Tutorial
This Tutorial shows you how to create a dice roller program in Excel. The tutorial makes use of the IF, AND, OR, and RANDBETWEEN functions to simulate the rolling of a pair of dice. With step by step instructions it can be used as a lesson plan for senior students.
Create a Pictograph in Excel 2007
This step by step tutorial shows you how to create a pictograph in Excel 2007.
Create a Pictograph in Excel 2003
This tutorial covers creating a pictograph in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pictograph using the Chart Wizard.
Excel Timeline Template
Among the templates offered for free by Microsoft is one for creating a timeline in Excel. This template works in all versions from Excel 97 on. This article walks through how to download and use the timeline template in Excel.
Excel's Flow Chart Template
The simple flow chart template for Excel is one of several available from Microsoft. The template works in all versions of Excel from Excel 97 on.
Choosing the Right Graph - Excel Graphs and their Uses
This article covers the main types of Excel graphs and their uses. The graphs covered include the bar graph, line graph, scatter plot graph, and the pie chart.
Excel 2007 Pie Chart Tutorial
This free tutorial covers creating a pie chart in Microsoft Excel 2007. The tutorial includes a step by step example of creating a pie chart in the latest version of Excel.
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 in the latest version of Excel.
Excel 2007 Line Graph Tutorial
This tutorial covers creating a line graph in Microsoft Excel 2007. The tutorial includes a step by step example of creating a line graph in the latest version of Excel.
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.
Data for Step by Step Chart Wizard Example
Sample data to accompany the above step by step tutorial on using the Chart Wizard in Excel. Use this sample data to follow the steps in the Chart Wizard tutorial.
Step by Step Excel 2003 Bar Graph Tutorial
This tutorial covers creating a bar graph in Microsoft Excel 2003. The tutorial includes a step by step example showing how to create a bar graph using the Chart Wizard. See the related tutorial "Formatting a Bar Graph" below.
Formatting a Bar Graph
This article covers a number of formatting options for bar graphs in Excel. This tutorial is part 2 of the "Step by Step Excel 2003 Bar Graph Tutorial" above.
Fibonacci Numbers in Excel
Fibonacci numbers form a sequence. After two starting values, each additional value in the sequence is the sum of the two preceding numbers. This article shows you how to create Fibonacci Numbers in Excel.
Excel Lesson Plans and Other Teacher Resources
This site gives you innumerable links to lesson plans, sample files, and other activities for using Excel in the classroom.
Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Spreadsheet Lesson Plans

©2009 About.com, a part of The New York Times Company.

All rights reserved.