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 then discusses how to use Database functions and apply conditional formatting to data.
SKU *: crs-4792
Sell price $: 29.00
Course Preview: <iframe src="//player.vimeo.com/video/1062273248?autoplay=1" allowfullscreen="" frameborder="0" height="357" mozallowfullscreen="" webkitallowfullscreen="" width="635"></iframe>
Course Short 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.
Compliance Deep Tag: - None -
Credit Hours: 5.0
CPE Credits Awarded *: 5.0
Approval Status: - None -
Course is for: ** Main Course Library **
Course Duration: 5.0
Complexity of Content: Basic
Suppress in lists: No
Last Updated/Reviewed Date: Dec 1, 2025
Course Topic: Excel
Prerequisitses:
Basic file management skills (open/close) are assumed. Basic Excel skills of navigation, using cell references and basic formulas such as =SUM() are assumed.
Version: Excel 2010 and up through Office 365
Learning Objective:
- Recognize basic components of a database.
- Identify and apply different ways to sort data.
- Discover and 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 Type: CPE Course
crs_type:
CPE Course
Format: on_demand
format_crs:
on_demand
Audit & Accounting: No
Careers: No
Ethics (NASBA): No
Excel: Yes
Finance: No
Human Resources (HR): No
Internal Audit: No
Leadership & Management: No
Marketing: No
Operations: No
Productivity & Tech: No
Risk Management: No
Sales: No
Tax: No
Free Trail: No
Other: No
Field of Study: Computer Software & Applications
crs cat:
Excel
CPA: Yes
CPD-IES8: No
CMA: Yes
CFE: Yes
Yellow Book: No
CGFM: Yes
CIA: Yes
CRMA: Yes
CPP: No
FPC: No
CTP: No
FP&A: No
CISM: Yes
CRISC: Yes
CISA: No
CIST: Yes
CRFS: No
SHRM-CP: No
SHRM-SCP: No
PHR: No
SPHR: No
GPHR: No
aPHR: No
PHRca: No
PHRi: No
SPHRi: No
cert type: CPA, CMA, CFE, CGFM, CIA, CRMA, CISM, CRISC, CIST
Enable/Disable: Yes
CPE Credits CPA: 5.0
Field of Study CPA: Computer Software & Applications
CPE Delivery Method CPA: QAS Self-Study
Program Location CPA:
Online
*Program Level: Basic
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Description:
Illumeo 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 the final authority on the acceptance of individual course for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
NASBA Sponsor Number: 109504
State of New York Sponsor Number: 002746
State of Texas Sponsor Number: 009890
In accordance with the standards of the National Registry of CPE Sponsors, CPE credits have been granted based on a 50-minute hour.
NASBA Sponsor Number: 109504
State of New York Sponsor Number: 002746
State of Texas Sponsor Number: 009890
Enable/Disable: No
Program Location CPD-IES8:
Online
Description:
Your specific provider of Continuing Professional Development accreditation has final authority on the acceptance of individual courses for CPD-IES8 credit.
Enable/Disable: Yes
CPE Credits CMA: 5.0
Field of Study CMA: Computer Software & Applications
CPE Delivery Method CMA: QAS Self-Study
Program Location CMA:
Online
*Program Level: Basic
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Enable/Disable: Yes
CPE Credits CFE: 5.0
Field of Study CFE: Computer Software & Applications
CPE Delivery Method CFE: QAS Self-Study
Program Location CFE:
Online
*Program Level: Basic
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Enable/Disable: Yes
CPE Credits CGFM: 5.0
Field of Study CGFM: Computer Science
CPE Delivery Method CGFM: QAS Self-Study
Program Location CGFM:
Online
*Program Level: Basic
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Enable/Disable: No
Program Location YB:
Online
Description:
The GAO's Yellow Book, Government Auditing Standards, establishes CPE requirements. Auditors performing work under GAGAS, including planning, directing, performing field work, or reporting on an audit or attestation engagement under GAGAS, need to maintain their professional competence through continuing professional education (CPE). Therefore, each auditor performing work under GAGAS should complete, every two years, at least 80 hours of CPE that directly enhance the auditor's professional proficiency to perform audits and/or attestation engagements. At least 24 of the 80 hours of CPE should be in subjects directly related to government auditing, the government environment, or the specific or unique environment in which the audited entity operates. At least 20 hours of the 80 should be completed in any one year of the two-year period. For details on the Yellow Book CPE requirements go to http://www.gao.gov/ and https://www.gao.gov/assets/700/693136.pdf.
Enable/Disable: Yes
CPE Credits CIA: 5.0
Field of Study CIA: Computer science
CPE Delivery Method CIA: QAS Self-Study
Program Location CIA:
Online
*Program Level: Basic
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Description:
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Internal Auditor (CIA) CPE program.
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Internal Auditor (CIA) CPE program.
Enable/Disable: Yes
CPE Credits CRMA: 5.0
Field of Study CRMA: Other activities contributing to professional competence
CPE Delivery Method CRMA: QAS Self-Study
Program Location CRMA:
Online
*Program Level: Basic
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Description:
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details CPP:
 | This activity, ID No. 19 ILL 000 has been approved for 1.0 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). Please make note of the Course Code on your CPP Recertification Log. For more information about certification or recertification, please visit the APA website at www.americanpayroll.org. |
Description:
This program has been approved for 12 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). For more information about certification or recertification, please visit the APA homepage at www.americanpayroll.org.
This program has been approved for 12 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). For more information about certification or recertification, please visit the APA homepage at www.americanpayroll.org.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details FPC:
| This activity, ID No. 19 ILL 000 has been approved for 1.0 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). Please make note of the Course Code on your CPP Recertification Log. For more information about certification or recertification, please visit the APA website at www.americanpayroll.org. |
Description:
This program has been approved for 12 Recertification Credit Hour(s) toward RCH recertification through the American Payroll Association (APA). For more information about certification or recertification, please visit the APA homepage at www.americanpayroll.org.
This program has been approved for 12 Recertification Credit Hour(s) toward RCH recertification through the American Payroll Association (APA). For more information about certification or recertification, please visit the APA homepage at www.americanpayroll.org.
Enable/Disable: No
Program Location CTP:
On Demand/Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Description:
Approved for up to 2.4 CTP/CCM recertification credits by the Association for Financial Professionals
Approved for up to 2.4 CTP/CCM recertification credits by the Association for Financial Professionals
Enable/Disable: No
Program Location FP&A:
On Demand/Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Description:
Approved for up to 2.4 FP&A recertification credits by the Association for Financial Professionals
Approved for up to 2.4 FP&A recertification credits by the Association for Financial Professionals
Enable/Disable: No
Program Location IRS-EA:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details IRS-EA:
 | This activity, ID No. XXXXXX has been approved for #### CPE credit hours toward IRS Enrolled Agent (EA) continuing education requirements. In accordance with the standards set forth in Circular 230 section 10.6, CE credits have been granted based on a 50-minute hour. |
Enable/Disable: Yes
CPE Credits CISM: 5.0
Job Practice Area CISM: Information Risk Management and Compliance
CPE Delivery Method CISM: QAS Self-Study
Program Location CISM:
Online
Description:
Your specific provider of Continuing Professional Education accreditation has final authority on the acceptance of individual courses for CPE credit.
Enable/Disable: Yes
CPE Credits CRISC: 5.0
Job Practice Area CRISC: Risk Identification
CPE Delivery Method CRISC: QAS Self-Study
Program Location CRISC:
Online
Description:
Your specific provider of Continuing Professional Education accreditation has final authority on the acceptance of individual courses for CPE credit.
Enable/Disable: No
Program Location CISA:
Online
Description:
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Enable/Disable: Yes
CPE Credits CIST: 5.0
Critical Risk Domain CIST: Strategy and Analysis
CPE Delivery Method CIST: QAS Self-Study
Program Location CIST:
Online
Description:
Your specific provider of Continuing Professional Development accreditation has final authority on the acceptance of individual courses for CPD credit.
Enable/Disable: No
Program Location CRFS:
Online
Description:
Your specific provider of Continuing Professional Development accreditation has final authority on the acceptance of individual courses for CPD credit.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details SHRM-CP:
 | This activity, ID No. XXXXXX has been approved for #### recertification credit hours toward SHRM-CP™ and SHRM-SCP™ recertification through the Society of Human Resource Management® (SHRM®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the Society for Human Resource Management website at www.shrm.org. |
Description:
Illumeo is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CP℠. This program is valid for 2 PDCs for the SHRM-CP℠. For more information about certification or recertification, please visit www.shrmcertification.org.
Illumeo is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CP℠. This program is valid for 2 PDCs for the SHRM-CP℠. For more information about certification or recertification, please visit www.shrmcertification.org.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details SHRM-SCP:
| This activity, ID No. XXXXXX has been approved for #### recertification credit hours toward SHRM-CP™ and SHRM-SCP™ recertification through the Society of Human Resource Management® (SHRM®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the Society for Human Resource Management website at www.shrm.org. |
Description:
Illumeo is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-SCP℠. This program is valid for 2 PDCs for the SHRM-SCP℠. For more information about certification or recertification, please visit www.shrmcertification.org.
Illumeo is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-SCP℠. This program is valid for 2 PDCs for the SHRM-SCP℠. For more information about certification or recertification, please visit www.shrmcertification.org.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details PHR:
 | This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
Description:
This program has been approved for 2 Business aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification credit hours through the HR Certification Institute. For more information about certification or recertification, please visit the HR Certification Institute homepage at www.hrci.org.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details SPHR:
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
Description:
This program has been approved for 2 Business aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification credit hours through the HR Certification Institute. For more information about certification or recertification, please visit the HR Certification Institute homepage at www.hrci.org.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details GPHR:
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
Description:
This program has been approved for 2 Business aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification credit hours through the HR Certification Institute. For more information about certification or recertification, please visit the HR Certification Institute homepage at www.hrci.org.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details aPHR:
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
Description:
This program has been approved for 2 Business aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification credit hours through the HR Certification Institute. For more information about certification or recertification, please visit the HR Certification Institute homepage at www.hrci.org.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details PHRca:
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
Description:
This program has been approved for 2 Business aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification credit hours through the HR Certification Institute. For more information about certification or recertification, please visit the HR Certification Institute homepage at www.hrci.org.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details PHRi:
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
Description:
This program has been approved for 2 Business aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification credit hours through the HR Certification Institute. For more information about certification or recertification, please visit the HR Certification Institute homepage at www.hrci.org.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details SPHRi:
| This activity, ID No. 000000 has been approved for 1.0 HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org. |
Description:
This program has been approved for 2 Business aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification credit hours through the HR Certification Institute. For more information about certification or recertification, please visit the HR Certification Institute homepage at www.hrci.org.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Enable/Disable: Yes
Hours: 5.0
Free Marketing Course: No
Sponser: Illumeo
Participation: Solo
Instructor: Recorded
Presence: Remote