SEQUENCE Function in Excel: Generate a List of Numbers or Dates
SEQUENCE creates a spilled list of numbers — serial numbers, calendars, repeating patterns.
Read article →Author Archives: Atul Vij
Protect Excel Sheets and Workbooks the Right Way
Protect Excel Sheets and Workbooks the Right Way
Lock formulas while letting people type in input cells, protect the workbook structure, and understand what Excel protection does — and does not —…
Read article →SORTBY Function in Excel: Sort by Another Column
SORTBY Function in Excel: Sort by Another Column
SORTBY sorts one range by the values in another — even by a column you do not display.
Read article →XMATCH Function in Excel: MATCH With Better Defaults
XMATCH Function in Excel: MATCH With Better Defaults
XMATCH returns the position of an item, defaulting to exact match, and can search from the end or use wildcards.
Read article →Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time error 1004 is Excel VBA’s catch-all error. Here are the 7 causes I see most often — with the exact fix for each.
Read article →SORT Function in Excel: Sort Data With a Formula
SORT Function in Excel: Sort Data With a Formula
SORT returns a sorted copy of a range; the original stays untouched and the result re-sorts as data changes.
Read article →XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?
XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?
A practical comparison of VLOOKUP, XLOOKUP and INDEX-MATCH in Excel — when each one works, when it breaks, and which to use in 2025.
Read article →JavaScript for Excel Users: Arrays, map, filter and reduce Explained
JavaScript for Excel Users: Arrays, map, filter and reduce Explained
Learn JavaScript’s most useful array tools — map, filter, reduce, sort — by comparing each one with an Excel formula you already know. Run…
Read article →SQL for Excel Users: 10 Queries That Replace Everyday Excel Work
SQL for Excel Users: 10 Queries That Replace Everyday Excel Work
Learn SQL through tasks you already do in Excel — filters, sorting, pivot tables, VLOOKUP and remove duplicates — with 10 queries you can…
Read article →Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)
Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)
VLOOKUP returns only the first match. Combine TEXTJOIN, UNIQUE and FILTER to list every matching value in one cell — plus a version for…
Read article →FILTER Function in Excel: Return Every Row That Matches
FILTER Function in Excel: Return Every Row That Matches
FILTER returns all rows (or columns) that meet a condition, and the result updates live as data changes.
Read article →Python for Excel Users: Read, Clean and Summarise a Spreadsheet with pandas
Python for Excel Users: Read, Clean and Summarise a Spreadsheet with pandas
A gentle first step from Excel to Python: load a spreadsheet with pandas, clean it, build a pivot table and save the result —…
Read article →