Antriksh SharmaJul 19, 20211 min readSales Dashboard in ExcelTried to replicate Andy Kriebel's Sales Dashboard in Excel. Link to Tableau viz - https://public.tableau.com/app/profile/andy.kriebel/viz...
Antriksh SharmaJul 9, 20211 min readGet Row Number with XLOOKUP in ExcelIn 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...
Antriksh SharmaJul 5, 20211 min readSUM Cells by Color in Excel with VBAIn 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...