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 [...]
Filed under: Excel, File Management, Toolbars | 2 Comments »
There are many tools available to help you prepare for migration to Office 2007. The 2007 Office Resource Kit has white papers, books and other tools that you can download, such as the Migrating to Excel 2007 white paper.
One of the tools is the Migration Planning Manager kit, which contains an Office File Converter that [...]
Filed under: Excel, File Management | No Comments »
When you save a Microsoft Office file, you can store keywords to help you find that file later. For example, when you’re creating an estimate for a client’s Excel project:
In Excel, click on the File menu, and click on Properties
On the Summary tab, enter Estimate, Excel in the Keywords box, then click OK.
Later, you can [...]
Filed under: Excel, File Management | 4 Comments »
When saving or opening a file in Excel or Word, you might have to navigate through several layers of folders to find the one that you need. To make it easier to open folders that you use frequently, add them to the My Places bar. To do this in Excel:
Click the File menu, and click [...]
Filed under: Excel, File Management | No Comments »
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.