Managing Data with Excel
SKU: CPE-07-071
Credit Hours: 5
Level: Basic
Field of Study: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: Online PDF
Instructor: Patricia McCarthy, MBA
Participants at the end of this course 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