Just an outrageous idea I’m mooting… Ever since Excel burst onto the scene, it’s been based on a worksheet grid. Each cell in that grid accepts either a formula or constant value. The formula bar is primarily used to input…
Who knew Excel spreadsheets could produce such exhilaration and palpable tension among competitors and crowds alike? Well, there certainly was at the Microsoft Excel World Championship 2023, which took place in Las Vegas days ago in front of a captivated…
Want to crash Excel? Of course you do, and there’s a concoction of things you can do to cause one (and frustration). Reference the same range in GROUPBY’s row_fields and values arguments, along with using PERCENTOF in function and 0…
Yippee! 🥳 Excel finally has a date picker 📅 — imitating another Google Sheets feature — except going above and beyond to ensure it’s a cut above. At the moment, it’s only available to Excel for web users but will…
The announcement of eta lambda support has further simplified the summing of columns. When the BYCOL function was released, I was impressed that we finally had a solution that didn’t involve referencing every column individually. It’s gone to the next…
Web scraping in Excel has just got better. If you’ve ever used the Get Data From Web tool, you’ll know how limited it was. After pasting a URL and clicking OK, you’d be presented with the Navigator window containing a…
End of content
End of content
