Sales Dashboard in Excel
Tried to replicate Andy Kriebel's Sales Dashboard in Excel. Link to Tableau viz - https://public.tableau.com/app/profile/andy.kriebel/viz...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
Jul 9, 20211 min read
Get Row Number with XLOOKUP in Excel
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...
5,9060
Antriksh Sharma
Jul 5, 20211 min read
SUM Cells by Color in Excel with VBA
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...
1490
Antriksh Sharma
May 26, 20211 min read
Option Private Module in VBA - Prevent users from accessing sub-routine or functions.
VBA allows you to create sub-routines or functions that can be hidden from the end user using only Excel interface, but sometimes that...
5923
bottom of page