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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
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 →Getting Started with Python in Excel: The Complete Guide to =PY() and Pandas
Getting Started with Python in Excel: The Complete Guide to =PY() and Pandas
Learn how to use Python natively in Excel with =PY(). Import pandas, analyze DataFrames, generate Seaborn charts, and run machine learning in spreadsheet cells.
Read article →Basics of VBA / Macros Chapter – 7 (Range Part-1)
Basics of VBA / Macros Chapter – 7 (Range Part-1)
Range Object The Range object which i
Read article →Basics of VBA / Macros Chapter – 15 (If Else/Then Statement Part-1)
Basics of VBA / Macros Chapter – 15 (If Else/Then Statement Part-1)
A practical VBA lesson to use If, ElseIf and Else to turn business rules into readable decisions, with complete code, test data, mistakes, checks…
Read article →Basics of VBA / Macros Chapter – 6 (Declaring Variables Part-4)
Basics of VBA / Macros Chapter – 6 (Declaring Variables Part-4)
Static Variables Sometimes you want to retain the value of a variable in VBA when a procedure ends. You can achieve this by
Read article →Basics of VBA / Macros Chapter – 14 (Formatting Part-2)
Basics of VBA / Macros Chapter – 14 (Formatting Part-2)
A practical VBA lesson to apply fills, borders and status colours from values while keeping the workbook maintainable, with complete code, test data, mistakes,…
Read article →Basics of VBA / Macros Chapter – 5 (Declaring Variables Part-3)
Basics of VBA / Macros Chapter – 5 (Declaring Variables Part-3)
Variable Scope The scope of a variable in Excel VBA determines where that variable may be used. You determine
Read article →Basics of VBA / Macros Chapter – 13 (Formatting Part-1)
Basics of VBA / Macros Chapter – 13 (Formatting Part-1)
A practical VBA lesson to build a readable report header and apply consistent number formats without selecting cells, with complete code, test data, mistakes,…
Read article →Basics of VBA / Macros Chapter – 4 (Declaring Variables Part-2)
Basics of VBA / Macros Chapter – 4 (Declaring Variables Part-2)
Option Explicit I personally strongly recommend to use Option Explicit at the start of your
Read article →Basics of VBA / Macros Chapter – 3 (Declaring Variables Part-1)
Basics of VBA / Macros Chapter – 3 (Declaring Variables Part-1)
Here we learn how to declare, initialize and display a variable in Excel VBA. To tell that we are using a variable is called…
Read article →