Which power plan is best for me? Excel for everyday problems

Which power plan is best for me? Excel for everyday problems

We had to switch power providers soon, so I started reviewing the options. There are heaps of providers in New Zealand and each offer a ton of different plans. Some offer welcome bonus or credit worth up to $ 200. Other offer straight forward rates. Some others offer discount if you sign up for both electricity and gas with them. So how do you decide which one is better for you?

Using Excel of course.

The result is awesome. I ended up saving more than $1000 with a simple model. Puzzled? Curious? Check out this short but powerful video tut.

Continue »

Conditional Rank, the easy way [quick tip]

Conditional Rank, the easy way [quick tip]

Yesterday, my mate from across the ditch, Hui posted about conditional rank formula (RANKIFS) using awesome SUMPRODUCT

Of course, not everyone can whip up a sumproduct formula like that. On a scale of One to Hui of Excel awesomeness, you would need to be at least an H to write sumproduct or countifs formulas shown in that post. So does it mean, you can’t conditional rank if you don’t know your X from L?

Don’t worry. We got you covered. You can still get your conditional ranks, without inception level array formulas. Simple, use pivot tables instead.

Continue »

Formula Forensics 043: Rankifs or Conditional Rank

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

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

Conditional Formatting – Chart Data Labels

Learn how to conditionally format Chart Data Labels without VBA

Continue »

Histograms & Pareto charts in Excel – tutorial, tips and downloadable template

Histograms & Pareto charts in Excel – tutorial, tips and downloadable template

Time for some statistics and charting fun. Let’s learn all about histograms and Pareto charts in Excel 2016. You will learn

  • What, why and when?
  • How to set up and customize histograms
  • How to use Pareto charts?
  • How to create dynamic histograms?
  • Creating histograms in old Excel (2013 or prior versions)

Sounds interesting? Let’s get started then.

Continue »

Find out if a number has repetitive digits [formula homework]

Find out if a number has repetitive digits [formula homework]

Time for a quick formula finesse check. Let’s say you have a number in A1. What formula can you use to find out if it has duplicate digits.

For example, if A1 has 123405, then answer should be FALSE

and if A1 has 123455, then answer should be TRUE

Go ahead and post your answers (formulas, VBA or M script) in the comments section.

Continue »