All articles in 'Huis' Category
![Excel Tips, Tricks, Cheats & Hacks – Readers Edition](https://chandoo.org/wp/wp-content/uploads/2016/05/Hacks-Readers-Hdr.png)
Over the last month we have seen some Excel Tips, Tricks, Cheats & Hacks presented by some of the best Excel practitioners on the internet.
In this final post of the series we highlight the Readers Contributions.
![Excel Tips, Tricks, Cheats & Hacks – Readers Edition Prequel](https://chandoo.org/wp/wp-content/uploads/2016/05/Hacks-Readers-Hdr.png)
Over the past 3 weeks we have been able to showcase some Excel Tips, Tricks, Cheats and Hacks from some of the best excel practitioners on the net.
But now it’s your turn…
Apply Conditional Formatting using Slicers
![Apply Conditional Formatting using Slicers](https://chandoo.org/wp/wp-content/uploads/2016/05/ETH_Hdr2.png
)
Have you ever wondered about applying different Spreadsheet Formats or Styles to reports which you may be send to different people and so the styling may be different for each recipient?
I haven’t, but in this post I will show how you can add it to your worksheets.
Continue »![Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition](https://chandoo.org/wp/wp-content/uploads/2016/05/EXcelHack-NON-MVP.png)
Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites.
Continue »![Excel Tips, Tricks, Cheats & Hacks – Excel Ninja Edition](https://chandoo.org/wp/wp-content/uploads/2016/04/Hack-Ninja-Header.png)
Excel Tips, Tricks, Cheats & Hacks – Chandoo.org Excel Ninja Edition
Learn some of the Chandoo.org Excel Ninja’s favorite Excel Tips, Tricks, Cheats & Hacks
![Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition](https://chandoo.org/wp/wp-content/uploads/2016/04/Hack-Header.png)
Learn some of the Microsoft Excel MVP’s favorite Excel Tips, Tricks, Cheats & Hacks in this post
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition
![Formula Forensics 040 – Apportioning Sales by Criteria](https://chandoo.org/wp/wp-content/uploads/2016/02/FF40Master.png)
Lets look at how to apportion sales according to multiple criteria
Continue »Formula Forensics No. 039 – Find the Cell Address for a value (2D & 3D Reverse Lookup)
![Formula Forensics No. 039 – Find the Cell Address for a value (2D & 3D Reverse Lookup)](https://chandoo.org/wp/wp-content/uploads/2015/10/FF39.png)
Find the Cell Address for a value from a 2D or 3D Range
(2D & 3D Reverse Lookup)
![Formula Forensics No. 038 – Find Which Worksheet a Max or Min Value is located on](https://chandoo.org/wp/wp-content/uploads/2015/10/FF38d.png)
Learn how to find which worksheet a max or min value occurs on using this neat formula
Continue »![What functions is Excel missing ?](https://chandoo.org/wp/wp-content/uploads/2015/06/Function.png)
What functions you believe Excel is missing?
Continue »![Conditionally Format Chart Backgrounds](https://chandoo.org/wp/wp-content/uploads/2015/03/CBG01.gif)
Learn two techniques to conditionally format the background of a chart based on some external value.
Continue »![Custom Number Formats – Colors](https://chandoo.org/wp/wp-content/uploads/2015/02/2003-Color-Picker-Master.png)
Did you know you can use Excel 95-03 Color Names or Color Numbers in your Custom Number Formats in all Excel versions up to an including Excel 2013?
This post will show you how.
Continue »![Calculate Pi by throwing Frozen Hotdogs !](https://chandoo.org/wp/wp-content/uploads/2014/11/Hotdog.gif)
Did you know you can Calculate Pi by throwing Frozen Hotdogs !
No ?
Learn how to calculate Pi by throwing Frozen Hotdogs with this Excel Simulation of Buffon’s Needle.
![Formula Forensics No. 003b – Lukes Reward – Part II](https://chandoo.org/wp/wp-content/uploads/2014/11/FF003b-Main.png)
A Formula based solution to extract records from a table that match a number of criteria.
Continue »![Formula Forensics No. 037 – How to Count and Sum Filtered Tables](https://chandoo.org/wp/wp-content/uploads/2014/07/FF37_4.png)
How to Count and Sum data from Filtered Tables
Continue »