All articles with 'contests' Tag

How Would You Visualize Product Sales Data? [Excel Challenges #2]

Published on May 30, 2011 in Charts and Graphs, Excel Challenges
How Would You Visualize Product Sales Data? [Excel Challenges #2]

We have a new Excel Challenge folks!

I know our friends in US are away celebrating Memorial Day weekend. But that should not leave rest of us from fun. So, we have a new Excel Challenge. This time, you need to make a chart, to visualize product sales data.

And what more, one lucky person could get an Amazon Kindle Reading Device (Wi-fi version) by making the chart.

Continue »

80% Discount on PUP & PowerPivot Contest – Hurry up!

Published on May 3, 2011 in excel links
80% Discount on PUP & PowerPivot Contest – Hurry up!

Since I am busy with background work on VBA Classes launching next week, today I want to give you two quick updates.

1. John Walkenbach is offering 80% discount on his Power Utility Pack Excel add-in, only today (3rd May) between 11AM-1PM EST.
2. You can win an XBOX 360 + Kinect by participating in PowerPivot Nerdtastic Quiz on their facebook page.

Read more to get the details about these two.

Continue »

Excel Challenge #1 – Make Nuts without Going Nuts

Published on Mar 9, 2011 in Excel Challenges, Learn Excel
Excel Challenge #1 – Make Nuts without Going Nuts

We have a new series on chandoo.org. – Excel Challenges. From now, every 1-2 months, I will post an interesting Excel Challenge. These are tricky problems for which elegant solutions should be found. To keep the challenges exciting, we will have a small prize for a winner (if more people answer correctly, we pick one randomly)

Excel Challenge #1 – Find Overlaps in Machine Schedule Dates

We have an Excel Table, with the following data (snapshot above). You need to write formulas to display Ok or Not Ok in the adjacent column based on the following criteria:

1. Display Ok if the scheduling dates for that row do not overlap with remaining scheduling dates for that machine
2. Display Not Ok otherwise.

Continue »

6 Christmas Cards in Excel – Download and Spread Joy

Published on Dec 15, 2010 in Learn Excel
6 Christmas Cards in Excel – Download and Spread Joy

Few days back, I have asked you to make a Christmas card in Excel (or any of your favorite festival’s card).

We got 6 entries for this contest. All the entries showed a lot of creativity to come up with beautiful cards using Excel. See the entries, download the excel files & find out who the winner is. Read the rest of this post.

Continue »

Make a Christmas Card, and you can Win a $50 Gift Card

Published on Dec 3, 2010 in Learn Excel
Make a Christmas Card, and you can Win a $50 Gift Card

Christmas is my favorite festival. It has certain magical feel to it. This year, it is going to be even more special, because we have 2 more hilarious, lovely people to share our joy with, not to mention over 16,000 of you to celebrate it with.

So naturally, I was excited when Fred suggested that we have a contest on this in our forums. So here we go.

Continue »

Bad News & VLOOKUP Contest

Published on Oct 5, 2010 in blogging, Learn Excel
Bad News & VLOOKUP Contest

Hello Folks.

I have a rather bad news for you. My internet service provider (TATA Photon) has mysteriously blocked chandoo.org. My site hasn’t been loading since Sunday. While, I know it is up and running, I cannot see it unless I go thru a proxy server.

It may take a few days to get this resolved. I am using this time to take a break from blogging and finish reading a few books.

But I have a contest for you that will keep you busy. Share your favorite VLOOKUP tip / trick and you can win an iPod Nano. Read more for rules & how to participate.

Continue »

Share an excel link and win $14.85 gift card from Amazon

Published on Sep 6, 2010 in excel links
Share an excel link and win $14.85 gift card from Amazon

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.

Continue »

Winner of Excel Expense Tracker Contest – RomeoG

Published on Aug 10, 2010 in blogging

Remember the excel expense tracker contest we did when our little blog hit 10,000 RSS Subs? Well, the results are out, and the winner is RomeoG. His (or her?) workbook (shown below) received 31 votes. RomeoG will receive the Toshiba net-book (this one). Thanks everyone for participating & voting. You can see the winning entry […]

Continue »

7 Personal Expense Trackers using Excel – Download Today

Published on Jul 16, 2010 in Charts and Graphs, excel apps
7 Personal Expense Trackers using Excel – Download Today

Keeping track of your expenses is one of the fundamentals of living good life. So I asked you to prepare a personal expense tracker as part of our 10,000 RSS Subscriber Milestone contest. I have received 7 excellent entries in this contest, each capable of making expense tracking a breeze while providing good analytics of […]

Continue »

Office 2010 Contest Winners are here!!!

Published on Jun 25, 2010 in blogging, Excel Howtos
Office 2010 Contest Winners are here!!!

Okay folks, sorry I took quite awhile to post this. But I was busy with excel school and getting my kids buzz cut. So here you go. Contest winners – India Paresh shah (website) Abhishek Jain Rahul Mulchandani (website) Contest winner – International Tom (this Tom) Congratulations Winners. You will very soon hear from me […]

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 »

If Excel is a Superhero … [5k Contest and Giveaway]

Published on Aug 4, 2009 in blogging, Humor
If Excel is a Superhero … [5k Contest and Giveaway]

All you need to do to win prizes worth $195 is fill up this sentence: “If excel is a superhero…”. Find out more by reading the post and send in your entries thru comments.

Continue »

Twitter Formula Contest – We are 5000 strong now

Published on Aug 3, 2009 in blogging, Learn Excel
Twitter Formula Contest – We are 5000 strong now

Time for blowing my own trumpet and patting my own back over my pointy hair. I feel very proud to announce that our little community at Pointy Haired Dilbert now has its five thousandth member.

Take a minute and pat yourself on the back. This is an achievement because of you. Go ahead, I am waiting.

Ok, enough patting. Time for some gifts and fun.

We have 2 contests to celebrate the occasion. This is the first one. I will announce the second contest tomorrow. Read the rest of this post to find out more about the twitter formula contest

Continue »

and the Winner is…

Published on Apr 21, 2009 in Charts and Graphs, Learn Excel

The winner for our first visualization contest is decided. Curious? Read on…

Continue »

Budget vs. Actual Charts – 14 Charting Ideas You can Use

Published on Apr 5, 2009 in All Time Hits, Charts and Graphs, Featured

Do you want to make a budget vs. actual performance chart but not sure what option to use? Check out these 14 excel charting alternatives and find the one that tells your story.

Continue »