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 →Atul Vij
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 →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 →Basics and Abbreviations of VBA / Macros Chapter – 1
Basics and Abbreviations of VBA / Macros Chapter – 1
VBA full form is Visual Basic for Applications. It is the programming language of Excel and other Office programs. Points to be learned for…
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 →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 →VBA Plus / Macros Chapter – 1 (Swap Values – 1)
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
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 →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 →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 →