Excel: Data Management: All Titles: Explore Topics: UITS IT Training: Indiana University

Complete this workshop to learn how to import data, create custom lists, validate data entry, sort and filter data, and work efficiently with multiple worksheets. We'll also cover Excel's table-related features and introduce PivotTables.

Learning Objectives

Specify data validation criteria
Modify data with functions
Protect a worksheet
Work with custom lists
Convert a data range to a table and work with table features
Sort and filter data
Create a PivotTable
Link data between worksheets
Work with multiple worksheets
Compare workbooks

Prerequisite Skills

Understand spreadsheet terminology
Create and modify Excel spreadsheets
Enter text or numeric data and formulas or functions
Create named ranges
Format worksheets
Create simple charts

For a more in-depth look at the content of Excel: Data Management, view the title contents below.

Title Contents

Expand the accordion folds to see a detailed description of the content.

For IU learners: If you're interested in the content for Excel: Data Management, but prefer not to enroll in the online course, you can access the course content below.

Explore the contents of Excel: Data Management:

See how to open a new workbook and name the worksheets.

See the full content for Getting Started with Data Management
(IU Login Required)

Explore how to group worksheets, summarize data across worksheets, and consolidate data.

See the full content for Grouping Worksheets
(IU Login Required)

Learn how to import and clean up text from an external source.

See the full content for Importing and Cleaning Data
(IU Login Required)

Create and format an Excel table.

See the full content for Working with an Excel Table
(IU Login Required)

Explore and create data validation criteria.

See the full content for Validating Data
(IU Login Required)

Separate cell contents using a Wizard and combine cell contents using a formula.