Introduction and Unit Objectives

The best tool available today for exploring real-life questions of quantity and change is the spreadsheet.” — Bret Victor, “Kill Math”

Excel makes creating tables very easy. These tables, in turn, make using Excel and looking at data super simple.

In this unit, we learn all about making tables. When you are done, you will be able to create tables in seconds, add and remove column and rows, add and modify the very helpful total row, filter, and sort data and remove duplicate records with a simple click on a button.

Unit Objectives:

  • Create a table from a cell range, and convert it back to a cell range
  • Add and remove columns and rows from a table
  • Apply and configure table style options
  • Insert total rows
  • Filter records
  • Sort data by multiple columns
  • Change sort order
  • Remove duplicate records