Excel: Working With Data

Learning Objectives

  • Improve data entry with data validation
  • Split and concatenate cell contents
  • Work with named ranges
  • Protect a worksheet
  • Clean source data
  • Work with data across worksheets
  • Combine and format worksheets
  • Sort and filter data 
  • Create a simple PivotTable

Prerequisite Skills

  • Format cells and worksheets
  • Select data
  • Work with formulas and functions

Expand Course Available

View Course in Expand

Recording of a Previous Session

Learn more about Excel: Working With Data in this short introductory video.

Description of the video:

Hello and welcome to Excel: Working With Data. In this course, you will be exploring more advanced topics about working with information in Excel, specifically, improving data entry with data validation, splitting and concatenating cell contents, working with named ranges, protecting a worksheet, cleaning source data, working with data across worksheets, combining and formatting worksheets, sorting and filtering data, and creating simple pivot tables. Before getting started, you'll want to make sure that you're familiar with the basics of working in Excel. This includes formatting cells and worksheets, selecting data, and performing calculations with formulas and functions. If you're familiar with those topics, then you're ready for Excel: Working With Data. Make sure you have Excel installed on your computer. As we go through the course, we will be referring to exercise files. You can download those from the download links included in each section of the course. Now it's time to get started with Excel: Working With Data.

More information about this course

This online course is free to everyone and available for enrollment through IU Expand.

This course consists of a series of short lessons, examples, demonstrations, practice quizzes, and hands-on exercises.

To complete the course content, you will need:

  • a web browser and internet access to use the course material on IU Expand.
  • a copy of the software relevant to the training installed on your computer.