Excel Basics

Pivot Tables

Excel Charts

Here are links to pages that may help you make better charts in Excel. Your first stop if you are trying to figure out how to do a chart in Excel should be John Peltier's website. He also has lots of general information on Excel. Next you should look at Tushar Mehta's Excel page.

Link to my Powerpoint and the Excel Sheet that made the graphs for my powerpoint

Chart Hints

Constructing good charts
How to construct bad charts
Add class to your reports
Fixing Excel Charts
Tufte Charts in Excel
Combine two types of charts
Combo Charts

Dot Plots

http://exceluser.com/dash/dotplot.htm
http://peltiertech.com/Excel/Charts/DotPlot.html (includes Excel add-in)

Box Plots

http://peltiertech.com/Excel/Charts/BoxWhisker.html (includes Excel add-in)
http://www.duncanwil.co.uk/boxplot.html

Sparklines

Sparklines: theory and practice
http://www.dailydoseofexcel.com/archives/2006/02/05/in-cell-charting/
Sparklines for Excel

In-cell Charts and Light-weight Data Analysis

http://www.dailydoseofexcel.com/archives/2006/02/05/in-cell-charting/
http://www.juiceanalytics.com/weblog/?p=236
http://www.juiceanalytics.com/weblog/?p=239
Conditional Formating
Bullet Graphs
Excel in-cell graphing ideas (xls)
In-cell Charting – Tornado Chart Example

Excel Add-ins