business

Validation Tooltip Trick – Episode 1191

               

This isn’t so much of a dueling podcast as Bill being obnoxious and breaking Mike’s worksheet. Changing the location for the Validation Tooltip box? 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.(…)

Add Print Area – Episode 1190

               

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!

Web Excel – Episode 1189

               

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(…)

Offset Lookup – Episode 1188

               

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. …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(…)

Fill Handle Regression – Episode 1187

               

A lot of behind-the-scenes math goes into dragging the fill handle…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 from MrExcel. Download a new(…)

Learn Excel from MrExcel