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! (more…)
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! (more…)
Learn how to hide rows using Excel’s FILTER feature. (more…)
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! (more…)
Learn how to sort data in Microsoft Excel using the sort command. (more…)
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! (more…)