Back in December 2021, How Fast is Fast Data Load in Power Query? demonstrated how long it took to load varying-sized datasets into the Data Model with and without Power Query’s Fast Data Load enabled. What’s changed since then? Well,…
Excel has limits — plenty of them. Whether it’s the number of worksheet rows, characters in a cell, or the percentage you can zoom in. We’ve all bumped into a limit of some type at some point. There’s a useful…
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…
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…
End of content
End of content
