The Power Query exploit in Excel is a concern but one that most Excel users are already protected from. Look past some of the shock headlines (e.g “120 million users personal information at stake due to Microsoft Excel flaw”) . Mimecast did a good job tracing this security bug in Power Query which has existed […]
Outlook for Mac (2016, 2019 and 365) has a Weather Bar similar to Outlook for Windows with differences both good and bad. Turning the Weather Bar on or off plus the Fahrenheit / Celsius choice is at Outlook | Preferences | Calendar | Weather. Like the Windows version, it’s not clear how to turn the […]
Drop-down list boxes are useful in Excel but, like many things in Office, there’s more than one way to do it and more to know that the simple examples often given. Making a pull-down list is easy and there’re many tips showing the basics. In this article we’ll go beyond that. We’ll show that simple […]
The Archive button in Outlook 2016/2019 and Outlook 365 is a very different thing than previous versions. Archive is just another folder among many in the same Outlook mailbox and data store. It’s a default folder (which can’t be changed) for Office 365 hosted, Outlook.com, and Exchange accounts. For other accounts (POP3, IMAP) you can […]
Here’s some other problems with the Word Sort feature and tricks to work around them. Generally speaking, long or complex sorting is better done in Excel. Excel has much better data management features to split and sort. The final result can be copied into Word. Sort a list of names by surname or more in […]
