Excel -- Back from Hiatus! - Episode 1411
1,522 views · Published 22 August 2011 · 2:45 · Indexed 26 October 2026
Channel: MrExcel.com · 2011 · Education
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920