2010

2010 Picture Tools – 1088 – Learn Excel from MrExcel Podcast

               

Excel 2010 adds some new picture tools. Episode 1088 shows off some of the cool tricks in Excel 2010. 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!

2010 Screen Clipping – 1087 – Learn Excel from MrExcel

               

New in Excel 2010, stolen from OneNote 2007 – the ability to insert a screen clipping into your worksheet. Episode 1087 shows you the two ways to use this new functionality. 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(…)

2010 Live Preview – 1086 – Learn Excel from MrExcel Podcast

               

More tricks with the Paste Options menu, this time with Live Preview. Episode 1086 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!

Dueling: 2010 New Functions – 1080 – Learn Excel from MrExcel

               

Excel 2010 offers 56 new functions. In this dueling podcast Episode 1080, we take a look at some of those functions. 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!

2010 Pivot Percents – 1079 – Learn Excel from MrExcel Podcast

               

Another improvement in Excel 2010 is in the pivot table calculation options. You can now calculate the rank of an item, or the % of the parent row! Episode 1079 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(…)

Learn Excel from MrExcel