About Chandoo.org

chandoo small-about-photoAt Chandoo.org, my aim is to make you awesome in Excel. I do this by sharing whatever little I learn everyday. Our community has an open mind. We are eager to learn and share. We all constantly teach each other new tricks and ideas using comments and forum posts.

I am glad to know that you are here and want to be a part of us.

I invite you to join our mailing list. Every week I send 2-3 emails with an excel tips or charting tutorials to help you become awesome in MS Excel. Also check out our welcome page to know how we can help you better.

I have launched Chandoo.org in year 2004. After 3 years of personal rants and chatter, I shifted the focus of site to Microsoft Excel, primarily to share new ideas and discuss about the problems I am working on. Soon, the site gathered momentum and today it is a massive part of my life.

We get 1,650,000 monthly views with readers from all over the world. There are ~75,000 members reading this blog through feed readers & email. The blog has been featured on Major newspapers, few books, LifeHacker, MSN, BNet, Technet and Delicious. It made me a better person and communicator. I am able to connect with a wide part of the world and exchange ideas freely. All thanks to this little site.

You can support this site by,

My products are well received by our members. You can try one of them and become even more awesome.

About Me : Chandoo

I am your CEO here, Chief Excel Officer. My full name is Purna Duggirala. Chandoo is my nick name and I used it as my domain name too. I have an MBA from IIM Indore and Computer Science degree from Andhra University. I am passionate about Data Analytics and Visualization and this blog is my platform for sharing what I learn about Microsoft Excel and new ways of presenting data. I have been awarded MVP status in 2009 by Microsoft (and renewed in 2010, 2011, 2012, 2013 & 2014). My MVP profile is here.

I am married to Jo, my college sweetheart. During September 2009, we became parents to 2 beautiful and naughty twins. A boy and girl. Life has been hectic and incredibly fun ever since. (here is a pic). We are based out of India, but we travel around the world and meet new people and cultures all the time. As of April 2010,  I have quit my day job to become full time entrepreneur. You can read about my journey as a start-up owner at Startup Desi.

Thanks for visiting my site. Feel free to drop feedback on my email : chandoo.d [at] gmail [dot] com.

Please learn more about our policies or ask a question in our forums or get in touch with me.

How do we run Chandoo.org

I quit my job in April 2010 and Chandoo.org has been my only business ever since. Thus began my entrepreneurial journey. If you are curious to know how I run my business, please visit Startup Desi to learn more.

Stuff We use & Recommend

Many people ask me what software, tools & services I use to manage a reasonably busy site like Chandoo.org. Please visit Stuff we use & recommend page to know more.

You may also want to read about how you can use HTML and other codes to enhance your posts here: Enhance Your Posts Here.

Join our community

If you like Chandoo.org story and want to be part of our community, please join us thru one of below links.
Signup for our FREE Excel Tips Newsletter

NEW!!! – Enjoy Chandoo.org Podcast

Recently, I have launched Chandoo.org podcast and like everything else we do, its aim is to make you awesome.

To listen our podcast sessions or subscribe click here.



Chandoo.org

Like this article? Please sign-up for our free email news letter or add our RSS Feeds to your reading list to receive excel tips, charting ideas every weekday.

368 Responses to “About Chandoo.org”

  1. Krish Ashok says:

    You still with the insurance practice? Have I seen you in JNR, Chennai?

  2. Chandoo says:

    @Krish… yeah, I have seen you in JNR few times.. Even though I am with still with IP, I am currently at Columbus, may be we can catch up sometime later when I come back :)

  3. Jon says:

    Hello,

    I help run Celebpulp.com and I am trying to spread the link love by linking to other blogs that I think our visitors would like to visit. Do you mind if I link to your website: chandoo.org ?

    Since Celebpulp.com gets a few thousand visitors on the site each day, I’m sure some of them will enjoy your site as well. I will NOT link to your website until you reply telling me it is OK with you. Do you think you can link to Celebpulp.com? I look forward to your reply.

    Jon

  4. Hitesh says:

    What the hell dude. U dont look like a “normal” IIM graduate. Look at ur huge blog archive. Are u not busy? Or does it simply mean other MBA’s just try and look busy? U do have a life.
    keep it up.

  5. Chandoo says:

    @jon … Welcome to PHD…
    go ahead, you are free to link to any content on my website :)

    @Hitesh, hi there, welcome to PHD, thanks for the comments, well, I like to live in my world no matter how crazy everyone else is trying to be. Hope you like some of the content here… Enjoy :)

  6. Vinayak says:

    hi Chandoo
    you have a nice setup here. i was sreaching for Job profile for BA in TCS. i am trough with first level of interview. if possible can you help me with some details of role as a Business analyst. what they will be expecting from me in personal interview . pls reply me soon \. int on 22 feb
    regrads
    vinayak k
    9901772344

  7. Mahadi says:

    Hi Chando,
    I want to develop a mutual fund folio tracker on my website where my clients can login and enter details. Of course latest NAV should get updated on dairly basis or as applicable. Can you help?
    Thank you n kind regards,

  8. Chandoo says:

    @Mahadi – thanks for visiting PHD, welcome :)
    sure thing, I have done similar stuff earlier, what are you exactly looking for, write a note to me at chandoo dot d at gmail dot com and I shall reply sometime soon, meanwhile you may want to take a look at http://chandoo.org/wp/2006/11/13/howto-excel-based-mutual-fund-portfolio-tracker/

    welcome once again.

  9. Tarun says:

    A really good “About” page. Enjoyed the humor.

  10. Chandoo says:

    @Tarun .. Welcome to PHD, Thanks :)

  11. Sandip says:

    Hi,
    I Use your Mutual Funds Excel.
    Its Very Useful For Me.
    I m S/W Developer. Can i use your Excel File In my S/W only for Read NAV Purpose.
    Please Tell Me Its Legaly or Not.

  12. Chandoo says:

    @Sandip: please feel free to use it. If you are planning to sell this software, you may want to check with AMFI India whether such syndication is allowed. For personal purposes, it is ok I guess.

  13. Dehli Belly says:

    Hi Chandoo
    Do you know which formula I need to use to sum the figures of the last five working days in a list with dates and revenues?
    Thanks
    Dehli

  14. MADACCOUNTANT says:

    Hi Chandoo,

    Nice site! I hope to particpate and help others and also learn as much as possible.

    Michael
    (MADACCOUNTANT)

  15. Hey Chandoo, m a fan. I am sorry i have an eye for noticing typos..your homepage says Chandooo instead of Chandoo!?maybe something you would like to correct. :)

  16. Amarjeet says:

    Hi, i am a novice in excel. want to learn more and more things in excel. i am learning accounting that’s why i need too learn MS excel.

    thanks a lot for help.

  17. RAND says:

    Chandoo…thanks for the info.

    I am trying something “new” for me in excel and am running into a wall. I downloaded your check boxes, and copied/pasted them in…great if I only need those 30. but I need 100. the new ones I add in format back to the old check box “format” location from the first cut and paste. SURELY I am missing something. This cannot be as hard as it seems. Why can I not “drag” the formatting with the checkbox. Is there a VBA script that would solve this whole frustrating malfunction.

  18. Joe Espana says:

    Chandoo, this is a terrific site. Excellent for xl novices like me. Well done for helping so many people with your creative ideas. Kind regards

    Joe (from the UK)

  19. Faseeh Shams says:

    Hi Chando,

    Great website and great information. I have a majors in HR and now half way through my Majors in Marketing and a professional photographer; have always found Excel as the most compelling tool ever. Thanks so you now I would get to master it as well.

    keep up the good work.
    Faseeh.

  20. Fernando Ruiz says:

    Hi Chandoo.
    I would like to say how greatfull I am with this excelent site. I used to think I knew many things about excel capabilities, but the example here has open my perception about excel. Hope in a close time I can participate with some good stuff and keep this open source for all guys.
    Good look.

  21. Martha says:

    I am new to the Excel Help Forum… posted first time and didn’t see my post so I assumed it was rejected for no tick marks. Showed “zero posts” on my profile as well. Reposted with ticks. Now I see nothing and my profile says I posted twice. Now I’ll not only not see any replies… but I’ll be a rude double poster as well!!! Any help is appreciated. Love this site.

  22. pidol says:

    Hi Chandoo,

    Many thanks for your great work. I’m interested in VBA for Excel 2007/2010. I have stumbled on a few books on the web. Can you recommend a very good one that will help me learn the fastest.

  23. Salando.GH says:

    Hi Chandoo,
    Really interesting stuff on your site. I have developed a penchant for excel lately and your site will really go a long way to make me “become awesome in excel”. Great job you are doing.

  24. Ram Kapoor says:

    Hi Chandoo,
    First of all, I would like to thank you for sharing your expertise. I am an avid follower of this website; working as an HR Analyst. Would really appreciate if you could help me? How can we use excel to do predictive modelling?

    Thanks again,
    Keep up the good work.
    Ram-

  25. JL says:

    Hi Chandoo,

    I think you are all fantastic for sharing your knowledge and I’ve learned a lot from your site.
    Keep up the good work!

  26. d v joshi says:

    hi chandoo
    recently i had seen your exclusive excel site. i found your site is full of knowledge. i also find that i can learn so many things from U. i am ready to subscribe for excel learning . pl send me yor schedule.
    THANKS !
    d v joshi

  27. Omkar says:

    My love affair with your blog will never end.

    Omkar

  28. Apparao Yerramchetty says:

    Dear Sri Chandoo Sir,
    I am appreciating you and I wish u very good success in future developments also. I am working as an Accounts Officer in BSNL. I know excel upto the certain extent i.e, data entry, editing and some of the formulas etc for my regular work. I want to become a expert in excel programming (i.e, with available monthly reports from departmental softwares like Pay package, I want take some other reports by using excel). To do this task, what I have to do? How can I proceed? Please advice me.

  29. Rajan says:

    Your site is indeed very informative.
    we are into sales training and I was looking out for some simple charts sales people should use to make their life simpler.
    Would you like to share any such interesting articles on excel for Sales Executives. I need a 3-4 page simple write up.
    secondly We would like to explore a possibility of having a 1-day program only on How excel can be used for enhancing sales productivity?
    If you are game please let me know.
    Rajan Parulekar

  30. AQ Mahomed says:

    Howsit (How are you – South African Greeting)
    I just discovered your website, I think that I am well versed on Excel, but there is definitely room for improvement. I will bookmark this site and ensure that I visit regularly. Once again well done on such a superb website.
    Regards
    Me

  31. Brijesh D says:

    Hi Chandoo,

    I am also very much intersted in Excel just like you and have been working with it since 2000 and have explored it with functionality and applicability. Somehow there’s area which i am getting a little confused with and somehow cannot find a solution.

    I would like to embed the Last Modified date of a document in the same document as this will save a lot of work during versioning and auditing. If you get time please do let me know how this can be done and I will be grateful to you

    Regards,
    Brijesh D

  32. Anant Singh Choudhary says:

    I am looking for a professionally qualified CA or similar , with excellent excel skill person , for working in Thailand , if u come across with any one please send his CV.

    Thanks and Regards
    Anant Choudhary

    anant_choudhary2003@yahoo.com
    + 662-2465213
    +668-19093021

  33. Anant Singh Choudhary says:

    Hi Chandoo

    I am fan of yours , seen your good work done on excel.
    Wishing you good luck in your future life.
    Want to learn more and more about excel from you.

    Regards
    Anant Choudhary

  34. Smitha Goutam says:

    Hi Chandoo,

    Have never come across website for Excel like this… Superb stuff…

    Regards,
    Smitha

  35. Hi Chandoo! Do you have any updates to your “Excel twitter client” with OAuth? I was extensively using your “Excel twitter client” and I’m so stuck because of OAuth implementation! My tweet ratio has drastically reduced. Thanks for your great work! Believe you’ll update your’s one among smart excel utility.
    With Regards.
    Mohan

  36. Krishna says:

    Hi Chandu,

    Nice to Meet you brother. I am Krishna from hyderabad. I completed My graduation and working as a Data Analyst in Camp Systems.

    I would like to shift to Excel Related Job. Do you have any Idea about those jobs and What are the basic and needed qualifications needed for those jobs.

    I can expect that you are busy one, But whenever you have time, Please reply to me question.

    God Bless you and Thanks for this wonderful Blog,

    Krrish

  37. champak says:

    Dear,
    U R great. I Like your attitute towards Life. Which services offered by your company?
    Regards,
    champak

  38. Anindya says:

    Hi!! CHandoo

    Amazing piece of work. It takes lot of courage,Knowledge,humanity and indeed lots of wisdom to come up with some stuff like this. I am sure personally, there is huge room for things to scale beyond but the journey has begun and i feel elated to be a part of this journey. keep up the good work sir.

  39. Chandoo says:

    @Krishna: Welcome to chandoo.org brother.

    Instead of trying for an excel related job, go for jobs like analyst, business analyst, financial analyst etc. These jobs have better career prospects and help you learn and earn more. These jobs have ample excel (or other data crunching software use) so you will enjoy them too.

    @Champak: Thank you so much. I am happy you like my site. I offer some products and training programs. For details visit – http://chandoo.org/wp/shop/ and http://chandoo.org/wp/training-programs/

    @Anindya: I am humbled. Thank you so much and welcome to our community.

  40. Anoop says:

    Hi chandu,

    Just wanted to say good job! I have a blog too and hoping one day to make some money. It is great to see an Indian in US making money from blogging.

    And I think you should do bit more SEO. I have tried searching for excel stuff but never fond your website.

  41. Rajeev says:

    Hey Chandoo,
    Just finished reading your story on msn. I am very pleased to know there are people like you who are adding new dimensions to IT knowledge. You have a awe inspiring career.

    Wish you all the very best!
    cheers,
    -rajeev

  42. ashok says:

    Hi sir,
    great inspiration from you!My friend forwarded this website to me! very nice :-)

  43. Akhil Kumar says:

    Hi sir, great to see ur news on MSN home page.
    Wants to become like you.
    Greatly inspired by your invention or IDEA.

  44. sandy says:

    Great inspiration!!!…showed us that there are many ways to grow up in career….just read the article about you in msn…great job….good luck….

  45. Balaji S Venkat says:

    Hi Chandoo – You are awesome – Just great ideas- You are an Inspiration to all those who aspire to become innovators . Our country should need innovators like you ..will be your fan..cheers…balaji / bangalore

  46. Harish says:

    Amazing Stuff Bro ….. Great Work …. :)

  47. Raghu says:

    Hello Chandoo
    You are doing gr8 job.Its an interesting and inspirational aticle published about you in msn.You proved that, its not the field we work on,its the commitment we must show on ,irrespective of result.That is what made you so much gr8.Hats Off n All The Best.Iam Proud that you are 4m vizag.

  48. Sunil Nadgauda says:

    Hi Chandoo,

    Have you developed something which will help someone manage their finances/money? I use to use MS Money for a long time. Microsoft recently discontinued that product. But I think Excel can be an exellent tool to develop an application for personal finance/ Money Management.

    Thanks,
    Sunil

  49. Aditya says:

    HI…chandooo

    I really liked ur site..it’s very useful.

  50. Gautam M says:

    Hi Chandoo,

    Its amzing to know the story of yours which i read the other day. Its fascinating because you have carved a niche for yourself. Honestly its very satisfying to know that you have been successfull following what you are best at. You have set up a good example here.
    Chandoo I have a question for you, which was the website that you started your blog while you were working at TCS? do let me know, since you didnt had Chandoo.org at that time.

  51. Sandy says:

    Hi Chandoo, great to know about your achievements. After reading your blogs I am very much interested in learning more in Excel.
    My job is Project management. Right now I am trying to add a custom field to an existing report in Excel which pulls the data from Timesheet (reporting db). I am unable to figure out where the custom field data is being stored in Reporting DB. I added a column to existing timesheet in project web access. Afer updating the timesheet data is still not showing up anywhere
    Let me know if you can help me with this.
    Thanks,
    Sandy

  52. Seenu says:

    Hi chandoo,
    I came to know abt ur blog thru AndhraJyothi Newspaper.
    Ur commitment to blog is superb.
    really fantastic work…
    keep Going

  53. Vijay Sriram says:

    Hiii Chandoo,
    This is an excellent blog for upcomming students who are interested in computers..
    Please let me know will excel be helpfull for computer science students of B.tech….
    ThankQ for reading my comment…..:-)

  54. Praveen says:

    Great chandu for Achiving Mvp keepup keep rocking vizag guys

  55. Gvs Praveen says:

    Dear Chandu
    congratulations for doing sucha Beautiful and Useful site i came to know abt you through Andhrajyothi Article which is published on sunday 20th you did a great job bro weldone.

  56. JHANSI says:

    HAI Chandu this jhansi uuuu really great!!!!!!!!!!!

  57. Manoj says:

    Hi Chandu, I read about you yesterday in the Andhra Jyothi News Paper. Left job and doing dot com business kind of stuff, really appreciate it. Good Luck and keep going.

    Manoj

  58. Parmesh says:

    Hi Chando,

    Very Inspirational article in Andhra Jyothi..Gud job!

  59. PURUSHOTHAM ATHRAM says:

    Hi Chandoo
    i read your article on telugu daily jyothi
    i felt very have. i read it amusingly. thanks
    a lot. now i will go through this blogs. i’m
    a working for FCI i hope your blogs will
    help to my organization.

  60. RAKESH says:

    hi sir,
    it’s very good site for excel. thanks.

  61. Viney Mehta says:

    Hi Chandoo………………..Thanks a Lot for everthing that you are doing for Excel Community……….I am doing really well in the field of excel Automation in one of the leading Manufacturing Company in India………………..Your Newsletters, Tips and trick are rally making me AWESONE in EXCEl………………..Thanks again and God Bless……………..

  62. P.C.Mahanti says:

    Hai,
    This is mahanti from sompeta, srikakulam(dt). I came2 know about u and ur site through the news paper(Andhra Jyothi). I’ve complited MCA from B.U and having experience of nearly eight years in teaching field starting from school level 2 Eng.College.When i came 2 know about u, my interest become more on this matter.So this is the comment for u 2 understand about me and my interest on ur service.
    I want ur help in this case for the updation of blogs through the net by using documents.
    thanking u,
    Bye
    Mahanti.

  63. Yuvraj says:

    Hey, i recently read an article on MSN about the work you are doing. Today got some time out to visit your blog. Man, its awesm.. keep up that spirit. I am sure you are serving as a rolemodel for many rite now. :) Allthebest in your efforts..

  64. laxman says:

    hai
    please give how to make filters automatically selected given date in cell

  65. Hui... says:

    @Laxman
    You can add a simple piece of code to the Worksheet Object for the sheet your table is on in VBA
    .
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$B$1" Then ActiveSheet.Range("$A$4:$B$25").AutoFilter Field:=2, Criteria1:=[B1]
    End Sub

    .
    Change A$:B25 to represent your data table
    Change B1 to be the cell with your criteria
    Change the Field No Field:=2 to be the field no you need

  66. laxman says:

    hai sir thankq
    give an example on my question”how to make filters automatically selected given date in cell”

  67. Hui... says:

    @Laxman
    .
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$B$1" Then ActiveSheet.ListObjects("MyTable").Range.AutoFilter _
    Field:=1, _
    Operator:=xlFilterValues, _
    Criteria1:=[B1].Text
    End Sub

    .
    example at : https://rapidshare.com/files/437021034/Laxman_Autofilter_Date.xlsm

  68. Ashutosh says:

    Hi Chandoo,

    i am verry new to excel , i found it verry interesting and want to be expert in dis, would u just guide me , how to start learning step by step. as i am being confused to see many things like dash board, templastes, formulas… pls guide me

  69. Michael Hayen says:

    Dear Sir,

    I use Open Office. Does Open Office Calc have all the requirements to be of use in your course?

    Thanks.

    Michael Hayden

    • Chandoo says:

      @Michael: Thanks for your interest in Excel courses. Unfortunately, I rarely use Open Office and based on my experience, you will not be able to enjoy many of the lessons on charting, dashboards & advanced stuff in OO. You should use Excel 2007+ (or 2003) versions for best results.

  70. Matt Smedley says:

    Hi Chandoo,

    I’ve come across your site during various searches for specific solutions using Excel. Great resource! Congrats and all the best!

    Matt

  71. Hi Chandoo,

    Congratulations for the great work!
    I have a couple of questions regarding excel.

    1) How can I generate auto correlated numbers in excel – Suppose I have fixed the correlation to be 0.7 ( Corr(X,Y) =0.7) then how can I generate random X,Y for it?

    2) How a Monte Carlo simulation can be done to test Krippendorff’s Alpha ( statistical parameter) against Intra class Correlation?

    It would be really thankful for your reply!

    Thanks!

  72. Jason says:

    HELP!
    Your site is awesome.
    But it would really help beginners like me if you can create a step-by-step process to learn from this site.

  73. Hui... says:

    @Abhishek

    1. Corr(X,Y) requires an array of at least 3 points to give any meaning (2 points always have 100%) correlation.
    You can setup say 3 pairs
    `- A B
    1 5 10
    2 10 14
    3 15 50`
    and use a Correl cell function say
    D5: =CORREL(A1:A3,B1:B3)
    Now you can use Data, What If Analysis, Goal Seek
    and use
    Set Cell: D5
    To Value: 0.7
    By Changing: B1

    This will return the value that B1 has to be to make the array have a Correlation of 0.7

    2. Krippendorff’s is beyond my Stats, can’t help you here sorry.

  74. Kyrre says:

    Hello!

    I have just found this site, and its great for me!
    I could not find anything about printing different sheets without doing it manually.
    I mean, i have this bad excelworkbook with 30 sheets. At the first sheet I fill in some data(not vba) and as a result of this, sometimes I need to print sheet 2,3,5,9 and 21. Or 2,3,15 and 17.

    Is it a way to use a dropdownmeny with different options that will print different sheets as a result of the choise you make?

    I hope it is an easy way:)

    Thanks for helping me:)

  75. venky says:

    Awesome site. Keep up the good work.

  76. Siddharth says:

    You rock!!!!

  77. Siddharth says:

    Have you used the Business Functions addins ever?? The probably obviously is you can’t send a sheet using Business Functions to another user who doesn’t have Business Functions installed. Do you have a section on developing customised functions using VBA??

  78. Mohamed says:

    Hi..
    I just got your site from my friend. It is very useful for me. I am interest to know more in Microsoft Excel.
    I hope you will reply my each comments soon as possible.

  79. Vishwanath Reddy.K says:

    Hai…Chandooo….
    this blog is very useful to learners and to know the solutions for any query occurs.
    first of all i would lke to say Thanks & congrats,this blog is amazing….
    it is very useful to know things which are in excel.
    and i want to learn the Macros.
    am staying at Hyderabad.can u suggest me which institute is good and can u send me tutorial for Macros.i want to learn macros in MS Excel.please send me the notes.
    i am looking for MIS analyst job.presently am working as MIS executive. i have good knowledge on Excel but where i attended an interviews for the position MIS analyst they usually asking do u know the Macros? so i decided to learn the macros.

    Thanks & Bye,
    vishwanath Reddy.K

  80. Nitin Bagga says:

    Hi Chandoo,

    I want to learn Ms-excel from the basic.Can u tell me which module will be more useful which u have mentioned in excel school.

  81. Martin says:

    Hi Chandoo,

    I come from germany and have one question:

    If I have payed(197USD) via PayPal, can I emidietly download the 31hrs video???? and the another Workbooks?

  82. Dhanapal R says:

    Hi,
    I read an article about you in one of the website. Its Awesome the way you have done it.

    I am also a PGDM from SDM-IMD Mysore and have a website http://www.k2questions.com/ very nascent, which offers information to students from 12th std to MBA including Engineering, Masters, Bachelors degree.

    I am very keenly interested in learning from you, i would be happy if you visit my website http://www.k2questions.com/ and suggest me the way forward.

    Thank you in advance.

  83. nilesh says:

    hi
    i am an civil engineer with mba
    i am working as consulting engineer and financila advisor
    iwant all formula in a package

  84. Cathy says:

    Do you know of anyone who can build a simple dashboard for us?

  85. Hui... says:

    @Cathy
    Have you asked Chandoo directly?
    visit: http://chandoo.org/wp/excel-consulting/

  86. Gina says:

    Hi Chandoo,

    I am so happy to have found this site. It has helped me come up with some great Excel solutions for my job. Thank you so much for presenting the information.

    I just saw your family photo with your wife and the brand new twins (although I believe that photo is over a year old) Such a beautiful family! You have so much to be proud of and grateful for, my friend.

    Many thanks for all of your posts and email notifications.

    All the best to you and yours.

    Gina in the mountains of Western NC, USA

  87. Loved your intro. Humorous and Sweet, yet professional :-)

  88. Anurag says:

    @Dhanapal R – I am sure Chandoo wont be having much time so I paid a small visit to your website.
    Firstly I felt it very Clumsy – Information Overloading
    Secondly It seems you are forcing to make it popular (read it ‘trying to sell it!)
    and lastly in 10 seconds i also felt, you are just pushing a student to learn ‘mugging’

    How I felt Chandoo is unique.
    very neatly arranged, precise and compelete information (of what you need!!!!!!)
    Secondly, He is not selling the knowledge, He is sharing it (More knowledge share, more it will grow– I am too good :))
    and most import, he is teaching us the concept in chandoo’s way which Rocks!!!!!!

    PS: Sorry chandoo using your blog for such a discussion but I know you must be busy in inventing something AWESOME in excel so i did your part.

  89. Prithi says:

    Chandoo, thanks bud for putting up all those great excel stuff up there and above all sharing it. It helped me a lot and 2 days seems the CHANDOO BUG has got me. :)

  90. Laura Roberts says:

    How stupid! Your tag line for ‘spelling mistakes in a corporate world. Corporate is misspelled!

  91. Ed Horn says:

    How do I get the 95 Excel Tips download if I am already signed up for your newsletter. Please send a link. Thanks,
    Love your site. I use it all the time.

  92. PK says:

    Hi,

    After visiting this blog I have learned usage of many functions. The best part is, good explanation of what it is and how does it work. There are many sites out there but Chandoo.org is amazing. Thanks for sharing.

  93. John Halm says:

    I am looking for someone to assist/critque my resume. If anyone has a reasonable price please let me know. JEHalm@yahoo.com

  94. Rakesh Marar says:

    Hi Chandoo, Loved your blog and your initiative to help others gain command over Excel. I am a fresh graduate and about to enter a BSchool this year in Mumbai. I am quite good with computers but I get totally stuck with Excel. I would like to gain some fruitful working knowledge about Excel although I do not have any formal on the job experience. Could you kindly guide as to how your lessons can help me during my BSchool years and the future. Thanks in Advance, Once again, Hope to be Awesome !!

  95. Richa says:

    Hi Chandoo,

    Firstly this site is INCREDIBLE!!!!

    Realy anazing work. Keep it up. DO u have somthing of such kind for PPT ??

    Thx a lot one again..Great work.

    All teh best for ur life.

    Regards
    Richa

  96. James Chapman says:

    I have this fill down macro which I would like to share.
    Hope people find it useful.

    Sub FillDown()
    Dim oWS As Worksheet
    Set oWS = ActiveSheet

    If Selection.Rows.Count = 1 And Selection.Columns.Count > 1 Then
    Call Multi_FillDown
    Exit Sub
    End If

    If oWS.FilterMode = True Then
    MsgBox “Please Unfilter Any Columns Before Running This Macro”
    Exit Sub
    End If
    For i = Range(Selection, Selection).Row To Cells.Find(What:=”*”, After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    If Rows(i).Hidden = True Then
    MsgBox “Please Unhide Any Rows Before Running This Macro”
    Exit For
    End If
    Next

    If WorksheetFunction.CountA(Cells) > 0 Then
    frow = Cells.Find(What:=”*”, After:=[A1], _
    SearchOrder:=xlByRows, _
    SearchDirection:=xlPrevious).Row
    End If
    srow = Range(Selection, Selection).Row
    col = Range(Selection, Selection).Column
    Range(Cells(srow, col), Cells(frow, col)).Select
    Selection.FillDown
    Range(Cells(srow + 1, col), Cells(frow, col)).Copy
    Range(Cells(srow + 1, col), Cells(frow, col)).Select
    Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
    xlNone, SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
    Cells(srow, col).Select
    SendKeys (“{ESC}”)

    Set oWS = Nothing
    End Sub

    Sub Multi_FillDown()
    For Each Cell In Selection
    Cell.Select
    Call FillDown
    Next
    End Sub

  97. Prasad says:

    Hi Chandoo,

    Many thanks for your great work. I’m interested in VBA for Excel.

  98. Nitin Chanda says:

    Hello Chandoo,

    Gr8 work indeed. Helping people to master their skills on Excel. I’ll be glad to receieve new tips from you every week.

    Best Regards,
    nitin chanda

  99. Yogesh Dhoot says:

    Hi Chandoo,

    Thanks for creating this forum for people to learn excel tricks which are generally not so easy. I have learnt a lot from your blogs and daily emails. I would like to tell you that with help of this forum i had created an excel macro (With charting inputs from you) which saved ~800hrs of man work every year. As a result i was awarded with an “Innovation Award”. I would thank you again for your tutorials which help trick in easier ways.

    Best,
    Yogesh Dhoot

  100. shweta dhyani says:

    Dear Chandu…
    Hi , i am quite new to ur site.. but going through various if ur magic and tricks, i ve successfully developed a sales dashboard for my national head.. thanks to you. now i have one problem as i am trying to add the numbers ( which have been fetched from a master table using 22 nested concatenate operators). its giving me result 0. but when i copy them on some other sheet as special , it gives me the exact number. how to solve this error.

    pl help.

    thanks

    shweta

  101. Mark Hawkins says:

    Any chance of putting a link for by book about rickshawing across India ………..all proceeds go to Railway Children charity for street kids worldwide ?

  102. harry says:

    please suggest me a book to learn microsoft Excel And word.

  103. saleem basury says:

    really fine chandoo i learned a lot from you

  104. Raghu Gunnala says:

    Chandoo,
    You are just awesome Dude. Your site is an encyclopedia by itself for excel.
    I really appreciate the service you are doing to mankind via this website.
    Keep up the good work Sir.

  105. Ben Pedret says:

    Hello Chandoo,

    There seem to be a problem with the link to the .zip or xls example files that you’ve provided at the following URL:

    http://chandoo.org/wp/2009/06/03/venn-diagrams-in-excel/

    Can you please check the link as I would very much like to try to example files.

    With kind thanks.

    Ben

  106. Hui... says:

    @Ben
    When you select the links you should get a list of files
    Find the correct file “My Venn attempt OLD” and select it
    Then on the right hand pane at the top click the download button

  107. john says:

    Hi Chandu…great to watch your stuff on internet…i have an interview on friday but it is in excel and i never used before ..by trade i am a developer (dotnet)…all they metioned in the interview letter that i need to undertake an assessment, which will involve analysing data from an excel matrix…any example please .. if i get basic understanding “analysing data from an excel matrix” thats enough please….hope to hear from you soon

    Thanks

  108. Krunal Patel says:

    Hi Chandoo,

    Thanks a lot for your guidance and helps.

    I so glad that I meet you up on net and gained a lot from you and your Lessons till date.

    I become a big fan of yours.

    Even I believes that its my bad-luck that I meet you up too late….. But anyway I believes that…. this will make a big difference in my professional career in future.

    Thanks a lot ones again.

    Kind Regards,
    Krunal Patel

  109. Ashley says:

    I randomly came across your website on a google search. I just wanted to say how helpful you lessons and tutorials are. Keep up the good work and enjoy the time with your family.
    Ashley

  110. Rebecca Napao-it says:

    CHANDOO, PLEASE HELP ME ACTIVATE MY EXCEL FORMULA E-BOOK. I BOUGHT IT ALREADY. THE TIME HAS EXPIRED. PLEASE KINDLY RESEND IT.

  111. Chandoo says:

    @Rebecca… Thanks for the purchase. I have already sent the file to you.

    PS: Today is 2nd birthday of my kids, so busy with the celebrations

  112. Zack says:

    Hi Chandoo,

    Is there anyway I can purchase just your 8hr Dashboard Reporting course?

    Thank you.

  113. Abhishek says:

    Hi Chandu,

    You are really a genious. I am very beginer and working in data analytics from last two years. Can you please help me out to how I can be a expert in VBA.

  114. E.Thean says:

    Dear Chandoo,
    I am keen to work on a project involving development of templates in excel for use by our operations. I would like to know if you are keen to offer your expertise I would need for the projects I am undertaking. Kindly let me know if we can explore further into the possibility.

  115. ben.Faure says:

    Thank you Chandoo!

  116. daniel schut says:

    Hi Chandoo,

    I’d just like you to know I really appreciate your site and all the tips you give. I think sharing little bits via a blog on a day-by-day basis is so much better than writing one of those awful books. Thank you!

  117. Eli Reer says:

    Great site of learning tons of hidden and open tips and tricks that Excel has in store… I have / will end up spending a lot of time just going through the site …

    Awesome job…!!!!!!!!!!!!

  118. Alok kumar says:

    Hi Chandoo,

    I m beginner of excel so how to know more about excel.

  119. Waqar says:

    Hi Chandoo
    It is great pleasure for me to send u msg.
    Can u guide me about dashboard i am not new excel.
    waiting for ur reply

    rest is ok
    waqar

  120. Jagdish says:

    HI Chandoo Sir,

    I am also one user in your website http://chandoo.org Its a very excellent Side Thanx a lot. You are one of my Ideal as a Excel Hero.

    Request you to share with me some Good Ideas how can I will start with Excel Macro & VBA Programming Language.

    I want start with Excel Macro & VBA Programming course as well I have called you website number as well but you are providing online classes but I have not a good knowledge about the VBA codes.
    That’s why I am little bit confused. Request you to share some good Ideas for the same.

    I want also be excel Champion.

    Regards,
    Jagdish N
    9899386928

  121. Kshitij Balapurkar says:

    Hi Chandoo…

    I am a CA final Student and excel is an indivisible part of my professional life…

    I have learned many new thing from your site… and still keep on reading anything that comes to my mind… just that i could learn something new… and every time there is something new… I am just at learners stage and i still learning..

    I am just grabbing this opportunity to say thanks to the best “HELP” available… You are really superb in it…

    Thanks for being there..

  122. Hi Chandoo
    Your web is excelent!!!
    I learn every day of you. I from Peru in South America.

  123. Hemant says:

    Your website is like a one Terra Byte extension to Excel’s Help File.Innovative and fresh.Keep it up!

  124. Narinder says:

    Hi Chandoo,
    too usefull ur wes site .. .. . . . . . . . . I Enjoy Excel Eveday there.
    Thankx

  125. jim says:

    great site. very helpful. Many thanks!

  126. Dileepan says:

    Wow ! Great!!

  127. manas says:

    Hi Chandoo,
    Nice site and feel good that ur an indian. i think this site can answer my query: i have 2 pictures(jpeg), i want to use if function to call pictures in some locations of spreadsheet. like if cell A:2 has value 1 show picture 1 and if i write value 2 in cell A:2 the picture changes to 2nd one. is it possible.

  128. Hui... says:

    @Manas
    Have a look at the two examples below:
    http://chandoo.org/wp/2009/07/13/product-catalogs/
    http://chandoo.org/wp/2009/05/19/dynamic-charts-in-excel/
    Both use charts but you can just as easily use an picture.

  129. Kalyan Chakravarthy says:

    Hi Chandoo,

    I read your profile. Nice to hear that you are MVP certified. Actually I’m very much interested in learning excel. Actually, I just want to know more about MVP certification and want to be certified professional like you. Can you please let me know what is the eligible criteria for MVP. can i have the details please.
    Here is my profile:
    Name: Kalyan Chakravarthy
    Education: B.com Graduate
    Profession: Working for HSBC Global Finance

  130. Pravin says:

    Good site, useful for every one thanks for your work .and keep it up ..

  131. SARAN KUMAR says:

    @chandoo,

    I love your blog. Keep it up !!

    @KALYAN,

    First of all, MVP is not a certificate but is an award given by Microsoft. For getting this award, you need to participate in different forums or in own blog by giving artciles, or by giving answers to the readers questions. Based on your one year contribution on that particular domain, you can be awarded by the microsoft as MVP.

    Thanks
    Saran
    lostinexcel.blogspot.com

  132. Juan Carlos Etayo says:

    Chandoo…..proud to be your fan..!!

  133. nirmal says:

    hi Chandoo, can u please tell me that learning access is useful to make a database software and does it have advantages over excel

  134. sudheer kuchipudi says:

    hai babai i am sudheer from basavanna palem(ongole).how r u.

  135. nitin says:

    dear chandoo is it possible to create a degree in excel sheet i mean a price time squareing degree chart

  136. Leigh says:

    I have a question to post but Icant figure out how to get a userid and password.

  137. Francisco d'Anconia says:

    Welcome my friend to a great site ! Excel is awesome and most have no clue the power that be.

  138. nitin says:

    dear chandoo i want to draw an 45 degree 90 degree 180 degree etc etc angle on excel line chart what is the porcedure??? is there any portractor (geometry protractor for creating the angle) available on excel sheet.

  139. JIm says:

    Is there a demo of the excel financial modelling program?

  140. Kamran says:

    I don’t have money to purchase your products and can’t attend your classes, it means that i can’t be expert in excel…?

    • Hui... says:

      @Kamran
      You can become expert in Excel without attending classes or reading books
      There is stacks of free stuff on the internet
      Get involved in some web sites, read, read, read
      Then Practice, practice, practice
      Try answering forum questions, even if some one else has answered it, try it yourself
      Start small and work up steady steady
      Ask questions on the various forums
      Even an old Excel 97 or 2003 version of Excel will still do 90-95% of what the newer versions can do.
      Similarilly books, Look for old Excel books 97, XP or 2003 in school or other book sales, they still contain most of what you need to know
      There are a lot of free tutorials on different aspects of Excel on Youtube, watch and then practice.

  141. Paul Brown says:

    Hi Chandoo, great blog, would you be happy for me to feature your RSS feed in one of our Excel training blogs? I notice that you told another commenter that they could link to your content, but I thought I would ask before using your feed :) Cheers, Paul

    • Chandoo says:

      Hi Paul…

      You can link to our content. However, you cannot host our RSS Feed or post full articles. Short excerpts (<100 words) are ok. I notice that you did host our RSS feed. So I request you to replace it with short excerpts. Thanks for your interest in linking to us.

  142. Paul Brown says:

    Hi Chandoo
    Apologies, someone has been a bit premature with this. I will have the posts reset with excerpts as you require. Regards, Paul

  143. Lou says:

    Sir,

    100 thank yous for your brilliant work dedicating what you know and understand to others like myself that just plain suck at excel.

    I’ve learned so many neat things that speed up my work and research.

    Thanks Again!!!

  144. Ankita says:

    Such A Very Good Blog About Excel. Very Inspiring Journey For Being An Entrepreneur..

  145. Subramanyam says:

    Hi
    It is very nice to see the blog and proud that a Telugu person has got so much rewards. visit my blog careerandresum.wordpress.com
    I helped few people when there was no Excel – I used Quattro and Lotus in those days and trained whole staff of a company out of interest. I am basically a game changer – when every was using wordstar etc., for balance sheet and etc I trained them about using Lotus and then Excel.
    I wanted to learn Pivot table – I got it from your site and many thanks.
    If can reach any bank people in India, there is a format they use – CMA data sheet – to make analysis of credit worthiness. If you can put it in pivot table and sell it – by introducing in http://www.caclubindia.com then you will have many customers .

  146. Hazel says:

    Hi Chandoo…very nice website you have.

    I have a difficulties in my project that need your advice.

    Im now running a dashboard in excel sheet. I have a workbook with multiple sheets, and sheet1 will be the main page to consolidate all data from other sheets( total 9 sheets).

    The data in other sheets has to be update on a weekly basis, and what i intend to do is that, i plan to have an update button in the main page, and once clicked onto the button, the system will then generate each of the sheet to compare with previous week value, if there is update value, it will then updated onto the 1st sheet, and action will repeats for the remaining sheets.

    can you guide me on how to start writing the code?

    greatly appreciate your help on this.

  147. Ram says:

    Hi ,

    Chandoo Blog is very inspiring to me .
    Even Chandoo is Role model for budding Bloggers!!! who can innovate online . He has mastered on single topic “Become Awesome in Excel”

    By http://www.grandpacoins.in

  148. Abhik says:

    Hi Chandoo,

    It’s really awesome site. The information on this site is quite valuable and most importantly FREE .. which many sites charges. It’s a Hats off effort… It help me a lot to simplify my
    way of working in excel.

    I had a question I work with huge database which are downloaded in Tab delimited format. Then I use “convert to text” formula then select delimited with ” | ” the data gets converted to excel format.

    Now the problem is whenever there is huge data (file size more than 250,000 KB) either the file get hanged or data is converted but the lines are not in place. Data moves from one column to another and the whole report gets disturbed. To fix this it takes a huge toll of time and patience which is nothing but frustrating.

    Would you able to help me in solving this type of problem ?

    Regards,
    Abhik

  149. Mukund says:

    Hi,

    i am using you project mgmt template and dashboards, and these are really helpful and excellent.

    i have one more request , do you have any templates for expense tracking.

    thanks.

    mukund

  150. Jay says:

    Hi Chandoo,
    Thanks for posting all the information on your website. They are very helpful and informative. I will like to ask you for a help concerning excel Pivot table.
    I was recently working on a Pivot table in excel and there seems to be one particular problem that is preventing from moving forward. I was hoping to get a view from an expertise like yours.
    My Pivot table has two different Running total field(Running Total for for Column A and Running Total for for Column B). I will like to create a new calculated field based on the two Running Totals ( = Running Total (A)/Running Total (B)). I know it is a simple as dividing the two fields but the problem is how do i divide the two running Total field. Running Total is an internal function which i don’t have access to. When I tried inserting a new Calculated Field, I only have access to A and B instead of Running Total (A) and Running Total (B). I tried entering Running Total (A) / Running Total (B) but it gives me an error.

  151. Miguel says:

    Hi Chandoo! I’ve always found it difficult to use excel, mostly because I rarely use it on a consistent basis. With your site, I am able to quickly play with one of your tips, get it up and running and add to my little treasure trove of excel bag of tricks.

    Oh, one more thing: love your logo’s doo, Chandoo!

  152. sawan says:

    Dear Chandoo

    Thanks you very much for your lessons on excel.

    I am learning so many new things in excel because of your online tutorial and also trying to implement at my work place.

    My best wishes are with you and keep rocking with your kind lesson.

    With regards
    sawan

  153. Jim Florence says:

    Hello Chandoo,

    I love the website and appreciate all the great adice you provide.

    I have a small issue I’d like to see if you or any of your followers have expereinced or resolved.

    In a dashboard, I have a range of data (a1:g14) that is separated by column h and resumes (i1:o14.) The data reads left to right and down to “g” then picks up at “i,” left to right and then down again (basically there is a gutter in the middle of the dashboard.)

    All of the data is related and I would like to sort from lowest to highest (column g & o) but the data would have to be rearranged across the gutter, possibly moving back and forth on each side depending on the rank.

    Is it possible to sort the data but tell it where to locate once sorted? I hope this makes sense. I’m happy to provide a screen shot if it helps the illustration.

    Thanks, Jim

  154. HARISH NEBHWANI says:

    “WAH KAYA IDEA HAI SIR JI,

  155. Faisal Mehmood says:

    hello there i really enjoying to read your articles really helpful excel points thanks and keep it

  156. vikas says:

    Hi Dear,

    I want to do the complete Advance Excel vba training online please provide me the fee structure for the same.

    Thanks
    Vikas Verma

  157. Ramesh Dashmuni says:

    Hi..
    I want to know how to convert currency figures into words.
    ie. Rs.100.00 to Rupees One Hundred Only.
    can be used for invoices totals at the bottom where we state the amount in words.
    Regards
    Ramesh

  158. VINOD says:

    Hello Chandu Bhaiya

    I have doubts in excel, i need to take solutions with you kindly give me your mail so that i can send my queries.

    Please annaya

    VINOD

  159. April says:

    Hello. Love that you are dedicated to this!

    Can I throw out a difficult question? I need a formula to calculate the number of guests booked at the same time through a range of dates.
    I have two columns, arrivals / departures.
    How do I see the earliest arrival and the latest departure….how many students/guests are here at the same time when many of them come and go at different times?
    I tried your overlap and that helped, sort of.
    Thanks in advance.

    • Hui... says:

      @April
      Can you post a file of sample data so we can see what is going on.

      • April says:

        Hui,
        Hello. How do I send a file to the forum? Do you have an email I can send the file to? Would love to have your input.

        April

        • April says:

          Just sent it to you.
           

        • Hui... says:

          @April
          You had emailed it to Chandoo but he forwarded it on

          Click on my Name, my Email is at the Bottom of the page

          Your problem really depends on what you want

          I have attached your file
          I added a few Named Formula as well as 4 formulas
          The formulas return the following data:

          Arrived in April '12 11
          Departed in April '12 12
          Arrived & Departed in April '12 3
          Arrived Before & Departed in Apr ' 12 9

          Refer: https://www.dropbox.com/s/kje1wsduy81pxdu/Moss.dates.Hui.xlsx

          So the question really is what do you want from your data?

          • April says:

            Thanks for looking into this. Your forumlas are very helpful.

            I need to know how many “bookings” students I have at any one given time. I chose weekends because that’s when they arrive/depart. I have a lot of overlap and I need to know how many students I have here on a given date /weekend-despite overlap.
            I’m not sure that’s clear as I am having a difficult time discerning the best way to calculate. I need to make sure I have enough accommodations for the students so I can stop sale if I am saturated one weekend.
            Not all students who arrive in January leave in January.
            Some leave other months. Also, some who arrive in say May, leave in May. It all depends.   
            Does that make more sense? 

          • Hui... says:

            @April

            I have added a section for examining a specific date

            It assumes the balance at the start is zero

            So staying at a specific date is  Sum(arrivals up to and inc that date)-Sum(Departures(up to and incl that date)

            Refer: https://rapidshare.com/files/3290143037/Moss.dates.Hui2.xlsx

             

          • April says:

            @@Hui
            Amazing! Wow! thanks a million! The specific date works wonderfully!
            I love your resources and will be bookmarking your material as well as looking into your other resources!!
             
            Thank you!

  160. Anu V Nair says:

    Chandoo,

    I am first in your site and from the first look i am very thankful to you for making this LIVE SITE…. Now I am working as an AutoCAD Engineer. Now my company given me a new work PROJECTS FOLLOWUP. That means Project report of all the projects containing the Project’s A to Z….
    So please give me some hints or help to do this through excel…..While I am searching for the same i got your address…………

    Thank You
    ANu 

  161. Krishna Nandanavanam says:

    Thanks. Good work Mr. Chandoo.

  162. priyanka says:

    i like it…… hope i will be good with excel someday………..

  163. Alina Gabriela says:

    Hi,
    Is there any certification after completing a course ?
    Thank you,
    Alina

  164. Patrick says:

    Thank you, thank you. Your site has given me answers to several questions I had about Excel. I don’t use it often, but when I do, I get frustrated trying to do something that seems like it should be easier to do than how I am approaching it.
    I like your approach to offering tips and information. I may do something similar for my website about Mac advice and building websites in WordPress: MacSage.com
     
    Thanks again!
     
    Patrick

  165. So inspiring that tears came out, So beautiful that i wish i meet you someday. I am also in a transitional phase after leaving job to do MBA and then again leaving the job after MBA to become entrepreneur. But i believe i can earn a respectful life as an entrepreneur and my small cute site.

  166. Purna!!  How great!!  I have been listening about you over and over in Chris Guillbeau’s book $100 Start-up.  He said you were in Koh Tao at the time he meet you.  Youre brilliant and Koh Tao is a great place to carry out your business.  I was there in June 2010.  Hey, so you have a new follower… ME.  I am an engineer in the States and I am using one of your sugestions just this morning.

  167. John says:

    Hello Chandoo and thank you so much for your site. It is full of information and you are a very generous soul for sharing it with us. I work in an accounting practice in Australia. We needed to develop a spreadsheet that would prevent duplicate data entry, specifically preventing an invoice number from repeating. I found the answer at your site and it works! The socks have been knocked of the feet of me and my co-worker! I have bookmarked your site and will be back. Great service, Sir.
    Thanks, John.

  168. Sunil says:

    I have downloaded MF Portfolio Tracker India V3.0.
    However I am unable to update latest NAV as Data/Reload Data button can not be clicked. PLease advise.

  169. kiran says:

    i got lot of  information about excel in chndoo’s and i want to regular classess, pls give me sugessions
    I have bookmarked your site and will be back
    thanks

  170. kiran says:

    i want to chandoo’s  mobile contact with u

  171. ed terpstra says:

    Question on your excel-videos/gifs on your website ..

    Im sorry this is not about excel .. but about the ability to explain excel to people .. i truly like the short videos/gifs you run on your website VERY EXPLANATORY … (and obvioulsy small in size!)

    Question : what tool do you use to make these short gifs?

  172. Sam says:

    Chandoo: You are brilliant, great work!

  173. Vaibhav says:

    Hi,

    I am facing a peculiar problem on my excel file , i am using this file in my office. It has loads of date say close to ~ 35mb. Now in one of the tabs i have a pivot set up which i refresh to set up the data in a given format to facilitate my work.
    Now for the last few months after I save and close this file, when i again open it up the file has an error. It say “unable to read” the file, it asks” do you want to recover the file”. After i say yes and recover the file, the pivot is vanished. This is really hampering my work. 

    I would appreciate if any one of you can help me with this.

    Regards,
    Vaibhav

  174. Vaibhav says:

    Hi All,

    I am trying to pull data for some structured swaps modeled on bloomberg under the swpm function in my login.
    I am using the following function
    =BDP(“SL4213RA CORP”,”SW_OPTION_VEGA”,”SETTLE_DT=20120531″,”SW_CURVE_DT=20120531″)

    Now i have two question here
    1) I am getting the option vega where the discounting curve and forward curve is assumed as bid, where as, I want the price where all these scenario are assumed as mid.
    2) I also want the market price for these instruments, for historical dates.

    Your help will appreciated, do let me know in case of any doubts.

    Thanks and regards,
    Vaibhav

  175. Varun says:

    i need formula for growth but my last year data is in minus
    exp.
    last year Profit            current year Profit
    -36                                  10
     
    when i use this formula (current year profit-last year profit)/last year profit%. its come to -127.78. can u plz give me solution of this problem  
    Regards
     
    Varun

    • Hui says:

      @Varun
      If you are basing this years growth on last years growth then -127 is the answer
      Maybe you should look at the average growth over the last 3 or 5 years
      You should get direction for this from your company/boss as it is not something the general public can answer
       

  176. tech RJ says:

    hi chandoo

    i have started a new food shop in aus. but i know basic of excel. can u please do tutorial on “how to make invoice from the products diffrent worksheet”.keep traking on sales history, for example like bar chart shows sales vs price.

  177. Ananthram says:

    This is one Awesome Site to learn A to Z of Excel Knowledge Thank you Chandoo for creating a Charming Website like this… it helps me in daily Life..

  178. Juber Ganja says:

    Hi Chandoo.

    I want to Extract PDF text into Excel using VBA code Please help me.

  179. T Jayakumar says:

    I have two excel files (Source and linked files). In Source file of Cell A1, numerical value of 1234 is entered. this is linked in the linked file A1 cell. Now if source file is deleted I want the value of A1 in the linked file becomes 0 with out any prompt.
    is it possible if so how

    with regards
    Jayakuamar 
    brightsais@gmail.com 

  180. Anamika says:

    I never thought that there is so much to Excel. I know to make an excel sheet for keywords or data and that’s all I have tried so far. I am amazed by the sort of information you have here. You are doing an incredible job.

  181. izal says:

    Hi chandoo, 

    We’ve been currently building a web-app which empowers the excel and various software, to clean, integrate, merge and share  data /spreadsheet/list without breaking a sweat. 
    I’m sure this app will increase the percentage of coffee time up to 75% during duplication I would say(aforementioned on your duplication blog).

    Looking for an excel guru like you to give us more valuable feedback, if you are interested to give it a try, contact me.  

    Cheers 

  182. Vaibhav Sharma says:

    Do you recomend books for excel proficiency..????

    And same query for macros and pivots..???

  183. izal says:

    Hi Vaibhav, 

    Thanks for replying. 
    No, we recommend  a web-app which enables you to (for instance) validate data and address, finding invalid format, de-duplicate, merge, and sharing list/data without breaking a sweat. Executing the mentioned tasks without any formula, only buttons. Mainly we focus on cleaning features.
    So here it goes, the users can import/copy paste their excel/pivot data into our web-app and play with it.
    It would be wonderful If we could share any thoughts with the excel addicts. so we can know your problems and what dreams you have to increase your coffee time while dealing wit excel, we try to build it for you.
    Don’t hesitate to throw me questions or dreams and to try out private alpha version : izal@podbox.com

    Cheers

     

  184. salim says:

    HI Chandoo
    I am your great fan i ve learnt lot from u
    yr site is of great learning for all
    no one gives such good templates @ free of cost
    These learning helped me earning Rs 50k for a project
    i want to submit u my projects for validastion
    how shall i send u

  185. AA says:

    Hello Chandoo,
    Can you provide me some information and worth of going for MOS certification in MS Excel 2010 (77-882 and 77-888). I wish to go for it and looking for materials, if you could help!

    Thanks, Arif 

  186. Hasaan Fazal says:

    Hi, 

    Although I have left the tweet at your twitter account, but still asking here again.

    How do you create gif files? I mean I understand from your page that how you record clips. But how do you convert movies to gif files? I would appreciate if you share your precious experience about this as well. Thank you 

  187. Kiran says:

    Hi Chandoo

    I consider myself as intermediate in VBA Excel, my hobby is to google the VBA forums and learn new things. I love learning new VBA Excel tricks.

    I have been trying to learn ” How to Intergrate Excel and Database ” and tried many websites but nobody is clear on the codes.

    I would like to learn this, could be please help me or share any site where I learn this.

    Finally, I have visited so many VBA forums and sites. I would rate http://chandoo.org as the best.

    Thanks

    Kiran

  188. MOHIT KHURANA says:

    Hi Chandu,

    I am looking for a vba based birthday scheduler for my company, an automated system which can show the pics of the employees birthday falling that day, in current week and current month, also automatically in the morning 8.00 am should send a automatoc bday wish to that person , the mail body should have a bday template background with his passport size photo and name on it..

    can u help me and guide me how to proceed    

  189. KIRAN KUMAR says:

    Dear Chandoo Sir,

     Please provide the Macro Basic Step on ….. 

    Regards,
    KIran 

  190. mohsin nadkar says:

    Hi Chandoo.

    I am reading your blogs since last 5 month… I am working in purchase department. Actullay i felt i dont know how to create purchase department dashboard report using excel.
    Would you like to help me to create the same or provide any idea using following feilds.

    I have data with PO ISSUED DATE, PO No, VENDOR NAME,VENDOR ID,QTY. UNIT COST,TOTAL COST,PO RECEePt DATE, PO RECeIPT QTY, etc. it will be greate if you post some dash bpard report example in yzour blog.

    please please help me………………

    Thanks & Regards,

    MOHSIN NADKAR     

  191. Sergey says:

    Best excel site evar!
    Also, meow. 

  192. Kvs says:

    Hello Chandoo sir,

    i have been seeing your site and learned many things. Used your ppt’s as well. Thanks for sharing such valuable information.

    I have a query ~ I have a text named >24 hrs in one cell which should be published in the pivot i make, is it possible. Request you to please help me.

    Thanks

  193. Sawan says:

    Visiting your website gives me a similar feeling to the one that a kid gets when walking into a chocolate factory…

    therez so much to learn here that I find myself vacillating between the gamut of options

    Hope to reach a point someday when I comment on this very page… saying “hey! I am through all of the articles on this site!!” :P

    Proud to see u follow ur passion…  

  194. Anurag Singh says:

    Hi,

    Great Effort! I would just like to add that can we get more homework assignments after each lesson and solutions to existing homework. 

  195. MANOJ says:

    Respected Chandu Sir,
    Veery Very good after noon,,,,,,,,,,,,,need your help in excel, I am very crazy about the grear excel.

    Thanks and Regards 
     
    Manoj 

  196. Hiren Jani says:

    Hi i am new user on your website. can you send me simple VBA page or document?
    i also want to know about VBA online teaching.is it possible?
     

  197. Amit says:

    Hello Chandu,

    I am regular follower of your comments and updates.Need help

    for a macro.I need to create a macro to check whenever user while entering data in cell hits space bar.A message box should popup to say”Space is not allowed.Please reenter data”.I know this can be done using forms using keyup but not sure how to do it in VBA.

    regards
    amit

  198. JEHalm says:

    What are typical fee’s for a Phd from India and can it be done virtually?

  199. dheeraj says:

    hi sir,
       
        mee site chala helpful ga untundi…thanks a lot…
    sir,i want a little help…
    i used to practice online tests in internet…i know that they used to make those online tests using excel worksheets,i mean,   in A1-question,B1,C1,D1,E1-options and they use some codings/software(i donno) and convert into html format…  
    help me…


    dheeraj 

  200. dheeraj says:

    am thinking to make some online tests and put in a blog….

    so help me how to make a online test easily sir…. 

  201. Hosli says:

    Hello…
    Chandoo you are awesome. Keep up the good work.
    Q: What the meaning of PHD?

  202. Naresh Araveeeti says:

    Hi Chandoo,

    your stuff is extraordinary. you are doing a splendid job. you are  the key book of manny professionals and many analysts. 

    keep up the  high-quality work.

    Thanks&Regards,
    Naresh.
     
     
     
     

  203. Hi Chandoo, 

    I really learnt a lot from your site about Excel. Especially the beginner package on excel is really good! Keep doing the good work! 

  204. akshata says:

    The Bløkbord Timber Company of Norway grows fir trees usingsustainable forestry techniques. It supplies Christmas trees ofvarious sizes for both the domestic (home) and municipal (town andcity) markets throughout Scandinavia, and re-plants its forestsannually. It observes the fact that the municipal market demands largetrees of about 6 metres height, while the domestic market favourstrees of about 2.2 metres, so different ages of trees are cut asrequired.Two random samples of the heights of 25 trees each were taken duringthe pre-Christmas season last year from the many hundreds of treessold commercially, to support the company’s rigorous quality assuranceprogramme. The results are given in Table 1 below:Table 1: Height of Christmas Trees / metresSample 1                                       Sample 23.44    4.80    2.83    7.85    1.28    1.85    6.33    2.16    2.62    5.691.98    2.43    5.61    2.01    5.33    1.81    2.93    5.48    2.22    5.441.06    1.77    2.68    5.93    1.33    5.94    2.40    1.95    2.33    5.732.47    2.28    1.58    2.48    6.88    1.57    5.89    7.93    2.77    6.705.42    2.35    2.51    2.28    1.58    3.10    6.08    5.99    2.18    1.46InstructionsUse Excel to analyse the data provided both numerically andgraphically for such parameters as mean height, standard deviation,and height distribution, and carry out significance tests as you thinkappropriate, in order to draw whatever conclusions you can from it.Use your results to discuss critically the validity of the specificstatement, “the average height of all the trees cut was 3.57 metres”.

    Please help me with this!!!

  205. Adam G says:

    Hi Chandoo,

    I recently purchased both your portfolio and project packages and I love them both!  Thank you very much.

    The gantt charts in the portfolio dashboards only go up to a certain date.  How do I extend it to go past 2014?

    Thanks
    Adam 

  206. We’re a group of volunteers and starting a brand new scheme in our community. Your website offered us with useful info to paintings on. You have performed a formidable process and our entire neighborhood shall be grateful to you.

  207. Mohan says:

    Hi.

    After a long time I have visited your website, Chandoo. Its fascinating and I love the questions which people asks in this blogs. I try to learn Excel by my own and love to experiment any stuffs which I find it interesting. 

    So just going through the blogs here, I got one interesting scenario which was a question published by Amit on 22nd Oct. I don’t know if you have got the solution to this Amit, but it gave me something interesting to learn. Thanks a lot.
     
    I am mentioning the solution step by step:
     
    1. Go to VBE (Alt + F11)
     
    2. Go to ‘Insert’ –> ‘User Form’
     
    3. Now create a Textbox (By default, the name of the textbox will be ‘Textbox1′ – and since this is an example, I am not changing it ;) )
     
    4. Now Double click on the Textbox which you have created. It will open a code window with ‘Private Sub TextBox1_Change()’
     
    5. Now put the code 
     
    If InStr(TextBox1.Value, ” “) >= 1 Then
            MsgBox “Space is not allowed. Please reenter data”
    End If
     
    The code should look like:
     
    Private Sub TextBox1_Change()
     
        If InStr(TextBox1.Value, ” “) >= 1 Then
            MsgBox “Space is not allowed. Please reenter data”
        End If
        
    End Sub
     
    I think so this should do the trick ;)

  208. kaushik shah says:

    Hi chandoo,

    Actually, i required salary sheet as per IT laws including PF, ESIC, Prof. Tax, Income Tax, HRA, Conveyance, Washing Allowance with Basic Salary software.

    It should be operated means one worker salary will find if we add the working days only.

    This will help us more, if you can do this.

    Regards,

  209. Tony says:

    Hi Chandoo,
    I am really impressed by all your work.
    Do you have e-book on Dashboard, Project management… with downloadable examples?
    My time is not that flexible to join classes, so I would like to purchase ebook with examples for enjoying during free time and referring when needed.
    Again, great work man
    Best regards,
    Phong

  210. MANJIT SINGH - Ludhiana (India) says:

    Hi Chandoo,
    I am impressed by your work with EXCEL. You are really awsome in EXCEL.
    I need your help to get data of one employee from a master file against Employee Code. I am sending you a mail. Pls reply i will be very thankful to you.
     
    Regds
    manjiet
     

  211. Steve says:

    Thanks for the tips, it has helped me to draft a few spreadsheets to manage staff performance etc. Cheers. 

  212. BruceW says:

    Hi Chandoo 
    Am much unsuccessful research I need some assistance with custom formats. I need to display 15 000 000 and -15 000 000 as 15 000 and (15 000) ie display amounts in thousands . #, works but displays 15000 not 15 000 (with the space as a separator). My regional settings has space as a thousands separator as opposed to comma. All the forums deal with a comma as a thousand separator but not a space. Any assistance would be grateful
    Regards Bruce 

     

  213. Kits says:

    Hi Chandoo,
    I am from datawarehousing(ETL) background. I want to have a technology change and hence want to excel in VBA. How can i use your tutorials and from where can i start? I need the complete knowledge required to be excel in VBA. I am totally novice to this. and how much time these tutorials will take?

  214. Dayanand says:

    Hi Chandoo,
    I heared that you are one of MVP(Most valuable person ) in Excel…I want to be like you buddy..
    Will you help me to be excel in excel
    Daya
     

  215. This is an EXCELlent tutorial website, cheers and keep up with your EXCELlent work and knowledge share.
    Thank you!

  216. Naveen says:

    hi
    I am sorry if I makw a mistake asking this.
    i have registeredwith Chandroo and got user name and pass word too
    but still i could not ask my  excel question as i couldn’t find the place where my question be posted
    Can somebody guide me for this
     

  217. Ângelo says:

    Hi Cahndoo !
    Man you help me a lot !!! i’m brazilian,and i believe in excel’s power …. kkk!
    i’ll share your bolg with my friends,
    tks for everything,
    see you and God bless you,man !
    Ângelo Oliveira – Brazil

  218. Abhishek says:

    Hey Chandoo,
     
    Thank for the great effort to make a lovely website.
    i want to learn excel start to Macros however confused what to start and when to start.
    please guide me.
     
    Thanks buddy.

  219. KDS says:

    One very important question: Do these work on Excel: Mac 2011?

  220. Way cool! Some very valid points! I appreciate you penning this post plus the rest of the site is
    also really good.

  221. amanda says:

    Chandoo,  you rock.  Sending many thanks to you from the US for your fantastic, step-by-step guidance.

  222. Ram says:

    hi,
    Does doing MICROSOFT EXCEL SPECIALIST certification help an MBA Finance guy at the time of placements???

  223. wei says:

    Could you tell me how to make your GIF images are, use what software, thank you

  224. yaparala says:

    Hi Chandu,
    srini here from AP. i dont have word to say about job. i am proud of you, your APian.

    before seeing your website, i dont know in Excel. now i am very good knowledge on excel, this credit goes to you only.i can say proudly your my invisible guru(master).

    Thanks for online help.

  225. Ashwin says:

    Hi Chandoo bro., how are you doing ?? I have just started reading your blog/website ,, it is really cool n all useful info. is there , really like the good work., Thanks a Lot !!!!!!!! Rgds, tc

  226. swatantra says:

    Hi,
    Chandoo I love your website. Although I have little knowledge in Excel but slowly I’m getting involved in Excel owing to its excellent features & versatility. Your website comes handy with your depth of knowledge & experience. Many many thanks for teaching me.

    I loved your family pic. Beautiful family. Congratulations on having rare twins with rare names – Nakshatra n Nishanth.

    I’m a real estate agent in Bhopal (MP) in India & running a shoe store as well. I do my billing in Excel. I’m desperately trying to find a solution wherein my billing will be linked to my Inventory to update it simultaneously. Please tell me if you have a solution. I shall be grateful.

    Warm regards.
    swatantra kumar sethi

  227. adil says:

    Dear Chandoo

    Please look at that picture in your website.

    http://img.chandoo.org/power-pivot/distinct-count-agreements-by-person-data.png

    Can you please tell me how to create this fancy border on the image.

    with regard

    adil abdullah

  228. Tim says:

    Hi,
    Trying to post a topic/ask a question. But when I log in the post a new topic option disappears. Am I doing something wrong?

    Thanks.

    Tim

  229. hal says:

    Good morning!

    This has the makings of another dynamic duo. Which one of you is Batman? Robin?

    Seriously, any plans on heading to the southern part of the US? We would love to have you share your Excel wisdom with us down here.

    Who knows, you and Bill could possibly make a great wrasslin’ tag team as well, just a thought!

    Hal

  230. Jerry Erwin says:

    Please unsubscribe me from e-mails (too many to keep up with)

    Thanks

    Jerry Erwin

  231. M.F.H says:

    Really I would like to thank you so much for this effort…. really appreciated and BIG THANKS…

    Please keep such information always available..

    Good Luck

  232. Astrid says:

    Hello Chandoo!

    I have just stumbled on this site and must admit that I am not the only one re-inventing the wheel but improving the aura of invention using excel :) :) :) :)

    Excel is a large part of my day-to-day work – I am very passionate about Excel and am soooo very glad that it is not like a novel that you read once and the end is final… there are always new ideas and professionals, such as yourself who write the sequels! Otherwise, what would we be without Google ;)

    I loove getting a tricky mind-boggle – and solving it – my puzzle!

    Hope I have enought time to visit and learn from you!

    Keep it up!

    Very best regards,
    Astrid

  233. Xiao says:

    Hi I made a dashboard. I’d like to share it. How can I proceed it ?

  234. JoJo says:

    hi, chandoo. I know nothing about excel except to calculate my basic maths. But i’m here to learn. Can you show me how the excel 2013 meal planner sheets are switching so smoothly with just a single click. I tried the hyperlink but it is different but it doesn’t work the same in meal planner template. thank U.

  235. Atique says:

    Chandoo Sir,

    I would like to know about any Certification Course specially for Financial Modelling in India which can boost my career.
    Please suggest me about the Course/Exam

  236. Amir says:

    Chandoo

    I enjoyed your website content and your attitude.

    Wish the best

    Amir

  237. MAcro says:

    I have two queries,

    1. I am unable to register cause everytime i click on register and it gives “content not available on this URL”

    2.I want to run a macro in a way that if I record macro in one cell, it could run on every cell on giving command.

  238. Brad Edgar says:

    Chandoo,

    All I’ve got to say is that you are a mastermind when it comes to the topic of Excel. I’ve already learned so much just through browsing the pages of your website and I have yet to purchase my first product from you.

    Thank you so much for your efforts and hard work in trying to help people achieve more with Excel to better their lives and the people around them.

    Cheers,

    Brad

  239. Lanre Olokun says:

    Hello Chandoo,
    I want to commend the great effort that you have put into setting up this site.
    Here, I hope to develop myself more in Financial Modelling.
    Thank you.

  240. Mahyar says:

    Hi Mr Chandoo, I have a question about in. How can i subtract a number (for example:10) one by one . I have 2 cells,I want that when type in cell1=1 , cell2 will become 9.
    when type in cell1=2 , cell2 will become 8 ,….
    .
    .
    .
    when cell1=10 , cell2 will be 0
    Thnaks as help you to me

    • Chandoo says:

      Assuming, starting number is in A1 and value you want to subtract is in D1:

      In A2 write =A1-$D$1
      and drag it down.

      Now, type any 2 numbers in A1 and D1 to see what you want.

  241. Rajiv Shukla says:

    This site absolutely a life-saver…very usefull, I have shared it many…
    Here’s a trcik that I can share:
    cntrl+{ = to open the location of a linked cell….

  242. Rajiv Shukla says:

    I apologize for the typos…here’s what i was trying to say….
    This site is absolutely a ‘life-saver’, very useful…I’ve shared it as a resource with many…and all of them have appreciated it. Thank you again.

    Here’s a trick that I would like to share….
    CNTRL+{ = opens the location of a linked cell…

  243. I can not log into my account.. When I try to register it says my username is already in use…. When I enter my email address it says not found, but I still get my newsletters….

  244. Sai Charan says:

    Hi Chandoo,

    Thank you so much for your great efforts to building this. I am a bigger in excel, is there any way that I can attend for class room trainings on the same.

    Thanks&Regards,
    Sai Charan

  245. Nishikant says:

    Hi Chandoo,

    I have gone through some of your examples very easy to learn and to understand you have given full efforts to create this “Resource” for those who want trying to do something big in there life

  246. John Agnelli says:

    Stephen, I got the first letter and every one after EXCEPT Margaret Cho’s. Can you remedy that, please?

  247. saintjohn says:

    supa Chan,
    I could not bring back my formula bar to my work sheet.
    can u pls help?

    • Mohan says:

      @saintjohn

      Assuming you are using Office 2007 & above:

      In ‘View’ Tab, check Formula Bar

      If you are using Office 2003:

      Go to Tools > Options > View > Show > Formula bar

  248. saintjohn says:

    many thanks,my formula bar is back !

  249. saintjohn says:

    Hi Chan
    many thanks,my formula bar is back !

  250. Anjum Abbasi says:

    Hi Mr.Chandoo,

    Thanks for Nice Work.

    can you please provide alternate link for below videos because in Pk we are not able to view Youtube videos. I hope you will give consideration to my request.

    http://chandoo.org/wp/excel-vba/videos/
    http://chandoo.org/wp/excel-tutorial/
    http://chandoo.org/wp/excel-tutorial/working-with-pivot-tables/

  251. Prashant K says:

    Hi Chandu,

    Need some advice regarding my project work…part of it is to compare 100 products.

    There are nearly 20-40 parameters on which these products are compared. As of now I have maintained a plain vanilla excel sheet for it.

    The problem arises when i need to view specific reports, analysis and counts.. simple filtering do not help at all..

    Should I start learning Ms Excess or there is a way around in excel, do i need to learn a bit of VBA ..

    Please advice….

  252. Syed says:

    Hi Chandu,

    Great site! Love everything here! Do you have any templates/models for call center analysis?

    Syed from Chicago

    • Christine Vazquez says:

      I’ve been following you Chandu for a couple years now and this site is invaluable. I too am interested in any templates and/or models for call center analysis… or field service related analysis, as well.

      Regards, Christine in SF Bay Area

  253. Ilawrence says:

    Hi
    I would like to know if you can design a spreadsheet for my business. Please reply with private email.

    Thanks
    Ian

  254. Lerato says:

    Hi.
    I want to join your forum butu don’t know how.

    Can you asist me with fomular to match colums and return value i another column, e.g:
    If colum A has 10000 employee names and i want to paste 10 employees names on column B and thier managers on Colum C . each manager is put on same raw with their em,ployees. when i find the emp,loyee name on column A, i want excle to return thier manager’s name

  255. sudha says:

    What is the remedy for updating mutual funds through with mutual fund tracker .3 in excel format with amfindia

  256. mehdi jalilzadeh says:

    hello;
    tanks for to help me
    have nice time & see u

  257. Nirmal says:

    Hi Friend,
    I am new to VBA, now only i starting my carrier in IT, I am working for VBA Development, is this valuable? Possible to earn more and more?
    Thanks,
    Nirmal

  258. shankar pai says:

    best wishes from
    shanker pai
    MAKE A WILL FOUNDATION celebrate 28dec as philanthropy day
    WASTE MANAGEMENT INSTITUTE
    S.S.Pai and co advocates high court

  259. H.Eskandarinia says:

    Hi
    Thank you for your valuable site.
    I recommend this motto for your site

    Chandoo can do

    Best regards

  260. sowmya says:

    can you please tell me where can I get a data set on ecommerce website such as log files, time stamp files, clickstream data ?
    I need to create a dashboard using this data. please reply asap.

  261. Priya says:

    Hey…Thanks this is of great help

  262. Rajesh says:

    Chandoo,
    I happen to visit your site accidentally this year(2013) from Oct or so to be honest when i was searching for some solution for an excel problem, what dragged me in was the amount of information that you had provided in excel and the inspiring story of yours..thanks for sharing such abandant info which really inspires many to take something on their own…I also started writing my blogs recently “alltestingconcepts.wordpress.com” just to share my experiences and Knowledge with the larger audience based on available time with me(i am bit slow in putting up my blogs)..Probably people like you had some triggers in doing so which had affected positively..Thanks

  263. Prateek says:

    Thanks for for valuable site chandoo, i am new to this site

  264. Raghu says:

    Hi Chandoo

    Your blog is brilliant. Keep it up. Can you please let me know how to add two stock charts one below another as candles please?

    Thanks
    Raghu

  265. Abram Wah says:

    I am surprised by the knowledge in this blog I found it to be more than extremely motivating but it really also made me reflect. It is tough now a days to get relevant information to ones search, so I am happy that I found this blog post

  266. MEHUL PARIKH says:

    Greetings, Chandoo. After being inspired by the expense trackers you displayed in your blog, I began working on one of my own. I was able to gather formulas from great minds on other fourms and your blog. I would appreciate your offer to look at my worksheet and help me tweak it to make it better and show a graph. I would certainly be happy to share my expense tracker idea with your members. I thank you for your service.

  267. Steve says:

    I came across your site and been looking through lots of your videos and liked how easy it is to follow.
    I do have a question. Is there a way using VBA to get data certain data from a table in word and export it into excel using VBA?

  268. Pradeep says:

    Hello Sir,

    I am a B.com graduate and I am interested in learning VBA excel coding.
    I do not have technical background. Can you help me how to become a master in excel as well as in VBA Excel coding.

    Thanks,
    Pradeep

  269. Sagar says:

    Hello Chandoo,

    The link to your MVP profile is broken. You should consider replcing https://mvp.support.microsoft.com/profile/Purnachandra.Duggirala with https://mvp.microsoft.com/en-us/mvp/Purnachandra%20R%20Duggirala-4024544

    Regards,
    Sagar

  270. Shlomo Messinger says:

    How do you sort the following in excel:

    Fri 1/31/2014 1:12 PM
    Fri 1/31/2014 1:52 AM
    Fri 1/31/2014 10:39 AM

    I converted it to a number and then sorted them and converted them back to a date time, is there an easier way?

    Thanks,

    Shlomo

  271. AussieSingh says:

    Hi Chandoo,

    I was looking for some help in excel and i came across your website. This is an amazing website and your explanations and vid’s are good.

    Keep up the good work, as there are many people like me looking for some help over excel!!

    Thanks
    AussieSingh

  272. Chandra shekhar says:

    Hi Chandoo

    How to convert Numerics into text, for example if Rs.150, how we need to convert as Rupees one hundred fifty only …?

  273. Ravella says:

    Hi Chandu can u send a text to my e-mail so that i can talk to u..i am in USA ( From HYD)

  274. Daniel Lamarche says:

    Hi Chandoo,
    At least a month ago I asked you a question about your Excel VBA course. It was a simple question but I wanted to know about the material since I am already comfortable in Excel VBA .
    Problem is that I never gor a reply. Too busy?

    • Chandoo says:

      Hi Daniel,

      I am sorry for delay in replying to your message. We do get a lot more mail than I can handle and very few times I miss replying to 1-2 such mails. Your email came few days before Christmas and I guess I was in holiday mood and did not notice it.

      I have already replied to you. Once again please accept my apologies for delay in replying and I hope to see you in our class.

  275. M.Asad Malik says:

    Hi Chandoo,

    How are you?
    I am in a fix right now….I want to start excel training so i could do amazing things with it..but I don’t know where to start..
    I have some experience like most of the people have when you are accountant in some software house making invoices etc…
    Where should I start Kindly suggest?

    Regards,

    M.Asadullah Malik
    Lahore, Pakistan

  276. Matt says:

    Can you start your VBA class at anytime or are there certain windows when you can start?

  277. satish says:

    Dear Chandoo,
    Is it possible to get a good Job just by learning Excel ?
    I am relocating to the UK in a few months ,my prior experience has been in windows and networking.Been in my mid 30’s I would like
    to know if I should focus more on excel.What sort of courses do
    you provide ? GREAT SITE !!!

  278. Julie Quick says:

    Hi Chandoo!

    I took your Dashboard class in Washington DC and loved it! Wondering if your on-line dashboarding class is similar or the same content? If yes, than I will move on to your Power Pivot Class.

    Thank you – love what you do!

    • Chandoo says:

      @Julie… Glad to hear from you again. The online class overlaps 60% with the live class you attended. In the online class you get more details on below:

      • Formulas & Advanced Formulas
      • In-depth coverage on charts
      • Dynamic & Interactive charts
      • More dashboard examples – total of 9 as against 1 in live class
      • Additional content on Conditional formatting, pivot tables & tables

      Let me know what you prefer.

  279. Majed` says:

    Thanks for greate job.

    i already buy the portfolio managment dashboard and need to let each project name in the dashboard have picture linked with dashboard , how can i do that.

    Thanks alot.

  280. Ula? says:

    Dear Chandoo
    I would like to say hi to you and I have need an information. but not about excel this time :) I love image crop effect in your web site could you please tell me which software use for this. :)
    Thanks foy your help

  281. datta says:

    Good site to learn a lot of excel stuff. Glad I saw it atleast today !!

  282. Vijay says:

    Hi Chandoo,
    Came to one of solutions on formula from your website. Was impressed with the way the solution was presented and it really worked…Thanks so much!!! Best wishes for your passion and venture.

  283. Rajesh PV says:

    Hello Chandoo,
    Fantastic is a small word to say after browing your website. Keep it up. Thanks for all your efforts in maintaining the site.

  284. salman says:

    I took your Dashboard class in Washington DC and loved it! Wondering if your on-line dashboarding class is similar or the same content? If yes, than I will move on to your Power Pivot Class.
    http://sufitywarszawa.pl

  285. sallobaba1 says:

    I took your Dashboard class in Washington DC and loved it! Wondering if your on-line dashboarding class is similar or the same content? If yes, than I will move on to your Power Pivot Class.
    http://www.danwoodfamily.de

  286. Shankar Bonda says:

    Dear Chandoo Sir,

    My Self shankar Bonda.I have good command on excel.Here I am solve excel related issue.

    I want to work with you and take more excel tips which help to me grow up on excel.
    i hope when you see this massage you give good suggestion to me.

    i am really your big fan.

    Regards
    Shankar
    India:9768229756

  287. Achyut says:

    Hi Chandoo,

    This is nice portal and really help us to build our excel knowledge.

    Thanks for publishing these materials openly. This is really need open mind to share such kind of training material with all.

  288. Ramesh says:

    Dear sir,

    I need a small help in excel. I want to know if I enter an end date of an event then automatically the excel should fill in all the dates for other tasks backwards excluding weekends. example

    if the event end date is June 10th then it should enter the dates like below:

    Collect ppt on 9th june ( here collecting the ppt is a task that has to happen a day before the event)

    arrange gate pass – 8th june
    finalize the venue of event – 10th May
    task 3 – 21 may
    task 4 – june 1st
    etc etc

    The only thing I will give is the end date of the event which is 10 June

    I hope you will help me sir.

    Thanks & regards
    Ramesh

  289. Steve says:

    Hi, Chandoo, I am a big fan of your website. I have been following your news-letter for two years and also installed your app “Learn Excel” in my cellphone. However, when I changed my cellphone and reinstalled the app, all the old articles and padcasts are gone, only the recent ones are still in the app. I still have them in my tablet, but could you tell me how I can transfer to my smart phone? I’ve tried to copy the whole folder from my tablet to my phone, but the app could not recognize them. Your help will be very much appreciated!

  290. Pulkit Trivedi says:

    Hi,

    It’s really help us to build our excel knowledge.

    Thanks for sharing each & every details…

  291. hi says:

    Can i get management report template.Can you designed. What are the charges?

  292. chris says:

    I enjoy your site. The color, humor, and explanations are great. You usually find one or the other on most sites, but you have managed to have both.

    Keep it up… wish I found you years ago.

    Thanks, chris

  293. Kathy says:

    Hi Chandoo

    I signed up for excel school in March 2014 and was using it every day.

    I started a new job shortly after and had no time to access it for a while. I now want to carry on studying with you but have forgotten the link to get into the online classroom.

    Would you be able to send me the link or remind me how to get on again.

    If you need any further info from me to confirm my payment/access rights just let me know.

    Many thanks in advance

    Kathy

  294. Harpal says:

    i plotted .01, .02, .03, .04, .05 on x-axis and 5, 6, 7, 9, 10 on y-axis in excel. The x-axis label shows 1, 2, 3, 4, 5 instead of .01, .02, .03, .04, .05.
    How to make excel chart showing .01, .02, .03, .04, .05 as x-axis label.

  295. Klaudia says:

    Wow that was odd. I just wrote an very long comment but after I clicked submit my comment didn’t show up.
    Grrrr… well I’m not writing all that over again. Anyway, just wanted to say
    fantastic blog!

    • Hui... says:

      @Klaudia
      I have looked through the Spam and Trashcan and cannot see your post ?
      I have searched for your name and this is the first and only post here from you ?
      Hui…

  296. Suresh Narayanan says:

    Hi Chandoo,

    Thank you very much for sharing your knowledge.

    Speaking from the bottom of my heart, I learnt a lot from your website. You and your team are doing a really Awesome job.

    Recently I got promoted to Managerial cadre and I would like to implement few of my suggestions with the help of Excel and VBA macros.

    My question for you is, Do you any plan to conduct live classes on Chennai. If so, I kindly request you to drop a email along with the cost of the course.

    I prefer to attend only physical classes instead of online courses

  297. Suresh Narayanan says:

    I will also try to call you by tomorrow to double check on this

  298. Vijay K says:

    Hi Chandoo,

    Last couple of days, I’ve been trying to learn few techniques about the dashboards through Excel and stumbled into your website.

    You’ve a lot of useful tips and techniques, and above all good presentation with the actual spreadsheets created to put those techniques into practice.

    And a small note, the link to MVP has expired, please update it to: https://mvp.microsoft.com/en-us/mvp/Purnachandra%20R%20Duggirala-4024544

    Thank you and keep it up.

  299. Bryan says:

    Hi Chandoo,

    Two thumbs up for your excellent website.
    By far the best Excel + VBA learning source i’ve ever come across for the past 5 years.

    Thank you so much

  300. Akshay Saxena says:

    Hi,
    first of all i would say u about your blog,
    this is amazing nd knowledgeable blog for whom,who want to lean excel like me.

    Now, I have a question for you.
    Currently i am working as Data Analyst in a Company. but there i am not able to work on excel so, to go in any other company what all i should learn as Data Analyst.

    Will Wait for your reply.
    Thanks In Advance.
    Akshay

  301. Rakesh Mistry says:

    Your transaction details:
    – Name: Rakesh, Mistry
    – Email: xxx
    – Transaction ID: xxx
    – Item name: Project Portfolio Templates
    – Item Number: 1173606

    I am really disappointed!! I have made a purchase and I can not change the $ to £ on the Dashboard….because the project-portfolio-dashboard-VBA-v1-2010.xlsm spreadsheet is protected and there is no password supplied. If no one responses in the next 24 hrs, I will be requesting a full refund!!!!!!!!!!

    • Chandoo says:

      Hi Rakesh,

      Thanks for your purchase. We protect the files with blank password to prevent accidental deletes or changes. Follow below steps to unprotect.

      1. Right click on sheet name that you want to edit.
      2. Choose unprotect.
      3. Press Enter when asked for a password.
      4. Done.

  302. James says:

    I am very disappointed with service!! Service is very bad… I called more than 10 times in last few days but no response…. no reply for the email as well….

    Very bad service…. very very disappointing….

    I’ll not recommend at all to join this…..

  303. Anil says:

    Hi Chandoo,

    I also faced the same problem. I tried calling all the numbers provided on the website but no response.

    I dropped couple of emails as well in last couple of days but no reply for the emails as well.

    If you are offering the classes to selected students then also at least give a courtesy reply and inform the pre-requisite.

    Thanks

    • Chandoo says:

      Be patient my friend. You sent an email September 14th (Sunday) and you expect us to reply to you immediately? Our response time is 1 week. Thanks for understanding.

  304. Simran says:

    Hi Chandoo,

    Are you the only one who managing the whole courses? Sounds if you are away then people won’t get the reply….. Sounds errrrrrrrrr

  305. Rakesh Mistry says:

    Nobody has repsonded to my email which was sent on Monday 15th Sept 2014.

    In Chandoo’s absense, the other members who work with Chandoo have not even bothered to reply!

    Hi Chandoo,

    I hope you and your team are well!

    Really need your help today!

    I recently purchased the project-portfolio-dashboard-VBA-v1-2010, and just noticed that I need to record 20 project plans. When opening the spreadsheet, under the ‘Plans’ tab I can only add upto 10 project plans. Please can you re-send me the project-portfolio-dashboard-VBA-v1-2010 which allows me to add more than 10 project plans.

    Thank you

    Rakesh Mistry
    (rakeshmistry@hotmail.com

  306. Anil says:

    Hi Chandoo,

    Thanks a lot for the reply.

    I’m interested to join “Excel School + Dashboards + VBA”. Please send me the detail for fund transfer.

    Sorry to bother you while you on your trip… Please let me know if someone else can help and quickly revert back after fund transfer.

    Thanks
    Anil

  307. Rakesh Mistry says:

    Hi Chandoo,

    I hope you and your team are well!

    I am really struggling!!!!

    I have 2 major issues and I question . Please see attached my workbook.

    1. I have logged risks and issues for one project called “Communication” under the Risk & Issues tab. The problem is that Dashboard is not showing # of issues or # of risks for that project. Please can you amend or check ‘all’ the calculations. (I have tried everything and I am really struggling!!!!)
    2. Every time I open time workbook the format of the Gnatt Chart is out of place. (you will see) Please can you amend this.
    3. On the Dashboard you have a box called People. Please can you explain the what the bar charts tells us.

    Regards

    Rakesh Mistry
    rakshmistry@hotmail.com

  308. Rakesh Mistry says:

    Hi Narayan,

    I hope you are well !

    I am really struggling!!!!

    I have 2 major issues and 1 question below . Please see attached my workbook.

    1. I have logged risks and issues for one project called “Communication” under the Risk & Issues tab. On the Dashboard , on the left hand side where you select you project it is not showing No. of issues or No. of risks for that project. Please can you amend or check ‘all’ the calculations. (I have tried everything and I am really struggling!!!!)
    2. Every time I open time workbook the format of the Gnatt Chart is out of place. (you will see) Please can you amend this.
    3. On the Dashboard you have a box called People. Please can you explain the what the bar charts tells us?

    Regards

    Rakesh Mistry
    rakshmistry@hotmail.com

  309. Hisham says:

    Dear Chandoo,
    Firstly I want to express my admiration to you. I am (Economist) on Oil and Gas, and I want kindly to advice me about the best way to be involved in building an (economic modeling) as a Profitability Analysis to study economics and evaluation the Petroleum Projects, I mean the value chain of this industry (Upstream, Refineries, Pipeline project, Marketing…etc).
    Also, I’d like to ask if you have a specialized course for that topics (Economic Modeling for Petroleum Projects). or a an Integrated Model for study these projects (Economic & Financial Model as a Profitability Analysis and Risk Analysis), and what is the cost of these products assuming send via email.
    Thanks again and accept my respects.
    Best Regards,

  310. Julie says:

    Hi Chandoo – I emailed you form this email address last week with a question regarding invoicing me for my colleague and I to take your classes – is that possible?
    You’re the best = thanks!

  311. Ashvene Devi says:

    Hi Chandoo,

    I have reviewed some of the dashboards you have done and your site is really impressive. I am actually from Malaysia, just wanted to check with you, whether you give classroom trainings or its just online trainings?

    Thank you & Regards,
    Ashvene

  312. Ashvene Devi says:

    Hi Chandoo,

    Also was thinking of creating a project tracker to track company’s Lean Six Sigma Green Belt participant’s assignments. Do you have any suggestions? Would like to insert information such as their names, project titles, project goals, project charter due dates, due dates for each stage of the assignment.

    Thank you & Regards,
    Ashvene

  313. Marsha says:

    Chandoo,
    I had to stop in the middle of my work to THANK YOU for your simply awesome and effective Excel tips. I am specifically referring to the Time Saving Strategies you submitted for Business Analysts. This breakdown is extremely efficient and brings a high level of relevance to using Excel effectively. I will be teaching some of these strategies to the Analysts at my organization on Friday and b/c of your tips, I am overly excited to present to them.

    Thanks a million, I could go on and on, but I will return later and let you know how the session goes! :)
    Best to you!
    Marsha McConnell

  314. BobG says:

    Let me start by saying I enjoy your podcasts and emails very much. I have found them to be very helpful as I learn more and more about Excel. I am in need of some assistance. I have an excel table to which I add several new rows each week. It is accessed by multiple users, and I need to use sheet protection to protect the formulas and certain data within. The table however, will not expand with sheet protection on. I was hoping to solve this with a macro that could add 10 rows and then activate the 1st cell in the first empty row.

  315. HARESH SHRIMALI says:

    My Dear Chandooji :
    I have problem :
    Kindly help me, I have an Excel Sheet in Excel 2013 having one column with 10 Numbers in all cells of C Column( Total 2116 ). to want to convert it in US Date Format i.e. 773-214-9821. Please help me so that in future if I add 10 digits in C Column, it will automatically be converting in US Date format i.e. if I enter 55469652234, it should be converted in 554-696-2234 . By Cell Format Method & Formula Method Or more methods.
    Thanking you in Advance.

    HARESH SHRIMALI
    AHMEDABAD
    08530155400

  316. RAJ says:

    Hi Chandoo,

    Amaze to see all the above information. I hope even I get a solution to my problem.
    I am trying to use this excel as a token machine. I have linked up this token sheet with other sheet which shared by four users. If any off the users changes the token number, it gets change in our main display but the problem it doesnt say the token number. WHAT I EXACTLY WANT IS AS THE VALUE GETS CHANGED IN ANYONE OF THIS SPECIFIED CELLS (B4, B5, B6 & B7 THE EXCEL MUST ANNOUNCE THE NUMBER. For example If in cell B4 the number 7 comes, so the excel should tell ” TOKEN NUMBER 7?, after that in cell B7 is updated 21, so its should again tell as ” TOKEN NUMBER 21?… and so on it should keep doing the same.

    I hope I get my solution at the earliest.

    Thanks
    Raj

  317. Nizar Ashour says:

    Hi Chandoo,

    I am looking for excel application that can be used to extract real-time stock market information from the stock market feed .

    I am also interested in storing the data for further analysis.

    if you have any program or n add on that can be used for this purpose please contact me.

    Regards,

    Nizar Ashour

  318. Nitin verma says:

    Hi Chandoo,
    This site is excellent. completly site.
    and i like this site.

Leave a Reply