Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Excel 2007 Level 3 - Data List Management

GK# 8775

Course Overview

TOP

In only one day, you will learn advanced functions related to Data List Management in Excel 2007.

What You'll Learn

TOP
  • Add, edit, search for, and delete records in a data list using a form
  • Look up data
  • Sort records in a data list using a variety of methods
  • Filter data in a list using a variety of methods
  • Work with filtered data
  • Create and work with subtotaled lists
  • Use various database functions to summarize data
  • Create, modify, and work with PivotTables and PivotCharts
  • Import external data from a variety of sources into Excel

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. Maintaining Data Lists

  • Working with Data Lists
  • Working with Data Forms
  • Working with Lookup Functions

2. Sorting Data

  • Understanding the Basics of Sorting
  • Using Custom Sort Orders

3. Filtering Data

  • Understanding the Basics of Filtering
  • Filtering Methods
  • Using AutoFilter
  • Working with Advanced Filter

4. Summarizing Data

  • Understanding the Basics of Automatic Subtotals
  • Working with Subtotaled Lists
  • Using Functions to Summarize Data
  • Working with Tables

5. Working with PivotTables

  • PivotTable Concepts
  • Creating a PivotTable
  • Modifying the PivotTable Layout
  • Customizing the PivotTable
  • Understanding PivotChart Concepts

6. Working with External Data

  • Understanding External Data Concepts
  • Importing Data from Access
  • Importing Query Data from Web Pages
  • Importing Data from Text Files

Prerequisites

TOP

Who Should Attend

TOP

Those who are familiar with Microsoft Office Excel 2007

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Request this course in a different delivery format.
Enroll