Some good advice for better spreadsheets from the distinguished science journal, Nature, (established 1869!) who have tips about the right way and wrong way to use Excel or Google Sheets. The article Six tips for better spreadsheets opens with a horror story about a list of latitude/longitude “It was a complete mix, The spreadsheet was […]
We’ve completed our series on ‘Hidden’ options in Word, Excel and PowerPoint. How to hide text, images, cells, slides etc within documents. Hiding is a useful option and avoids deleting content that might be needed later. It lets you make a different version of a document/sheet/deck without the hassle of maintaining two very similar documents. […]
Deep in Microsoft Word is the choice “Automatically Update Document Styles“. What does that do and which documents are affected? There are several similarly worded options to do with ‘Style’ and ‘Automatic’ so let’s be clear … we’re talking about File | Options | Add-ins | Manage | Templates | Go | Templates and Add-ins […]
Excel shows midday or noon as 12:00 PM which doesn’t suit everyone, here’s how to change the defaults to a word such as ‘Midnight’ or any other time label you’d like. ABC News in Australia delves into the argument about showing 12 PM – There is no such time as 12pm. The argument is that […]
In many situations, there’s common text or even whole messages that you want to reuse in emails. Here’s an option to save and add that text with a single click. It’s a lot faster, more consistent and already in Microsoft Outlook. Outlook has a feature that’s good for recycling text for emails. Strictly speaking, Word […]
