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

IU logoJoin using the self-enroll feature of Canvas (requires IU username and passphrase).

Enroll in Excel: Data Management (IU: No cost)

Non-IU learners

world iconJoin 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.