Spreadsheets are useful for managing data sets as tables and lists, for visualizing data using charts, and for data analysis of all kinds.
The widespread availability and ease of use of spreadsheets makes them an ideal mathematical tool for adult learners.
In this series of tutorials we demonstrate spreadsheet skills and techniques that you can use for data management and analysis.
The tutorials are divided into five groups. The introduction describes the terms used throughout the series.
The Introduction
Basic Skills: Working with Tables Part One: Moving a table Part Two: Formatting the table Part Three: Organizing and Sorting
Intermediate Skills: Working with Functions Basic Techniques Cell Referencing
Intermediate Skills: Charting Create A Basic Chart Understanding the Chart Wizard Copying a chart to another program Line Charts: the basics Line Charts: Advanced techniques and comparison with XY charts XY (Scatter) charts: the basics XY (Scatter) charts: plotting a function Pie Charts 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 Inference From Charts: Trend Lines and correlation Regression Analysis Least Squares
Advanced Skills: Data Analysis Making use of data copied from a web page in Excel
Narrated Excel Tutorials
Level: Introductory to Advanced
20 narrated tutorials on topics ranging from data management using a spreadsheet to data analysis.
© 2006, Empire State College
