Excel Formulas

Step-by-step Excel tutorials that solve one problem at a time — VLOOKUP with duplicate values and VLOOKUP with MATCH, SUMIFS across a date range, conditional formatting for negative and positive numbers, tick and cross marks with IF, automatic serial numbers, and comparing two columns to find differences.

There are practical office tasks here too: bank reconciliation against a Tally ledger, extracting RTGS, NEFT and UPI numbers from a bank statement, aging reports for receivables and payables, Gantt charts, interactive dashboards, Excel to Word mail merge, and converting amounts into words. Most posts come with a video walkthrough and the practice file used in it, so you can follow along on the same data.