Ukraine flag & colors in Word, Excel or PowerPoint
Find and add the Ukraine flag or national colors into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. Ukraine Flag Image There are many, many copies of the Ukraine flag available. We’ve opted for the Wikipedia site because it has an SVG scalable version (preferred) and PNG versions for older […]
What is Excel Argument Assistance?
Excel is getting even more help to write formulas, look out for Argument Assistance coming to Excel on the web and hopefully beyond that. Argument Assistance won’t solve loud disputes with your partner, boss or that annoying guy on the bus. It’s a larger panel to guide people through completing a function. At the moment […]
How to use Excel’s Accessibility Ribbon
Excel has an Accessibility Ribbon to help you make changes to ensure that worksheets are easier for people with disabilities to read and edit. For some time, there’s been a Check Accessibility feature on the Excel Review tab. That opens a side-pane with suggestions for improving the worksheet. Go to Review | Accessibility | Check […]
Black Chess King ♚ symbol in Word, Excel, PowerPoint and Outlook
Insert the Black Chess King ♚ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Black Chess King ♚symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. Or perhaps as general symbol of royalty? See also Black Chess […]
Styles in Excel; quick, table, new, modify
You can combine Excel cell formatting into a style, but not like in Word. Excel has Styles … truly it does. Word has a way to combine formatting attributes of a letter, word or paragraph into a single block with a name like ‘Heading 1’. Excel has a feature also called Styles but it’s a […]
Get best quality images in a PDF made from Word
Get the best quality images in a PDF file made from Microsoft Word for Windows by changing some simple settings. There are also options in Word for Mac, Excel and PowerPoint. Better quality images in the PDF file are possible, starting with Word’s settings for saving images within the document. Then changing the image quality […]
Fixing common Office document accessibility problems
Accessibility Checker serves as a free tool that helps ensure that Office files are easy to understand by everyone. Use it to quickly fix common Office doc problems that can make your documents, sheets and slides harder to comprehend. It’s available for Microsoft 365, Office 2021/LTSC and Office 2019. Word, Excel, Outlook, OneNote, and PowerPoint […]
How Proficient I am in Microsoft Word?
A delightful piece in The New Yorker turns a resume cover letter into an ode about the applicants love of Microsoft Word. Eli Burnstein’s humorous article opens with: “Bold and italics are the oils that grace my palette. Cut and paste the strings upon my lyre. Fonts, bullets, columns, indentations—these stubborn materials are no match […]
Clever solution for Singular/Plural in Excel
Jon has found a clever way to show words (singular, plural or zero) with many numbers in Excel using conditional formatting. We already shown you several ways to put singular or plural words against numbers in Excel – like 1 cookie or 3 cookies. At the end we noted how it got more complicated when […]
Extra linked data types in Excel 365
Excel 365’s Linked Data Types have gone beyond the original Stocks and Geography feeds. Now there are more Linked Data Types to pull more public information into Excel 365 workbooks about diverse topics as Anatomy, Chemistry, Plants, Movies and more. It’s a massive extension of the existing Stock and Geography data types like Anatomy Animals […]
Windows 11 has a better way to clone an existing file
There’s a quick way to clone or duplicate an existing file in Windows 11 so you can make a new, similar document. Quite often a new document is based on an existing one, for example a fresh invoice for the same things each month. Or a proposal to a new client, which is similar to […]
COUNTIF for Excel
The COUNTIF worksheet function in Microsoft Excel has a simple format that provides a quick and easy way to count the number of times a certain condition is met in a data set. By Kara Monroe That sounds imposing but it isn’t. Most likely you already use COUNT to count the number of cells that […]
Excel how to remove both items if a duplicate
Excel has an in-built feature to remove duplicates from a list but what if you want to delete both items if they are duplicated or more than two? Remove Duplicates Remove Duplicates is tucked away on the Data tab, Data Tools | Remove Duplicates. It will ensure that an Excel list/table has only unique values […]
Three ways to add EPS graphics into Microsoft Office
Three ways to insert or import an EPS (Encapsulated PostScript) graphic into Word, Excel, PowerPoint or Outlook. There are two a ‘quick and dirty’ options and a way that allows some editing. Microsoft Office did support EPS files for many years but dropped them in 2017/2018 because the EPS format is a security risk. EPS […]
Four SVG editing choices for Office 365/2019/2021
There are four different ways to change an Office icon or SVG graphic in Microsoft 365, Office 2019 or Office 2021. The two official SVG edit methods in Microsoft Office with their in-built limitations or some choices before inserting into Word, Excel, PowerPoint or Outlook. Within Office Limited SVG/Icon changes are available from the Graphics Tools […]
Make simple changes to SVG graphics
Some simple changes to SVG graphics can bypass some of the more annoying limits of SVG support in Word, Excel and PowerPoint for Office 2019/365. Here’s a simple SVG with three parts: the circle <circle> the rectangle <path id=”bar” …> letters are defined in other <path … > and <use …> statements. In this article […]
