| | |||||||
|
Welcome to the YD Scuba forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact support. |
| Non Diving Posts: Discuss Pivot Tables in Excel in the Non-Diving Related Forums forums: OK, in a moment of stupidity my boss asks me to put together some information about some products I deal ... |
| | LinkBack (1) | Thread Tools | Display Modes |
| ||||
| Data should be in a "database", with each column having a (different) header. You need a key data item or add a counter column depending on the data. After that you just use the data wizard (its one of the few nice wizards on XL) You can summate the key data item or count it (again depending on what you are trying to show). Then select one or two of the variables to analyse and set one up as a row and another as column. The pivot table should now generate (either on the sheet or a new worksheet - you chose on the wizard) That's it. Your boss can dick about with it now. You can add variables hide them summate them do all sorts all in real time. Its the single best tool I have ever seen for data analysis and the best bit of MS software ever written in the history of time. There used to be a good tutorial on XL but they seem to have gone for online stuff now. Annoying - it would take about 500 words of posting to explain and I could show you in less time than I have wasted so far with this... Dead easy and brilliant. If you really can't get your head round it email it to me Monday and I'll set it up and email it back. Chris (PivotTable Tutorial)
__________________ BSAC internet branch 2411 - http://groups.yahoo.com/group/ydesac/ So much better than BSAC direct and much less hassle than your local branch.. Last edited by chrisch : 22-07-07 at 05:21 PM. Reason: add URL |
| Thread Tools | |
| Display Modes | |
| |
| LinkBack to this Thread: http://www.yorkshire-divers.com/forums/non-diving-posts/58744-pivot-tables-excel.html | |||
| Posted By | For | Type | Date |
| Daily Dose of Excel » Blog Archive » Creating a Simple Pivot Table | This thread | Refback | 25-08-07 05:47 PM |
| | ||