Free tutorials, tested files and tools that run in your browser.
🤯 Wacky fact
DeepMind’s AlphaFold 2 made a leap in predicting how proteins fold, and its database grew to over 200 million predicted structures. Its creators shared the 2024 Nobel Prize in Chemistry.
Free course
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 →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 →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 →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 SAP Logon is used initiate a user session in a desired SAP Server. The same SAP Logon pad can be used to…
Read article →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 →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 →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 →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 →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 →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 →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 →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 →