Material Detail

“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 columns 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

This will delete the comment from the database. This operation is not reversible. Are you sure you want to do it?

Thank you for reporting a broken "Go to Material" link in MERLOT to help us maintain a collection of valuable learning materials.

If you feel this material is inappropriate for the MERLOT Collection, please click SEND REPORT, and the MERLOT Team will investigate. Thank you!

You are being taken to the material on another site. This will open a new window.

Do not show me this again