11:52

LAMBDA Function in Excel | Create Your own functions now

03:41

Geography Data Type in Excel

09:22

Join text in EXCEL with and without TEXTJOIN Function | All versions

08:33

What is Mail Merge in MS Word? | Amazing feature to save time

04:30

How to password protect your Excel Spreadsheet

09:43

UNIQUE Function for removing multiple occurrence of records

05:32

Filter function | Excel 365

10:56

RANDBETWEEN Function | SIMULATION through Monte Carlo Technique

06:12

SEQUENCE FUNCTION | MS365

04:54

LET Function in EXCEL : New Function

03:21

SWITCH Function in EXCEL

19:03

Smart ways to customize number formatting of a cell

09:03

Dependent Cascading Dropdown list | Everything about INDIRECT function

12:28

Repeat cell values multiple times as per given number | 3 methods MS365 and Non-MS365

23:54

Conditional Formatting in Excel | Create beautiful patterns | Formatting with array formula

16:45

Matrix (Array) Maths | MMULT Function | Sort data with single cell formula without SORT Function

05:20

Now copy your searchable dropdown list | Dropdown for multiple cells

10:33

Subtotal & Groups in Excel | Nested Subtotal

18:07

No Nested If now | Range Problem Solved | Lookup | IFS | Median

14:35

12 Useful Date Functions | Learn to find retirement age

14:45

INDEX-MATCH: Things which you don't know about it. |Dynamic Range

11:25

Find last row | Dynamic Expandable Range with INDEX|Power of approximate Match

09:17

Searchable Drop-Down List || Without FILTER Function of MS365

04:07

Fill blank cells from the value above | Excel Mystery solved

02:44

Magics of wildcards in Excel | Don't miss it.

12:12

EXCEL CALENDAR with single cell formula

15:58

How to generate different sequences of number | Convert Vertical data to tabular data & vice versa

16:03

How to extract data from List A which are not in List B

09:38

Filter and Extract with INDEX AGGREGATE

00:57

DD.MM.YYYY to DD/MM/YYYY or any proper date format of Excel

04:39

How to sort Data with formula

19:41

Extract unique items for dynamic data validation drop down list

13:38

Filter data Real time as you type in Excel | Dynamic Filter

08:52

How to save whatapp group contacts to your phone in one go | Export whatsapp contacts to your phone

19:09

Filter and Extract with INDEX SMALL function

09:45

Separate Text and Numbers from each other joined together

07:55

VLOOKUP Encyclopedia : Part- 2 | Multiple Lookup Value | Multiple Match Extract with VLOOKUP

09:17

Vlookup Encyclopedia Part 1| Dynamic Lookup Array | Multiple Lookup Array

03:58

How to build your own search box in Excel

11:19

How to extract last and first word in excel

08:05

Clean text in MS Word copied from Webpage & PDF| Remove citations, pagebreak, hyperlink, white space

09:43

5 different ways of Comparing, Matching & Data Extracting Techniques in Excel

11:07

Text to Column: A complete Guide (Delimiter, Fixed Width, Qualifier, # DD.MM.YYYY to DD/MM/YYYY)

04:57

Cleaning raw data in Excel