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 […]
Copilot Chat in Word, Excel & PowerPoint, a Practical Guide for Microsoft 365 Users
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 a separate browser or Copilot […]
Turn Copilot Off in Microsoft 365: How to Guide for Word, Excel, PowerPoint & Outlook
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 to switch off Copilot completely […]
Office 2016 gets surprise ‘late’ security updates
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 the updates. We’re obliged to […]
PDF Save As or Print: Best Methods Explained
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 from Word, Excel, PowerPoint, Outlook, […]
Master Excel’s SWITCH Function: Simplify Conditional Logic & Replace Nested IFs
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 plus tips for combining SWITCH […]
How to get Pantone’s 2026 color in Word, Excel and PowerPoint
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 … Cloud Dancer “Cloud Dancer” is […]
US State Department switches fonts, Times New Roman vs Calibri
In a move reversing a 2023 policy, the U.S. State Department has officially returned to using Times New Roman font for its communications, ending the brief tenure of Calibri. Why choose one font over another? Times New Roman vs Calibri – the pros and cons of each font. The US State Department is switching fonts […]
Left arrow ← in Word, Excel, PowerPoint and Outlook
Type the Left arrow ← into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The official Unicode name is ‘Leftward Arrow” ← but it can be called ‘Left pointing’ ‘Left facing’ or just ‘Left Arrow’ See also Right arrow → symbol in Word, Excel, PowerPoint and OutlookLeft Right arrow […]
Add Rows Above or Below a Dynamic Array in Excel
If your Microsoft Excel workbook uses dynamic arrays, you might have run into a common frustration: adding a heading or a total below (or above) the spilled list often triggers a #SPILL! error or leaves awkward gaps when the list expands/contracts. It’s easy to “stack” your dynamic array with extra rows along such as a […]
Excel Attachments Failing in New Outlook — What You Need to Know
Users of the new Outlook for Windows are running into a frustrating bug: certain Microsoft Excel attachments simply won’t open — instead, they trigger the vague error message: “Try opening the file again later.”. Here’s how to bypass the bug. Some users are finding themselves locked out of Excel attachments in the shiny new Outlook […]
