Excel on YouTubeExcel Class NYC Faceook PageExcel Class on LinkedInExcel Class on TwitterExcel Class on YelpExcel on BloggerExcel on WordpressGoogle Places

Tag: learn excel

Excel Budgets

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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.