Trim ranges with the dot in Excel
How do you reference a range in a formula? For decades, the answer has been simple: select multiple cells to create a reference with the starting cell on the left, a colon in the middle, and the ending cell on…
4 ways to calculate percentages in Excel
Percentages show up everywhere — in finance, business, and day-to-day life. In Excel, there are four straightforward ways to work with percentages. Each example below assumes the Percentage number format is applied, so you don’t have to multiply by 100….
Create an Excel + Python word cloud
Word clouds are a clever way to visualise text data, but they’ve always been tricky to build in Excel without relying on add-ins or VBA. However, since Python integration landed, it’s become a lot easier. In the example, a collection…
Convert units the easy way in Excel
Converting data from one measurement system to another is a common need, whether it’s for clarity, comparison, or simply to match standards. It could be length, weight, speed, volume, or temperature — to name five. The CONVERT function does what…
Insert the current date and time in Excel
If you want the current date or time in a cell, don’t type it manually. You’ll waste precious seconds (and risk mistakes). Instead, use these keyboard shortcuts: 📆 Insert current date Ctrl + ; ⏰ Insert current time Ctrl + Shift…
Remove Excel worksheet and workbook protection
If you think Excel’s worksheet and workbook protection will truly keep your files secure — think again. Both are surprisingly easy to bypass. That’s bad news if you’re relying on them for security, but good news if you’ve ever forgotten…
