This course shows you how to take basic rows and columns of data and turn it into useful information that can be incorporated into the decision-making process. We start with Excel’s simple basic Database features of sorting and filtering data and then look at subtotals and nested subtotals. From there, we explore one of Excel’s most exciting features – the pivot table. The course than discusses how to use Database functions and apply conditional formatting to data.
Course Publication Date:
March 28, 2020
This course is available with
NO ADDITIONAL FEE if you have an active
self study membership or
all access membership or can be purchased for
$20.00!
| Author: | Mill Creek Publishing |
| Course No: | COMP-DATAEXCEL-2350 |
| Recommended CPE: | 2.00 |
| Delivery Method: | QAS Self Study |
| Prerequisites: | Basic file management skills (open/close) are assumed. Basic Excel skills of navigation, using cell references and basic formulas such as =SUM() are assumed. |
| Advanced Preparation: | None |
| Recommended Field of Study: | Computer Software and Applications
|
|
|
|
Learning Objectives
- 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 how components of a database function and how to apply them.
- Recognize how to apply and remove conditional formatting.
- Recognize and apply an Outline format.