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 →