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
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
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
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
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
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
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
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
Excel 365 is getting new functions that bring the power of Regular Expressions (RegEx) into spreadsheets. It’s HUGE news and a big step forward for Excel. We’ve spent some time trying out the new functions and we’re genuinely excited by the possibilities. Unfortunately, almost six months have passed since the
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
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
Excel 365 is getting (at last) a clear warning that some cells have not been recalculated aka a ‘stale cell’ with the addition of a ‘Format Stale Values’ option. This feature only applies if you’re using partial or manual calculation modes. Most of us use the default Automatic mode where
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
Get Economic data or graphs from FRED (Federal Reserve Economic Data) to load into your Excel workbooks or PowerPoint slides. From unemployment rates to the price of potato chips. FRED has 825,000 data sets for the USA and around the world. Tip: search FRED for your country (Canada, United Kingdom,
Keep a close eye on the increase/decrease decimals buttons on the Excel ribbon because Microsoft is changing them without warning. Increase / decrease decimals is a very common Excel feature to change the visible accuracy of a number. For example, choosing Currency or Accounting style (which defaults to two decimal
How to show currency amounts in Excel with the country and correct currency symbol included. Excel doesn’t support the standard way that different currencies are displayed with their country codes like this: Dig into the Accounting/Currency Formats and you’ll find these among a VERY long list of currency symbol options.
Pantone’s color of the year for 2025 is “Mocha Mousse”. You can use that exact color in Word, Excel, PowerPoint, Outlook and Designer using the Hex/RGB color code. And we’ll look at the flowery prose that’s become a hallmark of this annual promotion. The color of 2025 is … Mocha
Harness the power of Excel with our Christmas Card and Email Manager! It’s designed to help you manage your Christmas messages—cards, letters, and emails—for both sending and receiving. Download it now and streamline your holiday communication for a limited time. Keep track of which Christmas messages you’ve sent and how,
Enter the Ctrl + – (minus) shortcut in Excel. This powerful shortcut instantly deletes entire rows or columns without any confirmation. But there’s hidden trickery going on and some misleading info online. Ctrl + – is commonly said to “delete the selected row or column” but, as usual, the reality
Dig into a Microsoft Office document file, such as Word, Excel, or PowerPoint, and see its inner workings, here’s a straightforward method. It reveals the small files that comprise an Office document, mostly XML files, which you can easily explore with a text editor. Very occasionally it’s helpful or necessary
There are many ways to get a list of file names and folders, here’s four simple ways including one that might be a surprise. Copy from Explorer In Windows Explorer, select the files you want then right-click and choose “Copy as path” or Ctrl + Shift + C. The list
The existing Office app “Recent documents” widgets for iPhone and iPad are now available on Mac computers. There are widgets for Excel, Outlook, PowerPoint and Word. Each app has four widget options from small (one file) to a six file with thumbnails ‘extra large’ choice. The fastest way to find
OneDrive isn’t the only choice for sharing Office documents. Dropbox can also share Word, Excel or Powerpoint documents including real-time collaboration. The Dropbox and Microsoft Office integration allows users to open, edit, and save Office files directly from Dropbox. Use either Office apps on the web (Office Online) or modern
There’s a hidden trap in Microsoft Excel’s DateDif function that rarely gets a mention and is too easy to overlook. DateDif() is a long-standing Excel function that returns the duration between two dates. It’s not a ‘full’ Excel function because it was added for compatibility with Lotus 123 and has