Data in each cell should represent 1 thing (i.e. one ‘City Name’ or one ‘Country’).
If various fields are pushed into 1 cell then learning Excel’s -Text To Columns- feature will save you many hours of work! Continue reading
Data in each cell should represent 1 thing (i.e. one ‘City Name’ or one ‘Country’).
If various fields are pushed into 1 cell then learning Excel’s -Text To Columns- feature will save you many hours of work! Continue reading →
Learn how to sort data in Microsoft Excel using the sort command. Continue reading →
This video reviews two parameters of Excel’s vlookup function (‘col_index_num’ and ‘table_array’). Continue reading →
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 →
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 →
Advanced uses of the SUMPRODUCT function including how to incorporate “this or that” logic. Continue reading →
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 →
A quick review of the Sumproduct function and 2 more examples. Continue reading →
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 →
Watch this video to learn more about sheets in Excel (i.e. rename, move, copy, select, delete, insert, etc.) Continue reading →