All articles in 'Huis' Category
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
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
Lets look at how to apportion sales according to multiple criteriaContinue »
Find the Cell Address for a value from a 2D or 3D Range
(2D & 3D Reverse Lookup)
Learn how to find which worksheet a max or min value occurs on using this neat formulaContinue »
What functions you believe Excel is missing?Continue »
Learn two techniques to conditionally format the background of a chart based on some external value.Continue »
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 »
Did you know you can Calculate Pi by throwing Frozen Hotdogs !
Learn how to calculate Pi by throwing Frozen Hotdogs with this Excel Simulation of Buffon’s Needle.
A Formula based solution to extract records from a table that match a number of criteria.Continue »
How to Count and Sum data from Filtered TablesContinue »
Today we take a look at an exercise in how to develop a simple Calendar selection tool for your worksheets without using complex VBA Calendar Controls.Continue »
Learn how to Count Text, Blanks and Non-Blank cells with this Countif() Quick TipContinue »
Chandoo.org produces it’s Second Excel MVP.Continue »
How to Solve an Equation in ExcelContinue »