|
Course: Using Arrays to Become an Excel Poweruser
Author:Patricia McCarthy
|
|
Course ID:EXMCARRPU
CPE Hours: 2.5
Format: PDF and Excel exercise files
Price: $19.95
This is an updated version of an earlier course -Excel Arrays-A Powerful Tools. If you have taken that course then this one is not recommended since a lot of it is the same material.
|
|
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.
Click here for Table of Contents
MATCH, ABS, SUMPRODUCT,SUMIF, NESTED IFs are briefly discussed and used in the Ebook.
The manual walks you slowly through each process.
|
|
Delivery: Internet/Interactive
NASBA Category: Computer Science/Specialized Knowledge
Level: Intermediate to Advanced (See Prerequisites)
Prerequisites: This course is based on Excel 2003 and Excel 2007.
You should have one of these Excel versions. Excel 2010 will also work
however this course does not cover Excel 2010 functions.
|
