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…
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…
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…
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…
During his recent visit to the UK, I sat down with the leader of the free world, President Donald J. Trump, in a pub. The purpose of this diplomatic meeting was to discuss all things spreadsheets and how we can…
Loading large queries, running macros, or using add-ins can cause Excel to freeze up and leave you staring at that dreaded spinning blue ring. The good news is you don’t have to wait around. You can open a fresh instance…
