MrExcel Excel Videos

Jim from Timken shares a trick to prevent typing extra zeroes, even if you are entering 0.000012. This trick works for entering numbers in thousands, millions, thousandths, millionths or any order of magnitude.

Can you keep the data validation drop-down arrows visible? This video offers three alternatives.

It is Hit or Miss today at the MrExcel podcast, literally. The question is how to label a value as a hit if it falls within plus or minus 1 of a target. Bill shows four different formulas to solve the problem. To buy the Formula Tip Card mentioned in the episode, visit Formula Tips from MrExcel (Laminated Card)

At my Fort Myers Florida Power Excel seminar, someone showed me a new way to Paste Values. Does this video show all possible ways?

Excel MVP Jordan Goldmeier stopped by yesterday for a guest appearance on the podcast. Traditional rules say that a User Defined Function is not allowed to change other cells, but Jordan has found a way to allow UDFs to break the rules. Watch how he uses this technique to create a Rollover effect in cells, first in a periodic table of the elements, and then in a dynamic chart. The link to the periodic table is at Apress/dashboards-for-excel

Rupesh asks how to increment an invoice number in the form of YYMMM001, where the 001 should count up until you run the macro in a new month. A bit of VBA solves the problem.

Stacy has to adjust formulas every year so they average the last five years of figures. This episode offers several techniques to make this easier. The Laminated Formula Tip card mentioned in the episode is for sale at: Formula Tips from MrExcel (Laminated Card)

How to create an Excel chart that will look good on a black and white printer.

Chris has 400K records from the Board of Elections. The date of birth field is a string of 8 digits in YYYYMMDD format. Today's episode shows how to convert that number to a useful date and then how to apply a filter to copy everyone born in a certain decade.