Learn how to retrieve a value or several values using Microsoft Excel’s offset function. Offset is one of my favorite functions due to it’s flexibility. Continue reading
Post Category → Formulas
Video 00026 Financial Functions_FUTURE VALUE part 2
What’s the difference between Compound Interest and Simple Interest?
I know that there’s a difference but I often forget the details so I created this video for you and for me! Continue reading
Video 00025 Financial Functions_FUTURE VALUE
Calculate the future value of your money in Microsoft Excel using the Future Value function. Continue reading
Video 00027 COUNT functions in Excel
Learn how to use Excel’s various count functions to count numbers, blanks, non blanks and how to conditionally count (count if a condition is met). Continue reading
Video 00017 VLOOKUP Introduction Part2
This video reviews two parameters of Excel’s vlookup function (‘col_index_num’ and ‘table_array’). Continue reading
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