Learn how to use Solver to allocate players evenly to Teams.
A Solver Tutorial.
Learn how to conditionally format Chart Data Labels without VBAContinue »
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 »
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 »
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 »
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 »
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 »