Spreadsheets: The Basics

Learning Objectives

  • Enter data into a spreadsheet
  • Format a worksheet
  • Enter a formula
  • Enter a function
  • Create and use named ranges
  • Create a simple chart
  • Modify data
  • Insert a new worksheet
  • Insert rows and columns into a worksheet
  • Sort and filter data
  • Create an Excel table (Excel only)

Prerequisite Skills

  • Use a mouse
  • Open and save files
  • Open and close windows
  • Switch between windows

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.