Summary of Spreadsheet Basics: Lookup Value

Spreadsheet Basics: Lookup Value

<p>In this comprehensive presentation, Excel expert David Ringstrom, CPA, introduces you to several lookup functions, including VLOOKUP, HLOOKUP, MATCH, and CHOOSE in these courses. These powerful Excel functions allow you to rapidly develop accurate spreadsheets and look up information, such as pay rates, item prices, and accounting results, versus manually linking to specific cells. Step-by-step, David explains the context of when to use lookup functions, demonstrates troubleshooting techniques, and prepares you to deal with subtle issues that can prevent them from working properly.</p>

<p>David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.</p>

<p><a href=" https://www.illumeo.com/courses/spreadsheet-basics-lookup-introduction" target="_blank"> Spreadsheet Basics: Lookup Introduction</a>

<a href=" https://www.illumeo.com/courses/spreadsheet-basics-lookup-value" target="_blank"> Spreadsheet Basics: Lookup Value</a>

<a href=" https://www.illumeo.com/courses/spreadsheet-basics-lookup-address-formula" target="_blank"> Spreadsheet Basics: Lookup: Address - Formula</a>

<a href=" https://www.illumeo.com/courses/spreadsheet-basics-vlookupdata-validation" target="_blank"> Spreadsheet Basics: Vlookup/Data Validation</a>

Teacher: shah data

SKU *: crs-1725520

Sell price $: 24.00

Course Author: David Ringstrom

Authored on: 2024-06-29 19:15:29 -0700

Course Preview:

Course Short Description:

This course explains several lookup functions, including VLOOKUP, HLOOKUP, MATCH, and CHOOSE.

credit Hours: 0.9

CPE Credits Awarded *: 0.9

Approval Status: - None -

Course is for: ** Main Course Library **

Course Duration: 0.9

Complexity of Content: Foundational

Suppress in lists: No

Last Updated/Reviewed Date: July 30, 2024

Prerequisitses: No advanced preparation or prerequisites are required for this course.

Learning Objective:

Explore several lookup functions, including VLOOKUP, HLOOKUP, MATCH, and CHOOSE and much more.

Course Type: Non-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: No

CPD-IES7: No

CPD-IES8: No

CMA: No

CFE: No

Yellow Book: No

CGFM: No

CIA: No

CRMA: No

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: No

Program Location:

Online

*Prerequisites:

No advanced preparation or prerequisites are required for this course.

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.

Enable/Disable: No

Program Location:

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.

Enable/Disable: No

Program Location:

Online

Enable/Disable: No

Program Location:

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.

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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 19 ILL 000</span> &nbsp; has been approved for &nbsp;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 &nbsp; <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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 19 ILL 000</span> &nbsp; has been approved for &nbsp;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 &nbsp; <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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. XXXXXX</span>&nbsp;has been approved for &nbsp;#### 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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. XXXXXX</span>&nbsp;has been approved for &nbsp;#### 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 &nbsp; <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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. XXXXXX</span>&nbsp;has been approved for &nbsp;#### 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 &nbsp; <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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;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 &nbsp; <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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;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 &nbsp; <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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;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 &nbsp; <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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;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 &nbsp; <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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;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 &nbsp; <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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;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 &nbsp; <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, &nbsp; <span style="font-size:12px;font-weight:bold;">ID No. 000000</span> has been approved for &nbsp;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 &nbsp; <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