Hello Dear, Once i have read this book when i was totally unaware of even any computer application.
Off course every one learn from his/her experience. So try this following book. Stephen Copestake EXCEL 2003 in easy step dreamtech press ISBN:81-7722-505-7 On Wed, Apr 14, 2010 at 11:25 AM, Chaudhry Zahid Ali <chaudhry.zahid....@gmail.com> wrote: > Dear Michael, > > Thanks for the piece of advice. I'm basically new to the management > accounting world. Please do not take this as if I am new to finance and > accounting (But my excel skills are resticted and have no knowledge of > access yet). That said, can you guide me to some tutorials etc or books from > where I can jump start into this huge ocean. > > Kindest Regards. > > Chaudhry > > On Tue, Apr 13, 2010 at 11:58 AM, MD18358 <michael.e.dray...@citi.com> > wrote: >> >> Hi Chaudhry, >> I hate to commit sacrilege in the Excel VBA sight but its sounds like >> excel is probably not the right solution for such a massive task. >> Access can handle larger database queries. Even if you use Access to >> perform all your summerizing and then export it back to excel for the >> presentation parts, I think you you come out with far less stress. >> >> -Good Luck >> Michael >> >> >> >> On Apr 12, 2:41 pm, Chaudhry Zahid Ali <chaudhry.zahid....@gmail.com> >> wrote: >> > Hello Group, >> > >> > *Overview:* >> > I have a issue to discuss. I have got an excel sheet which contains over >> > 150,000 trial balance account subheads made up of data from different >> > branches (All Branches). So there are multiple account heads that are >> > repeating. I have constructed a Pivot table out of the data which on >> > application of a filter gives me NP and Sales amount for different types >> > (Huge, Big, Medium, Small) of branches. >> > >> > *Required:* >> > Now what I want to do is to apply two different filters on two different >> > columns which fall under the same Pivot table. Is it possible, or am I >> > asking too much from excel. I know I can construct a seperate table for >> > both >> > NP and sales, but the issue is I am trying to automate the process and >> > if I >> > make seperate account heads for seperate files, well, I will be ending >> > up >> > making atleast 50 Pivot tables in a file which has already crossed 200 >> > MB. >> > >> > *In Short:* >> > *HELP* >> > ** >> > Thanks...... >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> To unsubscribe, reply using "remove me" as the subject. > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
