Learn how to conditionally format Chart Data Labels without VBA

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.

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.

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.

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.

Time for some good, old fashioned VLOOKUP love. Let’s say you are writing VLOOKUP()s to get data from an unusually fat table, ie one with heaps of columns. You want to get to lookup ID in first column and get thingamajig in what is that column number. Well, better get counting from 1 and after 19 seconds and lots of squinting you arrive at column number 53 – which has thingamajig. 

If this sounds like your VLOOKUP routine, check out these three amazingly simple tips to save some time and effort with your lookups.

Yay, finally our first ever full length Power BI tutorial is up. In this 30 minute video tutorial, learn how to get some data in to Power BI and make a quick report to understand it. We will be creating this.

Let’s get started then.