Archive for June, 2010
As most of you would know, I am re-opening Excel School Online Excel Training Program on June 14th. That means, I am very busy doing behind the scenes work so that new students get best possible excel learning experience when they come rushing next week. (That is why you are seeing less no. of posts on Chandoo.org this week).
But I have few last minute surprises for you. Just read on if you are interested to learn excel and become even more awesome.Continue »
While I was working Denmark, there is one thing I noticed. Danes are one hell of football lovers. The football (soccer) enthusiasm is over the top when there is a match between Denmark and Sweden. A common practice in many offices is a football pool. This is how it works: When there is a match […]Continue »
Ok, so you have written a shiny new macro to solve all the problems. The macro, solveWorldProblemsAndMakeSomeCoffee() sits nicely in your personalmacros.xlam file somewhere in C drive. You have also installed the macro as an add-in so that it is always available. But wait!!! How do you run your sWPAMSC everyday in the morning? (ok, […]Continue »
It is almost 3:30 am now, I stayed awake for last 23 hours so that Excel School 2 can be ready for rolling. But that is no excuse for not having a post here. So here it goes. Excel has formulas for converting a bunch of text to UPPER, lower and Proper Cases. But not […]Continue »
The other day, while doing consulting for one of my customers, I had a strange problem. My customer has data for several KPIs and she wants to display average of top 5 values in the dashboard. Now, if she wants average of all values, we can use AVERAGE() formula if she wants top 5 values […]Continue »
Wow… I am very excited to announce that our little blog has breached the 10,000 RSS Subscriber mark. Our community has a total of 10,171 members as of yesterday. To celebrate this milestone, I am opening another contest on this blog. Read on to know the details: What is the contest: Your mission, if you […]Continue »
Have you ever wanted to fetch live stock quotes from excel? In this post we will learn about how to get stock quotes for specified symbols using macros. We use Yahoo! Finance API to fetch the stock quotes and other information related to a company using excel macros. Along the way, we will also learn various interesting things about Excel VBA. Think of this post as a crash course in VBA.
This is a guest post by Daniel Ferry.Continue »
While preparing a project plan, I had a strange problem. I wanted to highlight all the project tasks that fall with-in a certain date range. At the lowest level, the problem is like this: There are 2 ranges of dates (a,b) and (x,y) and I want to know if they overlap (ie at least one […]Continue »