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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
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.
In this Dueling Excel Episode, 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.
Howie asks why the fill handle does what it does when you select four numbers and drag. Episode #1187 discusses trend lines, LINEST, and straight line regression.
...This blog is the video podcast companion to the book, Learn Excel 97-2007.
In today's podcast, a quick way to hide the column headers, and a row height in inches. Episode #1186 shows you how.
...This blog is the video podcast companion to the book Learn Excel 97-2007 from MrExcel.
Create a pivot table that drives a SmartArt diagram.
...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!
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
How to visually present statistical values (+/-) in a cell
...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!
Create a dropdown that will display a different chart on your 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!
