Learn how to group a column of dates by Year & Month and sum another field.
Excel’s pivot table ‘Group’ feature only takes a few clicks of the mouse and can save so much time! Continue reading
Learn how to group a column of dates by Year & Month and sum another field.
Excel’s pivot table ‘Group’ feature only takes a few clicks of the mouse and can save so much time! Continue reading →
Learn how to exclude data from a pivot by using a report filter. Continue reading →
Learn how to hide rows using Excel’s FILTER feature. Continue reading →
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 →
Watch this video to learn how Microsoft Excel handles dates and times.
Also, learn how to find errors in your date values. 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 →