🚀 Transform Your Excel Game Today! Solve any problem in excel. See description

Code / Decode your data like a spy!! See description

Streamline Your Workflow with Smart Excel Solutions See description

Easy way to Copy array formulas as values in Excel!! See description

Prevent duplicates in a column in Excel!! Get this tool free with my udemy course. link in descripn

See description. Dynamic Lookup based on Headers in Excel Tailor Addin!!

Get Sum by color in multiple sheets!! See description

Advance Lookup - Get Multiple matches from multiple sheets!! See description

Dynamic formula that update on its own!! See description

Date picker | Insert Calendars inside Excel!! See description

Create Worksheet based on cell values | Move columns with specific header to tabs with headers name

Advance Lookup Technique - When your Lookup value is present at multiple places! See description

How to Convert Table Date vertically in Excel See description

Excel Tailor Formula Series - Learn to Join Two Ranges | Reverse a text in excel!! See description

Create Dropdown Quickly| Create Dropdown from Formula| Eliminate Duplicate Entry| Delete Data Valdn.

Excel Tailor formula Series - Formula to Get Sum Count by color/Get Count by color See description

Excel Tailor Formula Series - Extract Common / Uncommon Values. See description to download this.

Excel Tailor Formula Series - Extract text or number from a cell value. See description to download

Rename Multiple files in a folder from Excel!! See description to download this add-in

Get Excel Table Data based on headers!! See description to download this addin

Apply Filter on multiple sheets on same headings!! See description

How to Convert Table Date vertically in Excel through Excel-Tailor Add-in See description

Apply 2D Lookup in Excel See description

How to split data in multiple worksheets See description

Easy way to protect your worksheets! See description to download this addin

Match Positive and negative numbers without any formula! See description

Conditional Formatting - Only highlight 2nd table for duplicates

Excel Fill Series shortcut trick - Insert blank row after every n number of rows

Generate Random text in excel

in Hindi - 2 D Lookup with Index Match

Reverse lookup - 6 ways

Lookup for unmatched values (Fuzzy Lookup)

in Hindi - Get multiple matches from Lookup (2 Alternatives) with practice file

Create a custom reverse Lookup Function in VBA

Lookup formula for multiple criteria's without any helper column (3 Alternatives) with practice file

Single formula Lookup for multiple rows (2 alternatives) with practice file

Single formula Lookup for multiple columns (4 alternatives) with practice file

Check my excel course in description for more tricks like this

Database Functions

Power Query "Merge Feature"

Learn Ms Excel 3d Formulas

Learn Indirect Function to work on multiple tables

Advance Filter and Its Automation

Learn your First VBA Macro in 10 mins (Guaranteed)

Choose Function - One of the best lookups function

PowerQuery - Introduction and Data Extraction from different sources (Hindi)

Reduce your workload, Use Ms Excel Flash Fills in Hindi

Ms Excel Table secrets revealed

Use Ms Excel Formulas in Outlook, Insert Excel spreadsheet in Outlook

Ms Excel V Lookup with Approximate Match