All articles in 'Huis' Category

We Want Your Ideas

Published on Nov 24, 2016 in Huis, Posts by Hui
We Want Your Ideas

Chandoo.org is looking for your ideas!
What would you like to see discussed in future posts at Chandoo.org ?

Continue »

Stacked Bar/Column Chart with Indicator Arrows – Advanced

Published on Sep 15, 2016 in Charts and Graphs, Excel Howtos, Huis, Posts by Hui
Stacked Bar/Column Chart with Indicator Arrows – Advanced

Lets take last weeks Stacked Bar/Column Chart and add some high-performance steroids.

Continue »

Formula Forensics No. 041 – Convert a Roman Numeral to a Number

Published on Sep 14, 2016 in Excel Howtos, Formula Forensics, Huis, Posts by Hui
Formula Forensics No. 041 – Convert a Roman Numeral to a Number

Learn how to convert a Roman Numeral to a Number using this nifty formula. No VBA required.

Continue »

Stacked Bar and Indicator Arrow Chart – Tutorial

Published on Sep 12, 2016 in Charts and Graphs, Excel Howtos, Huis, Posts by Hui
Stacked Bar and Indicator Arrow Chart – Tutorial

Learn how to develop a Stacked Bar chart with Indicator Arrow in this Tutorial

Continue »

Hourly Goals Chart with Conditional Formatting

Published on Sep 1, 2016 in Charts and Graphs, Excel Howtos, Huis, Posts by Hui
Hourly Goals Chart with Conditional Formatting

A while back I developed a solution to a Chandoo.org Forum question, where the user wanted a 4 level doughnut chart where each doughnut was made up of 12 segments and each segment was to be colored based on a value within a range. If the values changed he wanted the chart to update, Conditional Formating like:
This post looks at how this was achieved.

Continue »

Excel Tips, Tricks, Cheats & Hacks – Readers Edition

Published on May 19, 2016 in Excel Howtos, hacks, Huis, ideas, Learn Excel, Posts by Hui, Quick Tip
Excel Tips, Tricks, Cheats & Hacks – Readers Edition

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.

Continue »

Excel Tips, Tricks, Cheats & Hacks – Readers Edition Prequel

Published on May 12, 2016 in Excel Howtos, hacks, Huis, Posts by Hui, Quick Tip
Excel Tips, Tricks, Cheats & Hacks – Readers Edition Prequel

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…

Continue »

Apply Conditional Formatting using Slicers

Apply Conditional Formatting using Slicers

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

Published on May 5, 2016 in Excel Howtos, excel links, hacks, Huis, Learn Excel, Posts by Hui
Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition

Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites.

Continue »

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 »