## Spreadsheet Tutorials

Spreadsheets are useful for:

- organizing and presenting data
- for visualizing data using charts
- for data analysis of all kinds.

In this series of tutorials we demonstrate spreadsheet skills and techniques that you can use for data management and analysis using Microsoft Excel 2000. Much of the material covered here is conceptual and will apply in any version of Excel, or some other spreadsheet. In a few cases what you’ll see in your spreadsheet may be different and you’ll need to find the equivalent command or feature in your spreadsheet.

The introduction describes the terms used throughout the series.

**Terms and Techniques
**The Introduction

**Basic Skills: Organizing, Formatting, Importing Data**

Part One: Moving a table

Part Two: Formatting the table

Part Three: Organizing and Sorting

Making use of data copied from a web page in Excel

**Intermediate Skills: Working with Functions
**

Basic Techniques

**Intermediate Skills: Charting**

Create A Basic Chart

Understanding the Chart Wizard

Line Charts: Advanced techniques and comparison with XY charts

XY (Scatter) charts: the basics

XY (Scatter) charts: plotting a function

Histograms Part One: Creating a histogram manually

Histograms Part Two: Using the Data Analysis Toolpak

Installing the Data Analysis Toolpak

Pareto Charts: Create a Pareto chart

**Advanced Skills: Statistics and Data Analysis**

Summary Statistics