Virtualization - Course Details

ME2010-L3-DM(S103D) Microsoft Excel 2010 - Level 3 - Data Management (S103D)

Virtualization Course Description:
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.
Virtualization Course Duration:
1 DAY
Virtualization Course Target Audience:
Those who are familiar with Microsoft Office Excel 2010
Virtualization Course Prerequisite:
NONE
Course Content:

  • 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