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 2010 Level 3 - Data Management

GK# 8249

Course Overview

TOP

In this clinic with hands-on labs, you will gain the knowledge and skills to work with advanced data management features and functionality of Microsoft Excel 2010.

What You'll Learn

TOP
  • Create and use Excel tables
  • 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 and work with filtered data
  • Create and work with subtotaled lists
  • Use various database functions to summarize data
  • Create, modify, and work with PivotTables, PivotCharts, and Slicers
  • Import external data from a variety of sources into Excel

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. Maintaining Data

  • Data List and Excel Table Concepts
  • Using Data Forms
  • Using Lookup Tables

2. Sorting Lists

  • Sorting Concepts
  • Sorting Lists
  • Custom Sort Orders

3. Filtering Lists

  • Filtering Concepts
  • Using AutoFilter
  • Using Advanced Filter
  • Working with Filtered Data

4. Summarizing Data

  • Automatic Subtotals
  • Working with Subtotaled Lists
  • Using Functions to Summarize Data

5. PivotTables

  • PivotTable Concepts
  • Creating PivotTables
  • Modifying PivotTable Layouts
  • Working with PivotTables
  • PivotCharts
  • Slicers

6. External Data

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

Prerequisites

TOP

Who Should Attend

TOP

Those who are familiar with Microsoft Office Excel 2010

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

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Request this course in a different delivery format.
Enroll