The US Department of Defense (DoD) is now fully deploying an extra-special secret version of Microsoft 365 to high-ranking areas including the Secretary of Defense. Called ‘DOD365-Secret’ or ‘DOD365-Sec’, this Microsoft 365 plan is one of the DoD’s first moves into cloud computing and 21st Century collaboration. The new system
Google Sheets can now support Python code in a similar but cheaper way than Python in Excel 365 Neptyne has released a Python Add-on for Google Sheets which works in much the same way at the newly released Python extension to Excel 365. The add on includes ‘spilling’ results to
Need a Halloween emoji or symbol? Here’s a quick and searchable list of more than 30 spooky, scary emoji for documents, sheets, slides, emails or messages that you can use or copy. In Microsoft 365, Office 2021 and Office 2019 there are also Halloween icons and symbols for Word, Powerpoint
There are plenty of creepy Halloween themed fonts available for free to work on Windows or Mac with Word, PowerPoint or other Office apps. Here’s seven that caught our eye plus one that you probably already have. All of these work in both Windows and Mac, mostly TrueType fonts. They
Our exclusive Pumpkin Color Charts have the perfect ‘pumpkin’ colors you can use in Halloween documents, slides and graphics with their Microsoft Office compatible color codes including the five Pantone colors called ‘Pumpkin’. There are many Halloween ‘pumpkin’ colors to choose from depending on the variety and ripeness of virtual
Office has various options for graphics or images of skeletons or skulls – perfect for Halloween or other gory, scary uses in Word docs, PowerPoint slides or Outlook emails. We can’t offer a 12-foot skeleton, complete with creepy glowing eyes. For this 3.56 meter monster you have to hunt through
Create your own fun, satirical ‘Halloween costume’ pack in the style of a popular meme using just Microsoft Word or PowerPoint. Use this article as a year-round example of how to overlay one image over another plus adding text to a picture. Take a blank Halloween costume image, add an
Excel 365’s PowerQuery has many wonderful features but occasionally there are common needs that it can’t easily handle. One of those surprising complexities is removing older duplicates but retaining most recent row for each. We’ll explain the simplest solution then why it works. Here’s some sample data on the left
Microsoft is boasting about the coming ‘offline support’ for the new Outlook but a look at the detail shows its very limited offline access. The current Outlook desktop apps for Windows and Mac have excellent offline support, meaning you can work on your mail, calendar, contacts even when there’s slow
One of the most commonly used and confusing Excel functions is much better in Excel 365 and Excel 2021. Vlookup() has a new, better and easier replacement Xlookup(). It’s a truly good and useful addition to Excel, some might call it a godsend. Xlookup is available in Excel 365 for
A British medical office has made a right mess of selecting trainee anesthetists by the misuse of Excel. Let’s look at what happened and some ways you can avoid similar mistakes. As told in The Register, the UK Anesthetic National Recruitment Office (ANRO) had the job of selecting candidates from
OneNote desktop will start getting AI tools, CoPilot, from November 2023. According to a Microsoft Roadmap entry, ‘general availability*’ of CoPilot in OneNote will start next month. Not ‘1st November’ as some are reporting but starting during November. Copilot in OneNote will be able to make lists, create a plan
Excel 365 is getting a simple way to add checkboxes into cells to easily set True/False, Yes/No, On/Off binary settings. You can hear the cries of “About bloody time” across the Excel world <g>. It’s long been possible to add a checkbox into an Excel worksheet but it’s a clumsy
Microsoft has fixed a bug in Outlook for Windows which wrongly popped up the notice “Outlook closed while you had items open. Reopen those items from your last session?” When Outlook closes with items open (email, appointment etc.), it should offer to reopen those items when Outlook next starts. The
There’s a hidden part of Excel which can be used to catch ‘data cheats’ or people who tweak workbooks to get the results they want. There’s a news story about research into honesty, the academic is being accused, ironically, of dishonesty in their findings. The Professor is suspected of tampering
OneDrive Personal Vault is available to Microsoft 365 users across the globe. It’s an extra security level for your most important and private files. Here’s how to setup, use it and work with Office documents in the Vault folder. OneDrive Personal Vault is a more secure extension to standard OneDrive. It’s
OneDrive Personal Vault is limited to 3 files for anyone with a free OneDrive account. It’s very easy to bypass that limitation, store as many files as you like and even add another security layer. See OneDrive Personal Vault, deep inside and tricks There are several ways to store multiple files
The low-cost Microsoft 365 Basic plan is now getting all the security features that were promised back in January when the plan was released. Microsoft 365 Basic’s main features are 100GB of OneDrive storage and a 50GB Outlook.com mailbox for US$20 a year. In January 2023 the plan was announced
Microsoft Office Add-ins are about to get a bit more ‘pushy’ with the addition of a fixed ‘Get Add-ins’ item to the File menu. Part of Microsoft’s continuing and somewhat desperate effort to get commissions from third-party software makers. Microsoft has been pushing Office add-ins for years, hoping to get
Use a hidden registry hack to protect your privacy by reducing the amount of private info Microsoft Office apps send to Microsoft. Dr Aleksandar Milenkoski, working for the German Federal Office for Information Security, has produced a report on what information Microsoft Office software sends back to the company. That’s information
You can disable the “Hyper” “Office” key or Ctrl+Alt+Shift+Win shortcuts to open Microsoft 365 and Office apps. We’ve told you about the Office Keyboard Shortcuts in Windows 11 and 10 which start by pressing Ctrl+Alt+Shift+Win together. That clumsy four-finger shortcut is an alternative to the Office key which Microsoft tried to introduce
How to insert the Stethoscope 🩺 symbol/emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Trivia: the stethoscope was invented by a Frenchman who was embarrassed putting his ear upon a lady’s chest to hear her heartbeats. His original was a simple tube,
The alternative name for India is Bhārat and that term is now being used, somewhat controversially, by the government. How does Microsoft Word handle “Bharat” and what are your choices for either using the word or not. Even if you’re not interested in the name change, it’s a practical lesson
Microsoft is adding Dall-E to new services for Microsoft 365 (Designer), Bing and Office (starting with Word). Let’s look at what Dall-E is, what it can do for you and the fun to be had. In short, Dall-E turns text into an image with often good and sometimes funny results.
