Spent about half an hour playing about with Sheets’ new table feature. Predictably, it is comprehensively inferior to Excel’s, and the things we take for granted are not as intuitive. You can sort, filter, use structured references, and customise the…
Excel has options allowing you to restrict cell entry so data is kept accurate and consistent. The Data Validation button is found on the Data tab. Selecting it brings up a window letting you limit the active cell or range…
In recent years, it’s become customary for multi-billion dollar corporations and conglomerates to rainbow-wash their social media accounts in support of June’s Pride Month. This trend initially started as a laudable show of solidarity towards marginalised groups, but many people…
As a rule of thumb, referencing a whole column in Excel isn’t considered good practice. It’s better to include only the cells you need in a range. And it’s even better to use tables so you’re working with structured references….
