Archive for October, 2009

Make a Bubble Chart in Excel [15 second tutorial]

Published on Oct 5, 2009 in Charts and Graphs, Excel Howtos
Make a Bubble Chart in Excel [15 second tutorial]

A Bubble chart displays circles (or bubbles) at given X and Y co-ordinates. Bubble chart is a very good way to show 3 dimensional data (for eg. Region-wise product sales) without confusing users. In this tutorial, we will learn how to create a bubble chart using excel.

Continue »

What buttons you have in the excel quick access bar ? [weekend poll]

Published on Oct 2, 2009 in Learn Excel
What buttons you have in the excel quick access bar ? [weekend poll]

This week’s poll is quite simple. Tell us what buttons/ icons you have added to the quick launch bar in excel 2007 (or toolbar in excel 2003)?

As for me, I have these in my home laptop’s excel:

Just use the comments and tell me about your settings.

Continue »

Use Cell Styles to Make your Spreadsheet Models User-friendly [Quick Tip]

Published on Oct 1, 2009 in Excel Howtos, Learn Excel
Use Cell Styles to Make your Spreadsheet Models User-friendly [Quick Tip]

Spreadsheet modeling or scenario modeling is one of the common uses of Microsoft Excel. People, especially in financial sector use MS Excel to do a lot of modeling. While excel has such powerful features like goal seek and scenarios, it also has a very useful feature called “cell styles” that you can exploit to make […]

Continue »