Many common Excel functions have a great new power added to them with little fanfare. They can become dynamic array functions which improves the consistency of worksheets. It’s simple and easy to do. When Microsoft added dynamic arrays to Excel, all the focus was on the new functions like SORT,
Some Excel functions won’t spill their results in the way you might expect. Edate(), EOmonth(), IsEven(), IsOdd() and RandBetween(), among many, need an extra little trick to become a dynamic array function. We’ve already explained how many common Excel functions (Round(), Trim(), Upper() and many more) can “spill” their results
Transform your next presentation by mastering five powerful ways to add images in PowerPoint. Whether you’re embedding visuals directly from the web, creating photo albums, leveraging SmartArt, or using Copilot enhancements, these expert tips will streamline slide preparation. On a PowerPoint slide with a picture placeholder, just click the image
The July 2025 security bug fixes list plugs another 137 problems found in Microsoft software. Some are really serious and need patching right away for all Microsoft 365 and Office users. BitLocker also gets some security fixes. This months load of Microsoft Office security updates includes a fix for a
There’s a new feature in Microsoft 365 Word, Excel, and PowerPoint for the web to request elevated permissions directly within the application. Anyone with view-only access can ask for higher editing or reviewing rights without leaving the document. Microsoft, as usual, buries an important condition deep in their promotional blurb
There’s a mystery English grammar rule that any native speaker knows but probably can’t explain. It’s the order of adjectives before a noun (e.g why “Brown Big Cat” is wrong). The Microsoft Word grammar checks for this rule but doesn’t always ‘see’ or fix it. Adjective order is a mystery
Add the US National flag “Old Glory” “The red, white and blue” into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help can be used for any other national flag, just look for a different source or our articles about
Autosave in Microsoft 365 and Office is one of the more frustrating features with annoying limitations. One of them is not automatically saving any macro-enabled Word, Excel or PowerPoint file. We’ve talked before about how Autosave is used to push customers into using OneDrive to save documents. Autosave could work
Clipchamp has a clever new feature that makes editing videos a lot easier and faster. Instead of trimming the video, just delete parts of the transcript, Clipchamp will do the rest. Clipchamp can already make a text transcript from the audio of a meeting or conversation. Microsoft Word can also
There are a lot of changes coming for Microsoft customers in October but there’s one that might be overlooked. Support for Microsoft 365 ARM-based 32-bit applications will conclude: Feature updates stop in October 2025 or . Security updates end in December 2026 or . Most Arm versions of Office are
OneNote Clipper is a quick way to save a web page so you can read it later. It can replace Pocket, the lovely clipping service that’s about to leave us. Pocket, the ‘read it later’ service, is ending on July 8, 2025. Pocket is/was a ‘ready it later’ service to
Discover PowerPoint placeholders — designed to make slide creation faster, easier, and more visually compelling. With smarter prompts, broader media support, and customizable layouts via Slide Master view, placeholders help you create polished, professional presentations with minimal effort. In PowerPoint, placeholders are those built-in boxes that make adding stuff like
Take control of Microsoft 365 by learning how to enable or disable Copilot in each app—Word, Excel, PowerPoint, Outlook, and OneNote. This guide provides step-by-step instructions to customize Copilot settings per application and explains why sometimes you can’t turn it off. Copilot integration into Microsoft 365 is a mess. Microsoft
Instead of complaining about Word’s Resume style suggestions. Turn it off! It’s easy to do, here’s how. I often see social media posts bitching about a Grammar or Style suggestion given by Word. There are plenty of problems with Word’s Grammar and Refinements feature, but this one is an easy
Microsoft has given Copilot in Excel 365 some smarts to choose the table or cells to work on. Previously, Copilot relied on the user’s selected cell to determine context, often defaulting to the nearest structured table. We explain how it works in the real world and the important limitation. Enter
Here’s how I saved $55 on a year of Microsoft 365 Family, in the search for a cheaper Microsoft 365 plan for a friend. It’s easy, legal, anyone can do it and there’s often bonus software to use or ignore. We searched online for a reputable online retailer who sold
Costco members in the USA and Canada can save on Microsoft 365 and Office 2021 with discounts up to 28% on what Microsoft charges. Microsoft 365 discounts The Costco US deals involve an egift Visa card rebate and sometimes extra months too. Microsoft 365 Family (six users) at Costco sells
Buying Microsoft 365 from another country might seem like a money-saver, but Microsoft’s region locks often block activation. Learn why it fails—and smart, legal ways to make it work. That might be tempting because of exchange rate and price differences but Microsoft won’t let you do it. A little currency
Still using .doc, .xls, or .ppt files? These outdated Microsoft Office formats are not just relics—they’re major security risks and should be banned. Hackers exploit these older files to spread malware, ransomware, and steal data, as they often bypass modern antivirus protections. After our suggestion to ignore old style Office
RTF files may seem safe, but they can carry hidden risks. Hackers use RTFs to exploit Microsoft Word and even infect systems through email previews. Learn why RTF isn’t as harmless as it looks—and how to stay protected. The confusion is understandable. After all .RTF (Rich Text Format) files aren’t
Microsoft has given PowerPoint’s placeholders a stylish revamp, making them not only more visually appealing but also smarter in guiding you on what content to insert. Placeholders in PowerPoint are the little icons on new slide with buttons to insert various content. What’s New? How to use the new Placeholders
Microsoft has ‘improved’ calendar sharing for all their Microsoft hosted accounts but Outlook (classic) has been left behind with too many bugs with some still outstanding. The changed Shared Calendars is a good move that’s been poorly implemented for many customers. The Shared Calendar changes are an attempt to standardize
Struggling with a sea of worksheet tabs at the bottom of your Excel window? Whether you’re managing dozens of tabs or juggling shared workbooks with tight screen space, discover how to fit more visible tabs across your Excel workbook can transform your workflow. In this guide, we walk through both
OneNote Quick Notes is the fast way to add a short ‘jotting’, image or whatever. How a Quick Note is made varies a lot for each OneNote app; Windows, iPhone, iPad, Mac or Web. Windows Windows has shortcuts and a taskbar icon for Quick Notes In the OneNote app, go
