Arrays in Microsoft Excel are a very powerful, yet generally unknown tool. Using array formulas allows you to perform tasks that may currently take more than one step and consolidate them into one step, improving efficiency.
Array formulas make it easier to perform tasks such as comparing and evaluating lists, mathematical operations, quantifying errors and identifying duplicates in data. Excel also has built in functions that may be used to work with arrays. These functions include SUMPRODUCT, the combination of the INDEX and MATCH functions and the AGGREGATE function. These functions will also be discussed.
- Teacher: usman data
SKU *: crs-1653673
Sell price $: 29.00
Course Preview:
<iframe src="//player.vimeo.com/video/253507288?autoplay=1" allowfullscreen="" frameborder="0" height="357" mozallowfullscreen="" webkitallowfullscreen="" width="635"></iframe>
Course Short Description:
This course introduces Arrays in Microsoft Excel.
credit Hours: 0
CPE Credits Awarded *: 1.5
Approval Status: - None -
Course is for: ** Main Course Library **
Course Duration: 1.5
Complexity of Content: Foundational
Suppress in lists: No
Last Updated/Reviewed Date: March 23, 2024
Prerequisitses:
No advanced preparation or prerequisites are required for this course.
Learning Objective:
- Discover how to use array formulas in mathematical operations
- Discover how to create and use defined range names
- Recognize the MATCH function and its uses in comparing lists
- Explore how to use of ISNA and ISERROR to ignore and quantify errors in data
- Recognize the use of COUNTIF as an array function to identify duplicates in data
- Recognize the SUMPRODUCT function and its uses when multiplying arrays
- Recognize the combined INDEX and MATCH function as a tool to insert information or match two lists
- Identify the uses of the AGGREGATE function
Course Type: CPE Course
Format: 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
Field of Study: Computer Software & Applications
Other: No
CPA: Yes
CPD-IES7: No
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
Enable/Disable: Yes
CPE Credits: 1.5
Field of Study: Computer Software & Applications
CPE Delivery Method: QAS Self-Study
Program Location:
Online
*Program Level: Basic
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Enable/Disable: No
Program Location:
Online
Enable/Disable: Yes
Hours: 1.5
Field of Study: Computer Software & Applications
CPE Delivery Method: QAS Self-Study
Program Location:
Online
Enable/Disable: Yes
CPE Credits: 1.5
Field of Study: Computer Software & Applications
CPE Delivery Method: QAS Self-Study
Program Location:
Online
*Program Level: Basic
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Enable/Disable: Yes
CPE Credits: 1.5
Field of Study: Computer Software & Applications
CPE Delivery Method: QAS Self-Study
Program Location:
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.
Enable/Disable: No
Program Location:
Online
Enable/Disable: Yes
Field of Study: Computer science
CPE Delivery Method: QAS Self-Study
CPE Credits: 1.5
Program Location:
Online
*Program Level: Basic
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Enable/Disable: Yes
CPE Credits: 1.5
Field of Study: Other activities contributing to professional competence
CPE Delivery Method: QAS Self-Study
Program Location:
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:
<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:
<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:
On Demand/Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Enable/Disable: No
Program Location:
On Demand/Online
*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:
<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:
Online
Enable/Disable: No
Program Location:
Online
Enable/Disable: No
Program Location:
Online
Enable/Disable: No
Program Location:
Online
Enable/Disable: No
Program Location:
Online
Enable/Disable: No
*Program Location:
Online
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
~Credit Details:
<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:
<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:
<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:
<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:
<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:
<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:
<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:
<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:
<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
Hours: 1.0
Free Marketing Course: No