It had to happen, there’s now a Copilot() function in Excel to drop AI responses directly into spreadsheets. It’s a clever trick but, as usual, there are problems that Microsoft overlooks in their hype. Excel’s new COPILOT() function brings AI directly into spreadsheet formulas. Available now in Excel for Windows
A simple way to update Microsoft Office 365 for Windows with one click instead of digging into the menus to do it. We’ll show you the simple command line with options that make it possible. Normally, the Windows versions of Microsoft Office 365, Office2024, Office 2021 and Office 2019 all
Microsoft has begun rolling out Python in Excel—the powerful integration that allows users to write Python formulas directly inside Excel—to Microsoft 365 Family and Personal subscribers. That’s great news because Python adds a lot to Excel, making available a lot of features that previously Excel users could only dream about. What’s
Excel 365 has access to the Python language and packages. We’ll explain what that means, who gets it and why Python in Excel is a big deal. Python is a high-end and widely used programming language with many features in its many packages or add-ons. It’s this last bit that
Excel, long known for its love affair with numbers, has now developed a taste for images—thanks to Python. Microsoft has rolled out a feature that lets users insert images into individual Excel cells and analyze them using Python code. Yes, the spreadsheet just got a little more artsy and a
Discover Excel’s Text-Splitting Power – Unlock Faster, Smarter Data ManagementMicrosoft has elevated text handling in Excel by rolling out powerful formula functions—TEXTBEFORE, TEXTAFTER, and TEXTSPLIT—that revolutionize how you extract and split strings. No more convoluted nested LEFT, RIGHT, or SEARCH formulas . Normally when working with text it’s common to need
Discover a smarter way to insert images directly into Excel cells with the IMAGE() function — no more awkward floating pictures. With just one formula, you can pull in external images using a secure URL, control how they fit or fill the cell, and even fine-tune dimensions with pixel-level precision.
Finally, PivotTables are going ‘live’ and will automatically refresh if other parts of the workbook change. It’s something that Excel users have wanted for years. Auto Refresh turns your PivotTable into a live mirror—updates to source data within your workbook now instantly refresh any connected PivotTables, without you lifting a
Microsoft has officially warned all Microsoft 365 customers to update Office—or risk losing handy features like Read Aloud, Transcribe, and Dictate. Most people will already be OK but it’s worth checking to make sure. Microsoft is totally revamping the backend services that powers the voice related parts of Microsoft Office;
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
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
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
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. Learn how to properly get and use the US Flag in Word Excel PowerPoint for your presentations and documents. The same
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
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
Some Microsoft 365 consumer plans come with a monthly allowance of “AI credits” but it’s hard to find out how many are left. The AI credit balance does not show up in the Microsoft 365 apps nor Windows 11 account information. It should be there and maybe Microsoft will eventually
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
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
Microsoft has extended a nifty new feature to include Android users: the ability to view shared Word, Excel, and PowerPoint files without needing to sign in with a Microsoft account. Previously, this was an exclusive perk for iPhone/iPad users—but Android’s finally been invited to the party. That said, if users
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
Aggregate() is the grown up version ‘all in one’ function that can replace common functions like Sum() and Subtotal() plus powerful options not available in those older functions. AGGREGATE() function is a more advanced alternative to the SUBTOTAL function, offering significantly expanded capabilities. Almost an ‘all in one’ solution instead
Whether you’re managing schedules, tracking deadlines, or analyzing time-based data, comparing dates in Excel is a critical skill. This guide walks you through how to use the powerful IF function to compare dates—such as determining if one date is before, after, or equal to another. Learn essential Excel formulas that
