Rob PowerPivotPro Collie to offer PowerPivot School


PowerPivotPro SchoolRegistration is now open for Rob Collie’s Advanced PowerPivot course. Rob is my favorite Excel PowerPivot guru – he creates amazing dashboards and reports and has mastered time intelligence and other difficult functions.

If you want to become awesome at PowerPivot, check out his course. Registration is open August 1 – 7, 2013. Click here for more information.

August 2, 2013 at 11:38 am Leave a comment

Excel SoCal Social – Meetup in Santa Monica Weds July 31 2013


=”It’s “&TEXT(DATE(2013,7,31),”mmm dd, yyyy “) & ” @ ” & TEXT(TIME(17,0,0),”h:mm AM/PM”) & ” somewhere!”

Calling all southern California Excellers: Let’s meet up Wednesday July 31, 2013 6-8PM at Finn McCool’s Irish Pub in Santa Monica, hosted by @XSzil and @MrExcel.

While I make it to SoCal almost every summer, it’s been 9 years and 354 days since the last meetup down in Irvine.  Clearly, we can’t let 10 years go by, so it is time to get together again. (Wow – I look 10 years younger in these pictures from the last event)

This time, you will get two Excel gurus – as Szilvia Juhasz (@XSzil), Hollywood’s first spreadsheet heroine will be co-hosting the event. We will meet up at Finn McCool’s Irish Pub, 2702 Main Street, Santa Monica, CA 90405. There is a happy hour from 6-7PM and then we will do some live tweeting from 7PM to 8PM at the hashtag #XLSoCal. If you can’t attend, join us via Twitter. It is sure to be a good time – the most fun you will ever have while joining a bunch of tipsy Excel nerds arguing about VLOOKUP!

(Note for those tweeting: 7PM Pacific is 10PM Eastern US, 3AM in London, Noon in Sydney)

If the happy hour is happy enough, you might even go to see us re-enact the day when Szilvia showed up in one of my classes wondering why I didn’t include the awesome Show Pages feature in the first edition of Pivot Table Data Crunching. (Don’t worry, it is in the 2nd through 4th editions and one of my favorite pivot table tricks now).

July 28, 2013 at 1:20 am Leave a comment

Winners of Autographed Copies of “Ctrl+Shift+Enter” by Mike “ExcelIsFun” Girvin


Congratulations to You!

Continue Reading July 21, 2013 at 1:21 pm Leave a comment

Dueling Excel – “Show Baseball Innings as 7.1”: Podcast #1755


Baseball Statistcal Averages and Microsoft Excel – on The Same Team.

Continue Reading July 19, 2013 at 1:36 pm

Learn Excel – “Drag & Drop to Values, An Excel Daily Paper and Trending XL”: Podcast #1754


So much going on you’ll just have to read today’s Learn Excel post…

Continue Reading July 18, 2013 at 1:08 pm

Learn Excel – “Excel Latitude to Map Hyperlink”: Podcast #1753


Link your Excel Data to Geographic Locations.

Continue Reading July 18, 2013 at 12:42 pm

Learn Excel – “Summarize Dates by Month and Year” – Podcast 1752


An Easy Read for 10 Years of Data…

Continue Reading July 17, 2013 at 12:40 pm

Older Posts Newer Posts


Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 740 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive