Excel 2010 Lists & Tables
Objective
Learn list and table design techniques, as well as procedures
to sort, filter, and validate data. You will also learn to use
formulas in lists and tables, remove duplicate records, and use
the subtotal and outline features.
Prerequisite Skills
Course Description
Do you spend a lot of time searching for data in large spreadsheets?
Would you like to perform database functions such as filtering,
subtotaling, and sorting directly in your Excel spreadsheet?
Attend this course if you want to:
-
Learn the "rules" of designing an Excel list or
table.
-
Define a range of cells into a table.
-
Freeze row or column titles so they don't disappear as you
scroll.
-
Use table styles to change the look of your table quickly
and easily.
-
Use formulas in tables.
-
Remove duplicate records from a table.
-
Sort data alphabetically or numerically.
-
Filter data to display a subset of the data.
-
Set up data validation criteria to prevent data entry errors.
-
Convert a table back to a normal cell range.
-
Subtotal data within a list.
-
Use outlines with subtotaled data.
Class Length
90 minutes
Delivery Options
-
Virtual classroom - public
($70 per student; check times and register here)
-
Virtual classroom - dedicated (up to ten
people from the same organization)
($480 per class; contact us for
more details)
-
Virtual classroom - one on one
(Register for a 45-minute 1-on-1
Application Support session. Cost is $70 per student per
session.)
-
On-site instructor-led
(Contact us for details)
