Excel provides the PivotTable feature to help you examine data. A PivotTable is an interactive table that summarizes, organizes, and compares large amounts of data in a worksheet. You can rotate the rows and columns in a PivotTable to obtain different views of the same data. You can use a PivotTable to analyze data in an Excel workbook or data from an external database, such as Microsoft Access or SQL Server. [More]

You can find a value in a range of related data in a worksheet by using lookup functions. These functions find a value in the first row or column of a list and then return a corresponding value from another row or column. [More]

You can use conditional logic in a formula to return a specific result depending on whether a certain test, or condition, is met. If the condition is true, one result will be calculated. If the condition is false, a difference result will be displayed.

Microsoft Excel 2007 provides several logical functions you can use for conditionally evaluating a calculation: IF, AND, OR, NOT, and IFERROR. [More]

Once you have placed a graphic in InDesign, you might need to reposition the image within the frame. [More]

If you send an important email, you can easily remind the recipient to review it with an email flag. To do so, launch a new Message form. [More]

To quickly format a paragraph with single spacing, place the insertion point in the paragraph and press [Ctrl]1. Similarly, you can double-space a paragraph by pressing [Ctrl]2. To achieve the setting in between (1.5 spacing), press [Ctrl]5. [More]

If you’re working on a long document and want parts of the document to have Landscape page orientation, you can do so by following the steps outlined below: [More]

If your PivotTable’s source data contains errors, you’ll notice those errors pop up in your PivotTable too. [More]

When you're plotting points on a chart, a flat line of static data can provide a visual point of reference, so it's easy to compare the rest of the chart's data to that value. [More]

To make your documents easier to store, route, and locate, Word automatically saves hidden information (a.k.a. metadata) within your document. Metadata includes information such as authors’ and editors’ names, routing slips, and email headers. You can configure Word to remove this metadata during the save process if you'd rather restrict access to this information. [More]