fbpx
Search
Close this search box.

Author Archive

The Excel Mandelbrot

Published on Jan 12, 2023 in Complex Numbers, Huis, Mandelbrot, Posts by Hui, Random
The Excel Mandelbrot

This post examines the implementation of the Mandelbrot Function within Excel without the use of VBA code. It explores how this is done using Real and Complex numbers.

Continue »

Circular Arc – Doughnut Charts

Published on May 16, 2019 in Charts and Graphs, Excel Howtos, Huis, Posts by Hui
Circular Arc – Doughnut Charts

Learn how to make a Circular Arc Chart in Excel.

Continue »

Hui’s World ! – An Excel Project of Global Scale.

Published on Oct 23, 2018 in 3D Maps (non Power Maps), Excel Howtos, Huis, Posts by Hui
Hui’s World ! – An Excel Project of Global Scale.

Hui’s World is an advanced Excel animated chart displaying the Earth, Continents, Countries and States and key geographical features.
This post will describe how it works and how it was made.

Continue »

Performing Maths in Microsoft Word (In an Excel Blog)

Published on Aug 28, 2018 in Excel Howtos, Huis, Posts by Hui, Word
Performing Maths in Microsoft Word (In an Excel Blog)

Learn to how perform Maths on Tables of Numbers in Microsoft Word.

Continue »

One Control Three Cells

Published on Mar 5, 2018 in Excel Howtos, Huis, Posts by Hui
One Control Three Cells

Learn a technique to control multiple cells with 1 Control.

Continue »

Formula Forensics 043: Rankifs or Conditional Rank

Published on Oct 19, 2017 in Formula Forensics, Huis, Posts by Hui
Formula Forensics 043: Rankifs or Conditional Rank

Learn how to develop a Conditional Rank or Rankifs formula in Excel

Continue »

How to Distribute Players Between Teams – Evenly

Published on Oct 12, 2017 in Excel Howtos, Huis, Posts by Hui, Solver
How to Distribute Players Between Teams – Evenly

Learn how to use Solver to allocate players evenly to Teams.
A Solver Tutorial.

Continue »

Conditional Formatting – Chart Data Labels

Published on Oct 9, 2017 in Charts and Graphs, Excel Howtos, hacks, Huis, Posts by Hui
Conditional Formatting – Chart Data Labels

Learn how to conditionally format Chart Data Labels without VBA

Continue »

How to add a lot of Goal Seeking to a model

Published on Jul 4, 2017 in Huis, Posts by Hui, simulation
How to add a lot of Goal Seeking to a model

Recently in the Chandoo.org Forums, MR06 asked the question, “I am trying to create a sensitivity table that tells me what amount of equity I need to include in a deal in order to get a fixed IRR as the year 3 sales price changes.” MR06 was using Goal Seek to change the equity input […]

Continue »

Formula Forensics 042: Reverse Text – A Formulaic Solution

Published on Jan 4, 2017 in Formula Forensics, Huis, Posts by Hui
Formula Forensics 042: Reverse Text – A Formulaic Solution

Use the new Textjoin() function to reverse a string of characters suing a formulaic solution.

Continue »

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 »