Account Login:

Call 1-800-545-7601  
Today to Order!  

Mon - Fri 9AM to 5PM   

Arrays: A Powerful Excel Tool (PM1100)
Course Format: Online  Test Format: Online
Select Your State for Credit Hours

Field of Study(s): Computer Science

Arrays: A Powerful Excel Tool

Arrays: A Powerful Excel Tool





Course Description:


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 lists, mathematical operations ignoring errors, summing data using one or more criteria and finding minimums and maximums of data using various criteria.


Learning Objectives:


Upon successful completion of this course, participants will be able to:


  • If you are doing and IF statement in a separate column and then copying it down and then summing or averaging the results - an array will let you do it all in one step.
  • Do you sit there and delete error values in a column so that you can sum them?  This will show you a more efficient way
  • Do you need to compare 2 lists and see what is different on one from the other? Yes- an array simplifies the process.


Course ID:


NASBA Category:

Computer Science




Joseph Helstrom and Patricia McCarthy



Revision Date:

Oct 02, 2015

CPE Credits:



There are no prerequisites

Advanced Preparation:


Ready to Order?

Live online Webinars from the confort of your home or office

Unlimited CPE for only $299.00 News & Updates

Keeping up with the Times: Cloud Accounting
CPAs need to keep up with the times if they are to retain their customers
IRA Rollover Rule Changes
The IRA is an excellent vehicle for retirement savings. However, a recent change in rules may impose some limitations over this savings tool.
$50 Million County Revenue Case
The U.S. Supreme Court has decided to hear a case wherein Maryland tax rules were challenged by a Howard County business owner.
IRS Warns Against Phone Scam Targeting Tax Payers
Tax time is certainly not looked forward to by the majority of Americans, but it seems that there may be more than one reason for this
  More News and Updates

Products & Courses
Customer Service
General Pages
Copyright © 2017 Professional's Publishing Group : 5701 E. Hillsborough Ave, Suite #2459, Tampa, FL 33610 1-800-545-7601
14 - 1 - 1