Start numbering on the second page with 1 (WORD 2007)

1. Follow the steps for removing the page number from the first page.
2. On the Insert tab, in the Headers & Footers group, click Page Number, and then click Format Page Numbers.
3. In the Start at box, type 0.

Organize Your Records the Way You Want Them in Excel

You can customize how you sort your records by using a filter. To activate a filter:
1. In Microsoft Office Excel 2007, click Filter on the Data tab.

2. To choose your sorting options, click the filter arrow on the column that you want to sort, point to Sort by Color, and then click Custom Sort.

3. Create a customized sort order.
a. In the Sort dialog box, under Column, click the drop-down arrow next to Sort by, and choose the field that you want to be sorted. Values should appear in the Sort On field.
b. In the Order field, click Custom List. This will open a window that offers an entirely custom sort list.
c. In the left pane, list the values (each separated by a comma) in the order that you want them to be sorted, and then click Add.
d. In the right pane, select the list you've created, and then click OK.
e. In the Sort dialog box, click OK.

From now on, your records will be sorted according to your customized list.

Easy Filtering of Data in a Microsoft PivotTable View

There is a better way to select multiple report filters than dragging the filter down to a row. It is quicker to select additional filters directly from the original filter.

1. Select the filter, and then click multiple items at the bottom.

2. The filter selection changes to check boxes. Simply select the boxes you require.

Change the Default File Location

Many users find that they tend to open workbooks from the same folder on their computer. If that Windows Vista folder isn't Documents (My Documents in Windows XP), you can change the folder that Microsoft Office Excel 2007 displays when you want to open or save a workbook. Here’s how:
1. Click the Office button.
2. Click Excel Options.
3. In the left column, click Save.
4. Type the desired location in the Default file location box.

Fill In the Blanks in Spreadsheets the Easy Way

1. Select all the rows in your Microsoft Office Excel spreadsheet data set.
2. On the Home tab, in the Editing section, click Find & Select, click Go To, click Special, click Blanks, and then click OK.
3. Click the equal sign (=) on the toolbar, select the cell above, and then hold down the CTRL key while you press ENTER. Blanks in the spreadsheet will be filled automatically.
4. Copy all the data, click Paste Special, and then click Values. This will overwrite the formulas and enable you to sort the data by filling in each empty cell with the same information as the one above. This tip will work on any size of data set.

Insert and Format Charts

In Microsoft Office Excel 2007, you will find many new professional-looking charts to help you visualize your data and communicate it more effectively. To insert a chart:

1. On the worksheet, arrange the data that you want to use in a chart.
2. Select the cells that contain the data that you want to use for the chart.
3. On the Insert tab, in the Charts group, click the chart type, and then click a chart subtype that you want to use.

To see all available chart types, click a chart type, and then click All Chart Types. Excel will select the default formatting layout, but you can quickly modify it:
1. On the contextual Design tab, select a chart layout from the gallery to display the legend, axis, and title the way you want.
2. Select a chart style to modify color and effects.

Move the Cursor in Any Direction During Data Entry

By default, the cell pointer in Microsoft Office Excel moves down when you press ENTER after entering data in a cell. You can, however, change the direction in which the cell pointer moves.

1. Click the Office button, click Excel Options, and then click Advanced.
2. Select the After pressing Enter, move selection check box if it isn't already selected, and then on the Direction menu, click the direction in which you want the pointer to move.

Also, when working in a document, you can make the pointer move in the opposite direction from the one you've chosen by holding down the SHIFT key while you press ENTER.