Subscribe

Topic: Microsoft Excel Functions - Examples & Tutorials

New with Topic: Microsoft Excel Functions - Examples & Tutorials


chandoo
chandoo posted a blog entry
2010 Calendar – Excel Template [Downloads]
Here is a 2010 new year gift to all our readers - a free 2010 calendar excel file (a little secret: just change the year in...
 
chandoo
chandoo posted a blog entry
2010 Calendar – Excel Template [Downloads]
Here is a 2010 new year gift to all our readers - a free 2010 calendar excel file (a little secret: just change the year in...
 
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
Christmas Gift List – Set your budget and track gifts using Excel
Steven, one of our readers from England sent me a Christmas gift tracker worksheet. I found it pretty cool, so made some minor...
 
chandoo
chandoo posted a blog entry
Christmas Gift List – Set your budget and track gifts using Excel
Steven, one of our readers from England sent me a Christmas gift tracker worksheet. I found it pretty cool, so made some minor...
 
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
Top X chart – Show Top X values of a chart Interactively
Two charting principles we hear all the time are, Sort your data in a meaningful order before plotting it. Show only...
 
chandoo
chandoo posted a blog entry
Top X chart – Show Top X values of a chart Interactively
Two charting principles we hear all the time are, Sort your data in a meaningful order before plotting it. Show only...
 
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
Product Recommendation – Excel Lookup Toolbox
Anyone working on the data using excel will know the importance of lookup formulas. They are vital for making almost any...
 
chandoo
chandoo posted a blog entry
Product Recommendation – Excel Lookup Toolbox
Anyone working on the data using excel will know the importance of lookup formulas. They are vital for making almost any...
 
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
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
Baby Feeding Chart using Excel
While feeding the babies last night, I had this idea. Why not make an excel sheet where you can keep track of the baby's...