All articles with 'peltier' Tag

New Features in Excel 2010 Conditional Formatting

Published on May 19, 2010 in Charts and Graphs, Learn Excel

Conditional formatting is one of favorite features in Excel. CF has helped me save the day at work more than a dozen occasions. I almost became project manager just because I knew how to make a gantt chart in excel using conditional formatting. I have written extensively about it.

So, I was naturally curious to explore what is new in Excel 2010’s Conditional Formatting. In this post, I will share some of the coolest improvements in CF.

Continue »

Introduction to Panel Charts using Excel – Tutorial & Template

Published on May 12, 2010 in Charts and Graphs, Featured
Introduction to Panel Charts using Excel – Tutorial & Template

In this article we will learn what a Panel Chart is and how you can construct a panel chart in Excel.
What is a Panel Chart?

A panel chart is a set of similar charts neatly aligned in panels to help us understand some data which has multiple variables in it. Panel charts are also called by names “trellis displays” or “small multiples”. They are an effective way to display multi-variable data.

Here is an example panel chart showing the total defects per module over the last 4 weeks.

Continue »

Excel Links of the week [After a long time edition]

Published on Nov 9, 2009 in excel links

It has been a really long time since we have an excel links post here. That doesnt mean I am not reading anything exciting. It is just that I have gotten busy being a dad. But now that I am in to a saner schedule, we are bringing back the excel links. Here is a […]

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 »