Image privacy breach still in Microsoft Office
Back in 2015 we were amazed and dismayed to discover a privacy gap in Microsoft Office. Seven years later Microsoft has done nothing to fix or warn customers about. The problem is with images inserted into Office documents (Word, Excel, PowerPoint). The image ‘meta-data’ including GPS coordinates are retained with the inserted image. Anyone getting […]
“Free” Office for Windows is being trialed
Microsoft is testing a free version of Office for Windows with limited features, an important requirement and ads to ‘pay’ for the software. It’s three Microsoft 365 for Windows apps but with restrictions on what it can do and where documents are saved. If you download from this page at Microsoft.com and install using a […]
Pinned documents are now Favorites in Office – why?
Microsoft 365 apps are changing the ‘Pinned’ document list to ‘Favorites’ but why is Microsoft bothering at all? For many versions of Office/Microsoft 365 you’ve been able to keep regularly used files in a ‘Pinned’ list for faster access. The Pin icon lets you add a file to that list with a single click. Insiders […]
Stop Copilot appearing in Microsoft 365
Here’s how to stop Copilot prompts appearing in your documents, sheets and slides. Microsoft 365 customers are now seeing “Copilot Clutter” appearing in their Microsoft 365 apps, Word, Excel and PowerPoint. There is now a way to Disable Copilot available to some Microsoft 365 customers A Microsoft executive expressed surprise that customers didn’t want Copilot […]
Keep safe after this change to Microsoft account logins
There’s important change in the way Microsoft handles browser logins to Microsoft accounts. If you’re using someone else’s computer or a public terminal, you need to know about this new security hole. Whenever you’ve signed into a Microsoft account for a web site, you’ve almost certainly seen this box. Stay signed in ?Stay signed in […]
Smart Percentage Change in Excel
Calculating a simple percentage increase in Excel seems simple but, as usual, there’s a traps for the unwary. Here’s a smarter and more consistent way to figure out % change. First we’ll go over some basics which you’re welcome to skip … The formula for calculating a percentage change is simple: In other words, find […]
Excel’s order of calculation is not BODMAS
Excel has a slightly different order of calculation to the BODMAS rule taught to us at school. Those variations are important and can give a result you didn’t expect. Ray E from Iowa asked about one of those tricky algebra questions that appear on social media and generate heated arguments -10^2 . Ray wondered how […]
How to Disable Copilot in Microsoft 365
Microsoft is slowly adding an option to disable Copilot AI from their Microsoft 365 apps, Word, Excel and PowerPoint. Here’s what you’re supposed to see on your computer, but won’t necessarily. An option to disable Copilot is being rolled out to Microsoft 365 for Windows and Mac. First in Word 365 for Windows and later […]
Copilot Pro brings AI into Microsoft Office
AI technology without limits is available in Microsoft Office with Copilot Pro. AI features are integrated into Word, Excel, PowerPoint and Outlook for personal customers. Here’s how to get Copilot Pro and the secrets to getting it working. Copilot is Microsoft’s name for their AI based cloud services. They have been around for a little […]
HUGE changes to Microsoft 365 happening now
Microsoft 365 customers around the world are waking up to a new look in their Word, Excel, PowerPoint and Outlook apps. It’s part of Microsoft’s huge changes to Microsoft 365 Family and Personal plans which include a very limited Copilot AI service and a big price rise. Microsoft 365 users might first notice these changes […]
Two ways to make a running total in Excel
Here’s two ways to make a running total column in Excel. The way you were probably taught and a much better and more flexible choice. Running or Accumulative Totals are a very common thing in spreadsheets. Here’s a really simple example in columns C and E. Here’s two ways to make those totals, using Sum() […]
Copilot comes to Microsoft 365 with many limits and a high price
Microsoft 365 Family and Personal plans are getting Copilot AI integration into their Office apps but it comes with a big price increase and many limits to what people get for the extra cost. Customers in Australia, New Zealand, Malaysia, Singapore, Taiwan, and Thailand have seen massive prices rises in Microsoft 365 Family and Personal […]
Excel has ‘real’ Regular Expression functions
Microsoft Excel 365 has built-in support for regular expressions (regex). The functions REGEXTEST, REGEXEXTRACT and REGEXREPLACE have powerful pattern matching, text extraction and replacement directly into spreadsheet formulas, eliminating the need for VBA, add-ins or convoluted workarounds. Even better, the functions use a widely understood form of Regex for text-manipulation capabilities, data cleaning, validation and […]
How to remove words from the Word dictionary
How and why to remove words from the main Microsoft Word dictionary. The Office Exclusion List ensures a red squiggly underline appears to warn you about an unwanted word. Sometimes the supplied Office dictionary has words you don’t want or you’d like a warning about. Here’s how to put the red squiggly line under words […]
2025 calculations in Excel
2025 is a special number, as various social media posts have pointed out. It can be calculated in some interesting ways like (20 + 25)2 = 2025. Naturally we had to convert these into Excel formulas. 2025 is 45 squared, in other words, a ”perfect square”. This last happened in the year1936 (442) and the […]
Great Excel monthly calendar from just one cell
Modern Excel lets you make a whole monthly calendar from just one cell formula. We’ll explain how it’s done with a sample workbook for our supporters. At its simplest, Excel can make a single month like this from a formula in cell A6 which fills all the cells with the correct dates for that month. […]
