You are here: arrow Home arrow Guides arrow Spreadsheets

Spreadsheets Guides

 

Meet Me at A & 25th (Excel 2001) #276-1 (7 pages)

This guide includes fun, quick activities that will make working with data interesting and easy for you and your students. The following skills are covered in this tutorial:

  • creating worksheets
  • working with simple formulas
  • producing pie charts and bar graphs
  • modifying data in a spreadsheet

Download the Guide Order Form.


Top

 


Click on picture for first page of guide


 

Meet Me at A & 25th (Excel 2000) #276-2 (7 pages)

This guide includes fun, quick activities that will make working with data interesting and easy for you and your students. The following skills are covered in this tutorial:

  • creating worksheets
  • working with simple formulas
  • producing pie charts and bar graphs
  • modifying data in a spreadsheet

Download the Guide Order Form.

Top


Click on picture for first page of guide

Meet Me at A & 25th (Excel X) #276-3 (7 pages)

This guide includes fun, quick activities that will make working with data interesting and easy for you and your students. The following skills are covered in this tutorial:

  • creating worksheets
  • working with simple formulas
  • producing pie charts and bar graphs
  • modifying data in a spreadsheet

Download the Guide Order Form.

Top



Click on picture for first page of guide

Meet Me at A & 25th (Excel XP) #276-4 (7 pages)

This guide includes fun, quick activities that will make working with data interesting and easy for you and your students. The following skills are covered in this tutorial:

  • creating worksheets
  • working with simple formulas
  • producing pie charts and bar graphs
  • modifying data in a spreadsheet

Download the Guide Order Form.

Top



Click on picture for first page of guide

Create Pivot Tables #277-2 (10 pages)

Using Microsoft Excel 2000, you can create flexible reports called PivotTables and PivotCharts to analyze and manipulate data. This guide shows you how to:

  • set up the PivotTable
  • change PivotTable fields
  • create a PivotChart
  • use the PivotChart and PivotTable together

Download the Guide Order Form.

Top



Click on picture for first page of guide

Create Pivot Tables #277-3 (10 pages)

Using Microsoft Excel XP, you can create flexible reports called PivotTables and PivotCharts to analyze and manipulate data. This guide shows you how to:

  • set up the PivotTable
  • change PivotTable fields
  • create a PivotChart
  • use the PivotChart and PivotTable together

Download the Guide Order Form.

Top


Click on picture for first page of guide

Create Pivot Tables #277-4 (10 pages)

Using Microsoft Excel 2003, you can create flexible reports called PivotTables and PivotCharts to analyze and manipulate data. This guide shows you how to:

  • set up the PivotTable
  • change PivotTable fields
  • create a PivotChart
  • use the PivotChart and PivotTable together

Download the Guide Order Form.

Top


Click on picture for first page of guide

Import and Chart Data (Excel 2000) #278-2 (9 pages)

Microsoft Excel 2000 can import and manipulate data from a variety of sources, including text files derived from mainframes, databases, and other applications.This guide shows you how to:

  • import data from a tab-delimited text file
  • perform calculations
  • format data
  • create a chart

Download the Guide Order Form.

Top

 


Click on picture for first page of guide

Import and Chart Data (Excel XP) #278-3 (9 pages)

Microsoft Excel XP can import and manipulate data from a variety of sources, including text files derived from mainframes, databases, and other applications.This guide shows you how to:

  • import data from a tab-delineated text file
  • perform calculations
  • format data
  • create a chart

Download the Guide Order Form.



Top

 


Click on picture for first page of guide

Import and Chart Data (Excel 2003) #278-4 (10 pages)

Microsoft Excel 2003 can import and manipulate data from a variety of sources, including text files derived from mainframes, databases, and other applications.This guide shows you how to:

  • import data from a tab-delineated text file
  • perform calculations
  • format data
  • create a chart

Download the Guide Order Form.



Top

 


Click on picture for first page of guide

Data Tables and Lookups (Excel 2000) #279-2 (7 pages)

Using Microsoft Excel 2000, you can create data tables that show how changing variables in a formual can affect the outcome. With this guide you will be able to:

  • review raw data
  • add a worksheet
  • set up a table
  • use the Lookup feature
  • create a one and two input table
  • name the table range
  • format the table

Download the Guide Order Form.

Top

 


Click on picture for first page of guide

Data Tables and Lookups (Excel XP) #279-3 (7 pages)

Using Microsoft Excel XP, you can create data tables that show how changing variables in a formual can affect the outcome. With this guide you will be able to:

  • review raw data
  • add a worksheet
  • set up a table
  • use the Lookup feature
  • create a one and two input table
  • name the table range
  • format the table

Download the Guide Order Form.

Top

 


Click on picture for first page of guide

Data Tables and Lookups (Excel 2003) #279-4 (7 pages)

Using Microsoft Excel XP, you can create data tables that show how changing variables in a formual can affect the outcome. With this guide you will be able to:

  • review raw data
  • add a worksheet
  • set up a table
  • use the Lookup feature
  • create a one and two input table
  • name the table range
  • format the table

Download the Guide Order Form.

Top

 


Click on picture for first page of guide

Advanced Data Entry (Excel XP) #280-1 (8 pages)

Microsoft Excel XP provides several features to enhance data entry. With this guide, you will be able to:

  • apply conditional formatting
  • use alert messages nad pick lists for data validation
  • create input messages to provide instructions for data entry

Download the Guide Order Form.

Top

 


Click on picture for first page of guide

Advanced Data Entry (Excel 2000) #280-2 (8 pages)

Microsoft Excel 2000 provides several features to enhance data entry. With this guide, you will be able to:

  • apply conditional formatting
  • use alert messages nad pick lists for data validation
  • create input messages to provide instructions for data entry

Download the Guide Order Form.

Top

 


Click on picture for first page of guide

Advanced Data Entry (Excel 2003) #280-3 (9 pages)

Microsoft Excel 2003 provides several features to enhance data entry. With this guide, you will be able to:

  • apply conditional formatting
  • use alert messages nad pick lists for data validation
  • create input messages to provide instructions for data entry

Download the Guide Order Form.

Top

 


Click on picture for first page of guide

Create and Use Forms (Excel 2000) #281-1 (7 pages)

You can use forms in Microsoft Excel 2000 for a variety of purposes, including data entry, finding and filtering records, and automating common tasks. With this guide, you will be able to:

  • add and find new record
  • express with criteria expressions
  • start with ready-made forms
  • customize the form template

Download the Guide Order Form.

Top

 


Click on picture for first page of guide

Create and Use Forms (Excel XP) #281-2 (7 pages)

You can use forms in Microsoft Excel XP for a variety of purposes, including data entry, finding and filtering records, and automating common tasks. With this guide, you will be able to:

  • add and find new record
  • express with criteria expressions
  • start with ready-made forms
  • customize the form template

Download the Guide Order Form.

Top


Click on picture for first page of guide

Create and Use Forms (Excel 2003) #281-3 (7 pages)

You can use forms in Microsoft Excel 2003 for a variety of purposes, including data entry, finding and filtering records, and automating common tasks. With this guide, you will be able to:

  • add and find new record
  • express with criteria expressions
  • start with ready-made forms
  • customize the form template

Download the Guide Order Form.

Top


Click on picture for first page of guide