VBA Plus / Macros Chapter – 1 (Swap Values – 1)
This example teaches you how to swap two values in Excel VBA. You will often need this structure in more complicated programs as we will see later.…
Read article →Markets today
- 1 USD₹95.18
- 1 EUR₹106.49
- 1 GBP₹127.04
- 1 JPY₹0.605
- 1 CNY₹14.27
- 1 CHF₹115.21
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
SAP HANA keeps whole databases in memory.
Introduced around 2010, SAP HANA stores data primarily in RAM and in columns rather than rows, which makes large analytical queries far faster than traditional disk-based databases. It is the foundation of SAP S/4HANA.
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
Lock Down WhatsApp: 9 Privacy and Security Settings to Change Today
Lock Down WhatsApp: 9 Privacy and Security Settings to Change Today
Nine WhatsApp settings that stop account takeovers, unknown group adds and spam calls: two-step verification, privacy checkup, silence unknown callers, IP protection and more.
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 →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 →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 →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 →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 →Dependent Dropdown Lists in Excel (Two Methods That Actually Work)
Dependent Dropdown Lists in Excel (Two Methods That Actually Work)
Create a second dropdown that changes with the first — Category then Product, Country then City — using INDIRECT with named ranges or a…
Read article →Google Lens on Your Computer: Search With an Image
Google Lens on Your Computer: Search With an Image
Right-click any image in Chrome to search with Google Lens: identify products and plants, copy text from pictures, translate signs and find where a…
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 →How Do Noise-Cancelling Headphones Work?
How Do Noise-Cancelling Headphones Work?
Active noise cancellation listens to outside sound with tiny microphones and plays the exact opposite wave so the two cancel out. Why it works…
Read article →Document a Process Before You Automate It: A One-Page Template
Document a Process Before You Automate It: A One-Page Template
A one-page template to write down any office process — trigger, inputs, steps, rules, exceptions, outputs and checks — so automation projects start from…
Read article →