All articles in 'Huis' Category

Excel Tips, Tricks, Cheats & Hacks – Excel Ninja Edition

Published on Apr 28, 2016 in Excel Howtos, hacks, Huis, ideas, Posts by Hui, Quick Tip
Excel Tips, Tricks, Cheats & Hacks – Excel Ninja Edition

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

Continue »

Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition

Published on Apr 21, 2016 in Excel Howtos, hacks, Huis, ideas, Learn Excel, Posts by Hui, Quick Tip
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition

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

Continue »

Formula Forensics 040 – Apportioning Sales by Criteria

Published on Feb 15, 2016 in Excel Howtos, Formula Forensics, Huis, Posts by Hui
Formula Forensics 040 – Apportioning Sales by Criteria

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)

Published on Oct 15, 2015 in Formula Forensics, Huis, Posts by Hui
Formula Forensics No. 039 – Find the Cell Address for a value (2D & 3D Reverse Lookup)

Find the Cell Address for a value from a 2D or 3D Range
(2D & 3D Reverse Lookup)

Continue »

Formula Forensics No. 038 – Find Which Worksheet a Max or Min Value is located on

Published on Oct 14, 2015 in Formula Forensics, Huis, Posts by Hui
Formula Forensics No. 038 – Find Which Worksheet a Max or Min Value is located on

Learn how to find which worksheet a max or min value occurs on using this neat formula

Continue »

What functions is Excel missing ?

Published on Jun 9, 2015 in Huis, Posts by Hui, Quizzes
What functions is Excel missing ?

What functions you believe Excel is missing?

Continue »

Conditionally Format Chart Backgrounds

Published on Mar 27, 2015 in Charts and Graphs, Excel Howtos, Huis, Posts by Hui, VBA Macros
Conditionally Format Chart Backgrounds

Learn two techniques to conditionally format the background of a chart based on some external value.

Continue »

Custom Number Formats – Colors

Published on Feb 3, 2015 in Excel Howtos, Huis, Posts by Hui, Quick Tip
Custom Number Formats – Colors

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 !

Published on Nov 28, 2014 in Huis, Posts by Hui, simulation, VBA Macros
Calculate Pi by throwing Frozen Hotdogs !

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.

Continue »

Formula Forensics No. 003b – Lukes Reward – Part II

Published on Nov 10, 2014 in Formula Forensics, Huis, Posts by Hui
Formula Forensics No. 003b – Lukes Reward – Part II

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

Published on Jul 23, 2014 in Formula Forensics, Huis, Posts by Hui
Formula Forensics No. 037 – How to Count and Sum Filtered Tables

How to Count and Sum data from Filtered Tables

Continue »

Hui’s Calendar Tool (as Borrowed from Chandoo)

Published on Apr 7, 2014 in Automation, Huis, Posts by Hui, VBA Macros
Hui’s Calendar Tool (as Borrowed from Chandoo)

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 »

Countif – Quick Tip

Published on Dec 16, 2013 in Huis, Posts by Hui, Quick Tip
Countif – Quick Tip

Learn how to Count Text, Blanks and Non-Blank cells with this Countif() Quick Tip

Continue »

Chandoo.org produces it’s Second MVP.

Published on Oct 10, 2013 in Huis, Posts by Hui
Chandoo.org produces it’s Second MVP.

Chandoo.org produces it’s Second Excel MVP.

Continue »

How to Solve an Equation in Excel

Published on Sep 19, 2013 in Huis, Posts by Hui
How to Solve an Equation in Excel

How to Solve an Equation in Excel

Continue »