Learn how to sort data in Microsoft Excel using the sort command. Continue reading
Post Category → Videos
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 00014 Pivot Table: Extend the data range
If you’ve created a pivot table and later added more data then you’ll need to expand the pivot’s data range. 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 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
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