will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Excel Favourites Add-In
As you work in Excel, the files that you’ve used most recently appear at the bottom of the File menu. The default number of files that appear is 4, and you can increase this to 9, in the Tools>Options dialog box, on the General tab.
If you’d like more than 9 entries, and some control of the list order and names, you can download and install Ken Puls’ XLG Favourites Add-in. Stephen mentioned this add-in yesterday in the comments, and I’ve installed it to try it out.
The add-in creates an XLG item in your File menu, where you can open and manage a list of favourite files.
You can quickly add the current workbook to the list, and use the Manage XLG Favourites command to rename the items, and change the order of the list.
I’ve got several files that I uses every day, and this should make it easy to find and open them quickly.
Filed under: Excel, File Management, Toolbars
Comment from Stephen
Time: October 30, 2008, 7:20 am
Debra, one of the great benefits I found in this add-in is to be able to add favourite folders as well as favourite files. eg. a folder for each project, customer, etc.
And the files you can add are not just limited to Excel files. eg. adding a pdf or doc file then selecting it from the XLG Favourites menu will see the file open in their native application - so there’s even less reason to work from any application other than Excel!
(Glad to provide some inspiration for your blog. Keep up the good work.)
Comment from Debra Dalgleish
Time: October 30, 2008, 2:35 pm
Thanks Stephen, and inspiration is always appreciated! I haven’t tried the folders or other apps files yet, so thanks for pointing out those features.