Discover the COPILOT Function in Excel
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 and Mac (Insider Beta channel), […]
Simple ‘one click’ force an update to Microsoft Office
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 update automatically and you don’t […]
Python in Excel for Microsoft 365 Consumers: Available Now
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 Available Now (Preview) For consumer […]
Excel gets Python – who, when and why
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 makes Python an important extension […]
Python Meets Pixels: Excel Now Analyzes Images Like a Pro
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 lot more tech-savvy. Forget floating […]
Excel’s better text splitting powers
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 to break the text apart […]
A smarter way to add pictures into Excel
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. This modern approach, available across […]
PivotTables get auto refresh at long last!
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 finger. No more manual “Refresh” […]
Microsoft Alert: Update Office or voice features are silenced
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; Dictate, Read Aloud or Transcribe. […]
See which Excel cells need updating or stale
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 Excel updates cells when necessary. […]
Make any Excel function dynamic (almost)
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, FILTER, and SEQUENCE that “spill” […]
Excel Spill Mystery: Why It Happens and How to Fix It
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 into multiple cells. But then—bam!—you […]
July Office updates include a real worry
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 series of “Remote Code Execution” […]
Request more access to a Word, Excel or PowerPoint file
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 so we’ll put it up-front […]
Add the US Flag into Word, Excel or PowerPoint
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 help can be used for […]
Why can’t AutoSave work with a macro in a Word or Office document ?
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 for all files, not matter […]
