How to protect Excel sheets from unwanted changes - Part 1
Protecting an important Excel worksheet from careless editing, or allowing only specific cells to be modified is all part of Read More
How to use Copilot() in Excel for analyzing text
The new Copilot() function can be great for taking disorganized data like feedback from people and grouping it quickly. We’ll Read More
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 Read More
Facts are a slippery thing with the Copilot() function in Excel
Just like Copilot or its parent ChatGPT, the Copilot function in Excel use for analysis but not so much for Read More
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 Read More
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 Read More
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 Read More
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 Read More
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 Read More
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 Read More
All about Office 2024 for Windows and Mac
Keep up to date with Microsoft Office 2024, the new and latest version of Office. It’s features, price, support and Read More
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 Read More
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 Read More
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’ Read More
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 Read More
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 Read More
