Excel Arrays: Powerful Tools

This course provides advanced knowledge of Excel functions and is guaranteed to increase your efficiency and productivity in the workplace. Arrays are a powerful Excel tool that can help you consolidate multiple steps, thereby simplifying and streamlining many Excel functions. This straightforward and practical course walks you through each process with step-by-step instructions, explaining how arrays allow you to:

• Copy IF statements in a separate column and then easily sum or average the results all in one step.
• More efficiently sum a range that contains error values.
• Easily compare multiple lists and identify differences.
• Use MATCH, ABS, SUMPRODUCT, SUMIF, NESTED IFs and FREQUENCY.


*To access the practice files for this course, go to westerncpe.com, log in to your account, and click on “Order History.” Practice files are included under Downloadable Materials.

• Perform calculations using Excel arrays.
• Apply constants to arrays.
• Define names to identify an array and multiply arrays using the defined names.
• Use SUM and IF in array formulas.
• Create arrays using nested IFs.
• Compare lists using arrays.

Select			Format		Retail Price
			Online		$29.00		After purchasing this course, you may click here to log in and access the course material.
			Hard Copy		$29.00