Basics of VBA / Macros Chapter – 19 (Mod Operator Part-1)
A practical VBA lesson to use Mod for repeating patterns, grouping and periodic actions, with complete code, test data, mistakes, checks and a downloadable…
Read article →Basics of VBA / Macros Chapter – 18 (Select Case Part-2)
Basics of VBA / Macros Chapter – 18 (Select Case Part-2)
A practical VBA lesson to use ordered Case Is ranges for banded calculations without presenting illustrative rates as current tax advice, with complete code,…
Read article →Basics of VBA / Macros Chapter – 17 (Select Case Part-1)
Basics of VBA / Macros Chapter – 17 (Select Case Part-1)
A practical VBA lesson to replace a long chain of repeated comparisons with a clear Select Case structure, with complete code, test data, mistakes,…
Read article →Basics of VBA / Macros Chapter – 16 (Logical Operators Part-1)
Basics of VBA / Macros Chapter – 16 (Logical Operators Part-1)
A practical VBA lesson to combine multiple tests with And, Or and Not without creating hidden logic errors, with complete code, test data, mistakes,…
Read article →Excel Waterfall Chart: Build a Profit Bridge in 2 Minutes
Excel Waterfall Chart: Build a Profit Bridge in 2 Minutes
Show how you got from last year's profit to this year's with an Excel waterfall chart: data layout, setting totals, colours for increases and…
Read article →Why Are Pencils Yellow?
Why Are Pencils Yellow?
Most pencils are yellow because a premium brand painted its pencil that way in the late 1880s and rivals copied it. What is documented,…
Read article →Translate Any Web Page, PDF or Photo Into Hindi or English
Translate Any Web Page, PDF or Photo Into Hindi or English
Built-in ways to translate a whole web page in Chrome and Edge, a PDF or Word document with Google Translate, and text in a…
Read article →Basics of VBA / Macros Chapter – 10 (Range Part-4)
Basics of VBA / Macros Chapter – 10 (Range Part-4)
Offset The Offset property in VBA takes the range which is a particular number of rows
Read article →Basics of VBA / Macros Chapter – 9 (Range Part-3)
Basics of VBA / Macros Chapter – 9 (Range Part-3)
Resize The Resize property in Excel VBA makes a range (border below for illustration only
Read article →Basics of VBA / Macros Chapter – 8 (Range Part-2)
Basics of VBA / Macros Chapter – 8 (Range Part-2)
CurrentRegion This example illustrates the CurrentRegion property in Excel VBA. The cur
Read article →Income Tax Calculator FY 2026-27 in Excel: New vs Old Regime with Slabs and Rebate Formulas
Income Tax Calculator FY 2026-27 in Excel: New vs Old Regime with Slabs and Rebate Formulas
Download and build an Indian Income Tax calculator in Excel for FY 2026-27 (AY 2027-28). Compare New vs Old Tax Regime, Section 87A rebate,…
Read article →Mastering LAMBDA and LET in Excel: Build Custom Reusable Functions Without VBA
Mastering LAMBDA and LET in Excel: Build Custom Reusable Functions Without VBA
Learn how to use LET and LAMBDA in Excel 365. Eliminate redundant calculations, speed up workbooks, and package complex formulas into custom named functions.
Read article →