Arrays- A Powerful Excel Tool

Patricia McCarthy, MBA

Production

2.0

0

Not applicable

$19.95

70%

Specialized Knowledge and Applications - Specialized Knowledge & Applications

Arrays are a powerful Excel tool that few people know about. It allows you to take multiple steps and consolidate them into one.

• 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.

MATCH, ABS, SUMPRODUCT,SUMIF, NESTED IFs are briefly discussed and used in the Ebook.
The manual walks you slowly through each process. The manual is 42 pages.

0

2010

1.0

A working knowledge of Excel functions

Overview

Complete, no additional material needed.

None.

Self-Study

Anyone needing Continuing Professional Education (CPE).Education Education

07/29/2010

07/29/2010

Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.

CPE, online, self-study, self study, CPA, CPAs, continuing professional education, continuing education, accounting, accountants, business, commerce, arrays, Excel tool, Excel, IF statement, MATCH, ABS, SUMPRODUCT, SUMIF, NESTED IF

COURSE LEARNING OBJECTIVES