Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Thursday, August 27, 2009

2010 Exit Excel - 1089 - Learn Excel from MrExcel

It became harder to exit Excel starting in Excel 2007. Episode 1089 takes a look at how to exit 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!

Labels:

Wednesday, August 26, 2009

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!

Labels: ,

Tuesday, August 25, 2009

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 learn one of the 377 tips from the book!

Labels: , ,

Monday, August 24, 2009

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!

Labels: ,

Friday, August 14, 2009

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!

Labels:

Thursday, August 13, 2009

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 workday to learn one of the 377 tips from the book!

Labels: ,

Wednesday, August 12, 2009

2010 Pivot Labels - 1078 - Learn Excel from MrExcel Podcast

Excel 2010 finally gives you an option to fill in the blank spots in the outermost row fields. Episode 1078 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!

Labels: ,

Tuesday, August 11, 2009

2010 Ribbon Customization - 1077 - Learn Excel from MrExcel Podcast

Office 2010 finally allows you to customize the ribbon. Episode 1077 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!

Labels: ,

Monday, August 10, 2009

2010 Backstage - 1076 - Learn Excel from MrExcel Podcast

More features from the Excel 2010 technical preview: The Excel 2010 Backstage view replaced the old Office Icon for all of the things that you do to a document. Episode 1076 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!

Labels:

Friday, July 31, 2009

Dueling: Sparklines - 1070 - Learn Excel from MrExcel Podcast

Sparklines are tiny, word-sized charts that can appear in a cell. Excel 2010 makes it easy to create sparklines. In Episode 1070, Mike & Bill show you several examples 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!

Labels: ,

Thursday, July 30, 2009

Icon Sets Data Bars - 1069 - Learn Excel from MrExcel Podcast

Excel 2010 introduces some new icon sets and data bars functionality. Episode 1069 will show you these features.

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!

Labels: , ,

Wednesday, July 29, 2009

Excel 2010 SmartArt - 1068 - Learn Excel from MrExcel Podcast

Improvements to Excel 2010's SmartArt functionality. In Episode 1068, I show how to make your SmartArt text dynamically generate from cells in the worksheet.

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!

Labels: ,

Tuesday, July 28, 2009

Slicers! - 1067 - Learn Excel from MrExcel Podcast

One of the great new features in Excel 2010 is the Slicer functionality. Slicers are a great visual way to filter your pivot table. Episode 1067 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!

Labels: , ,

Monday, July 27, 2009

Excel 2010 Paste Options - 1066 - Learn Excel from MrExcel Podcast

A preview of new features coming in Excel 2010: Episode 1066 shows you the Paste Options shortcuts 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!

Labels: ,