Dueling Excel – “Highlight Open Items after 4 Days”: Podcast #1717


Dueling Excel looks at Conditions and Causes – And NO VBA!

Learn Excel 2010 – “Most Popular Functions =NOW & =TODAY: Podcast #1624


Be Precise or Generalize… “NOW” or “TODAY”? Find Out!

Learn Excel 2010 – “Random Weeks Over Next 6 Months”: Podcast #1469


Generate Random weeks from today, six months forward.

Timestamp – 1106 – Learn Excel from MrExcel Podcast


David from Australia sends in a cool trick for adding a timestamp to a spreadsheet. Episode 1106 shows 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 workday to learn one of the 377 tips from the book!

Episode 551 – Red-Flag Dates


Van writes in with a suggestion about podcast 539. In that podcast, we were trying to calculate which customers had their birthday coming up soon. Van suggests using conditional formatting and the TODAY() function to flag the customers to whom you need to send birthday cards. Episode 551 shows you how. This blog is the(…)

Learn Excel from MrExcel