Excel Intermediate Lesson 8: LET for Readable, Faster Formulas
Name the parts of a long formula with LET so it is readable and calculates once. Worked examples: GST, share of total, top rep and paid ratio.
Read article →Name the parts of a long formula with LET so it is readable and calculates once. Worked examples: GST, share of total, top rep and paid ratio.
Read article →Number, currency, percentage and date formats, custom formats like 000 and lakhs, alignment and wrap text, borders, Format Painter, cell styles — and why formatting never changes the value underneath.
Read article →Replace long nested IFs with IFS and SWITCH, combine conditions with AND/OR, and count with AND/OR logic in COUNTIFS. Grades, commissions and follow-up flags.
Read article →Due dates, delivery dates with holidays, working days in a month, Indian financial-year quarters and FY labels, all with formulas you can copy.
Read article →Clean messy ERP and bank exports: split pipe-separated text, fix case and spaces, pull invoice numbers and names with TEXTBEFORE, TEXTAFTER, TEXTSPLIT, TRIM and SUBSTITUTE.
Read article →One formula, many results: FILTER, SORT, SORTBY, UNIQUE and SEQUENCE spill whole lists that update themselves. With real examples from a sales register.
Read article →Two-way lookups, lookups to the left, last-match searches and not-found defaults with INDEX/MATCH and XLOOKUP, with a regional targets grid.
Read article →Build region, month and status reports from a raw sales register with SUMIFS, COUNTIFS and AVERAGEIFS, including date ranges, wildcards and not-equal criteria.
Read article →Cumulative totals, running counts, running totals by category and month-to-date sums — with expanding ranges, SUMIFS, Excel Table formulas and the new SCAN function — plus the slow-down mistakes to avoid on big sheets.
Read article →Stop writing Sales!K2:K81 everywhere. Name your ranges or turn data into an Excel Table so formulas read like =SUM(Amount) and grow with new rows.
Read article →The TEXT function turns numbers and dates into exactly the text you want: dd-mmm-yyyy, day names, leading zeros, lakh/crore commas, percentages and times. 20 format codes with examples and the traps.
Read article →Final project: targets without a relationship via TREATAS, % of target with status, months above average, FYTD trend and an RLS-ready one-page report.
Read article →