SubscribeAbout Chandoo.org
At 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 weekday I send one email with an excel tip or charting tutorial to help you become awesome in MS Excel.
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,250,000 monthly views with readers from all over the world. There are ~38,500 members reading this blog through feed readers & email. The blog has been featured on 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,
- Joining one of my training programs – Excel School or VBA Classes.
- Trying my excel templates for project management.
- Getting a copy of my excel formula e-book.
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). 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 thanks to our jobs, 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.
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.
At Chandoo.org, I have one goal, "to make you awesome in excel and charting". This blog is started in 2007 and today has 350+ articles and tutorials on using excel, making better charts. 
180 Responses to “About Chandoo.org”
You still with the insurance practice? Have I seen you in JNR, Chennai?
@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
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
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.
@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
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
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,
@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.
A really good “About” page. Enjoyed the humor.
@Tarun .. Welcome to PHD, Thanks
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.
@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.
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
Hi Chandoo,
Nice site! I hope to particpate and help others and also learn as much as possible.
Michael
(MADACCOUNTANT)
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.
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.
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.
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)
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.
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.
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.
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.
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.
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-
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!
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
My love affair with your blog will never end.
Omkar
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.
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
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
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
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
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
Hi Chandoo,
Have never come across website for Excel like this… Superb stuff…
Regards,
Smitha
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
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
Dear,
U R great. I Like your attitute towards Life. Which services offered by your company?
Regards,
champak
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.
@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.
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.
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
Hi sir,
great inspiration from you!My friend forwarded this website to me! very nice
Hi sir, great to see ur news on MSN home page.
Wants to become like you.
Greatly inspired by your invention or IDEA.
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….
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
Amazing Stuff Bro ….. Great Work ….
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.
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
HI…chandooo
I really liked ur site..it’s very useful.
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.
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
Hi chandoo,
I came to know abt ur blog thru AndhraJyothi Newspaper.
Ur commitment to blog is superb.
really fantastic work…
keep Going
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…..:-)
Great chandu for Achiving Mvp keepup keep rocking vizag guys
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.
HAI Chandu this jhansi uuuu really great!!!!!!!!!!!
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
Hi Chando,
Very Inspirational article in Andhra Jyothi..Gud job!
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.
hi sir,
it’s very good site for excel. thanks.
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……………..
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.
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..
hai
please give how to make filters automatically selected given date in cell
@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
hai sir thankq
give an example on my question”how to make filters automatically selected given date in cell”
@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
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
Dear Sir,
I use Open Office. Does Open Office Calc have all the requirements to be of use in your course?
Thanks.
Michael Hayden
@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.
Hi Chandoo,
I’ve come across your site during various searches for specific solutions using Excel. Great resource! Congrats and all the best!
Matt
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!
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.
@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.
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:)
Awesome site. Keep up the good work.
You rock!!!!
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??
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.
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
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.
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?
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.
hi
i am an civil engineer with mba
i am working as consulting engineer and financila advisor
iwant all formula in a package
Do you know of anyone who can build a simple dashboard for us?
@Cathy
Have you asked Chandoo directly?
visit: http://chandoo.org/wp/excel-consulting/
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
Loved your intro. Humorous and Sweet, yet professional
@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.
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.
How stupid! Your tag line for ‘spelling mistakes in a corporate world. Corporate is misspelled!
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.
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.
I am looking for someone to assist/critque my resume. If anyone has a reasonable price please let me know. JEHalm@yahoo.com
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 !!
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
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
Hi Chandoo,
Many thanks for your great work. I’m interested in VBA for Excel.
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
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
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
Any chance of putting a link for by book about rickshawing across India ………..all proceeds go to Railway Children charity for street kids worldwide ?
please suggest me a book to learn microsoft Excel And word.
really fine chandoo i learned a lot from you
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.
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
@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
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
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
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
CHANDOO, PLEASE HELP ME ACTIVATE MY EXCEL FORMULA E-BOOK. I BOUGHT IT ALREADY. THE TIME HAS EXPIRED. PLEASE KINDLY RESEND IT.
@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
Hi Chandoo,
Is there anyway I can purchase just your 8hr Dashboard Reporting course?
Thank you.
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.
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.
Thank you Chandoo!
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!
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…!!!!!!!!!!!!
Hi Chandoo,
I m beginner of excel so how to know more about excel.
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
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
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..
Hi Chandoo
Your web is excelent!!!
I learn every day of you. I from Peru in South America.
Your website is like a one Terra Byte extension to Excel’s Help File.Innovative and fresh.Keep it up!
Hi Chandoo,
too usefull ur wes site .. .. . . . . . . . . I Enjoy Excel Eveday there.
Thankx
great site. very helpful. Many thanks!
Wow ! Great!!
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.
@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.
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
Good site, useful for every one thanks for your work .and keep it up ..
@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
Chandoo…..proud to be your fan..!!
hi Chandoo, can u please tell me that learning access is useful to make a database software and does it have advantages over excel
hai babai i am sudheer from basavanna palem(ongole).how r u.
dear chandoo is it possible to create a degree in excel sheet i mean a price time squareing degree chart
I have a question to post but Icant figure out how to get a userid and password.
Welcome my friend to a great site ! Excel is awesome and most have no clue the power that be.
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.
Is there a demo of the excel financial modelling program?
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…?
@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.
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
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.
Hi Chandoo
Apologies, someone has been a bit premature with this. I will have the posts reset with excerpts as you require. Regards, Paul
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!!!
Such A Very Good Blog About Excel. Very Inspiring Journey For Being An Entrepreneur..
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 .
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.
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
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
@Abhik,
Are you storing this data within the Excel workbook or just using Excel as a temporary place holder.
Do send me more details on sharma.vijay1@gmail.com on this to help you out.
~VijaySharma
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
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.
@Jay
Can you post your file for us to have a look at your problem?
http://www.yourfilelink.com/get.php?fid=795546.
I need to be able to do the red column with pivot table
Here is another link if the wont work
http://forums.techguy.org/attachments/207337d1333991731/file.xlsx
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!
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
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
“WAH KAYA IDEA HAI SIR JI,
hello there i really enjoying to read your articles really helpful excel points thanks and keep it
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
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
@Ramesh
Have a look at : http://chandoo.org/forums/topic/converting-text-to-numbers-and-vice-versa
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
Hello Vinod,
I would encourage you to visit our forums and post your queries here, there are a lot of good and friendly people around to help.
http://chandoo.org/forums/
~VijaySharma
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.
@April
Can you post a file of sample data so we can see what is going on.
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
Just sent it to you.
@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?
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?
@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
@@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!
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
Thanks. Good work Mr. Chandoo.
i like it…… hope i will be good with excel someday………..
Hi,
Is there any certification after completing a course ?
Thank you,
Alina
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