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
- 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
- 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
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).Enroll in Excel: Data Management (IU: No cost)
Join via IU Expand at a low cost (requires an IU Guest account, a free sign-up for anyone).Enroll in Excel: Data Management (Non-IU: $9.99)
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.
Materials and Files
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 download the PDF and exercise files below.
Please note: The PDF and exercise files provided here formed a basis for the online course, but will not be kept in sync with the online course.