Excel-related articles.
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,…
Here’s a chart Excel needs: a cartogram. It’s a type of map that represents geographic regions with shapes sized according to a specific data variable rather than their land area, which can affect the interpretation of a result. If you’ve…
In Excel for Mac, when you select a range of values and then press Backspace, they are all cleared. The same behaviour occurs in Excel for Web. However, in Excel for Windows, it’s a different story. Pressing Backspace only clears…
Structured references are often preferred to cell references because they add a dose of readability and memorability. Let’s be honest, you’d rather see tblEmployees[Name] than A2:A11, wouldn’t you? A few months ago, I talked about how it would be good…
Last Thursday (30/05/2024), Jeremy Vine was joined by two guests on his BBC Radio 2 afternoon show. They were Giles Male, co-founder of Full Stack Modeller, and Harry Matthews, Group Financial Controller at the Landauer Group. Both discussed their love…
Get Data and Get data are two prominent UI buttons found on Excel’s Data tab and Power BI’s Home tab, respectively. Both have the same icon, and both serve the same purpose — to import data. One has a big…
End of content
End of content
