Re: $$Excel-Macros$$ Financial modeling
Thanks Sachin. If somebody has down loaded *Financial Analysis with Microsoft Excel 4th edition *Please mail it to the group. Anand On Wed, Feb 10, 2010 at 11:57 AM, Sachin Shukla wrote: > Dear Shiv, > > Please find another book on said subject. > > Thanks > > Sachin Shukla > Business Analyst > > > On 2/10/10, Shiv Goel wrote: >> >> thnks sir >> >> >> On Tue, Feb 9, 2010 at 9:15 AM, janet dickson wrote: >> >>> Hello Group >>> I hope this book will be of use >>> >>> Book Title: >>> *Financial Analysis with Microsoft Excel 4th edition* >>> Book Infos: >>> Published in 2006 >>> Author: Timothy R. Mayes >>> ISBN: 0324407505 >>> Book Description: >>> FAME explores the use of Excel as THE calculating tool for finance >>> professionals. As students enter College with basic skills for using Excel >>> and other software packages they need for their business courses, the >>> materials they read must be ramped up. The book as it stands covers the main >>> topics that students would see in a typical corporate finance course: >>> financial statements, budgets, TVM, capital budgeting, the Market Security >>> Line, some options materials, pro forma statements, cost of capital, >>> equities, and debt. In the final chapter of this revision, we include a >>> section on how students can build their own models (or macros) to perform >>> everyday financial analyses. >>> Password=ebookspyder.net >>> Size: 5.63MB >>> >>> http://rapidshare.com/files/13166402/Financial.Analysis.with.Microsoft.Excel.4th.Edition.zip >>> >>> Regards >>> >>> >>> On Tue, Feb 9, 2010 at 3:59 PM, Shiv Goel wrote: >>> I want to learn the visual basic for financial modeling purpose if any body having any notes,books or some other study material please send me or main me link. i will download it thanks in advance -- Shiv Goel 8NBYN060 ICFAI National College,YNR 9416275776 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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 >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 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 >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,700 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 >>> >>> >> >> >> >> -- >> Shiv Goel >> 8NBYN060 >> ICFAI National College,YNR >> 9416275776 >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 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 >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 subscribers worldwide and receive many nice notes >> about the learni
Re: $$Excel-Macros$$ How to skip non working days to calculate number of days betewwn dates ??????
Dilipji, If we need to consider 1st and 3rd Saturday as working, please guide. Thanks in advance Anand On Mon, Feb 22, 2010 at 11:33 PM, Dilip Pandey wrote: > Dear Abdul, > > Use Networkdays function to accomplish this task. An example is attached > with this email. > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > On 2/22/10, Abdul Rasheed wrote: >> >> >> >> How to skip non working days to calculate number of days betewwn dates >> ?? >> >> Such as sunday or any vacations came between working days. >> >> >> >> Thanking You >> >> Abdul Rasheed >> >> >> >> -- >> >> -- >> 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 >> > > > -- > > -- > 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 > -- -- 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
Re: $$Excel-Macros$$ How to skip non working days to calculate number of days betewwn dates ??????
Yes Dilipji, its working. Only thing is if there is 5th Saturday in the month as working, we need to revise the formula Anand On Tue, Feb 23, 2010 at 4:28 PM, Dilip Pandey wrote: > Dear Anand, > > Attached is the customised solution as per your need. > Let me know in case of any further help. > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > On Tue, Feb 23, 2010 at 8:50 AM, Anand Desai wrote: > >> Dilipji, >> >> If we need to consider 1st and 3rd Saturday as working, please guide. >> >> Thanks in advance >> Anand >> >> On Mon, Feb 22, 2010 at 11:33 PM, Dilip Pandey wrote: >> >>> Dear Abdul, >>> >>> Use Networkdays function to accomplish this task. An example is attached >>> with this email. >>> >>> -- >>> Thanks & Regards, >>> >>> DILIP KUMAR PANDEY >>> MBA-HR,B.Com(Hons),BCA >>> Mobile: +91 9810929744 >>> dilipan...@gmail.com >>> dilipan...@yahoo.com >>> New Delhi - 62, India >>> >>> >>> On 2/22/10, Abdul Rasheed wrote: >>>> >>>> >>>> >>>> How to skip non working days to calculate number of days betewwn dates >>>> ?? >>>> >>>> Such as sunday or any vacations came between working days. >>>> >>>> >>>> >>>> Thanking You >>>> >>>> Abdul Rasheed >>>> >>>> >>>> >>>> -- >>>> >>>> -- >>>> 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 >>>> >>> >>> >>> -- >>> >>> -- >>> 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 >>> >> >> -- >> >> -- >> 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.blog
Re: $$Excel-Macros$$ Re: Something is missing
Ayush, Spellcheck the way available in MS Word.. my be useful.. I m not sure any facility is available or not? Anand On Mon, Apr 12, 2010 at 11:33 AM, Abhishek Jain wrote: > Thanks Ayush. > > My tuppence: > > Extracting unique vales from a range with a function or formula is missing. > Using Advanced Filter every time is a bit lengthy process. It should be > something like =UNIQUEVALUES(A1:A100). > > I got a workaround for the above though ;-) but I think it should reside in > Excel only. > > Best regards, > > Abhishek > > > On Sun, Apr 11, 2010 at 11:32 AM, Ayush wrote: > >> I am posting the first idea :- >> >> 1) There should be an inbuilt feature of converting number into words. >> 2) Vlookup searches only in leftmost column of range, why not >> rightmost or middle column ? >> >> Now its your turn :) >> >> On Apr 11, 10:59 am, Ayush wrote: >> > Dear members, >> > >> > Most of us work in excel daily and lot of things come in mind like >> > "This is missing in Excel" , "Microsoft should add this feature in >> > excel" , "This feature can be better", and many more ideas.. >> > >> > I want you to share such ideas, bugs, suggestions, improvements, >> > weaknesses of excel with the group and might be Microsoft will hear >> > us >> > >> > I am confident that we will have solution only if you will share >> > problems. >> > >> > I am again thankful to each member for making this best group all our >> > the world.The members are increasing by day..I am proud to be >> > member of this group. >> > >> > Best regards, >> > Ayush Jain >> > Group Manager >> >> -- >> >> -- >> 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 > -- -- 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
Re: $$Excel-Macros$$ Re: Something is missing
Abhishek, I know about spellcheck feature. red-underlines are useful and time saving.. Anand On Mon, Apr 12, 2010 at 1:20 PM, Abhishek Jain wrote: > I think it is available.The only thing is it does not red-underlines the > miss-spelled words as MS Word does. > > > Abhishek > > On Mon, Apr 12, 2010 at 11:54 AM, Anand Desai wrote: > >> Ayush, >> >> Spellcheck the way available in MS Word.. my be useful.. I m not sure any >> facility is available or not? >> >> Anand >> >> On Mon, Apr 12, 2010 at 11:33 AM, Abhishek Jain > > wrote: >> >>> Thanks Ayush. >>> >>> My tuppence: >>> >>> Extracting unique vales from a range with a function or formula is >>> missing. Using Advanced Filter every time is a bit lengthy process. It >>> should be something like =UNIQUEVALUES(A1:A100). >>> >>> I got a workaround for the above though ;-) but I think it should reside >>> in Excel only. >>> >>> Best regards, >>> >>> Abhishek >>> >>> >>> On Sun, Apr 11, 2010 at 11:32 AM, Ayush wrote: >>> >>>> I am posting the first idea :- >>>> >>>> 1) There should be an inbuilt feature of converting number into words. >>>> 2) Vlookup searches only in leftmost column of range, why not >>>> rightmost or middle column ? >>>> >>>> Now its your turn :) >>>> >>>> On Apr 11, 10:59 am, Ayush wrote: >>>> > Dear members, >>>> > >>>> > Most of us work in excel daily and lot of things come in mind like >>>> > "This is missing in Excel" , "Microsoft should add this feature in >>>> > excel" , "This feature can be better", and many more ideas.. >>>> > >>>> > I want you to share such ideas, bugs, suggestions, improvements, >>>> > weaknesses of excel with the group and might be Microsoft will hear >>>> > us >>>> > >>>> > I am confident that we will have solution only if you will share >>>> > problems. >>>> > >>>> > I am again thankful to each member for making this best group all our >>>> > the world.The members are increasing by day..I am proud to be >>>> > member of this group. >>>> > >>>> > Best regards, >>>> > Ayush Jain >>>> > Group Manager >>>> >>>> -- >>>> >>>> -- >>>> 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 >>> >>> <><><><><><><><>
Re: $$Excel-Macros$$ GNATT CHART
Give search on Google with Filetype:xls, you will get many options... I wish it will work for you. Anand On Tue, Jul 6, 2010 at 10:55 AM, zafnu wrote: > Hi, > Can u please help me to create a '*Gnatt Chart*' in excel. your immediate > action is highly appreciated. > > Thanks & regards > Zafnim backer. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 7000 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 > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 7000 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
Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
> 2. > > On Wed, Feb 23, 2011 at 4:59 AM, Ayush Jain wrote: > >> Dear members, >> >> I am too excited to share that discussexcel.com website development is in >> good progress and we are ready to launch the website on 4th Anniversary of >> our Google group. i.e. 16th -17th March. >> >> In the meantime, Can you advise a good tagline, punchline for website. >> >> My thoughts are : >> 1) building excel-lence >> 2) Excellence in Excel >> 3) Let's discuss and learn excel >> >> what do you think, Let me know >> >> Keep watching this space for more >> >> Regards >> Ayush Jain >> Group Manager. >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 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 >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel