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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
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 →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 →PHONETIC Function in Excel: Furigana Reading of Japanese Text
PHONETIC Function in Excel: Furigana Reading of Japanese Text
PHONETIC returns the phonetic (furigana) characters stored with Japanese text typed on a Japanese input method. Text without stored furigana (anything typed in English,…
Read article →SQRTPI Function in Excel: Square Root of x Times Pi
SQRTPI Function in Excel: Square Root of x Times Pi
Maths & trigLevel: ExpertAvailable in: Excel 2007+SQRTPI returns SQRT(x*PI()), which turns up in statistics and physics.
Read article →ASC Function in Excel: Full-Width to Half-Width Characters
ASC Function in Excel: Full-Width to Half-Width Characters
ASC converts full-width (double-byte) letters and katakana to half-width. In English text there is nothing to convert, so text comes back unchanged.
Read article →Excel Lesson 16: Conditional Formatting
Excel Lesson 16: Conditional Formatting
Make important cells stand out automatically: highlight rules, top/bottom, data bars, colour scales and icon sets, formula rules that colour whole rows, managing rule…
Read article →Partial Match and Wildcard Lookups in Excel (Contains, Starts With, Ends With)
Partial Match and Wildcard Lookups in Excel (Contains, Starts With, Ends With)
Find "Raj Traders Pvt Ltd" when you only typed "Raj", look up codes that start with a prefix, and sum or count rows that…
Read article →Excel for Finance Lesson 2: TDS Register and Quarterly Summary
Excel for Finance Lesson 2: TDS Register and Quarterly Summary
Maintain a TDS register in Excel: section-wise rates, the higher rate without PAN, TDS per payment, monthly deposit totals and due dates, and a…
Read article →Highlight an Entire Row in Excel With a Formula (Conditional Formatting)
Highlight an Entire Row in Excel With a Formula (Conditional Formatting)
Colour the whole row when status is Overdue, an amount crosses a limit or a date has passed: conditional formatting formulas with the $…
Read article →Build a TDS Calculator in Excel (Section, Rate, Threshold and PAN Check)
Build a TDS Calculator in Excel (Section, Rate, Threshold and PAN Check)
Build a table-driven TDS calculator in Excel: a section master with rates and thresholds, XLOOKUP by section and payee type, single and yearly threshold…
Read article →