Ute from Germany sends in a better way to show negative points in a column chart in a red color. His cool trick works for Excel 97-2003. Episode 674 will show you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every(…)
Hamideh sends in an interesting question. He set up a really cool custom number format to prevent people from having to enter 4 dashes in a part number. However… now Find appears not to work. In Episode 673, I will show you the hidden setting to assist with the Find. This blog is the video(…)
Bill makes a special offer for you today in Episode 600 . . .
Joe Marten sends in a better way to limit the number of characters entered in a cell. Episode 599 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book! For(…)
Jerry from Georgia asks how to randomly distribute numbers from a list of numbers. For example, you might want to evenly distribute a list of prospects to sales reps. Episode 598 shows the somewhat convoluted method to make sure you don’t get any duplicates. This blog is the video podcast companion to the book, Learn(…)