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
...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
...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
...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
...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
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! |
Bill Jelen

