Archive for June, 2010

6 things you should know about Excel School

Published on Jun 10, 2010 in Learn Excel, products
6 things you should know about Excel School

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 »

Football Betting Sheet Template

Published on Jun 9, 2010 in excel apps, Learn Excel
Football Betting Sheet Template

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 »

How to Add your Macros to QAT or Excel toolbars?

Published on Jun 8, 2010 in Excel Howtos, VBA Macros
How to Add your Macros to QAT or Excel toolbars?

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 »

Convert Text to Sentence Case using Excel Formulas [Quick Tips]

Published on Jun 7, 2010 in Excel Howtos
Convert Text to Sentence Case using Excel Formulas [Quick Tips]

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 »

Average of Top 5 Values [and some homework]

Published on Jun 4, 2010 in Featured, Learn Excel
Average of Top 5 Values [and some homework]

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 »

Win a Netbook – 10000 RSS Contest

Published on Jun 3, 2010 in blogging
Win a Netbook – 10000 RSS Contest

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 »

Get Stock Quotes using Excel Macros [and a Crash Course in VBA]

Published on Jun 2, 2010 in Learn Excel, VBA Macros
Get Stock Quotes using Excel Macros [and a Crash Course in VBA]

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 »

Check if two ranges of dates overlap [Excel Formulas]

Published on Jun 1, 2010 in Learn Excel
Check if two ranges of dates overlap [Excel Formulas]

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 »