It is the labor day weekend in USA. That means, majority of our readers are busy barbecuing, enjoying the last few days of summer with their families and vacationing. Even though, I am not in US, I never miss an opportunity to sit-back and relax. So I thought of not posting anything until 8th of Sept.
Then, I realized, what the heck, only US has labor day. For rest of us, this is just another labor day.
So, we have a contest. I am giving away one $14.85 worth gift card to a random commenter.
What you need to do:
- Share an Excel or visualization related link that can make all of us awesome.
That is all.
Some rules:
- This contest closes on Sunday, 12th of September.
- Please mention your name and correct email id in the comments (if you win, I need to contact you).
- You can post as many comments as you want.
- But, make sure all the links are awesome.
- You can also link to a previously posted article on Chandoo.org, because I know I am awesome 🙂
- Winner will be chosen randomly.
Story behind the $14.85:
IÂ know you are already burning inside with the question, “$14.85 Chandoo? Don’t you have like, $85.15 more?”
Well, as you know I recommend some excel and vba books at my online store. Some of you kind souls support me by clicking on the links to get one of those books. And whenever, you do, the folks at amazon give me a dollar or two as commission. Turns out that I have made exactly $14.85 as sales commissions in last month. So Amazon sent me this gift card worth exactly.
So, there you go. Now you know how the $14.85 came into existence. So go ahead and share a link. The gift card could be yours.
PS: Incase you are reading this in email or RSS reader, click here to share a link.
PPS: Here is a link on how to read charts [PDF] that I found quite useful.
PPPS: What are you still reading the PPPS for? Go and share, NOW!
58 Responses
Hi Chandoo,
Please find below a link that I figured it out while searching for an Excel solution related to statistcs. I found it very useful.
http://phoenix.phys.clemson.edu/tutorials/excel/index.html
Regards,
http://www.gapminder.org/
There is one more which I visit very frequently like I vist yours 🙂
http://www.cpearson.com/excel/topic.aspx
http://www.gapminder.org/ is the GOD of visualization (motion charts); Its totally free to use and has both online and desktop version; Has huge database of health & economics related data collated from multiple sources and going back very far ago in the past and also extrapolating the future.. Awesomeness personified..
Hi Chandoo, Your site is great and always look forward to getting notifications on google reader of any news from your site, including your family updates. The gapminder site is great – think it works with google spreadsheets which has got some great visualisation features.
Another, site that is great and gives good explanations of some great excel spreadsheets with a new one provided eack week is excelhero.com
http://www.excelhero.com/blog/2010/09/excel-optical-illusions-week-29.html
Just visited it and seen that they have a new one. Wish they were on google reader as it is a fantastic way of keeping track of blogs. Regards, Mike
Hi Chandoo,
This animated chart from Excel Hero is awesome!
http://www.excelhero.com/blog/2010/09/animated-business-chart-3.html
Regards,
Henrique
Debra Dalgleish, who runs the Contextures blog (http://blog.contextures.com/) was kind enough to set up this web page of some submissions I have made to her blog in the past…
http://www.contextures.com/rickrothsteinexcelvbatext.html
I believe all three post macros would meet your criteria, but I want to point people to the macro in the section titled “Delete Row With Specific Word” as it contains a particularly powerful technique to select and delete rows of data without using a loop.
I am getting the excel food from
http://chandoo.org/wp/
Outstanding excel site in the web !!!
Chandoo,
If you are talking about charting or Excel Jon Peltier’s website needs to be on the list.
http://peltiertech.com
An excellent tips on using excel.
Thanks again for expanding your knowledge to allow me to learn.
http://spreadsheetpage.com/index.php/tips
Sorry, forgot the link….
Chandoo,
you know that I truly love Excel, but you’ ve been asking for visualization related links as well. So, you probably guessed what I would recommend when it comes to visualization. Of course it is Tableau and Tableau Public:
http://www.tableausoftware.com/public/
I know that you are already working with it. However, to all of your readers who don’t yet know Tableau: check it out. Tableau Public is for free…
Statistical Literacy Guides http://www.lonegunman.co.uk/2010/06/04/statistical-literacy-guides/
Visual Business Intelligence Newsletter: http://www.perceptualedge.com/library.php#Articles
I’ve always been a big fan of Fernando C.
http://www.prodomosua.eu/ppage02.html
I watch Mikes videos all the time.. He loves excel and so do I
http://www.youtube.com/watch?v=aakNYCWD3MM&feature=channel
Here’s a link to a helpful Excel cheat sheet: http://www.investintech.com/articles/excelcheatsheet/
A hot, hot, sizzling tip on using the column formula in the vlookup formula. :
http://blogs.msdn.com/b/excel/archive/2010/08/31/vlookup-uhh-now-what.aspx
Check the comments. You’ll also notice that Dan L is in the comments advocating the use of named ranges.
Hi:
First of I want to tell you I am a big Chilean fan of your blog. It is really helping me to improve my knowledge about Excel, in a very fun and innovative way.
I am very fond of this link, because it helped me a lot to save time in the construction and presentation of the Balanced Scorecard report that I have to built monthly (this site has another very interesting posts too):
http://www.clearlyandsimply.com/clearly_and_simply/2010/03/export-microsoft-excel-dashboards-to-powerpoint.html
I would also say that Jorge has some good tutorials on Data/Chart visualization
http://www.excelcharts.com/blog/
Hi Chandoo, You are doing a great job of teaching excel tricks and usefull tips related to excel. Thanks for every singlle post………
I want to excel in EXCEL. I need information on conditioning formatting w.r.t scheduling dates. The problem is this: We give schedule of so many projcts in various work sheets of a work book. In the next review meeting , I am missing to update. This is causing embarrasment. what I need is 1) The past dates should all change to say todaya’s date by pressing a button. How do we do it.
2) What is the date format to be followed. ( I work in India where the general format is DD.MM.YY. This is what is being followed in the review meetings.) Can I keep workng with the same format ?
3)How to use formula in changing dates. is it possible ?
You earliest response will be highly appreciated.
regards
shivakumar N
@Shivakumar: Check out http://chandoo.org/wp/2009/06/16/gantt-charts-project-management/ and use the template there to simplify your project plan. You can also get a copy of my project management templates if you want to simplify your project management activities – http://chandoo.org/pmt/pmt-index-1.html
The following link helps in creating, Sharing and Publishing your spreadsheets online:
http://www.spreadsheetlive.com/
The following linke give you various tamplates to make your job easy:
http://www.vertex42.com/ExcelTemplates/
The following linke give you really some cool, crazy, stuffs in excel:
http://www.dataspectrum.cz/pages/eng_files/engfilesmain.htm
This link provides an encyclopedia and some cool stuffs you can try in excel:
http://spreadsheetpage.com/index.php/files
This link provides all your financial related Spreadsheets:
http://pages.stern.nyu.edu/~adamodar/
This link provides all your financial related Spreadsheets:
http://www.jaxworks.com/toc.htm
Advanced Excel Techniques you can learn from this site: (I love this site)
http://databison.com/
This is amazing guys.. download this ASAP Utility for Your Excel Addin.. It will boost your work skills and saves time and the best part is IT IS FREE FOR PERSONAL USE as site suggest 🙂
http://www.asap-utilities.com/
Hi Chandoo.
http://www.homeandlearn.co.uk/excel2007/Excel2007.html – 2007 Excel tutorials.
http://peltiertech.com/Excel/Charts/index.html – Charting techniques
Excel Visualisation
http://datapigtechnologies.com/blog/?cat=23
Excel Dashboard
http://www.databison.com/index.php/category/excel-dashboard/
&
charts
http://www.juiceanalytics.com/chartchooser/
Share the link and earn rewards like me
http://spreadsheetpage.com/index.php/files
Hi, earn rewards like me
http://www.spreadsheetlive.com/
Google visualization API at http://code.google.com/apis/visualization/documentation/gallery/motionchart.html (bought from Gapminder)
http://code.google.com/apis/visualization/documentation/gallery/motionchart
Excel Bastards from Datapig Technologies have:
1. Several screencast tutorials on Excel and Access.
2. Several bits of niche, but quite useful freeware.
3. A blog with some frequent tips.
my current all-time favorite can be seen at YouTube by EngineeringFun
http://www.youtube.com/watch?v=ocnliT7iHtI
Unbelievable what can be done with a simple x-y plot. I believe I got the link from a previous Chandoo blog.
-bill
I can’t go past
http://spreadsheetpage.com/index.php/jokes
Couple of URLs that have helped me…
http://www.exceluser.com/index.htm
http://www.bettersolutions.com/excel.aspx
Thanks Chandoo for initiating this contest. It has already proved very helpful with so many links that I have not come across.
This link helped me to make one of my co-workers very happy!
http://www.contextures.com/excel-data-validation-add.html
I was able to make one of my co-workers very happy using the information on this link to Debra Dalgleish’s Contextures – Add new items to a validation list.
http://www.contextures.com/excel-data-validation-add.html
I don’t go a day without using ASAP utilities from http://www.asap-utilities.com/
Perhaps a formula can win also:
=IF(“Share an excel link and GET $14.85 gift card from Amazon”=”Share an excel link and WIN $14.85 gift card from Amazon”;”I’m in heaven!”;”Chandoo, you tricked your worthy readers with a fake headline! Shame on you!”)
@Sebastian: Sorry, I didnt notice the mistake before. You are right. I will be changing the title now.
This guy knows his interactive reports =)
– original site: http://www.istudio.si/storitve/
– translated site (powered by Google translate; from Slovenian to English): http://translate.google.com/translate?js=n&prev=_t&hl=sl&ie=UTF-8&layout=2&eotf=1&sl=sl&tl=en&u=http%3A%2F%2Fwww.istudio.si%2Fstoritve%2F
Chandoo, I like the way you think out of the box and post these contest ! Besides the $14, there’s great wealth in the info tossed out here! Great job dude!
This site is a great starting point – It is a page with links to a number of Key Excel MVP Web Sites, some of which have already been mentioned here.
http://www.exceluser.com/explore/links_mvps.htm
Thanks again for all the great information you publish here.
I think this site is the best site:-
a) Free of Cost
b) Vedio Learning (No need to put more concentration on understanding the sentenses)
c) Good for the beginer as most of the Basic topics are covered including Macro
d)It is a kind of social work or charity (which is very help ful for the student who are unable to spent money in learning although he/she have a desire to learn more and more)
e) It is help for those students even who are not form english background knows only Hindi langaue.
Hi All,
One more for the kitty for all finance lovers, this site has various Excel and VBA based finance files apart from other finance resources. Explore and Enjoy !!!
http://www1.finance30.com/
Rohit 1409
A great site for learning from VBA perspective, covers mainly all MS Office Applications with major focus on our very own favorite EXCEL 🙂
http://www.vbaexpress.com/
Rohit 1409
@Thank you everyone for such good responses. The contest is closed now. I will declare a winner by this friday. 🙂 However, please feel free to share links.
I have made some reasonably large workbooks (a database not an option at my workplace) and have found these two links invaluable in maintaining good efficiency …
http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm
http://www.decisionmodels.com/index.htm
@ALL.. the randomly chosen winner is Donnie (comment #16). Donnie you will receive the gift card soon.
Thank you everyone for participating. Please keep sharing links 🙂