<p>In this course Excel expert David Ringstrom, CPA shares many Excel tips and tricks that he uses to fly through Excel every day. He's fond of stating "Either you work Excel, or it works you!" This course is designed to help you use Excel more effectively. In this course David teaches primarily from Excel 2010, but covers differences in Excel 2003, 2007, and 2013 where applicable.</p>


SKU *: crs-1725155
Sell price $: 24.00
Course Author: David Ringstrom
Authored on: 2024-06-19 20:15:17 -0700
Course Preview:

<iframe src="//player.vimeo.com/video/972071356?autoplay=1" allowfullscreen="" frameborder="0" height="357" mozallowfullscreen="" webkitallowfullscreen="" width="635"></iframe>

Course Short Description:

In this course David teaches primarily from Excel 2010, but covers differences in Excel 2003, 2007, and 2013 where applicable.

credit Hours: 0.15
CPE Credits Awarded *: 0.15
Approval Status: - None -
Course is for: ** Main Course Library **
Course Duration: 0.15
Complexity of Content: Foundational
Suppress in lists: No
Last Updated/Reviewed Date: June 26, 2024
Prerequisitses:

No advanced preparation or prerequisites are required for this course.

Learning Objective:
  • Identify approaches to avoid disabled features in Excel 2007 and later by converting XLS workbooks to the newest format.
  • Explore and combine text into one column or separate it into several by way of simple Excel techniques.
  • Identify and utilize Word 2013's ability to edit PDF documents to get report data into Excel.
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