OFF TO OFFICE

Cleaning raw data in Excel

How to password protect your Excel Spreadsheet

Separate Text and Numbers from each other joined together

LAMBDA Function in Excel | Create Your own functions now

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

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

LET Function in EXCEL : New Function

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

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

How to extract last and first word in excel

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

Dependent Cascading Dropdown list | Everything about INDIRECT function

SWITCH Function in EXCEL

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

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

Subtotal & Groups in Excel | Nested Subtotal

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

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

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

How to sort Data with formula

Filter function | Excel 365

How to FREEZE PAN in Excel

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

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

SEQUENCE FUNCTION | MS365

Make EXCEL Cell Speak

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

RANDBETWEEN Function | SIMULATION through Monte Carlo Technique

How to insert SLICER in Excel

Smart ways to customize number formatting of a cell

Extract unique items for dynamic data validation drop down list