Excel, SAP, Oracle & automation tips — plus wacky facts
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Book depreciation under the Companies Act (SLM and WDV from useful life), time-proportionate depreciation, and income-tax block rates with the half rate for assets…
Read article →Compare two projects with NPV and IRR, find the payback year, and measure a real SIP return with XIRR using actual dates.
Read article →EMI, interest and principal split, year-1 interest for tax, outstanding balance and how many EMIs a ₹2 lakh prepayment saves, with PMT, IPMT, PPMT,…
Read article →TextLevel: ExpertAvailable in: Excel 2007+DBCS is the older name of JIS, converting to full-width characters.Syntax=DBCS(text)ArgumentWhat it.
Read article →REGEXTEST returns TRUE if text matches a regular expression — validate PAN numbers, emails or codes in one formula.
Read article →DETECTLANGUAGE returns the language code of a text — useful for sorting customer feedback before translating it.
Read article →TRANSLATE uses Microsoft’s translation service to translate text between languages, right in the sheet.
Read article →Put it together: KPI cards, a trend chart, region and product breakdowns, a selector, consistent layout and colours, and print-ready setup for a one-page…
Read article →Put tiny charts inside cells: line, column and win/loss sparklines, high/low markers, data bars and REPT bars — perfect for tables and dashboards.
Read article →Show actual against target in one chart: column + line combo, secondary axis for percentages, target as a marker line, and highlighting months below…
Read article →Build clean column, bar and line charts in Excel: select data, insert, sort, gap width, data labels, axis formatting, removing clutter and saving a…
Read article →Match the chart to the question: comparison, trend, composition, relationship and distribution, with the charts that work and the ones that mislead.
Read article →
