Managing Data with Excel

Price: $47.50

CPE Credits: 5.0

Category: ,

Course Number: CXDATAMC

managing data

Description:
This EBook shows you how to take basic rows and columns of data and to manage it 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 take a 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. This course is an updated version of an earlier course EXMCMDEX0713. Table of Contents 

Delivery Method: Online QAS Self Study.

Level: Overview.

Version: Excel 2007/2010/2013/2016

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

Author: Patricia McCarthy

Publication: December 2014
Updated: December 2016

Format: PDF and Exercise Files
Pages: 77

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:
1. Recognize basic components of a database
2. Identify and apply different ways to sort data
3. Define and apply filtering techniques
4. Recognize the steps required to create and copy subtotals and nested subtotals
5. Recognize when it is appropriate to use a pivot table
6. Recognize the steps to create, edit and format pivot tables
7. Recognize and components of a database function and how to apply them
8. Recognize how to apply and remove conditional formatting
9. Recognize and apply an Outline format

Overall Course Rating: 4 Stars – Melissa L. 11/2017
cpe course rating

Description:
This EBook shows you how to take basic rows and columns of data and to manage it 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 take a 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. This course is an updated version of an earlier course EXMCMDEX0713. Table of Contents 

Delivery Method: Online QAS Self Study.

Level: Overview.

Version: Excel 2007/2010/2013/2016

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

Author: Patricia McCarthy

Publication: December 2014
Updated: December 2016

Format: PDF and Exercise Files
Pages: 77

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:
1. Recognize basic components of a database
2. Identify and apply different ways to sort data
3. Define and apply filtering techniques
4. Recognize the steps required to create and copy subtotals and nested subtotals
5. Recognize when it is appropriate to use a pivot table
6. Recognize the steps to create, edit and format pivot tables
7. Recognize and components of a database function and how to apply them
8. Recognize how to apply and remove conditional formatting
9. Recognize and apply an Outline format

Overall Course Rating: 4 Stars – Melissa L. 11/2017
cpe course rating

  • “I am extremely impressed with the courses and the reasonable price.” -Janet A. May 2017

    - Janet

  • I wanted to compliment you on the Accounting Fraud – Recent Case Studies (AUCASEMC) course I just took. The ebook was fantastic! Concise, easy to understand, very well structured, and very interesting. Exactly the way I like it. Thank you for putting it together. I feel it took me enough time to be worth 2 CPEs, but it was fantastic nonetheless. Thank you.

    - Mark R.

  • “The author did a good job of setting forth the ethical standards contained in the California State Board of Public Accountancy Rules and the AICPA Code of Conduct.”

    - California Ethics Course