Elert & Associates Technology Training
Home About Services Delivery Methods Courseware Testimonials Contact Us
Student Links Register for a Class Course Catalog Student Resources

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)

 

   

   

   Print this page without top and side navigation

View a virtual classroom demo