In light of issues uploading and syndicating 'Learn Excel from MrExcel Podcasts' we are attempting to resume uploading beginning with Episode #1588. We will not be attempting to upload earlier MrExcel Podcasts from this point. If you need to get caught up with previous episodes, please visit the 'Learn Excel from MrExcel Video Blog' on WordPress found here: http://learnmrexcel.wordpress.com/ We apologize for any inconvenience this may cause.

Thank you for understanding - Enjoy the Podcasts no matter where or how you view them!

We could not get Episode #1511 to load with Libsyn. Our Apologies. You may view the full length Blog Post and Video Podcast at the Learn Excel from MrExcel Blog on WordPress: Click Here To Visit

Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring Bill “MrExcel” Jelen! CFO Excel Pro offers, “… clear, concise illustrated articles written by Microsoft MVP Bill “Mr. Excel” Jelen that provide readers with step-by-step solutions to nagging “real-world” Excel problems.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

For anyone who hasn’t noticed, the third edition of Learn Excel is now available. This edition is titled “Learn Excel 2007-2010 From MrExcel – Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More – 512 Excel Mysteries Solved.” Yes, it is a really long title, but I wanted to convey that it is not a book for Excel beginners.

To learn more about Learning Excel 2010 and Bill's new book "Learn Excel 2007 through Excel 2010", from Bill himself, visit the "Learn Excel" blog post here to read his notes.

Today we will learn how to replace Numeric Chart Labels with a Formula using the method Bill gives in Episode #1426. Also learn to vary Colors by Point AND “Making Excel Columns Wider” using Gap Width.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions

In this episode of the MrExcel Podcast series [Episode #1223], you will learn how to customize the Excel 2010 ribbon to suit your needs.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

Tweet

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

One of the best features of Excel 2010's Backstage View is the Recently Used File List. This episode takes a look at the ins and outs of the Recently Used File list.

Deb from Wisconsin noticed that her date grouping was wiped out after refreshing a pivot table. Episode 1201 takes a look at how to find the bad dates and solve the problem.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Well, it was supposed to be for April Fools day, but after a slight mix up here Episode 1200 - MrExcel's 1100th Podcast - almost became 'The Lost Episode'.

Here is a great trick with the Speak Cells tools. Episode 1200 shows you how.
 
...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!