Bank Statement Lesson 7: Combine Monthly Statements With Power Query
Drop each month's CSV into a folder and refresh: Power Query combines, cleans and appends them automatically, with India date locale and amount cleaning.
Read article →Atul Vij
Build Your Own LLM, Lesson 1: How a Language Model Actually Works
Build Your Own LLM, Lesson 1: How a Language Model Actually Works
A plain-English tour of what happens inside ChatGPT-style models: tokens, probabilities, training on next-token prediction, and why a model that only guesses the next…
Read article →Bank Statement Lesson 6: Bank Reconciliation in Excel
Bank Statement Lesson 6: Bank Reconciliation in Excel
Match your books with the bank statement using COUNTIFS on amount and date, allow for posting delays, and list unmatched entries for the reconciliation…
Read article →Bank Statement Lesson 5: Monthly Summary and Cash Flow
Bank Statement Lesson 5: Monthly Summary and Cash Flow
Monthly income and spending, savings rate, lowest balance, average UPI spend and the biggest debits: a cash-flow summary from your statement with SUMIFS.
Read article →Bank Statement Lesson 4: Read UPI Narrations (Payee, UPI ID, Reference)
Bank Statement Lesson 4: Read UPI Narrations (Payee, UPI ID, Reference)
Split UPI narrations like UPI/DR/412345678901/SWIGGY/YESB/swiggy@ybl/Payment into reference number, payee name, bank and UPI ID with TEXTSPLIT and TEXTAFTER.
Read article →Bank Statement Lesson 3: Categorise Every Transaction With a Keyword Table
Bank Statement Lesson 3: Categorise Every Transaction With a Keyword Table
Auto-categorise bank transactions (Food, Groceries, Bills, Travel, EMI, Salary) with a small Rules table and one SEARCH-based formula you can extend any time.
Read article →Bank Statement Lesson 2: Clean Text Dates and Amounts
Bank Statement Lesson 2: Clean Text Dates and Amounts
Turn text dates like 04/05/2026 and amounts like "1,23,456.00" into real dates and numbers, and build one signed Amount column from Withdrawal and Deposit.
Read article →Bank Statement Lesson 1: Get Your Statement Into Excel
Bank Statement Lesson 1: Get Your Statement Into Excel
Which format to download (XLS, CSV or PDF), how to open it in Excel without breaking dates and amounts, and the first checks: count,…
Read article →The First “Computer Bug” Was a Real Moth (Mostly)
The First “Computer Bug” Was a Real Moth (Mostly)
In 1947, engineers working on the Harvard Mark II found a moth stuck in a relay and taped it into the logbook as the…
Read article →Why Is a Week Seven Days Long?
Why Is a Week Seven Days Long?
Months follow the Moon and years follow the Sun, but the seven-day week follows the seven "planets" ancient people could see. Why Ravivar to…
Read article →JIS Function in Excel: Half-Width to Full-Width Characters
JIS Function in Excel: Half-Width to Full-Width Characters
JIS converts half-width characters to full-width (double-byte), mainly for Japanese documents. It is available only when Japanese is enabled as an editing language (File…
Read article →VS Code for Office Users: 10 Features That Beat Notepad
VS Code for Office Users: 10 Features That Beat Notepad
Visual Studio Code is a free editor that is brilliant for cleaning text and data: multi-cursor editing, column selection, regex find and replace, sorting,…
Read article →