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 00011 SUMPRODUCT_Part3 How it really works!
Author Archives → Kevin Lehrbass
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 00036 Intro_WORKING-WITH-SHEETS
Watch this video to learn more about sheets in Excel (i.e. rename, move, copy, select, delete, insert, etc.) Continue reading
Free Excel template: Multi Quote Budget
Use this free Excel template to compare various quotes for each budget item. See how much you would save by changing the quote. Continue reading
Video 00013 Pivot Table: Introduction
If you work with data in Microsoft Excel then you have to learn about Pivot Tables!
Learning Pivot Tables will change the way you work with Excel! Continue reading
Video 00008 Features_Basic_FIND
Watch this video to learn how to use Excel’s powerful FIND feature. You will save so much time once you learn how to use this feature! Continue reading
Video 00007 Intro_HOW-TO-ENTER-DATA
Watch this video for tips on how to enter data in Microsoft Excel.
Some of the tips could save you a lot of time. Continue reading
Video 00006 Intro_NAVIGATION
Save time by discovering efficient ways to navigate within a sheet in Microsoft Excel. 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