![Writing “Either Or” formula in Excel [Formula Howtos]](http://chandoo.org/images/icons/learn-excel-online.png){kind=icon}
![How do you consolidate data from multiple sheets in to one? [open thread]](http://chandoo.org/img/dlt/howto-consolidate-data-from-multiple-excels.png)
![Print Worksheets in One Page Across [Quick Tips]](http://chandoo.org/wp/wp-content/uploads/2009/12/print-1-page-wide-setup-excel.png)
![Format Charts Faster in Excel 2007 [quick tips]](http://chandoo.org/img/c/quick-chart-formatting.png)
![Findout Thanksgiving Day’s Date for Any Year [Excel Formulas]](http://chandoo.org/img/i/findout-thanksgiving-date.png)
![Reverse a List using Formulas [Using Excel INDEX() Formula]](http://chandoo.org/img/l/reverse-list-in-excel.png)
![Transpose Excel Rows and Columns [Quick Tip + Video]](http://chandoo.org/img/i/transpose-rows-columns.png)
![Switch Rows and Columns in Charts [Quick Charting Tip]](http://chandoo.org/img/c/switch-rows-columns-in-charts.png)
![Copy Data Validations from one cell to another [quick tip]](http://chandoo.org/img/i/copy-data-validations.png)
Add to your RSS reader
 |
 |
 |
more |
Meet Chandoo
At Pointy Haired Dilbert, I have one goal, "to make you awesome in excel and charting". PHD is started in 2007 and today has 300+ articles and tutorials on using excel, making better charts. Read more.
Connect
Recently Popular- Pivot Table Tricks to Make You a Star
- Flu Trends Chart in Excel [Yes, we can edition]
- Dr. Scroll-bar Mortgage Calculator or: Why you should not be borning and use form controls
- Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations
- Best Charts to Compare Actual Values with Targets – What is your take?
- On PHD Forums
-
