Excel -- Back from Hiatus! - Episode 1411

1,522 views · Published 22 August 2011 · 2:45 · Indexed 26 October 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: Exciting Updates and New Excel Tips | Learn Excel from MrExcel Podcast | PowerPivot Tricks & Book Giveaway.

Welcome to the MrExcel podcast. In this episode, we're back with some exciting updates and new Excel tips and tricks. First off, I want to thank everyone for their patience during my hiatus. As some of you may know, I've been busy writing the third edition of Learn Excel from MrExcel, which is now available. This edition has a huge subtitle, "Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and much more," because I wanted to make it clear that this is not a beginner's Excel book. It's for those who use Excel on a regular basis and want to take their skills to the next level.

During my time away, I also spent two weeks house-hunting in Florida and had the opportunity to see the space shuttle Atlantis launch. It was an incredible experience that I will never forget. On a less positive note, my car caught on fire at a gas station, but thankfully, a quick-thinking individual named Norm grabbed a fire extinguisher and prevented any major damage. I also attended our annual sales meeting in Laguna Beach, where I discovered a new favorite restaurant, Eva's Caribbean Kitchen.

But enough about my adventures, let's talk Excel. I recently learned about some amazing new PowerPivot tools that I can't wait to share with you. And for those of you who have been wanting to use PowerPivot for SharePoint but don't have an IT department or SharePoint, I have a trick that will blow your mind. I'm also in the planning stages for three new books, including one that will be insanely challenging and another that will be perfect for beginners.

Now, onto the fun stuff. In this episode, I'll be showing you a cool trick that I learned from Jeff at Pivot Stream. Using a Pivot Table and slicer, I'm able to change the SmartArt and pictures in my presentation. It's absolutely wild and I want to challenge you to figure out how I'm doing it. Shoot me an email at [email protected] with your guess and in one week, I'll reveal the answer on the podcast. The first five people to correctly guess will receive an autographed copy of my new book.

Thank you for tuning in to this episode of the MrExcel podcast. I'm excited to be back and can't wait to share more Excel tips and tricks with you. Don't forget to check out the new edition of Learn Excel from MrExcel and stay tuned for more updates and contests. See you next time!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) MrExcel Podcast back after writing new book
(00:22) Added content and target audience 
(00:35) Other events during hiatus 
(01:23) Exciting new PowerPivot tools 
(01:33) Upcoming book releases 
(02:32) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Charts
Data Analysis
Episode 1411
IF function
Learn Excel from MrExcel podcast
Pivot Table slicer
Pivot Tables
PowerPivot
Subtotals
VLOOKUP


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153089/


Bill returns from a writing hiatus with a new book, one less car, and a good story to tell. Also, how is he using that pivot table slicer to show pictures on a screen? Figure it out and you can win the new book.

More from this channel