You can do incredible things in Excel but here’s something truly amazing. Someone has made a 16-bit computer chip (CPU) emulation entirely in Excel. We have links to the source code and fascinating video that explains it all. @Inkbox has recreated the basic logic of a CPU to make a
At long last, there’s a way to get Microsoft Forms results synchronized with an Excel workbook. It’s not what Excel users were expecting but it’s a start. Microsoft is calling this a ‘highly anticipated feature’ which is corporate weasel term for a long-standing customer request that’s finally fulfilled (in part).
According to Microsoft, AutoSave is the ‘greatest feature of all time’. That’s ‘over the top’ even for Microsoft and it only highlights the self-serving limitations of the current Autosave feature in Office. “Autosave is the greatest feature of all time and you can use it across your M365 apps. That’s
What you need to know about Copilot for Microsoft 365 which brings AI technology into Microsoft Office including Word, Excel, PowerPoint and Outlook. Here’s how to get Copilot for Microsoft 365 and the secrets to getting it working. What is Copilot for Microsoft 365? Copilot for Microsoft 365 applies to Microsoft
There are two ways to try out paid Copilot for less money. If you’re not sure but want to try the enhanced AI features in Office there are a smart ways to get Copilot without dropping a lot of money in advance for unknown benefits. Let’s face it, Microsoft is
The Microsoft Readiness Toolkit for Office add-ins and VBA is being cancelled (‘retired’) from the end of March 2024. The toolkit has been around for some years to help “identify compatibility issues with your Microsoft Visual Basic for Applications (VBA) macros and add-ins that you use with Office”. The download
Until now, Excel for iPad could use PivotTables already setup in desktop Excel. Now you’ll be able to make and edit PivotTables too. An Excel for iPad PivotTable looks the same as in other Excel’s Being able to make last minute changes to a PivotTable on the iPad is very
Many different ways to type or insert laundry care symbols, which appear on clothing labels, into Word, Excel or PowerPoint. Laundry care symbols can be for laundry area signs or for fun like this t-shirt. Or alternative symbols in a PowerPoint slide. All five symbols were black laundry care icons.
Catch Up is Microsoft’s new way to present the latest changes, comments, mentions and tasks in a collaborated document, sheet or slide deck. When a document is being managed by many people, there can be a lot happening. Edits to the doc, sheet or slides, comments and @mentions including tasks
How to get and use the copyright free Mickey Mouse and other public domain creations in Microsoft Office. Add to Word documents or PowerPoint slides. There’s been a lot of stories about content that is now in the public domain, especially Mickey Mouse. That copyright expiry applies to the USA
There are special web links to make a new Office document (Word, Excel or PowerPoint) with a single click. Microsoft has bought some .new domain names like https://word.new . When you click on a .new link, a fresh document is created for you. Word, Excel or PowerPoint files are created
Microsoft Office has many, many print calendars to choose from, if you know where to look. There’s a trick to choosing the right calendar for your needs, made by Word, Excel, Outlook or PowerPoint. Printing out calendars or adding them to documents/slides is possible in Microsoft Office though the selection
Here’s a better and more flexible version of the Calendar Creator with both Sunday and Monday start of week. Office Watch reader, David Peel, has made a better, more compatible Calendar Creator. We added some different versions to suit other calendar formats. We’ve told you about The Mystery of Excel’s
Excel can make calendars from some supplied templates. Some templates are labelled with a specific purpose however a few simple changes can make them better and suit what you need. Sadly, the help with the templates can be wrong or misleading. Here’s just one example to show what’s possible to
Excel can’t add up reliably and it never has. It’s an important limitation of computer software that everyone needs to be wary of. Phil N sent us an interesting Excel worksheet. He’s simply adding a column of numbers starting with a negative number then positive numbers – the total should
Microsoft has added new web links to access Microsoft 365 mailboxes in a browser as well as some other unpublished new domains to reach Office apps in a browser. The web links are https://Outlook.cloud.microsoft or https://Outlook.microsoft Use one of those links and login to your Microsoft 365 mailbox (e.g. Business,
Windows 11 and 10 has the Emoji Panel. What a pity that it totally sucks and is incredibly dumb. Emoji Panel is better than what we had before (nothing) but not by a lot. We’re talking about the Emoji Panel or ‘keyboard’ which appears in Windows 11/10 when you press
Excel Labs has just added a nice formula Debug option that helps you understand the steps inside a formula and fix errors. There are already three ways to look inside a formula; Evaluate Formula, F9 to calculate part of a formula and the recent Visual Preview. Now Microsoft’s Excel Labs
There are two important changes coming to Get & Transform (Power Query) in Excel. Both changes are probably already covered by the current setup but you should check any external data links now to avoid an unwanted surprise. These changes apply from 11 March 2024. Microsoft is a little vague
Microsoft messed about with Notes and Comments in Excel 365. Here’s what’s happened, name changes, overlapping functionality and how Excel has gone from ‘Notes’ to ‘Comments’ and now back to ‘Notes’ again! There are now two different ways to add text notes or comments into an Excel 365 cell. The
Here are three ways to add an explanation or note within an Excel formula itself, instead of separate notes. The ‘Achilles Heel’ of Excel or any spreadsheet program has always been explaining or commenting of cell formulas. Adding comments is an important part of any code including Excel’s VBA but
Here’s a far better way to view and edit formulas in Excel than the small formula bar. It’s a free add-in from Microsoft’s Excel Labs called Advanced Formula Environment (AFE) Understanding Excel formulas can be difficult, even ones you’ve written yourself. Imagine trying to work with a monster formula like
Pantone’s color of the year for 2024 is “Peach Fuzz”. You can use that exact color in Word, Excel, PowerPoint, Outlook and Designer using the Hex/RGB color code. And we’ll look at the flowery prose that’s become a hallmark of this annual promotion. The color of 2024 is … Peach
Excel’s web version now has some better ways to insert functions direct from the function search window. Also easily see the open/close bracket pairs. Insert Function ‘wizard’ Insert Function has expanded into a little ‘wizard’ (remember those?) after finding the function, a second pane lets you insert parameters with some
