Re: [AI] A big hello to everyone and an Excel question

2014-08-24 Thread tiku raj
Hi Friends, One more query how to use pivot table in Microsoft Excel 2003 2007. Please guide step by step if any of the list members are aware of it. Regards, Tiku On 8/23/14, Aravind R aravind.andhrab...@gmail.com wrote: regarding pivot table. select the entire range of date using

Re: [AI] A big hello to everyone and an Excel question

2014-08-24 Thread Aravind R
for office 2007 and 2010. regarding pivot table. select the entire range of date using ctrl+shift+end. press alt+n, go to insert menu, press v for table and t for pivot table. one dialogue box will come there, keep default options as it is and press ok button. a new sheet is created and you

Re: [AI] A big hello to everyone and an Excel question

2014-08-23 Thread Aravind R
regarding pivot table. select the entire range of date using ctrl+shift+end. press alt+n, go to insert menu, press v for table and t for pivot table. one dialogue box will come there, keep default options as it is and press ok button. a new sheet is created and you land on a3 of that sheet. press

[AI] A big hello to everyone and an Excel question

2014-08-22 Thread Adhimoolam Vetrivel Murugan
Hey all, Great to write to the list after a very long time! I need help with excel sheat in completing an assignment. Could someone explain step by step instruction in sorting data for a single colunm from a table containing 4 colunms and 12 rows. Second, I would also need help with Pivot Table.

Re: [AI] A big hello to everyone and an Excel question

2014-08-22 Thread Him Prasad Gautam
hi, First make clear which version of MS office are you using. On 8/22/14, Adhimoolam Vetrivel Murugan vadhimoo...@gmail.com wrote: Hey all, Great to write to the list after a very long time! I need help with excel sheat in completing an assignment. Could someone explain step by step

Re: [AI] A big hello to everyone and an Excel question

2014-08-22 Thread Adhimoolam Vetrivel Murugan
Hi, Office 2010 pro. Vetri. On 23/08/2014, Him Prasad Gautam drishtibac...@gmail.com wrote: hi, First make clear which version of MS office are you using. On 8/22/14, Adhimoolam Vetrivel Murugan vadhimoo...@gmail.com wrote: Hey all, Great to write to the list after a very long time! I

Re: [AI] A big hello to everyone and an Excel question

2014-08-22 Thread Him Prasad Gautam
hi, Be clear first: What do you want? 1. just sort a single column. 2. Sort multiple column first one then other then other etc. 3. Order of sorting ascending or descending. 4. Does the sheet contain the column title at the top or not? Based on these cases, do: 1. select any cell (better row one