Working with data

Sort

[7 minutes total]

These three tutorials show how to sort your data by as many as three different columns. This isan especially useful skill for organizing and creating subsets from original data files from state departments, testing companies, and/or school districts.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

Paste Special

[6 minutes total]

These three tutorials show how to use special copying and pasting techniques in Excel. The Paste Special function in Excel can be used to quickly link areas in your worksheets together, or to do other useful things like transpose (i.e., switch) the column-row orientation of data.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

Filter

[11 minutes total]

These seven tutorials show how to use the Filter feature in Excel, which allows you to quickly see or create subsets of your original data file. Filtering is one of the most powerful tools in Excel (particularly inconjunction with the Conditional formatting feature) and yet is extremely easy to learn.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

You may need to turn off your browser’s pop-up blocker or install the latest Flash plug-in to view these tutorials.