MrExcel Podcast

Why One Comma in $1234,567?

               

A week ago, I was invited by Areef Ali to do three Excel seminars in the beautiful twin-island republic of Trinidad and Tobago. At one of the breaks in the first day, one of the students in the class showed me the most perplexing problem in her Excel. She and her co-worker, both using two(…)

Learn Excel – “Bob Umlas Unwind Alt+Enter in Cell”: Podcast #1837

               

In today’s Podcast, another guest post by Bob Umlas. Bob has data where someone has used Alt+Enter to put multiple lines in a Cell. He wants to break each of those lines out to a new Cell. This video shows the easy trick. Back

Learn Excel – “Nested Functions with fx”: Podcast #1831

               

Rob asks for tips on entering Nested IF functions in Excel. Today in Episode #1831, Bill shows us how to use the Function Arguments dialog box to assist. Back

Learn Excel – “Use Solver with VBA”: Podcast #1830

               

Haizen has to arrange transport for ‘N’ employees where ‘N’ can be 1 to 500. There are three types of vehicles available with different capacity and different cost. He wants a Formula for Back

Learn Excel – “15 Years Ago Today: Convert Date to Month”: Podcast #1829

               

It was the Saturday before Thanksgiving in 1998 when I opened Notepad and launched the first ‘Tip of the Week’ at MrExcel.com. Using the Wayback Machine, see how the tip for Converting Daily Dates to Months holds up 15 years later. Lets take a look at Episode #1829 and see… Back

Learn Excel from MrExcel