Community Course

Creating and Analyzing Database Using Microsoft Excel 2007 and 2010

50450BC (Class Pack)
Based on student feedback via 'Metrics that Matter'
Creating and Analyzing Database Using Microsoft Excel 2007 and 2010
This 1 day course provides students with the knowledge and skills to use advanced features in creating and analyzing databases. Participants will learn how to sort and manage data in lists; filter and query data; apply lookup and database functions. Participants will also learn how to analyze and evaluate the information in databases by creating pivot table and pivot charts.
Please contact your Learning Partner in order to take this course
Author: COMAT Training Services

Course Duration: 1 Days

SATV: No

About This Course

This 1 day course provides students with the knowledge and skills to use advanced features in creating and analyzing databases. Students will learn how to sort and manage data in lists; filter and query data; apply lookup and database functions. Students will also learn how to analyze and evaluate the information in databases by creating pivot table and pivot charts.

Audience Profile

This course is intended for Information workers who have at least a year experience in using Microsoft Office Excel 2003/2007/2010.

At Course Completion

  • Working with Databases
  • Using AutoFilter
  • Working with Advanced Filters
  • Lookup Formulas
  • Exporting and Importing Data
  • Creating/Revising PivotTable