Excel 2003 Tutorial: Data Management

This document introduces users to using Microsoft Excel to. manage information in lists. … Excel’s list, data forms, filtering, and subtotals features, as well …

More PDF Content

Excel: Data Management Contents :
Introduction … 3
Objectives … 3
Prerequisites … 3
Related Training Available from Instructional Services … 3
Using Excel lists … 3
Creating a List … 4
Sorting … 5
To perform a Simple Sort … 5
To Sort by Multiple Columns … 6
Data Forms … 6
Adding Data Using the Data Form… 7
Finding Records Using Criteria… 8
Information Services Filtering Data… 8 AutoFilter… 9
Advanced Filters … 9
Special Features for Filtered Lists … 12
Totals and Subtotals … 12

Download Excel 2003 Tutorial: Data Management pdf from www.techdocs.ku.edu, 18 pages, 366.62KB.