Archive for July, 2019

Do you know that you can apply conditional formatting rules to visuals in Power BI? In this post, let’s learn how to conditionally format visuals in Power BI. Something like this:

This is an Excel replica of excellent Tableau visual on Tour de France winner data made by Marc Reid.

Last week I saw a stunning visualization on Tour de France using radial charts. I wanted to replicate it in Excel. So here we go.

This is a quick, fun and elegant way to make impressive charts. You can easily create info-graphic style charts in Excel using shape fill technique. Something like this:

Can we predict cricket match score in Excel? Using machine learning, ensemble modeling, multiple regression and Excel formulas we can. This tutorial explains how.