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.
- Sorting data using a single criterion (3:04)
- Sorting data using multiple criteria (2:29)
- Sorting data with multiple header rows (1:27)
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.
- Copying with Paste Link (3:51)
- Copying and transposing data (1:47)
- Adding (subtracting, multiplying, dividing) numbers and pasting numbers (values, formats, comments) with Paste Special (1:25)
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.
- Filtering data with AutoFilter (1:13)
- Analyzing data with AutoFilter (1:45)
- Using Custom AutoFilter to filter numerical values less or greater than a specified value (1:41)
- Turning filters off (0:34)
- Printing datasets from AutoFilter (1:39)
- Copying just the dataset obtained from AutoFilter (2:23)
- Using the Esc (Escape) key to clear selections and copy another dataset(1:16)
You may need to turn off your browser’s pop-up blocker or install the latest Flash plug-in to view these tutorials.
