Instructional Services >> Workshop Listing >> Workshop description

Excel 2007: Data Management

Workshop Details

Workshop description	Want to learn how to most effectively manage and utilize the data in your Excel workbooks and spreadsheets? Come to this workshop to learn the power of Excel to organize, summarize, calculate and import information. This workshop will cover: Using cell tables for sorting and filtering Grouping and outlining data Adding subtotals and totals Using the Data Validation tool Importing data Embedding and linking data Managing Windows
Category	Office Productivity
Registration fee	None
Workshop handout	http://www.techdocs.ku.edu/docs/excel_07_data_management.pdf

Prerequisites

We highly recommend that you attend prerequisite workshops, listed on the right, since familiarity with the skills and concepts taught in them is essential to benefit fully from subsequent workshops.

However, if you have independently learned the skills and concepts of the required workshop(s), your "equivalent skills" will be accepted as a substitute for attending the prerequisite workshop(s).

To help you determine your skill level, click the workshop titles on the right for descriptions which outline the topics taught in each workshop and that are assumed in later sessions. You are expected to know the commands and concepts listed within the descriptions for the prerequisite workshop. In most cases, you can also refer to workshop handouts and other helpful materials from the workshop description page.

In addition to any specific prerequisites listed, you should have, as a minimum, basic computing skills.

1. Excel 2007: Introduction