Course ID: EDM20107 - Data Management using Excel
Author: Patricia McCarthy
CPE Credits: 2.5

 Price: $18.75

Course Description: This course covers the basics of data management in Excel. If you have large amounts of data and are wondering what it can tell you then take this course.  Turn the reams of data into something useful by learning how to sort, filter and subtotal. Learn all about pivot tables- still the hottest feature in Excel! Other datamanagement tools that are covered are database functions and conditional formats.
Course description and outline
Sample page

Learning Objectives

• Manage large volumes of data efficiently
• Analyze information by transforming data using a variety of Excel tools
• Learn about different database toools such as filtering and outlining and how to use them to hide data not pertinent to your analysis
• Understand database functions and how they can save you time by extracting information from your data  with no impact to your data structure

Delivery
Interactive

Level
Basic to Intermediate Excel user

Version
Excel 2003

Prerequisite
A basic knowledge of Excel and file management is expected. You need to be able to open, find and close files.

NASBA Category
Computer Science

Review/Updated: October 2011

Format
PDF File and Exercise Files