Topic: Microsoft Excel Functions - Examples & Tutorials
New with Topic: Microsoft Excel Functions - Examples & Tutorials
chandoo posted a blog entry
How to Find Dates of Public Holidays using Excel
Lets celebrate these holidays in PHD Style. By learning few excel formulas that you can use to find out dates for some of the...
Lets celebrate these holidays in PHD Style. By learning few excel formulas that you can use to find out dates for some of the...
chandoo posted a blog entry
How to Find Dates of Public Holidays using Excel
Lets celebrate these holidays in PHD Style. By learning few excel formulas that you can use to find out dates for some of the...
Lets celebrate these holidays in PHD Style. By learning few excel formulas that you can use to find out dates for some of the...
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...
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...
19 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, excel apps, 2010, 2010 calendar
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, excel apps, 2010, 2010 calendarchandoo 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...
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...
19 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, excel apps, 2010, 2010 calendar
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, excel apps, 2010, 2010 calendarchandoo 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...
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...
22 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, date and time, Learn Excel, Microsoft Excel Functions - Examples &...
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, date and time, Learn Excel, Microsoft Excel Functions - Examples &...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...
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...
22 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, date and time, Learn Excel, Microsoft Excel Functions - Examples &...
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, date and time, Learn Excel, Microsoft Excel Functions - Examples &...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...
Steven, one of our readers from England sent me a Christmas gift tracker worksheet. I found it pretty cool, so made some minor...
23 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, excel apps, array..., custom cell...
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, excel apps, array..., custom cell...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...
Steven, one of our readers from England sent me a Christmas gift tracker worksheet. I found it pretty cool, so made some minor...
23 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, excel apps, array..., custom cell...
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, excel apps, array..., custom cell...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...
Every year, on 4th Thursday of November, folks in US celebrate Thanksgiving day. A similar holiday exists in Canada too, they...
35 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, choose(), date, date and time
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, choose(), date, date and timechandoo 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...
Every year, on 4th Thursday of November, folks in US celebrate Thanksgiving day. A similar holiday exists in Canada too, they...
36 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, choose(), date, date and time
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, choose(), date, date and timechandoo 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...
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 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...
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 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...
Two charting principles we hear all the time are, Sort your data in a meaningful order before plotting it. Show only...
48 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Learn Excel, bar charts, charting
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Learn Excel, bar charts, chartingchandoo 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...
Two charting principles we hear all the time are, Sort your data in a meaningful order before plotting it. Show only...
48 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Learn Excel, bar charts, charting
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Learn Excel, bar charts, chartingchandoo 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...
Today we will learn a new and exciting excel formula - the all powerful SUMPRODUCT.At the outset SUMPRODUCT formula may not...
50 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, Excel Howtos, illustrations, learn excel
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, Excel Howtos, illustrations, learn excelchandoo 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...
Today we will learn a new and exciting excel formula - the all powerful SUMPRODUCT.At the outset SUMPRODUCT formula may not...
50 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, Excel Howtos, illustrations, learn excel
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, Excel Howtos, illustrations, learn excelchandoo 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...
Anyone working on the data using excel will know the importance of lookup formulas. They are vital for making almost any...
55 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, products, Analytics, array...
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, products, Analytics, array...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...
Anyone working on the data using excel will know the importance of lookup formulas. They are vital for making almost any...
55 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, products, Analytics, array...
Pointy Haired Dilbert - Chandoo.org
| Topics: Learn Excel, products, Analytics, array...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...
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...
64 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, countif(), custom data..., data...
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, countif(), custom data..., data...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...
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...
75 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, charting, downloads
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, charting, downloadschandoo 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...
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...
75 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, charting, downloads
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, charting, downloadschandoo 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...
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...
78 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Learn Excel, baby feeding..., downloads
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Learn Excel, baby feeding..., downloads