We’ve expanded our live Paris Olympics medal table to compare countries’ performances to their population or wealth. Along the way we explain how to cope with some problems that can arise when Excel theory hits the Real World. Our newsletter readers get a working example workbook to try themselves. We
Excel for Mac is now getting the ‘From Folder’ option in PowerQuery. An important part of the PowerQuery puzzle. PowerQuery’s ‘From Folder’ lets you add more data to a query simply by adding data files into a folder. PowerQuery will then scoop up all the data and add it to
The Dictation feature in Outlook for iPhone, iPad and Android will leave the apps in September for no reason Microsoft will share. The announcement was made discreetly so that only Microsoft 365 non-consumer accounts with Admin access are notified. Message MC841218 “We will be retiring the Dictation feature from Microsoft
Paying Copilot Pro customers have lost a major part of what they pay for. Say goodbye to Copilot GPT Builder in early July 2024. It’s only been a few months since Microsoft launched their paid AI plans including Copilot Pro and they are already removing a major component. Copilot GPT
Here’s how to save a Word document with the private and hidden details automatically removed. Normally, you’re expected to manually go to File | Info | Inspect document to check/remove things like comments, hidden text, header, footers or watermarks. What if you want it to happen automatically, whenever you save
Use Excel to get your own automatically updating Medal Table for the 2024 Paris Olympics then make charts and maps too. Our newsletter readers get a working example workbook to try themselves. Not interested in the Olympic medal count? This article and download are a good, working example of how
Here’s some more ordinal rank (First, 2nd etc.) options for Excel including with joint or equal results plus special fun wording. In a previous article we looked at options for showing ordinal numbers in Excel, now we’ll go a step further to cope with joint or equal results plus special
A US government department has accidentally revealed a secret by overlooking the obvious in Office document security, the file name. Microsoft Office helps you scrub documents of private or secret information before sending. It’s easy to overlook the obvious data leaks that ‘Inspect Document’ doesn’t cover. ‘Inspect Document’ checks for
Add to your Outlook a special Paris 2024 Olympics calendar shows all the events plus opening/closing ceremonies with times in your location and search for favorite events. A special Olympics calendar shows all the events plus opening/closing ceremonies with times in your location. This calendar shows the Olympic calendar in
Here’s how to quickly add events from the Paris 2024 Olympics into your Outlook calendars, showing times in your location. The Paris Olympic organizers have provided an online calendar with .ics calendar files for individual events from their website. Those calendar files can be imported into Outlook for Windows or
Pronouncing the name “Kamala” is a source of confusion even to Microsoft Office’s Read Aloud feature which needs a little tweaking. How does Word’s grammar check handle the possessive, it is Harris’s or Harris’? Kamala Harris has a Sanskrit based name which is simple to pronounce once you know the
Securing your email account is vital. It’s the one thing that everyone must do unless they want hackers to invade your privacy and possible steal your money. A news story from Australia is yet another lesson in why everyone should properly secure their email account with two-factor authentication. A lady
Microsoft added support for WebP images in Microsoft 365, allowing users to insert WebP pictures into Word, Excel, PowerPoint, and other Office applications. WebP images offer high quality with smaller file sizes compared to traditional formats like JPEG and PNG. WebP is an image format unknown to many people but is
Microsoft Office has a Remove Background tool for images but there are two better, faster and free ways to do the same job. Background removal lets you get an image with a transparent surround which can be merged/overlaid into any other slide or document more seamlessly (left) than a separate
There are two quicker ways to insert an image or graphic from the Internet or web page into a Word document, Excel sheet, PowerPoint slide or Outlook email. The method most people are taught is to save an image to their computer then Insert | Picture | from this device
The Background Removal Tool in Microsoft Office lets you neatly delete the background of images with just one click. It makes the photo subject stand alone with a transparent background. We’ll explain how remove background really works, it’s not quite as simple as Microsoft’s demonstrations make out. Windows 11 Paint
Add Spain’s national flag into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. Get the Spain Flag Image There are many, many copies of the Spanish flag available. We’ve opted for the Wikipedia site because it has an SVG scalable version (preferred)
Don’t miss this often overlooked Office trick, changing the color of an image or graphic in Word, Excel, PowerPoint, or Outlook. We did this in our article about inserting Prince’s ‘Love Symbol Number 2’ in Office documents. The image is available in various formats but always black, not purple. As
The nifty Excel ‘Data from Picture’ feature is in all Excel 365. It’ll convert a picture of text & numbers into a worksheet … almost. And there’s alternatives if you don’t have Microsoft 365. Data from Picture is already all versions of Excel 365 for Windows and Mac and Excel
Add England’s national flag “St George’s Cross” into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. Not to be confused with the British “Union Jack” flag, the English flag is a simple red cross on a white field. Many online searches for
Many of us have seen the error message “Please check your network connection and try again” when the Internet is definitely available. What does this Office or OneDrive error message really mean and what can you do to fix it? This error message appears in Microsoft Office help and other
Now that Excel is getting proper Regular Expressions (Regex) here’s some resources to get you started. The upcoming Excel functions RegexTest(), RegexExtract() and RegexReplace() use a common type of regex (PCRE2) rather than some special Microsoft version. That’s important because each regex version has its own options and peculiarities. Using
Here are 12 suggestions and shortcuts to let you navigate a Word document faster. Word has many ways to navigate a document, most of which are hidden away and not obvious to the casual users. Once a document gets past a few pages, you need options for moving around that
The Navigation Pane is a great part of Word for Windows and Mac. Don’t miss on the hidden features because there’s more in that side-pane than the obvious. Navigation Pane is the best and fastest way to move around a document. It’s available in Word for Windows (Microsoft 365 and
