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.
The Square Root √ can be typed into Microsoft Word, Excel, PowerPoint or Outlook. There are two different styles to choose from plus a better option for equations and formulas. Square Root √ symbol is sometimes called a radical symbol, radical sign, root symbol, radix, or even a surd. The symbol can include a horizontal
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
GroupBy is a new and genuinely great function coming to Excel. It’s one of two new ‘aggregation functions’ but we prefer to call them fast summary powers. The more we use Groupby() , the more we like it. So we decided to focus on it with detail. Both Groupby() and
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
Our Christmas Card and Email Manager uses some of Excel’s power to keep track of your Christmas messages (casrds, letter and emails), both sending and receiving. It’s available to download and use, for a limited time. Microsoft has a Christmas Card template for Excel but, to be honest, it’s pretty
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
Add the Croissant 🥐 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. I have to declare a personal interest in this article because the Croissant 🥐 is an essential part of my breakfast. No morning is complete without the “Three C’s”
Office for Windows and Mac has three special outline styles for the borders of shapes and text boxes. Called ‘Sketched’ or ‘Sketchy‘ because they have a hand-drawn line look. It’s a nice little addition to Word, Excel, Powerpoint and Outlook. Let’s see how it works plus some details and limitations
Like almost any web site, we use technologies like cookies to store and/or access device information. We aim to keep that to a minimum. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions. We apologize for this box but it's legally required in some regions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.