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)
You don’t need to pay for Microsoft’s AI service, Copilot, to get some of its benefits in Microsoft Office, especially Word, Outlook and Excel. Try converting text to a table or vice versa. The trick to grabbing text from an image. Along the way you’ll also discover some of the
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
OpenDocument is another set of file formats for word-processing, spreadsheets and presentations. It’s an international standard that’s supported by Microsoft 365 and Microsoft Office. OpenDocument vs Microsoft Office docs While most people use the modern Microsoft Office document formats (.docx .xlsx .pptx etc) there’s a competitive set of Office file
Microsoft 365 is updating their OpenDocument format support to v1.4 which will improve compatibility with other software like LibreOffice. OpenDocument Format (ODF) is the International Standard for saving documents (ISO 26300 if you’re keeping score). It’s similar to the Microsoft Office formats in their basics of being XML based with
Python power in Excel 365 is getting closer to full public release. It’s now available for Microsoft 365 Current Channel (Preview), the last step before going out to all users. Python in Excel is possibly the most important improvement to Excel for a long time. All the power of Python
In Excel 365 you can list the world’s top companies and their market capitalizations including the shortlived leader, NVIDIA. NVIDIA have a lock on the supply of AI related hardware and so their stock price has dramatically risen. ‘Dramatic’ is an understatement because NVIDIA briefly jumped over Microsoft and Apple
Excel’s PowerQuery has many clever tricks, one of them is merging and matching data from multiple tables into a single table. Combine, clean, and transform data from multiple sources into the single format you need; a table, PivotTable or PivotChart It’s a simple relational database with relations set to match
How to choose more than one Microsoft Office file or document to open at the same time. One of the frustrations about the ‘pane’ interface in Office for Windows is the failure to include all the features that customers were accustomed to from the standard File dialog boxes. Microsoft added
Gantt chart for project management or event scheduling are possible in Excel. Here’s the step-by-step help plus a complete sample worksheet for our subscribers. Gantt chart can be widely used in project management for visualizing project schedules. They break down a project or event into tasks or activities as horizontal
A table or chart in Excel can be put into a Word document in two different ways but there are traps that Microsoft doesn’t mention in their help. We’ll explain what’s happening and how to fix it. This looks like a standard Word table and it can be formatted like
A recent poll commissioned by Microsoft confirms the widely held suspicion that people prefer the Calibri font over the new Aptos fonts pushed into Microsoft Office. This comes from a Twitter/X poll run by the Microsoft run @Microsoft365 account. The previous Office default font, Calibri, handily won the poll with
Patch Tuesday for May 2024 is a quiet month for Microsoft Office with only four security fixes but one of them is rated ‘Critical’. Also a list of the latest build/version released for each version of Office. Only Excel has a ‘Remote Code Execution’ bug which affects all supported Excel
All about Microsoft’s latest Office macro protection feature to stop virus infected documents loading nasties onto a computer. Mark of the Web MOTW is a relatively new way to protect your machine. Over 2022, a new layer of macro protection was added to Microsoft 365 for Windows. It’s something new
There are many ways to make pictures smaller, in both senses of the word. Here are three more options including great news for Windows 11 & Windows 10 users plus an important warning. Converting images into a smaller file size is sometimes essential. The large digital camera images (can be
Office-Watch.com has Star Wars Day covered with a series of articles which add the spirit of the Rebel Alliance or the Empire to your Microsoft Office documents, workbooks and slides. Star Wars Day is 4th May each year … “May the fourth be with you” geddit? Star Wars fonts Star
The existing Recommended PivotTables feature is now smarter in Excel 365 for Windows with more options and flexibility. For some time Excel has been able to suggest PivotTables based on the current Table. Recommended PivotTables is in Excel 365, Excel 2021, 2019, 2016 and earlier. Now in Excel 365 for
How to insert the Eye 👁 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Eye 👁 symbol is used for decoration “Look Here” or “See this”. Even as a fancy bullet point in Word or PowerPoint. How Eye 👁 looks in
Teams button creep into Office and Outlook ribbons because Microsoft tries to promote itself. Here’s how to get rid of it or any other Office buttons you don’t want. Teams icons prominently appear on Office ribbons, like this one on the Outlook Calendar ribbon. or this with Meet Now video
Excel PivotTable can show a count of unique items if you know where to look. Handy to see the number of customers, products or students from a long data list. What is the count of unique customers who made purchases in each region? How many unique products were sold in
