This video reviews two parameters of Excel’s vlookup function (‘col_index_num’ and ‘table_array’). Continue reading
Video 00017 VLOOKUP Introduction Part2
Post Category → Formulas
Video 00016 VLOOKUP introduction
Excel’s vlookup function is the most common lookup function. It’s often used in job interviews as bare minimum proof of Excel knowledge.
Are you using vlookup correctly?
Continue reading
Video 00012 SUMPRODUCT_Part4 this OR that
Advanced uses of the SUMPRODUCT function including how to incorporate “this or that” logic. Continue reading
Video 00011 SUMPRODUCT_Part3 How it really works!
Learn what Excel’s sumproduct function is really doing. See what’s going on inside by evaluating it.
Remember this: the F9 key is your friend! Continue reading
Video 00010 SUMPRODUCT_Intro_Part2
A quick review of the Sumproduct function and 2 more examples. Continue reading
Video 00009 FIND-and-SEARCH Excel functions
Are you looking for something in your Excel data?
Excel’s FIND feature is great when you want to quickly find something in your data.
But what if you keep repeating the same searches? Continue reading
Video 00002 SUMPRODUCT_function Part1
Many people have asked me about Excel’s sumproduct function. It is one of Excel’s most versatile and useful functions. Here is an introduction video. Continue reading