This course provides instruction for five basic topics in Excel. The following topics are addressed in the training program: 1) Conditional formatting, 2) Removing duplicates, 3) Find and replace, 4) Grouping cells, 5) Absolute/relative references. The instructional workbook covers a variety of topics from beginner to intermediate, and provides an explanation of each topic with an exercise for practice. The training will also provide examples of business application for each topic.
SKU *: crs-1592043
Sell price $: 12.00
Course Preview:
<iframe src="//player.vimeo.com/video/135593364?autoplay=1" allowfullscreen="" frameborder="0" height="357" mozallowfullscreen="" webkitallowfullscreen="" width="635"></iframe>
Course Short Description:
This course provides instruction for five basic topics in Excel.
Compliance Deep Tag: - None -
Credit Hours: 0.5
CPE Credits Awarded *: 0.5
Approval Status: - None -
Course is for: Intrinsic
Course Duration: 0.5
Complexity of Content: Basic
Suppress in lists: No
Last Updated/Reviewed Date: March 16, 2024
Course Topic: Excel
Prerequisitses:
No advanced preparation or prerequisites are required for this course.
Learning Objective:
- Discover the structure, function, and inputs of 1) Conditional formatting, 2) Removing duplicates, 3) Find and replace, 4) Grouping cells, 5) Absolute/relative references
- Recognize how to incorporate Excel functions in appropriate use case scenarios
- Identify the location of basic functions in Excel
- Discover basic shortcuts for the functions covered in the video
Coupon Terms: Coupon-Intuit
Course Functional Titles: Financial Analyst, Non Finance Professional
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: Specialized Knowledge
crs cat: Excel
CPA: Yes
CPD-IES8: Yes
CMA: Yes
CFE: Yes
Yellow Book: No
CGFM: No
CIA: Yes
CRMA: Yes
CPP: No
FPC: No
CTP: No
FP&A: No
CISM: No
CRISC: No
CISA: No
CIST: No
CRFS: No
SHRM-CP: No
SHRM-SCP: No
PHR: No
SPHR: No
GPHR: No
aPHR: No
PHRca: No
PHRi: No
SPHRi: No
crma_irs: No
cert type: CPA, CPD-IES8, CMA, CFE, CIA, CRMA
Enable/Disable: Yes
CPE Credits CPA: 0.5
Field of Study CPA: Accounting
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.
Enable/Disable: Yes
Hours CPD-IES8: 0.5
Field of Study CPD-IES8: Accounting
CPE Delivery Method CPD-IES8: QAS Self-Study
Program Location CPD-IES8:
Online
Enable/Disable: Yes
CPE Credits CMA: 0.5
Field of Study CMA: Accounting
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: 0.5
Field of Study CFE: Financial Transactions and Fraud Schemes
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: No
Program Location CGFM:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Enable/Disable: No
Program Location YB:
Online
Enable/Disable: Yes
CPE Credits CIA: 0.5
Field of Study CIA: Auditing and accounting
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.
Enable/Disable: Yes
CPE Credits CRMA: 0.5
Field of Study CRMA: Audit and Accounting
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.
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details CPP:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/certifications/APA-generic-RCH-updated-annually.png" width="80" height="80" alt="Approved by APA"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. 19 ILL 000</span> 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 <a href="http://www.americanpayroll.org/certification/recertification/">www.americanpayroll.org</a>. </span></td>
</tr>
</tbody>
</table>
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details FPC:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/certifications/APA-generic-RCH-updated-annually.png" width="80" height="80" alt="Approved by APA"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. 19 ILL 000</span> 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 <a href="http://www.americanpayroll.org/certification/recertification/">www.americanpayroll.org</a>. </span></td>
</tr>
</tbody>
</table>
Enable/Disable: No
Program Location CTP:
On Demand/Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
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:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/IRS_CE_Provider_Logo_Color.jpg" width="150" height="39" alt="pre-approved by IRS"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. XXXXXX</span> 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. </span></td>
</tr>
</tbody>
</table>
Enable/Disable: No
Program Location CISM:
Online
Enable/Disable: No
Program Location CRISC:
Online
Enable/Disable: No
Program Location CISA:
Online
Enable/Disable: No
Program Location CIST:
Online
Enable/Disable: No
Program Location CRFS:
Online
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details SHRM-CP:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/shrmcertseal2017.png" width="80" height="60" alt="pre-approved by SHRM"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. XXXXXX</span> 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 <a href="https://www.shrm.org/certification">www.shrm.org</a>. </span></td>
</tr>
</tbody>
</table>
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details SHRM-SCP:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/shrmcertseal2017.png" width="80" height="60" alt="pre-approved by SHRM"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. XXXXXX</span> 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 <a href="https://www.shrm.org/certification">www.shrm.org</a>. </span></td>
</tr>
</tbody>
</table>
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details PHR:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> 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 <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
</tr>
</tbody>
</table>
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:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> 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 <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
</tr>
</tbody>
</table>
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details aPHR:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> 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 <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
</tr>
</tbody>
</table>
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details PHRca:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> 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 <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
</tr>
</tbody>
</table>
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details PHRi:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> 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 <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
</tr>
</tbody>
</table>
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details SPHRi:
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tbody>
<tr>
<td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI"></td>
<td align="left" valign="middle"><span style="font-size:10px;font-weight:normal;">This activity, <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> 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 <a href="https://www.hrci.org">www.hrci.org</a>. </span></td>
</tr>
</tbody>
</table>
Enable/Disable: Yes
Hours: 0.5
Free Marketing Course: No
Sponser: Illumeo
Participation: Solo
Instructor: Recorded
Presence: Remote