Excel drop down list

Although "pivot table" seems like a complicated and advanced characteristic of Excel, it is clearly a completely easy but notably useful device. Pivot tables offer an extremely good manner to sum up facts into categories. For instance, when you have hundreds of worker facts showing employees from distinct departments inside special locations, you could create a pivot desk so as to display you at a look how many employees you have got at each location,excel drop down list in every branch, and in each branch at each place.

First, make certain that your list of records has no clean rows or columns - Excel appears at a clean row or column as indicating the quit of the information. Place the cursor everywhere inside the records list and click on on Data in the Menu Bar, click on on Pivot Table and Pivot Table Reports. The PivotTable and PivotChart Wizard - Step 1 of 3 window will seem. Click on the Finish button. From the Pivot Table Field List window, click on and drag the sphere name of the class you need as row headers to the region marked "Drop Row Fields Here." Click and drag the sector name of the category you need as column headers to the location marked "Drop Column Fields Here." Now, click and drag the name of the sphere you need to summarize to the vicinity marked "Drop Data Items Here."

Let's use, for example, a spreadsheet that lists employees (in a column known as NAMES) along with their vicinity (in a column referred to as LOCATION) and branch (in a column known as DEPARTMENT) to create a pivot desk that summarizes what number of employees are in each branch inside each vicinity. After setting the cursor within the facts and clicking on Data within the Menu Bar, Pivot Tables and Pivot Table Reports, the PivotTable and PivotChart Wizard - Step 1 of 3 window will seem - truly click Finish. In the Pivot Table Field List window click and drag LOCATION to the "Drop Column Fields Here", click on and drag DEPARTMENT to the area marked "Drop Row Headers Here", and click and drag NAMES to the vicinity marked "Drop Data Items Here." The resulting pivot table will display you how many employees you've got in each branch, in each area, and in each department at every place. Additionally, the pivot desk headers LOCATION and DEPARTMENT have dropdown lists that permit you to select handiest the branch(s) or locations(s) you need to show. Now, how smooth and the way useful is that?