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 →Markets today
- 1 USD₹93.92
- 1 EUR₹104.86
- 1 GBP₹125.71
- 1 JPY₹0.593
- 1 CNY₹14.08
- 1 CHF₹114.69
Since 2016 · Atul Vij →
Automate your Excel reports
Free tutorials, tested files and tools that run in your browser.
Explore topics
Pick a pocket of knowledge🤯 Wacky fact
Cows recognise each other’s individual moos.
Research on cattle vocalisations shows individual cows have distinct voices that herd mates recognise. Calves and mothers can identify each other by call.
Free course
Excel VBA in 15 lessons
From your first variable to UserForms, with a practice workbook that has every macro on a button.
15 of 15 lessons published
Start lesson 1 →Latest articles
Why Are Pencils Yellow?
Why Are Pencils Yellow?
Most pencils in America and many elsewhere are painted yellow. The popular story involves Chinese graphite, royalty and a famous Austrian pencil from 1890.…
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 and columns away from a certain range (border…
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) a specific number of rows and columns larger or…
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 current region is a range bounded by any combination of blank rows and…
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 →Migrating Excel VBA Macros to Python: A Step-by-Step Translation Guide
Migrating Excel VBA Macros to Python: A Step-by-Step Translation Guide
Step-by-step roadmap to convert slow Excel VBA macros (.xlsm) into fast, automated Python scripts using pandas, openpyxl, and xlwings.
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 →The Great Hedge of India: A Thorny Wall Built for a Salt Tax
The Great Hedge of India: A Thorny Wall Built for a Salt Tax
In the 19th century the British ran a customs line across India — much of it a dense thorn hedge — to stop untaxed…
Read article →