Microsoft Excel is considered one of the most useful tools in the workplace. However, if Excel is used incorrectly, it can seriously drag down productivity. This course guides you through shortcuts and functions to enable you to boost your productivity and shave valuable time from repetitive tasks. You'll learn:
Selected Shortcuts
Keep your hands on your keyboard to improve your speed. This online Excel course explores 5 shortcuts that assist when writing formulas and functions. The Excel lesson includes F9, fill down and right, Ctrl+Home, row shortcuts and column shortcuts. It also follows up on a discussion from Volume 1 Chapter 6, and expands the utility of F2.
Conditional Summing Basics
Have you explored the conditional summing functions in Excel? The SUMIFS function is absolutely a game changer. This online Excel course introduces the multiple condition sum function SUMIFS. The Excel lesson works through the syntax of the function, and provides several practical examples so you can work hands-on.
Remove Duplicates
This online Excel course explores how to remove duplicate values from lists and tables. This Excel lesson demonstrates how to use the remove duplicates feature to generate a unique list of report labels.
Lookup Basics with VLOOKUP
Are you comfortable performing lookups in Excel? They are the keys that unlock significant efficiency in recurring-use workbooks. This online Excel course covers the cornerstone of all Excel lookup functions, VLOOKUP. This Excel lesson covers the function syntax, and provides numerous exercises so you can work hands-on to develop your skill.
Improve VLOOKUP with MATCH
This online Excel course demonstrates how to address a serious limitation of the VLOOKUP function. The VLOOKUP function will break when a user inserts a new column between the lookup and return columns. This Excel lesson explores the MATCH function, and illustrates how to use it to bypass this VLOOKUP limitation. We work through the syntax of the function, and provide several practical examples so you can work hands-on.
Improve VLOOKUP with TEXT and VALUE
This online Excel course addresses a serious limitation of the VLOOKUP function, the fact that equivalent values stored as different data types won't match. That is, the number 100 won't match 100 in the lookup range if stored as a text string. This lesson demonstrates how to bypass this limitation by using the TEXT and VALUE functions. We work through the syntax of the function, and provide several practical examples so you can work hands-on.
Moving Beyond VLOOKUP with INDEX
This online Excel course addresses a major limitation of the VLOOKUP function, the inability to go left. That is, the VLOOKUP function is not designed to return a value that lies to the left of the lookup column. This Excel lesson demonstrates how to bypass this limitation by using the INDEX function. We work through the syntax of the function, and provide several practical examples so you can work hands-on.
<iframe src="//player.vimeo.com/video/59689572?autoplay=1" allowfullscreen="" frameborder="0" height="450" mozallowfullscreen="" webkitallowfullscreen="" width="600"></iframe>
This course covers selected Excel shortcuts including Conditional Summing Basics, Remove Duplicates, Lookup Basics with VLOOKUP, and Advanced VLOOKUP.
No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.
- Increase your Excel speed with selected shortcuts
- Remove duplicates from lists and tables
- Look up values in a table using VLOOKUP
- Utilize multiple lookup functions such as VLOOKUP, MATCH, and INDEX
CPE Course
on_demand
Excel, Free Trail
Online
No advanced preparation or prerequisites are required for this course.
NASBA Sponsor Number: 109504
State of New York Sponsor Number: 002746
State of Texas Sponsor Number: 009890
Online
Online
No advanced preparation or prerequisites are required for this course.
Online
No advanced preparation or prerequisites are required for this course.
Online
No advanced preparation or prerequisites are required for this course.
Online
Online
No advanced preparation or prerequisites are required for this course.
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Internal Auditor (CIA) CPE program.
Online
No advanced preparation or prerequisites are required for this course.
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Online
No advanced preparation or prerequisites are required for this course.
 | This activity, ID No. 19 ILL 000 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 www.americanpayroll.org. |
This program has been approved for 12 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). For more information about certification or recertification, please visit the APA homepage at www.americanpayroll.org.
Online
No advanced preparation or prerequisites are required for this course.
| This activity, ID No. 19 ILL 000 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 www.americanpayroll.org. |
This program has been approved for 12 Recertification Credit Hour(s) toward RCH recertification through the American Payroll Association (APA). For more information about certification or recertification, please visit the APA homepage at www.americanpayroll.org.
On Demand/Online
No advanced preparation or prerequisites are required for this course.
Approved for up to 2.4 CTP/CCM recertification credits by the Association for Financial Professionals
On Demand/Online
No advanced preparation or prerequisites are required for this course.
Approved for up to 2.4 FP&A recertification credits by the Association for Financial Professionals
Online
No advanced preparation or prerequisites are required for this course.
 | This activity, ID No. XXXXXX 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. |
Online
Online
Online
Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Online
Online
Online
No advanced preparation or prerequisites are required for this course.
 | This activity, ID No. XXXXXX 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 www.shrm.org. |
Illumeo is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CP℠. This program is valid for 2 PDCs for the SHRM-CP℠. For more information about certification or recertification, please visit www.shrmcertification.org.
Online
No advanced preparation or prerequisites are required for this course.
| This activity, ID No. XXXXXX 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 www.shrm.org. |
Illumeo is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-SCP℠. This program is valid for 2 PDCs for the SHRM-SCP℠. For more information about certification or recertification, please visit www.shrmcertification.org.
Online
No advanced preparation or prerequisites are required for this course.
 | 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. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| 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. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| 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. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| 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. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| 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. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| 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. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.
Online
No advanced preparation or prerequisites are required for this course.
| 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. |
The use of this seal confirms that this activity has met HR Certification Institute’s® (HRCI®) criteria for recertification credit pre-approval.