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
Video 00151 Custom Formats, VBA, and Nerds!
Post Category → Features
Video 00073 Helping Dean Pelton with his menu in Excel
Dean Pelton has a problem.
His menu is alphabetical and has too many meatball recipes.
Watch as Bill Jelen (aka Mr Excel) helps Dean: Mr Excel helps Dean Pelton
But how can I help Dean?
Video 00031 DATA VALIDATION restrict values entered into a cell
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
Video 00020 Use a FILTER to hide rows
Learn how to hide rows using Excel’s FILTER feature. Continue reading
Video 00023 TEXT TO COLUMNS to parse data
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
Video 00018 SORT_DATA in Excel
Learn how to sort data in Microsoft Excel using the sort command. Continue reading
Video 00008 Features_Basic_FIND
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