Pivot table is a feature of Excel that takes a long list of data, summarizes it into a shorter list that is more easy to analyze and assimilate.
The best way to explain how to create a pivot table in Excel 2007 is by using an example.
Below is a list of products, salesmen and total sales [...]
To hide rows based on cell value in Excel 2007 follow these steps:
Prepare your data including a header row.
In the Home tab, Editing group, click Sort and Filter then select Filter from the menu.
Your data will now look like this:
In this example we want to hide rows where the sales are greater than or equal [...]
To sum times you usually use Excel built-in function SUM. If you have three cells A1, A2 and A3 formatted as time (hh:mm), and you have :
A1 = 02:30
A2 = 10:15
A3 has the formula: =SUM(A1:A2)
then A3 will have the correct values of 12:45.
However if your total times are greater than 24 hours then things get [...]
If you want to copy data from Excel to Microsoft word then follow these steps:
In Excel
Select the worksheet data (range) that you want to copy to a Word document.
On the Home tab, Clipboard group, click
One of the newly introduced functions in Excel 2007 is the IFERROR Function. If you are using a formula in a cell, this function allows you to trap formula errors and specify a value to be substituted in the cell in case of an error.
Syntax
IFERROR(value,value_if_error)
Value is the argument (formula) that is checked for an error.
Value_if_error [...]
To copy data and then paste it as a picture (image) follow these steps:
Select the range you want to copy.
In the Home tab, Clipboard group, click Copy.
Select a cell in the range where you want to paste the picture.
In the Home tab, Clipboard group, click on the arrow below the Paste icon, point to As [...]
I find it annoying sometimes when I enter a correct formula in a cell and Excel gives me an error like “Inconsistent Formula” or “Formula Omits Adjacent Cells”.
Fortunately you can hide these error indicators through Excel Options.
Click the Microsoft Office button.
Click Excel Options.
In the left pane of Excel Options click Formulas.
In the Error Checking [...]
To change Excel 2007 default file location, follow these steps:
1. Click the Microsoft Office Button.
2. Click Excel Options.
3. In Excel Options window (left side) click Save.
4. In the text box labeled Default File Location , specify the path for the required location.
To save an Excel 2007 workbook to Excel 97-2003 format follow these simple steps:
1. In Excel 2007, open the workbook that you want to save in Excel 97-2003 format.
2. Click the Microsoft Office Button and point to the arrow next to Save As.
3. Under Save a copy of the document, click Excel 97-2003 Workbook.
The file will be [...]
If you want to validate a cell to restrict data entry to a date range then follow these steps:
Select the cell you want to validate.
On the Data tab, in the Data Tools group, click Data Validation.
The Data Validation dialog box will open.
In the Data Validation dialog box, click the Settings tab.
Click on the Allow box [...]
