top of page
Power BI | Excel | Python | SQL
Search

Antriksh Sharma
Jul 19, 20211 min read
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...
1530

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...
6,3120

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

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...
6253
bottom of page