Wed, 16 June 2010
Open Multiple Files with a Single Click. Do you always have to open the A/R file every time you open the invoice file? Group them in a workspace so you can open them together. Episode 106 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! |
Fri, 4 June 2010
Eric writes in with a frustrating question; "Why can't the macro recorder record the action of creating a pivot table? No matter what I do, it hardcodes that the original pivot data is 469 rows tall." Eric doesn't want to learn VBA, but needs enough to be able to generalize the recorded code. Episode 1211 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, 3 June 2010
|
Wed, 2 June 2010
|
Tue, 1 June 2010
Alternate shortcut keys....other ways to undo. Other ways to copy and paste. How to edit a cell comment. How to insert a new worksheet. And, a quest...how to assign F1 to do F2. Episode 1209 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! |
Bill Jelen

