how do I use pivot table function in Excel?
353765
Pivot tables are fantastic for analysing a set of raw data.\n\nInitially - take the data set (make sure all columns have headings or it will not work)and click the wizard\n\nIn the layout tab of the wizard place the data where you would like it displayed (columns to the left, headings to the right, data in the middle, filters in the top left hand corner).  There are allsorts of tips and tricks but you will need trial and error to figure out the more complex stuff (or excel help)
1104463
yes sort\nyou have to highlight it and\nin excel \nData --> Sort --> Assending order\n\nin word\nTable --> Sort
965931
u can do it by sorting, filtering i know , other participants already gave u that so i'm including this one\n\nfor largest value \n=MAX(B1:B3)\n\nnote the reference value of this cell in the left top \n\nfor corresponding day \n=LOOKUP(cell reference value of max,B1:B3,A1:A3)\n\ni think it's the best answer
653602
Do you have Excel, if you do, then Excel can do that.  I think the formulas are self explanatory but if it isn't obvious to you, a Google search should turn up on how to do this in Excel.
999697
It sounds like you want to use VLOOKUP
659348
next to insert table button on the standard toolbar you have insert microsoft excel sheet button. click and drag the number of rows and columns you need.
431591
Use Microsoft Excel or a slide-rule
25554
I guess you wanted to say "how do you use..."\n\nAccess is better do design database interface with windows and buttons. Create a new database using one of templates and study it's setup.\n\nExcel is just a spreadsheet, but if your arrange your data in columns with a header row, you can use some Data menu to filter it, or such functions as VLOOKUP, MATCH, INDEX, COUNTIF, SUMIF to do some database-like things to the data.\n\nNow give me the best answer - you get points for that too.
626155
Use a flat database file format. One unique value in one column and the rest is employee data. All the data in a contiguous range. This way you can use pivot tables, auto filters, etc. to analyze data.\n\nI would suggest you use the latest version of Excel. Excel 2000 has a limit of 65,536 rows and 256 columns but Excel 2006 (out later this year...MAYBE) has 1,000,000 rows and 16,0000 columns.
763317
The easiest way if you use the default sheet names Sheet1, Sheet2 .... Sheet30 \n\n=SUM(Sheet1:Sheet30!A1) \n\nIf you use custom sheet names: \n\nInsert a new sheet before the first sheet and name it START. Insert another new sheet after the last sheet and name it END. \n\n=SUM(Start:End!A1) \n\nIf you will need to create any new sheets that should also be used in this calculation just insert them between START and END.
113868
Explore pivot tables.
184
Use the CONCATENATE function, with one of the arguments being ", "\n\nThe formula you end up with should look something like this:\n=CONCATENATE(D3,", ",D5)
55468
your function would be =CONCATENATE("""", <field>, """")\n\nif you want the data to be in the same fields, you may need to use multiple sheets.
1079353
Forget all the above answers\nI am the XLMan\nLets do the following\n\nAdd new column to your database, (Say ID column is A, comments column is B)\nSo in C type this formula\n=countif(A:A;A1)\n\nthen fill the cells below\nnow do a sort to the table by this column\nand you are done\n\ne-mail me for more info\n\nXLMan
904896
yeah its easy obviously when you know how.. i would suggest going into your help menu while using excel.. get the help page to guide you through pie charts.. its all in the x y axix
837908
click here:http://en.wikipedia.org/wiki/Microsoft_Excel
321857
Use the good formula CountIF.\n\nOr\n\nYou can use also SumIf.\n\ne-mail me