Excel Tutorial – Vlookup Multiple Columns To The Right With An Array Formula
In the process of teaching Excel classes, many students ask: How can I write a single vlookup function that returns multiple values to the right, instead of a single value, which causes me to write many vlookup functions in many columns. This tutorial does not teach vlookup, that feature is taught in the Introduction and […]
SumProduct Function Applications
SumProduct Function Applications When teaching Excel classes students occasionally ask about the SumProduct function. There are many aspects of SumProduct that mirror the SumIfs functions capabilities but SumProduct can produce different answers when combined with the unary operator. This tutorial is not meant to be a thorough discussion of SumProduct but is meant to provide […]
Excel Class NYC – Free Excel Training Tutorial – Excel Text Functions
Excel Class nyc offers a free excel training blog tutorial post. This Excel Class Blog is part I of a three part series of Excel training about text functions.