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

Pivot Table Data Crunching: Microsoft Excel 2016

Pivot Table Data Crunching: Microsoft Excel 2016 »

Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.

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.

MrExcel LIVe

MrExcel LIVe »

A book for people who use Excel 40+ hours per week. Illustrated in full color.

Power Pivot and Power BI

Power Pivot and Power BI »

Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

Power Excel With MrExcel - 2017 Edition

Power Excel With MrExcel - 2017 Edition »

This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

Supercharge Power BI

Supercharge Power BI »

If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.

see more products »