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 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 [...]
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 [...]
To average a range of values that meet a given criteria or condition, you use the AVERAGEIF function.
Syntax
AVERAGEIF(range,criteria,average_range)
Range : The group of cells to be evaluated for criteria.
Criteria: is the criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged.
Average_range: is the actual set of [...]
1. Select the range from which you want to delete duplicate rows.
2. In the Data tab, Data Tools group click Remove Duplicates.
3. The Remove Duplicates window will open.
4. Specify whether your columns have headers or not.
5. Select the column(s) from which you want to remove duplicates then click OK.
6. The rows with duplicate data will be deleted and you will get [...]
To sort a data range by multiple columns, or keys, follow these steps:
1. Select the data range you want to sort.
2. On the Home tab, Editing group click on Sort & Filter.
3. Select Custom Sort.
4. The Sort window will open, with 3 combo boxes (drop-down) labeled Column, Sort On and Order respectively.
5. At first you will see one row of [...]
One of the options in the Data menu is the Subtotals. It allows you to create subtotals for a specific column in your worksheet, based on a key in another column. The subtotals will be added to the original data which will be retained as it is.
The best way to explain how to create a [...]
What is a pivot table?
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 is by using an example.
In the image below you see a list of [...]
To count cells, within a given range or list of arguments, that contains only numbers you use the COUNT function.
Dates and text that represent numbers are considered numbers and will therefore be counted.
Logical values, text, or error values are not counted
Syntax
COUNT(value1,value2,…)
Examples:
COUNT(A1:A20) :counts numbers in a range of cells.
COUNT(A1:A20, 7) :counts numbers in a range [...]
