Creating clean, professional-looking stacked fractions in Microsoft Office is easier than many users realize, if you know where to look. The built-in Equation feature lets you insert vertical (stacked) and other fractions quickly, without hacks or manual formatting. Here’s the fastest and most reliable way to add proper mathematical fractions
Microsoft talks about “Office Math” in Microsoft Office but you won’t find that name in Word, Excel, PowerPoint or OneNote. We explain where to find “Office Math” and why it appears under the name “Equation” in Microsoft 365 or Office. Also how to convert “Equation Editor” formulas into modern “Office
Olympic style medal tables (Gold, Silver, Bronze) can be rank correctly in Excel including allowance for joint or equal results. This guide shows how to build an accurate Olympic style rankings table in Excel that match how medal standings are officially calculated. 🥇🥈🥉 VBA and Lambda code included. Use this
Microsoft Office doesn’t make hex color codes obvious, but they’re fully supported if you know where to look. Whether you’re matching brand colors in Word, Excel, PowerPoint, or Outlook, using hex color codes ensures perfect consistency across documents and presentations. Here’s how hex colors work in Office and how to
Need the real Olympic logo for Word, PowerPoint, or other Office documents? No need to make your own, use unofficial or low-quality versions. Here’s how to find and use the official Olympic logos correctly in Microsoft Office documents, sheets, slides or emails, without copyright or quality issues. Also the correct
Microsoft’s OneDrive Personal Vault promises extra security for your most sensitive files, but many people misunderstand what it actually does. We explain how OneDrive Personal Vault works, what protections it truly offers, and, just as importantly, what it does not protect, so you can decide whether it’s right for your
A “service-side change” in Microsoft Office is Microsoft’s way of quietly changing how Office works, without updating your apps, asking permission, or bothering to tell you first. It’s new terminology so we explain what it is and how to know your computers are up to date. For admins, auditors, and
Microsoft has just released an emergency or out-of-band (OOB) security update to fix a serious Microsoft Office zero-day vulnerability or security bug that’s already being used in real-world attacks. Microsoft 365, Office 2024 and Office 2021 are affected, even ‘old’ Office 2019 & 2016 apps are fixed. This patch was
Import PDF data into Excel and refresh it automatically. Microsoft Excel 365 or 2024 for Windows has a refreshable PDF connector that lets you import tables or entire pages from PDF files using the Get & Transform tool. This means you can set up a process once and optionally refresh
Microsoft quietly added KeyTips to Office for Mac, giving users the same faster, keyboard-driven access to the Ribbon that Windows users enjoy. The long-awaited feature brings Mac users a little closer to parity with Word, Excel, OneNote and PowerPoint on Windows. It’s another “About Bloody Time” late innovation from Microsoft.
Did your Documents, Desktop or Pictures suddenly “live” in OneDrive? If you’re wondering why your files moved to OneDrive, you’re not alone. That wasn’t a ghost, it was Windows’ Known Folder Move. Microsoft tricks people by calling it “PC folder backup”. Here’s what that means, how to stop it safely,
Office 2024 is Microsoft’s latest standalone productivity suite for Windows and Mac, with a one-time no-subscription purchase for Windows or Mac. Office 2024 includes Word, Excel, PowerPoint, OneNote, Outlook (in Home & Business), and more, with performance, UI updates, and feature enhancements drawn from recent Microsoft 365 developments. This guide
Microsoft Excel’s Copilot() can show #CONNECT “Too many requests” errors if you use the function incorrectly. Copilot() is different from almost every other Excel function because it has limits on how often it can be used. Don’t panic, there’s practical steps you can take to keep Excel’s connection to AI
AI makes hard tasks in Microsoft Office so very easy, not just for typing or formatting, but for writing code, formulas, and automation scripts across Word, Excel, PowerPoint, and Outlook. In this guide, we explore the best AI coding tricks for Microsoft Office, showing how tools like ChatGPT and Copilot
Transform how you work with text using free AI tools like ChatGPT, Copilot, Gemini and Meta AI. In this guide, you’ll learn how to rearrange lists, convert tables to paragraphs, resort text alphabetically and reformat steps in seconds, all with simple prompts instead of tedious manual editing. Whether you’re working
Struggling to separate first, middle and last names in messy data lists or join first/last names? Traditional Excel tools or Flash Fill often fall short with real-world name complexity, including multi-part surnames and inconsistent formats. The latest AI tools, such as ChatGPT and Microsoft Copilot, can intelligently parse full names
Get greater control over your Excel workbooks by converting dynamic COPILOT() responses into static, editable values that won’t change unexpectedly. This guide walks you through simple yet powerful methods to ensure your AI-generated results stay stable, compatible with features like Stock data, and remain auditably accurate. Whether you’re preparing a
It can be fairly challenging to combine data in Excel. There are two new functions HStack() and VStack() to combine dynamic arrays or ranges, by either stacking the data horizontally or vertically. As shown in the example below by simply using =VSTACK(B2:D3,F2:H3) it’ll stack both cell ranges on top of
Microsoft is now embedding Copilot Chat directly inside Word, Excel, PowerPoint apps, giving users a conversational AI interface right next to the doc, sheet or slide. Ask questions, summarise, rewrite, explore ideas, and get help with your open document or spreadsheet without leaving the app. No need to switch to
If you’re finding Microsoft 365 Copilot intrusive or just prefer a cleaner Office view, you can turn AI off across your desktop app, including Word, Excel, PowerPoint and Outlook. Users who don’t want Copilot help can disable it on both Windows and Mac. In this guide, we walk through how
Microsoft has quietly delivered another round of security updates for Office 2016, even thought the software officially ended support two months ago. These patches focus on critical vulnerabilities that could still affect businesses and individuals running this older version of Microsoft Office. Here’s what’s been fixed and how to get
Learn how to create high-quality PDF files from Microsoft Office documents using the two main methods: Save As/Export and Print to PDF. This guide compares both approaches so you can choose the best one for your needs. Whether you want clickable hyperlinks, bookmarks, backgrounds, or a simple fixed layout PDF
Learn how to use Excel’s powerful SWITCH function, the modern alternative to nested IF statements. The SWITCH function evaluates a value against multiple matched outcomes and returns the first corresponding result, plus an optional default if nothing matches. Our guide breaks down the format, best usage patterns and practical examples
Pantone’s color of the year for 2026 is “Cloud Dancer”. You can use that exact color in Word, Excel, PowerPoint, Outlook and Designer using the right Hex/RGB color code. And we’ll look at the flowery prose that’s become a hallmark of this annual promotion. The color of 2026 is …
