Subscribe

Topic: Excel Howtos

New with Topic: Excel Howtos


chandoo
chandoo posted a blog entry
How to pick a random date? [Formulas]
Often when you need to generate a sample from large data set, you may want to pick data from a random date. In such cases, you...
 
chandoo
chandoo posted a blog entry
How to pick a random date? [Formulas]
Often when you need to generate a sample from large data set, you may want to pick data from a random date. In such cases, you...
 
chandoo
chandoo posted a blog entry
Excel Links – Learn Excel Online Edition
Recently I have conducted a survey on my blog to find out your pulse on PHD. Quite a few survey respondents have told me that...
 
chandoo
chandoo posted a blog entry
Excel Links – Learn Excel Online Edition
Recently I have conducted a survey on my blog to find out your pulse on PHD. Quite a few survey respondents have told me that...
 
chandoo
chandoo posted a blog entry
Format Charts Faster in Excel 2007 [quick tips]
Most of us use chart formatting options to change the way grid-lines, data series, labels, axis, titles, plot areas look. Chart...
 
chandoo
chandoo posted a blog entry
Format Charts Faster in Excel 2007 [quick tips]
Most of us use chart formatting options to change the way grid-lines, data series, labels, axis, titles, plot areas look. Chart...
 
chandoo
chandoo posted a blog entry
Findout Thanksgiving Day’s Date for Any Year [Excel Formulas]
Every year, on 4th Thursday of November, folks in US celebrate Thanksgiving day. A similar holiday exists in Canada too, they...
 
chandoo
chandoo posted a blog entry
Findout Thanksgiving Day’s Date for Any Year [Excel Formulas]
Every year, on 4th Thursday of November, folks in US celebrate Thanksgiving day. A similar holiday exists in Canada too, they...
 
chandoo
chandoo posted a blog entry
Reverse a List using Formulas [Using Excel INDEX() Formula]
Here is a simple yet novel use of formulas. Let us say you have a list of values in range A1:A5 and you want to reverse the...
 
chandoo
chandoo posted a blog entry
Reverse a List using Formulas [Using Excel INDEX() Formula]
Here is a simple yet novel use of formulas. Let us say you have a list of values in range A1:A5 and you want to reverse the...
 
chandoo
chandoo posted a blog entry
Transpose Excel Rows and Columns [Quick Tip + Video]
Transposing rows and columns in a table is one of the most useful tricks when you are pasting data. Yet, it always surprises me...
 
chandoo
chandoo posted a blog entry
What is Excel SUMPRODUCT formula and how to use it?
Today we will learn a new and exciting excel formula - the all powerful SUMPRODUCT.At the outset SUMPRODUCT formula may not...
 
chandoo
chandoo posted a blog entry
What is Excel SUMPRODUCT formula and how to use it?
Today we will learn a new and exciting excel formula - the all powerful SUMPRODUCT.At the outset SUMPRODUCT formula may not...
 
chandoo
chandoo posted a blog entry
10 Tips to Make Better and Boss-proof Excel Spreadsheets
We all have atleast one story of how that one time the boss / co-worker / classmate / cat ruined the carefully crafted excel...
 
chandoo
chandoo posted a blog entry
10 Tips to Make Better and Boss-proof Excel Spreadsheets
We all have atleast one story of how that one time the boss / co-worker / classmate / cat ruined the carefully crafted excel...
 
chandoo
chandoo posted a blog entry
Switch Rows and Columns in Charts [Quick Charting Tip]
Let us say you have built a nice chart showing your sales and profits for the top 5 products (learn how to highlight top 5...
 
chandoo
chandoo posted a blog entry
Switch Rows and Columns in Charts [Quick Charting Tip]
Let us say you have built a nice chart showing your sales and profits for the top 5 products (learn how to highlight top 5...
 
chandoo
chandoo posted a blog entry
Copy Data Validations from one cell to another [quick tip]
If only there is paste special for everything in life, things would be much more smoother and fun. Alas, the paste special is...
 
chandoo
chandoo posted a blog entry
Prevent Duplicate Data Entry using Cell Validations
We all know that data validation is a very useful feature in Excel. You can use data validation to create a drop-down list in a...
 
chandoo
chandoo posted a blog entry
How to get Excel 2003 Toolbars in Excel 2007 [productivity hack]
In our recent poll, I have asked you to tell me which buttons you have on the quick access toolbar?Finnur, one of our readers...
 
chandoo
chandoo posted a blog entry
How to get Excel 2003 Toolbars in Excel 2007 [productivity hack]
In our recent poll, I have asked you to tell me which buttons you have on the quick access toolbar?Finnur, one of our readers...
 
chandoo
chandoo posted a blog entry
Making a chart with dynamic range of values
We all know that to make a chart we must specify a range of values as input.But what if our range is dynamic and keeps on...
 
chandoo
chandoo posted a blog entry
Making a chart with dynamic range of values
We all know that to make a chart we must specify a range of values as input.But what if our range is dynamic and keeps on...
 
chandoo
chandoo posted a blog entry
Another Reason why Tables are so awesome [quick tip]
Ever since I have learned the tables feature in Excel 2007, I have fallen in love with that. They are so awesome and so user...
 
chandoo
chandoo posted a blog entry
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...
 
chandoo
chandoo posted a blog entry
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...
 
chandoo
chandoo posted a blog entry
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...