Here are 9
Free Excel Training Tutorials from NC State
Univeristy that will help you Visualize and Present Data in
Excel. The first two tutorials show you the basics of getting
the data into the cells and then creating graphs from the data.
The remaining Excel tutorials demonstrate and teach Advanced
Excel Techniques for formatting, displaying and graphing your
data in Excel.
Data
Input Into Excel Cells
Teaches you how
to enter your data into Excel's cells,
select and specify cell ranges, create formulas to manipulate your
data, and format data values for display.
Creating
a Scatter Plot and Line Graph in Excel
Shows
you how to create a scatterplot and a simple line graph from
your data
Excel
Bar Graphs and Histograms
How to create
both single and multiple bar
graphs. Learn how and what a histogram is used for. Also find
out how
to use the Frequency function so you can transform set of data
into into a
histogram.
Importing
Text Files into Excel
This tutorial
describes and shows you how to import data into Excel from
a text file written by another program.
Final
Formatting in Excel
Learn how to format
Excel graphing components: hide
or display them, modify their size, color, and orientation. How to add
new
components, such as reference lines, using Excel's drawing tools.
Plotting
Regression Lines Using Excel
This Excel
tutorial shows you how to create a regression trend line and how
to calculate and display the equation for the regression line and its
correlation coefficient, R-squared.
Superimposing
Graphs in Excel
Teaches you how to merge
data from two graphs, creating one graph. This is usually done
so you can show a second independent variable. Also learn how
to reformat an Excel graph to correctly present the new
variable.
Creating
Error Bars in Excel
This tutorial shows
you how to summarize
data in Excel using averages and how to display statistical results
using
error bars.
Selecting
Data in Excel for Display
Explains and
describes how to only present a part of your data set in Excel. Also
learn how to use graphs to discover and delete outlier data.