Managing Data with Excel
SKU: 02-071-01-CPE
Credit Hours: 5
Level: Overview
CPE Category: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: PDF
Instructor: Patricia McCarthy, MBA
Course Description:
This course will discuss ways to manage and transform large volumes of data into useful information that can be analyzed and used in the decision making process.
At the end of this course, students will be able to:
- Recognize basic components of a database
- Identify and apply different ways to sort data
- Define and apply filtering techniques
- Recognize the steps required to create and copy subtotals and nested subtotals
- Recognize when it is appropriate to use a pivot table
- Recognize the steps to create, edit and format pivot tables
- Recognize and components of a database function and how to apply them
- Recognize how to apply and remove conditional formatting
- Recognize and apply an Outline format