Learn Excel Blog

UserVoice – What is your Idea to Improve Excel?

               

I just returned from the Microsoft MVP Summit where I spent a few days with the Excel team. Would you like a way to communicate your Excel improvement ideas to the people who build Excel? There is a new way.

Read More

On Excel’s 30th Anniversary, Power Query is a Game-Changer

               

Today, September 30, 2015 is the 30th anniversary of Microsoft Excel. Version 1.0 debuted for the Mac on September 30, 1985. Excel, of course, was not the first spreadsheet program. It was not even the first spreadsheet program from Microsoft, who had released Multiplan a few years earlier. Eventually, though, Excel went on to become the spreadsheet program that is in use on 750 million desktops.

Illustration Credit: Walter Agnew Moore

Illustration Credit: Walter Agnew Moore

Over the last several months, I’ve been updating my books for Excel 2016. One of the best features, though is the feature formerly known as Power Query. This feature is so good, anyone with Excel 2010 or Excel 2013 can download Power Query for free.

I recently had a change to review an early draft of M is for Data Monkey by Ken Puls and Miguel Escobar. In an hour with the book, I learned many new Power Query tricks. So, today, for the return of the MrExcel Podcast, we take a look at how Power Query can be used to clean and load a whole folder of badly formed CSV files and then repeat the whole process tomorrow in a couple of clicks.

Excelapalooza Discount Coupon

               

I will be joining the Excelapalooza speakers this year, providing six sessions at this three-day conference outside of Dallas, Texas. Readers of MrExcel.com can save $145 on registration costs. Use coupon code MRExcel15 to reduce the registration cost to a flat $1305 price.

 

Top 10 Excel Songs on YouTube

               

Joe Chirilov is a long-time project manager on the Excel team. He summed it up best when he noted: “One of the perks of working on an awesome product like Excel: Fan Videos”.

With the May 5, 2015 release of Excel Func from Professor Steve Tuttle, the Top 10 Excel Song Parody list gets a shake-up. Here, for your viewing pleasure are the top 10 Excel songs.

#1: Excel Funcs (Parody of Uptown Funk)

Not just clever lyrics, but great production values and a riff “Excel Func You Up” that gets caught in your head. Coming in at #1 is U.T. MIS professor Clint Tuttle with Excel Funcs.

#2: Pivot Tables Make Everything Just Right

This looks like a few high school students, lead by @youarentbenjamin singing about Cells and Rows.

#3 Santa Baby, Excel Style

Szilvia Juhasz, backed by the Big Lucky Band belts out a great Excel holiday number. If it wasn’t 80 degrees in Akron Ohio today, this might rank higher. “I’ll let you touch my XY Scatterplot, Santa Baby”. Hot.

#4 All About that Paste

Professor Clint Tuttle has two songs in the Top Five with his acoustic guitar rendition of It’s All About that Paste, Copy & Paste.

#5 Bye, Bye, Excel & I

Another great voice – Karen X Cheng sings about her days on the Excel team, to the tune of Bye Bye American Pie. Some inside baseball here, but I’ve been in Building 36, so I get it.

#6 Dueling Excel Theme

You will see a lot of your favorite Excel MVP’s in this song & animated movie by Szilvia Juhasz for the Dueling Excel podcast series.

#7. Dean Pelton from the NBC Sitcom, Community

It is short. It is not catchy. But Excel was a huge story arc in this episode of Community. Since NBC reaches a 3E7 viewers, this 21 second ditty makes it into the Top 10.

#8 Best Skills In Your Life

Professor Clint Tuttle again, with a parody of The Best Days In Your Life.

#9 Royals Parody

This video shows how much we’ve learned in the last 2 years, such as the all-important rule of “hold your cell phone landscape when shooting video for YouTube”, but the portrait framing from row 2 doesn’t take away from the catchy lyrics from Clint Tuttle.

#10. We all Work with Excel Spreadsheets (Yellow Submarine parody)

There are a couple of versions of this Karen X Cheng song floating around. It would be great to have one  with better sound.

There you have it… the top 10 Excel tribute songs on YouTube. If you run across more, or if you want to make one of your own, drop me a note at MrExcel.com.

Oh wait… #11 Don’t Fear the Spreadsheet by George Wood. George Wood has composed a number of short podcast themes for the TWIT network and for the MrExcel podcast. Who can forget the Office 2007 theme for Where is it Wednesday – “It’s a Great Feature, I just can’t find it anymore…”. But of all the George Wood themes, I like this More Cowbell tune the best. Cameo here by DFSS co-author Tyler Nash.

Have You Ever Had an Excel Moment Like This?

               

If you’ve ever felt like:

  • “My Excel reports take way too long to update each month/week”
  • “I spend hours collating and cleaning data, updating formulas and charts and then no one reads my reports anyway, what’s the point?”
  • “If I could just impress the boss I’d get that pay rise/promotion I deserve”
  • “I need to get my Excel skills up to date so I can stand out from the crowd of other job applicants”
  • “I’m not sure how to approach setting up my Excel workbook the right way, so it’s easy to build and maintain”

Free Excel Dashboard Webinar

If you’re not sure what a dashboard is or how these skills might be relevant to you, and help you overcome the challenges above, then you can attend Mynda Treacy’s Free Excel Dashboarding Webinar. The webinar is today, Friday April 17, 2015 at three different times around the world. There are replays this weekend (Yes, it is good enough to take an hour of your Saturday!) and then on Monday and Tuesday.

Over 3000 people attended the previous webinar with glowing reviews. I highly recommend it!

Using just straight Excel, the webinar will teach you how to build a dashboard like this:

Dashboard

 

Free Excel Dashboard Webinar

Learn Excel from MrExcel