Why Does Excel Have Exactly 1,048,576 Rows? The Logic Behind Software Limits
Why Excel stops at 1,048,576 rows and column XFD, why old Excel had 65,536 rows, why numbers lose digits after 15, why FAT32 files…
Read article →Busy Accounting Software: GST Billing and Reports for Small Businesses
Busy Accounting Software: GST Billing and Reports for Small Businesses
How to set up Busy for GST billing: company creation, masters, sale vouchers with CGST/SGST/IGST, and the reports small businesses use every month.
Read article →MINIFS Function in Excel: Smallest Value Meeting Conditions
MINIFS Function in Excel: Smallest Value Meeting Conditions
MINIFS returns the minimum of values where all conditions are true.
Read article →MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS returns the maximum of values where all conditions are met; MINIFS returns the minimum.
Read article →TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TEXTJOIN joins a range of text with a delimiter and can ignore empty cells.
Read article →Python: Sort a Messy Downloads Folder by Year and Month
Python: Sort a Messy Downloads Folder by Year and Month
A 25-line Python script that moves files into Year/Month folders based on their modified date, with a dry-run mode so you can check before…
Read article →JSON Explained Simply (for Excel People)
JSON Explained Simply (for Excel People)
What JSON is, how to read it, how it maps to rows and columns, and how to load JSON into Excel with Power Query…
Read article →PowerPoint Slide Master: Fix Every Slide in One Place
PowerPoint Slide Master: Fix Every Slide in One Place
Stop formatting slides one by one. Use PowerPoint’s Slide Master to control fonts, colours, logos and layouts for the whole deck — and rescue…
Read article →CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT joins text from several cells or whole ranges. It replaces the older CONCATENATE. The & operator does the same for a few cells.
Read article →Loan Amortisation Schedule in Excel: EMI, Interest, Principal and Prepayments
Loan Amortisation Schedule in Excel: EMI, Interest, Principal and Prepayments
Build a complete loan schedule in Excel: EMI with PMT, month-by-month interest and principal with IPMT/PPMT or simple formulas, prepayments, and total interest —…
Read article →Power BI Desktop: Build Your First Report From an Excel File
Power BI Desktop: Build Your First Report From an Excel File
A beginner walkthrough of Power BI Desktop: import an Excel sheet, clean it in Power Query, add measures, build four visuals with slicers, and…
Read article →Depreciation in Excel: SLM, WDV and Income-Tax Block Method
Depreciation in Excel: SLM, WDV and Income-Tax Block Method
Calculate depreciation in Excel with SLN, DB and custom formulas: straight-line (Companies Act), written-down value, the 180-day half-rate rule, and a complete fixed-asset schedule.
Read article →