Posted on 11 June 2009
Flowing data had this posted a few months back showing various infographics which chart out the financial crisis and the events related to it.
There even an interesting clip that you can watch.
Interestingly the article also carries the impressive NY Times graphic on
how this bear market compares to ...
Continue Reading
Posted on 09 June 2009
Normal distribution is one of the most commonly found distribution types in nature. The normal distribution is a continuous probability distribution where the data tends to cluster around a mean or average. If you were to plot the frequency distribution of a normal distribution, you will tend to get the famous inverted bell-shaped curve also known as the Gaussian function.
Coming to the point, we are sometimes faced with situations where we would like to test out a hypothesis or carry ...
Continue Reading
Posted on 09 June 2009
If you want to make your large excel workbook calculate faster and have about 10 seconds of time on your hands, use this trick.
1. Open the workbook and select the spreadsheet with the largest number of formulas (or data).
2. While keeping the 'Ctrl' key pressed, press 'End'.
3. Check the cell address that the cursor has moved to.
4. If the cursor is well beyond the last cell that had a formula ...
Continue Reading
Posted on 08 June 2009
One often comes across situations when one wants to synchronize two or more pivot tables. The problem arises when two or more pivot tables have the same underlying data set but show different views to the user. In such cases, combining both of them without losing data separation is not really an option.
I wrote this small piece of VBA code a few months back that can help synchronize pivots across ...
Continue Reading
Posted on 07 June 2009
Beards are not a topic that you'd think someone would typically write about leave aside holding yearly competitions for.
Dyers.org is Jon Dyer's site where he talk about life, leisure, movies and his experiments with beards. Sometimes its stuff like this that makes you realize that life is so much more fun when you're off the beaten path.
Here is a nice chart of various beard styles on his site that caught my fancy.
...
Continue Reading
Posted on 07 June 2009
Time for a break from the usual Excel stuff......a couple of chosen Dilbert's.....
Continue Reading
Posted on 04 June 2009
Retirement planner in Excel will help you calculate your savings at the time of retirement. The Excel retirement planner takes in to consideration your monthly income, expenses, asset purchase over time, saving allocations and expectations of interest rates and asset appreciation to calculate the growth of your savings over a given period. You can download the
retirement planner in excel here.
All of us worry about the impeding retirement. How ...
Continue Reading
Posted on 03 June 2009
Adding new series to an Excel Chart can be a boring job. Normally you'd edit the Excel chart by right clicking the chart area and adding a new series in the Source Data box (which can take up to 7 clicks). By using this quick tip you can now insert a new chart series with just two mouse clicks. Here’s how it can be done.
Inserting a new series ...
Continue Reading
Posted on 23 May 2009
An in cell chart in excel is a chart that has been reduced to fit in a single cell.
In cell charts have been around for a long time but have gained significance in the past few years as projects and companies become more complex forcing analysts to pack more information per inch and more importantly, per second of the decision makers time.
In this article we will discuss quick ...
Continue Reading
Posted on 21 May 2009
You can use Excel to make charts using symbols and display unconventional characters. Here's a list of
symbols that can be used for making charts in excel. You can generate these symbols in Excel by formatting normal alpha-numeric characters with in-built or custom fonts (Windings, MS Outlook etc.)
Few quick tips:
To make a bar graph
Use the REPT(char) function in Excel to repeat a character. Choose from the list of symbols ...
Continue Reading
Posted on 20 May 2009
Have you ever encountered the #N/A, #REF!, #NAME?, #DIV/0!, #NULL!, #VALUE! or #NUM! errors in Excel? Learn more about these errors and how to avoid them in simple terms.
Why does Excel show #N/A, #REF!, #NAME?, #DIV/0!, #NULL!, #VALUE! or #NUM! errors?
#NAME? Error
The #NAME error is generated when a cell tries to reference a non-existent cell call a non-existent function. If you enter a formula that does not exist ...
Continue Reading
Posted on 19 May 2009
How do I create a dashboard in Excel?
To create a dashboard in Excel you organize the data used by the dashboard in an excel workbook, create flexible models out of the data and then finally present the data as a properly formatted report or a dashboard. Before we begin, always keep in mind that if the dashboard you are creating is going to be used (and oftentimes maintained) by other ...
Continue Reading
Posted on 19 May 2009
In this post you will learn about how to format pivot tables in excel. Formatting a pivot table is often the step that people tend to miss out when presenting information using pivot tables. By formatting a pivot table you can make the data stand out, occupy less screen 'real estate' and make the user's life simpler.
(You can download a copy of the
format a pivot table in excel workbook with an example here.)
How to Format a Pivot Table?
Let ...
Continue Reading