Why Is Mars Red?
Mars is red because its surface dust is rich in iron oxide — rust. How the rust formed, why the sky on Mars is…
Read article →Markets today
- 1 USD₹95.27
- 1 EUR₹106.04
- 1 GBP₹126.87
- 1 JPY₹0.603
- 1 CNY₹14.30
- 1 CHF₹114.98
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
There is a planet where it may rain glass sideways.
On the exoplanet HD 189733 b, astronomers think silicate particles form clouds, and winds of several thousand kilometres per hour could blow molten glass droplets sideways. Its deep blue colour comes from those clouds.
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
Basics of VBA / Macros Chapter – 2 (Creating Macro)
Basics of VBA / Macros Chapter – 2 (Creating Macro)
With VBA you can automate tasks in Excel by writing so called macros. We will learn how to create a simple macro which will be…
Read article →Back Up Your Windows PC: OneDrive Folder Backup and an External Drive
Back Up Your Windows PC: OneDrive Folder Backup and an External Drive
Two simple layers of backup for a Windows PC: OneDrive folder backup for Desktop, Documents and Pictures, plus File History to an external drive…
Read article →Using AI to Write Excel Formulas: A Safe 5-Step Checklist
Using AI to Write Excel Formulas: A Safe 5-Step Checklist
AI assistants are great at Excel formulas — when you give them the right details and test the result. A five-step checklist with an…
Read article →SAP Logon: GUI & Navigation
SAP Logon: GUI & Navigation
SAP Logon SAP Logon is used initiate a user session in a desired SAP Server. The same SAP Logon pad can be used to…
Read article →Office Scripts: Highlight Duplicates in a Table With One Button
Office Scripts: Highlight Duplicates in a Table With One Button
A short Office Script for Excel on the web that highlights duplicate values in a chosen column, clears old highlights and runs from a…
Read article →PowerShell for Office Work: 10 Small Scripts That Save Real Time
PowerShell for Office Work: 10 Small Scripts That Save Real Time
Practical PowerShell for non-programmers: rename hundreds of files, find duplicates, combine CSVs, clean old downloads, check disk space and more — each script explained…
Read article →Why Do We Have Time Zones? Railways Invented Them
Why Do We Have Time Zones? Railways Invented Them
Until the 1800s every town kept its own time by the Sun. Railways and telegraphs made that chaotic, leading to standard time and, in…
Read article →Split Text by Comma, Dash or Any Delimiter in Excel (TEXTSPLIT, TEXTBEFORE, TEXTAFTER)
Split Text by Comma, Dash or Any Delimiter in Excel (TEXTSPLIT, TEXTBEFORE, TEXTAFTER)
Break “Mumbai-MH-400001” or comma lists into columns and rows with TEXTSPLIT, TEXTBEFORE and TEXTAFTER in Excel 365, and the TRIM/MID/SUBSTITUTE trick for older versions.
Read article →Stop Spam Calls and SMS in India: DND, Spam Filters and Chakshu
Stop Spam Calls and SMS in India: DND, Spam Filters and Chakshu
Cut down telemarketing and scam calls: register on TRAI's DND via 1909, turn on your phone's spam protection, block senders, and report fraud through…
Read article →Context Windows Explained: How Much Can an AI Read at Once?
Context Windows Explained: How Much Can an AI Read at Once?
What an AI model's context window is, why long chats get worse, what happens when you hit the limit, and practical ways to work…
Read article →Run Long SAP Reports in the Background (SM36 and SM37 for Business Users)
Run Long SAP Reports in the Background (SM36 and SM37 for Business Users)
Stop SAP reports timing out: run them in the background with a variant, schedule them daily or monthly, check status and spool output in…
Read article →