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 →Atul Vij
JavaScript for Excel Users: Arrays, map, filter and reduce Explained
JavaScript for Excel Users: Arrays, map, filter and reduce Explained
Learn JavaScript’s most useful array tools — map, filter, reduce, sort — by comparing each one with an Excel formula you already know. Run…
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 →Excel Lesson 8: Excel Tables (Ctrl+T) for Every List
Excel Lesson 8: Excel Tables (Ctrl+T) for Every List
Turn any list into an Excel Table with Ctrl+T: banded rows, filters, automatic expansion, calculated columns, the Total Row, slicers, and formulas that use…
Read article →Excel for Finance Lesson 1: GST Sales Register and Monthly Summary
Excel for Finance Lesson 1: GST Sales Register and Monthly Summary
Build a GST sales register in Excel: CGST/SGST vs IGST by state code, rate-wise and head-wise monthly totals with SUMIFS and SUMPRODUCT, B2B vs…
Read article →Excel Lesson 17: Pivot Table Basics
Excel Lesson 17: Pivot Table Basics
Summarise thousands of rows in seconds: create a pivot table, drag fields into Rows, Columns, Values and Filters, change Sum to Count or Average,…
Read article →Office Scripts: Automate Excel on the Web Without VBA
Office Scripts: Automate Excel on the Web Without VBA
Office Scripts bring automation to Excel for the web and Microsoft 365. Record a script, read the TypeScript it creates, and write a report-formatting…
Read article →GST Calculation in Excel: Add GST, Remove GST, Split CGST/SGST/IGST
GST Calculation in Excel: Add GST, Remove GST, Split CGST/SGST/IGST
Formulas to go from GST-exclusive to inclusive, back-calculate the base from an inclusive price, split CGST/SGST vs IGST by state, look up rates by…
Read article →Excel Tables (Ctrl+T): 10 Reasons to Use Them for Every List
Excel Tables (Ctrl+T): 10 Reasons to Use Them for Every List
Excel Tables make lists self-expanding: formulas fill down, ranges grow, pivots and charts update, structured references read like English, slicers filter, and Power Query…
Read article →SUMIFS, COUNTIFS and AVERAGEIFS: The Complete Guide With 12 Examples
SUMIFS, COUNTIFS and AVERAGEIFS: The Complete Guide With 12 Examples
Master the conditional-sum family: multiple criteria, dates, wildcards, not-equal, blanks, OR logic and cell-referenced criteria, with 12 real examples and the mistakes to avoid.
Read article →Why Is Indian Standard Time 5 Hours 30 Minutes Ahead?
Why Is Indian Standard Time 5 Hours 30 Minutes Ahead?
IST is set by the 82.5° East meridian near Mirzapur — exactly 5½ hours from Greenwich. How India chose a half-hour time zone and…
Read article →Excel Pivot Tables: The Complete Guide from First Click to Dashboard
Excel Pivot Tables: The Complete Guide from First Click to Dashboard
Build pivot tables step by step: layout, value settings, Show Values As, grouping dates, slicers and timelines, calculated fields, distinct counts, GETPIVOTDATA, refresh tricks…
Read article →