Quantitative Skills Center

Introduction to Excel

The interactive worksheet below will provide an introduction to MS Excel including some setup and using icons, toolbars, and shortcuts. Participants will learn to use Excel functions with an emphasis on those needed for data analysis.


 Written Instructions

 Video Instructions: (Use Internet Explorer to view)

 Section 1: Paste, Fill, Insert, Replace

 Section 2: Sort, Descriptive Statistics (Average, Median, Mode, Standard Deviation, etc...)

 Section 3: Graphing

 Section 4: Pivot Tables

 Interactive Worksheet


Check out these websites for additional Excel help!

Excel 2010 Tutorials - Includes links to videos of getting started with Excel 2010, creating formulas, how to create a chart, etc.

Excel 2007: Use for Analysis of Economics Data A collection of handouts assuming no knowledge of Excel and relatively little knowledge of statistics.

DON'T FORGET- You can always stop by the Quantitative Skills Center and get some in person help and resources.