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.
Microsoft has announced some of the extras coming to the next version of Windows 11, rolling out from September 26 onwards. Here’s a quick look at some of these changes, in particular those which can improve your Office docs, sheets, slides and emails. Paint Paint app receives a major upgrade
Over the past ten years, OneTastic and its early version, OneCalendar, have established themselves as vital tools for dedicated OneNote users. These applications, developed as a passion project by Omer Atay from the OneNote product group, have proven especially beneficial for users who frequently record meeting notes across various sections
Microsoft and Project Gutenberg have joined to create thousands of audiobooks for free, using modern ‘text to speech’ technology that’s amazingly good. And we have some tips on how to create audiobooks with more variety in voice, accent and pace. Since 1971, Project Gutenberg has compiled a wide range of
Microsoft’s alternatives for the new Aptos fonts range are very poor. In some cases, the substitutions make no sense at all. We’ve looked at what happens if a document with Aptos fonts is opened Office 2016 and earlier versions of Word, Excel, PowerPoint and Outlook. Aptos fonts are the new
The trial release of Python in Excel is very interesting but it’s not the usual “Insiders” feature release with two important differences that will cost you later. “Insiders” is Microsoft’s name for their beta testing option to try upcoming features to the public Office apps. Excel gets Python – who,
Microsoft has many little ‘ads’ or suggestions that Microsoft Office 365 users (Windows or Mac) join the Microsoft 365 Insiders program (formerly Office Insiders). Is it safe to become an ‘Office Insider’ and why is Microsoft pushing it so much? Office Insiders is the testing program for new Office features.
There are some keyboard shortcuts to open or switch to Office apps in Windows 11 and Windows 10, if you have enough fingers! They are all based around the Ctrl + Alt + Shift + Win combo plus a letter. That might seem like a keyboard shortcut for an octopus
The Python Editor for Excel is a welcome innovation of the Microsoft Garage project making editing and debugging Python code in Excel a lot easier. Python Editor add-on for Excel mirrors the functionalities of renowned integrated development environments (IDEs) using the code management system behind Visual Studio Code. Sample code
Microsoft has fixed the big hassle that comes with the otherwise excellent Lambda() feature in Excel 365 with the new Advanced Formula Environment. Office Watch has sung praises over the power that Lambda brought to Excel. It’s the ability to write custom functions within Excel but without VBA macros. Proper
Unfortunately, copying an image made in Designer isn’t as simple as it should be. Here’s how to grab images made with Designer to use in your own Office documents. Don’t wait, start using Microsoft Designer now It’s easy to paste an image into Designer. Just copy the image from your
Here’s how to get the new Microsoft Designer app for iPhone and Android smartphones. Also how to share designs between the mobile app and the full Designer web app. Get the Designer app Go to https://designer.microsoft.com/install and scan the QR code provided on that page That will open the App
Python in Excel adds lots of new possibilities to Excel including a new way to the latest UTC time. Here’s the full code, how it works and a fix for an annoying problem. Knowing the UTC / GMT time is important for comparison with the ‘Last Trade Time’ data from
There are two ways to make Excel automatically refresh data connections and recalculate a worksheet. These tricks are important with the Stock and Currency data type in Excel 365 but also other situations. Normally Excel will update itself when you change a cell value. These days there are situations where cells
Insert the Water Pistol or Gun emoji 🔫 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. AND how to make the ‘gun’ point to the right. Water Pistol 🔫 symbol is the only ‘gun’ style symbol in the emoji collection. It’s officially
