Mon, 29 March 2010
|
Fri, 26 March 2010
Patrick from Alaska asks how to copy a chart but detach it from the original data set. In this Dueling Excel podcast, Mike and Bill show you various solutions.
...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! |
Wed, 24 March 2010
Jim from California asks why it takes two clicks to create a new workbook in Excel 2007. Episode 1197 shows you the solution. |
Tue, 23 March 2010
As envisioned by Professor Tufte, sparklines could have a bit of shading to show the acceptable ranges. While this is not necessarily built in to Excel 2010, you can achieve the same effect. Episode 1195 show you how. |
Mon, 22 March 2010
In Episode 1194, we take a look at how to add labels to your sparklines. |
Thu, 18 March 2010
Mary asks about how to force a report to fit to one page wide. Episode 1192 takes a look at Layout mode, Scale to Fit, and orientation....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! |
Wed, 17 March 2010
This isn't so much of a dueling podcast as Bill being obnoxious and breaking Mike's worksheet. Maybe there is a use for this, or maybe not. Episode 1191 will show 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! |
Tue, 16 March 2010
Excel 2007 offers a new way to set up non-contiguous print ranges. Episode 1190 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! |
Mon, 15 March 2010
Excel 2010 offers a cool trick that anyone with a browser can try out right now. You can view and edit your Excel workbooks in a browser. Episode 1189 shows you how to try it out....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! |
Fri, 12 March 2010
Find a value in this row and then get the values 1 and 2 columns to the right of that value. Mike and Bill duel it out in Episode 1188. |
Thu, 11 March 2010
Howie asks why the fill handle does what it does when you select four numbers and drag. |
Wed, 10 March 2010
In today's podcast, a quick way to hide the column headers, and a row height in inches ...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! |
Mon, 8 March 2010
Mike and Bill get together for another live dueling podcast, counting the number of Mondays between two dates. Episode 1185 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! |
Thu, 4 March 2010
Create a pivot table that drives a SmartArt diagram. Episode 1184 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! |
Thu, 4 March 2010
Is the fill handle smart enough to fill in quarters and halves? Maybe. Maybe not.Episode 1183 shows you why. Also, in this episode, a challenge to users - view the podcast for details! ...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! |
Learn Excel from MrExcel Video Podcast
Learn Excel from Bill Jelen with this daily 2 minute video podcast!
Bill Jelen
Buy The Learn Excel Podcast DVD
Categories
podcastsVidcast
general
Archives
JanuaryOctober
September
July
June
March
February
January
December
November
October
September
August
May
April
March
February
January
December
November
October
September
August
July
June
May
April
March
February
January
December
November
October
June
April
April
March
February
January
Syndication
