Topic: Excel Howtos
New with Topic: Excel Howtos
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...
3 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...
3 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
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...
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...
10 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: excel links, charting, Excel Howtos, Learn Excel
Pointy Haired Dilbert - Chandoo.org
| Topics: excel links, charting, Excel Howtos, Learn Excelchandoo 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...
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...
10 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: excel links, charting, Excel Howtos, Learn Excel
Pointy Haired Dilbert - Chandoo.org
| Topics: excel links, charting, Excel Howtos, Learn Excelchandoo 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...
Most of us use chart formatting options to change the way grid-lines, data series, labels, axis, titles, plot areas look. Chart...
11 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, chart..., charting
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, chart..., chartingchandoo 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...
Most of us use chart formatting options to change the way grid-lines, data series, labels, axis, titles, plot areas look. Chart...
11 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, chart..., charting
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, chart..., chartingchandoo 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...
16 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...
17 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
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...
Transposing rows and columns in a table is one of the most useful tricks when you are pasting data. Yet, it always surprises me...
23 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, 15sectuts, Excel 101
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, 15sectuts, Excel 101chandoo 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...
31 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...
31 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
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...
We all have atleast one story of how that one time the boss / co-worker / classmate / cat ruined the carefully crafted excel...
38 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, cell comments, cell styles
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, cell comments, cell styleschandoo 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...
We all have atleast one story of how that one time the boss / co-worker / classmate / cat ruined the carefully crafted excel...
38 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, cell comments, cell styles
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, cell comments, cell styleschandoo 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...
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...
39 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, axis..., bar charts
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, axis..., bar chartschandoo 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...
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...
39 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, axis..., bar charts
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, axis..., bar chartschandoo 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...
If only there is paste special for everything in life, things would be much more smoother and fun. Alas, the paste special is...
44 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, data..., keyboard..., Learn Excel
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, data..., keyboard..., Learn Excelchandoo 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...
46 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
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...
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...
53 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, productivity, quick acess...
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, productivity, quick acess...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...
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...
53 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, productivity, quick acess...
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, productivity, quick acess...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...
57 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...
57 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
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...
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...
64 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, data, excel tables, learn excel
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, data, excel tables, learn excelchandoo 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...
A Bubble chart displays circles (or bubbles) at given X and Y co-ordinates. Bubble chart is a very good way to show 3...
67 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, 15sectuts, axis...
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, 15sectuts, axis...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...
A Bubble chart displays circles (or bubbles) at given X and Y co-ordinates. Bubble chart is a very good way to show 3...
67 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, 15sectuts, axis...
Pointy Haired Dilbert - Chandoo.org
| Topics: Charts and..., Excel Howtos, 15sectuts, axis...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...
Spreadsheet modeling or scenario modeling is one of the common uses of Microsoft Excel. People, especially in financial sector...
71 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, cell styles, custom cell...
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, cell styles, custom cell...