accounting

Scale to Fit – Episode 1192

               

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

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

Learn Excel from MrExcel