Excel 2007 Tables
Objective
Learn table design techniques, as well as procedures to sort,
filter, and validate data. You will also learn to use formulas
in tables and remove duplicate records.
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 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.
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)
