Topic: Excel Howtos
New with Topic: Excel Howtos
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...
Today we will learn a new and exciting excel formula - the all powerful SUMPRODUCT.At the outset SUMPRODUCT formula may not...
6 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...
6 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...
13 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...
13 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...
14 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...
14 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...
19 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...
21 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...
28 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...
28 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...
32 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...
32 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...
39 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...
42 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...
42 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...
46 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...chandoo posted a blog entry
Excel Check Boxes, Even Simpler Way
In how to get tickmarks in excel, Jon commented,"[...] Better yet, use real checkboxes, so the user can change them with the...
In how to get tickmarks in excel, Jon commented,"[...] Better yet, use real checkboxes, so the user can change them with the...
62 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, checkbox, downloads
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, checkbox, downloadschandoo posted a blog entry
Excel Check Boxes, Even Simpler Way
In how to get tickmarks in excel, Jon commented,"[...] Better yet, use real checkboxes, so the user can change them with the...
In how to get tickmarks in excel, Jon commented,"[...] Better yet, use real checkboxes, so the user can change them with the...
62 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, checkbox, downloads
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, checkbox, downloadschandoo posted a blog entry
Want to become a Data God? Learn Excel Data Tables
Excel table is a series of rows and columns with related data that is managed independently. Excel tables, (known as lists in...
Excel table is a series of rows and columns with related data that is managed independently. Excel tables, (known as lists in...
67 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, Analytics, data
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, Learn Excel, Analytics, datachandoo posted a blog entry
Make a Pivot Table in Excel [15 Second Tutorial]
Last week we have posted a simple to understand excel pivot table tutorial here. Today I am going to supplement the tutorial...
Last week we have posted a simple to understand excel pivot table tutorial here. Today I am going to supplement the tutorial...
83 days ago
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, 15sectuts, data..., Learn Excel
Pointy Haired Dilbert - Chandoo.org
| Topics: Excel Howtos, 15sectuts, data..., Learn Excel