Olympic Rankings in Excel; Gold, Silver, Bronze
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 to make the right wording […]
Hex Color Codes in Microsoft Office: How to Use Exact Colors Every Time
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 use them correctly. Hex color […]
How to get the official Olympic logo for Office documents
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 color codes to match the […]
OneDrive Personal Vault Explained: What It Protects and What It Doesnât
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 data security needs. Files in […]
Revealed: What is a Service-Side Change in Office and how to find them
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 long-suffering users . The latest […]
Emergency Office Update: What Every Customer Needs to Know Now
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 not part of the normal […]
How to Import PDFs into Excel and Auto-Refresh Data Using Power Query
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 your spreadsheet whenever the PDF […]
Office for Mac has KeyTips: Faster Keyboard Navigation
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. Office for Windows has Keytips […]
Why did Windows move my files to OneDrive? (What it is & how to fix it)
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, and how to move files […]
Office 2024 for Windows & Mac: Features, Pricing and Everything You Need to Know
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 covers features, pricing, system requirements, […]
How to Fix Excel Copilot â#Connectâ Errors
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 working. The Copilot() function in […]
AI Coding Tricks for Microsoft Office: Hard tasks made simple with AI help
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 can generate VBA, Excel formulas, […]
Rearranging Text Instantly with free AI: Smart Tricks for Microsoft Word & Excel
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 in Word, Excel or another […]
Name Parsing: Smarter AI Way to Split First, Middle & Last Names
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 into structured columns, handling exceptions […]
Convert Excelâs COPILOT() Output into Static Cells â Stop Auto-Updates & Preserve Values
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 one-off report or embedding COPILOT() […]
Combine Excel Arrays with HStack() or VStack()
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 each other. Using =HSTACK(B2:D3,F2:H3) will […]
