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.
Excel: Data Management
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.
Enroll in the online course
Follow the appropriate enrollment method below, depending on your IU status.
IU faculty, staff, and students
Join using the self-enroll feature of Canvas (requires IU username and passphrase).
Non-IU learners
Join via IU Expand at a low cost (requires an IU Guest account, a free sign-up for anyone).
This course is part of an IT Training Certificate Series, which awards a certificate on successful completion of a final online exam. Learn more about the Excel Essentials Certificate Series.
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.
See the full content for Splitting and Combining Cell Contents
(IU Login Required)Explore how to protect an Excel worksheet as well as an entire workbook.
See the full content for Protecting Your Work
(IU Login Required)Create and use a custom list, work with the Name Manager, and utilize filters.
See the full content for Using the Auto Fill Feature
(IU Login Required)Create and work with a PivotTable.
See the full content for Introducing PivotTables
(IU Login Required)Practice creating a PivotTable.
See the full content for Challenge Exercise: Creating a PivotTable
(IU Login Required)
Find related training with our partners
Pluralsight
Pluralsight is a provider of video-based online training with a focus on more technically oriented and design focused topics.
Skillsoft
Skillsoft is a leading e-learning provider with a wide range of educational services and in-depth coverage of IT and other skills.
Contact us to request IT Training resources in other accessible formats.