Excel Budgets When speaking with Excel students, one of the most commonly asked Excel questions is: “How do I create a budget?”. My advice would be, if your boss asks you to create a department budget your first question should be “Okay, will the CFO provide a template for this project” (the answer should be …
Tag: learn excel
Nov 27
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 …
Oct 27
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 …
Aug 15
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.