In this blog let's take a look at how to compute New and Returning Customers with Excel's Dynamic Array Functions and Power Query.

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...