Managing Data with Excel

Course Description:

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.

Version: Excel 2010 and up through Excel 2019 and Office 365

Learning Objectives:

Upon successful completion of this course, participants 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 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

Course Number:	PM2002
NASBA Field of Study:	Computer Software and Applications
Level:	Overview
Author/Instructor:	Patricia McCarthy
Publication Date:	February 21, 2020
CPE Credits:	4
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

Course Format: Online
Test Format: Online
CPE Credit: 4
Level: Overview
NASBA Field of Study: Computer Software & Applications
Instructional Method: Self Study
Program 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

Our Price: $34.95
You Save
Credit Hours 4

Average rating : No Rating

0 Comments

Write a review [Rating Stars (5=Best)]

Rating *

Location

Subject

Name *

Email *

Details *

Self Study

Stay up to date on the latest changes...

Managing Data with Excel

0 Comments

Write a review [Rating Stars (5=Best)]

Quick Link

Help

Account

How may we Help you?

Connect with us

Self Study

Stay up to date on the latest changes...

Managing Data with Excel

0 Comments

Write a review [Rating Stars (5=Best)]

The Wait is Over

SIGNUP TODAY AND RECEIVE 8 HOURS OF FREE CPE CREDIT

Quick Link

Help

Account

How may we Help you?

Connect with us