Tried to replicate Andy Kriebel's Sales Dashboard in Excel. Link to Tableau viz - https://public.tableau.com/app/profile/andy.kriebel/viz...

In this tutorial lets see how you can use XLOOKUP in Excel to find the postion of the Lookup Value in the Lookup Array. Doing this with...

In this tutorial lets see how we can SUM cells in Excel with similar colors with the help of VBA. The dataset we are going to use: Now go...