In this follow up to Excel Efficiency: Tips & Tricks I Excel expert David Ringstrom, CPA shares more of his favorite Excel tricks. This course is designed to help you use Excel more effectively. In this session David teaches primarily from Excel 2010, but covers differences in Excel 2003, 2007, and 2013 where applicable.
Topics Covered:
- Discover techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet.
- Discover how to quickly access folders and workbooks, whether on your computer or on a network
- Discover how to disable worksheet animation in Excel 2013.
- Learn the risks--and rewards--of double-clicking on the fill handle in Excel.
- See steps to take if you can't open a damaged workbook.
- Embed frequently used lists, such as employees, departments, or key customers into Excel's interface for use with any spreadsheet.
- Teacher: umer data
SKU *: crs-1556539
Sell price $: 24.00
Course Preview:
<iframe src="//player.vimeo.com/video/104634487?autoplay=1" allowfullscreen="" frameborder="0" height="357" mozallowfullscreen="" webkitallowfullscreen="" width="635"></iframe>
Course Short Description:
This course offers even more tips and tricks to improving Excel efficiency.
credit Hours: 0
CPE Credits Awarded *: 1
Approval Status: - None -
Course is for: ** Main Course Library **
Course Duration: 1
Complexity of Content: Foundational
Suppress in lists: No
Last Updated/Reviewed Date: March 13, 2024
Prerequisitses:
Prerequisite: Basic proficiency with Excel
Advanced Preparation: None
Learning Objective:
- Discover how to overcome annoying user-interface aspects of Excel 2013
- Utilize Excel's Text Box feature instead of merging cells to store paragraphs of text
- Tally numbers faster and more efficently with Excel's SUBTOTAL function
Course Type: CPE Course
Format: On Demand
Audit & Accounting: Yes
Careers: No
Ethics (NASBA): No
Excel: No
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: Yes
CGFM: Yes
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
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
Field of Study: Computer Software & Applications
CPE Delivery Method: QAS Self-Study
Program Location:
Online
Enable/Disable: Yes
CPE Credits: 1
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
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
Field of Study: Computer Science
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
Field of Study: Other
CPE Delivery Method: QAS Self-Study
Program Location:
Online
Enable/Disable: Yes
Field of Study: Auditing and accounting
CPE Delivery Method: QAS Self-Study
CPE Credits: 1
Program Location:
Online
*Program Level: Basic
*Prerequisites:
No advanced preparation or prerequisites are required for this course.
Enable/Disable: Yes
CPE Credits: 1
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