Archive for May, 2008

10+ tips for boosting your Word 2007 productivity | 10 Things | TechRepublic.com

10+ tips for boosting your Word 2007 productivity | 10 Things | TechRepublic.com

We’ve put together a collection of tips from our Office Suite newsletter that will help them acclimate to Word’s new functionality and show them how to perform their everyday tasks using Word 2007 tools and techniques. You can download the collection as a PDF or follow the links below to read the tips individually.

Turn off gridlines in your Excel applications

Turn off gridlines in your Excel applications

Gridlines in your Excel worksheets can be quite distracting. Mary Ann Richardson explains how to make gridlines invisible in Excel 2002, 2003, and 2007.

Add autonumbering to your Excel spreadsheet

Add autonumbering to your Excel spreadsheet | Microsoft Office | TechRepublic.com

Unlike Access, Excel does not have an autonumbering feature that increments a number each time you add a new row. With Excel 2003 and 2007, you can use the Row function to add your own autonumbering to a data list.

Automatically add new data to an Excel chart | Microsoft Office | TechRepublic.com

Automatically add new data to an Excel chart | Microsoft Office | TechRepublic.com

Once you go through all the work of creating and formatting a chart, you don’t want to have to start over again when new data comes in. Fortunately, you don’t have to with Excel. You can simply copy and paste the new data to your chart.

More ways to use Excel to save yourself time and effort.

Enter text without changing the underlying cells in Excel 2007

Enter text without changing the underlying cells in Excel 2007

Excel cells are limited to 256 characters. However, the cell’s size and ability to display its contents change with the size of its surrounding columns. Excel 2007’s text boxes overcome these potential limitations

I know I’ve had this issue before. Check out the solution in Office 07!

KeyStone Learning - Office 2007 Tips

Deanna Reynolds has some excellent tips and tricks for many of the Office 2007 applications.  For instance,  she offers some advice on ways to reduce spam in Outlook as well as the steps for publishing a Powerpoint Presentation to the web.

Take a look at Deanna’s blog, over at Keystone Learning, for more Office 2007 tips and tricks!