MS Excel 2007™ – Level 3 – Databases

Techniques to Manage Information

This workshop is offered within organizations for groups of 5 people or more.

Program Topics

 

Working with Data Lists

  • Creating a Database
  • Using Forms to manipulate Data
  • Using Lookup Functions
  • Sorting Lists

Filtering Lists

  • Filtering Concepts
  • Using AutoFilter
  • Using Advance Filter
  • Working with Filtered Lists

Summarizing Data

  • Creating Automatic Subtotals
  • Working with Subtotalled Lists
  • Using Functions to Summarize Data

Creating and Using Pivot Tables

  • Understanding Pivot Table Fields
  • Modifying Pivot Table Layouts
  • Updating and Formatting Pivot Tables
  • Creating Pivot Charts

Importing Data

  • Importing a Text File
  • Importing an Access Table
  • Importing Data from the Web

Creating Macros

  • Create a Basic Macro
  • Edit a Macro
  • Saving a MS-Excel 07 Workbook with Macros

For more information on this workshop, please contact:
Sophie Gouédard
Tel: 613-234-2020, ext. 21
Email: sgouedard@pmctraining.com

Comments are closed