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 »

D’oh – Visualizing Homer’s favorite sayings in Power BI

D’oh – Visualizing Homer’s favorite sayings in Power BI

Before we begin:

Today is the last day for enrolling in our Power BI Play Date. Don’t miss out on this amazing opportunity to learn, use and benefit from Power BI at your work. Check out my online class and sign up before the doors close at midnight. Click here.

Let’s get our Simpsons on then.

D’oh, How often Homer says his favorite things?

Here is the visualization to explore Homer’s (and other character’s) favorite sayings in 27 years worth of Simpsons episode. Click on the image to play.

Continue »

Keep Calm and Power BI [Breathing Exercise Vizzes]

Keep Calm and Power BI [Breathing Exercise Vizzes]

We are in the midst of my Power BI Play Date course launch. I have opened the enrollments for this program last week and there is a tremendous response to this program.  To celebrate the new course launch and show you the lighter side of it, let me share a few breathing exercises built in Power BI.

Continue »

Power BI Play Date is here. Come, join us for a play

Hello friends,

It’s here. Power BI Play Date – our online training program is now ready for your consideration. Please take a few minutes to read this to know all about the program. If you are ready to join, click here.

Check out below show reel to see some of the reports you can create in our course. It is #AWESOME.

Continue »