MrExcel Publishing
Your One Stop for Excel Tips & Solutions

A Look Back At 13 Years of The MrExcel Podcast

October 12, 2018 - by Bill Jelen

A Look Back At 13 Years of The MrExcel Podcast

In the summer of 2005. I was flying to Toronto every month to record two appearances on Leo Laporte’s Call for Help TV Show. On the way home, I was having dinner at the airport bar and the guy sitting next to me said a sentence that was a complete mystery to me:

"Did you know that Leo’s TWiT Podcast is the Number One Podcast on iTunes?"

I had never heard of a podcast. I had never heard of iTunes. I had never heard of TWiT.

TWiT stands for This Week in Tech. It is Leo’s audio podcast that debuted April 18, 2005.

On my next trip to the Rogers TV studios in Toronto, I asked Leo about podcasting. He was the one who suggested that I start an Excel podcast. Now – all of Leo’s podcasts at that time were audio. You would subscribe to the podcast on iTunes and once a week, a new hour-long episode would arrive and be downloaded to your iPod.

continue reading »

More Reading

Find One-Hit Wonders with UNIQUE

Find One-Hit Wonders with UNIQUE »

October 4, 2018 - by Bill Jelen

UNIQUE is one of the new dynamic array functions in Excel. Using the second or third arguments, you can control if the function returns the UNIQUE or DISTINCT list of items. You can also control if UNIQUE works row-wise or column-wise.

Streamlining the Bennu Model With RandArray

Streamlining the Bennu Model With RandArray »

October 3, 2018 - by Bill Jelen

Last week at Ignite, the Excel team introduced dynamic arrays. Today, a closer look at the RANDARRAY function.

read more articles »

IMA Data Analytics Leveraging Excel

Featured Products

Excel 2016 in Depth

Excel 2016 in Depth »

Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016.

Excel Video Medley

Excel Video Medley »

Excel Video Medley covers everything from Pivot Tables to VLOOKUP to VBA. Learn how to create scientific graphs. Use Excel for statistics.

100 Excel Simulations

100 Excel Simulations »

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.

M is for (DATA) MONKEY

M is for (DATA) MONKEY »

Despite the moniker "data monkey", we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.

Learn to Write DAX

Learn to Write DAX »

Data analysis expressions (DAX) is the formula language of PowerPivot and Power BI. Simply reading a book is normally not enough to help Excel users learn DAX skills – you need to complete exercises and get plenty of practice to make the transition.

Supercharge Excel When You Learn to Write DAX For Power Pivot

Supercharge Excel When You Learn to Write DAX For Power Pivot »

Hands-on book to learn and master the DAX language!

see more products »