I doubt that you have ever seen custom formats presented like this before! Selecting a name from a drop down list changes the custom format and also displays a nerd! Continue reading
Use Excel’s data validation feature to restrict values that can be entered into cells.
Data validation can save you hours of data cleanup work! Continue reading
Learn how to hide rows using Excel’s FILTER feature. 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
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