Managing Data with Excel
This course 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 covers Excel 2007/2010/2013/2016

Course Publication Date: October 12, 2017

This course is available with NO ADDITIONAL FEE if you have an active self study membership or can be purchased for $20.00!

Author:Mill Creek Publishing
Course No:SKA-DATAEXCEL-2357
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
  
Add To Your Cart

Ready to take a course?

  • Includes all self study courses
  • Earn as many CPE credit as you need
  • 100% Guaranteed
Buy Self Study Membership

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 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.

CPE Depot Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

Sponsor Number: 109423

 (870ms)
CPE-WEB02 3.231.229.89 url(WWW.CPEDEPOT.COM)-domain(WWW.CPEDEPOT.COM)-anon

Search Courses

Group Plan

Group plans are convenient and cost effective!

Authors Wanted

We are looking for authors!