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 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 ~55,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,
- 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 & 2013). 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.
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 450+ articles and tutorials on using excel, making better charts. 
266 Responses to “About Chandoo.org”
You still with the insurance practice? Have I seen you in JNR, Chennai?
Hi Chandoo,
How do I sign up so that I am able to start a new topic or reply to posts in your Excel forum?
There is a log in option, but first I will need to sign up and I can’t find a way to do that.
Much appreciated,
LittleMi
@LittleMi
If you Goto http://chandoo.org/forums/
Directly above the Username box is a Register link
@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
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.
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.
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.
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.
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
i want to chandoo’s mobile contact with u
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?
@Ed
Have a look here: http://chandoo.org/wp/about/what-we-use/
Chandoo: You are brilliant, great work!
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
Once the file is functional
I would suggest saving as a Excel Binary *.xlsb file
There are also some macros you can run to recover lost or locked up space which is no longer in use.
Refer: http://www.vbaexpress.com/kb/getarticle.php?kb_id=83
or
http://jeremycottino.blogspot.com.au/2011/05/how-to-reduce-excel-file-size-using.html
Hi Hui,
Thanks for replying, I changed the extention to .xlsb in the excel file. The file is not opening, the error message says the file format or extentiomn cannot be identified.
Regards,
Vaibhav
@Vaibhav
You cannot simply change the file extension
You must open the file and then save it as a Excel Binary *.xlsb file
Use the Save As option from the File Menu
@ Hui
Thanks a ton for your help, what you recommended works, also it has led to the file size to 1/20 times.
Regards,
Vaibhav
@Vaibhav
@ Vaibhav,
This may be because of the following reason.
The original file pivots source may linked to some external source files. You please check is there any change in the external source file path, or fields (even if the field heading is missed pivot shows error).
Try to fix the source file and open this excel file again. This may work…
Thanks & Regards,
Saran
http://www.lostinexcel.blogspot.com
Hi Hui,
Can you guide me here. i am looking for some help here.
Or can you suggest me where can i post this, so that some one can help.
Thanks,
Vaibhav
@Vaibhav
When you say help here
At Chandoo.org you can post questions at the Chandoo.org/Forums or as a response to the relevent posts
The forums are at: http://chandoo.org/forums/
Adding a sample file is always a good idea, refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
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
@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
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.
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..
Hi Chandoo.
I want to Extract PDF text into Excel using VBA code Please help me.
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
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.
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
Do you recomend books for excel proficiency..????
And same query for macros and pivots..???
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
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
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
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
@Hasaan
Have a read here: http://chandoo.org/wp/about/what-we-use/
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
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
Dear Chandoo Sir,
Please provide the Macro Basic Step on …..
Regards,
KIran
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
Best excel site evar!
Also, meow.
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
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!!”
Proud to see u follow ur passion…
Hi,
Great Effort! I would just like to add that can we get more homework assignments after each lesson and solutions to existing homework.
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
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?
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
What are typical fee’s for a Phd from India and can it be done virtually?
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
am thinking to make some online tests and put in a blog….
so help me how to make a online test easily sir….
Hello…
Chandoo you are awesome. Keep up the good work.
Q: What the meaning of PHD?
@Hosli… PHD means Pointy Haired Dilbert. That is what our website used to be called prior to renaming it Chandoo.org. You can read the backstory here: http://chandoo.org/wp/2010/05/07/change-to-chandoo-org/
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.
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!
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!!!
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
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.
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
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,
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
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
Thanks for the tips, it has helped me to draft a few spreadsheets to manage staff performance etc. Cheers.
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
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?
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
This is an EXCELlent tutorial website, cheers and keep up with your EXCELlent work and knowledge share.
Thank you!
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
@Naveen
You can post questions in two areas
1. In the Chandoo.org Posts, like you have here
At the bottom of each post is a Comments section.
2. In the Chandoo.org Forums
Goto: http://chandoo.org/forums/
Login
Then at the bottom of the page select the appropriate forum
At the bottom of that page is a section to start a new post or go here: http://chandoo.org/forums/?new=1
Please also read the 4 Sticky Posts at the top of: http://chandoo.org/forums/
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
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.
One very important question: Do these work on Excel: Mac 2011?
Way cool! Some very valid points! I appreciate you penning this post plus the rest of the site is
also really good.
Chandoo, you rock. Sending many thanks to you from the US for your fantastic, step-by-step guidance.
hi,
Does doing MICROSOFT EXCEL SPECIALIST certification help an MBA Finance guy at the time of placements???
Could you tell me how to make your GIF images are, use what software, thank you
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.
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
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
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
@Adil
Have a read of: http://chandoo.org/forums/topic/torn-edged-paper-style-for-the-cell-borders
Including comments
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
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
Please unsubscribe me from e-mails (too many to keep up with)
Thanks
Jerry Erwin
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
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
Hi I made a dashboard. I’d like to share it. How can I proceed it ?
Xiao
You could make a post here or in the Forums in the Vault with a description and a Link
Have a read of http://chandoo.org/forums/topic/posting-a-sample-workbook