Word and PowerPoint have some great ways to add a border or frame around an image, graphic or logo. We covered these broadly in a Framing Pictures in Office and now we will look in detail at the Compound Type, or multi-line borders. Compound Type is Microsoft’s name for the
Xlookup is now available across all the Excel programs and apps, making it a viable alternative to Vlookup/Hlookup for Office 365 users. The Xlookup function is the much-improved way to lookup values from a list or table. It works really well but it’s taken some time to appear across all
Here’s how to find the version number of your Word, Excel, PowerPoint or Outlook apps for iPhone or iPad. Sometimes it’s important to know which exact app version you’re running. Normally, the apps are updated automatically but occasionally it’s important info. Maybe you need to check the version to ensure
The iPhone apps for Word, Excel and PowerPoint have been redesigned with a new look that reduces the initial menu options from five to three. At least that’s what Microsoft is saying, though there’s no change in the apps so far. According to Microsoft the apps are “Redesigned From Scratch:
Hiding in plain sight are some useful tricks for picture formatting within a shape. It’s possible to fit or fill the image within the shape and, importantly, move the picture around with shape outline. Office Watch has already talked about various ways to change the look of an image within
Here are three options for putting a photo inside any Microsoft Office Shape or Icon (Word, Powerpoint etc.). Photographers call it cropping a photo to a shape or graphic. There are three different ways to get the same or similar result. Two are quick and easy. The third option is
Our ebook PivotTables and PivotCharts from scratch now has a bonus extra for all readers, new and existing. Our Subscriptions Manager is an Excel workbook to organize online subscriptions like Netflix, HBO, Office 365 and (too) many more. We’ve just added an enhanced version of the Subscriptions Manager to our
Find and add the New Zealand national flag and alternatives into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help applies for any other national flag, just look for a different source. Get the New Zealand Flag Image There are many, many copies of the New Zealand flag available. We’ve opted for the Wikipedia
A new report lists the top software vulnerabilities of 2019. Little surprise that Microsoft and Office feature in the top ten but not with the latest security bugs. Recorded Future’s report is headed 2019 Vulnerability Report: Cybercriminals Continue to Target Microsoft Products and lists the top ten vulnerabilities of 2019.
It’s nice to see a small but important tweak to the Ink editing ‘Lasso’ feature in Word 365. Lasso now selects only inked elements when embedded with text. Lasso is a way to use a digital pen to select objects in Word, either to move or delete. However it’s been
Xlookup, the vast improvement on Vlookup/Hlookup is now available on Excel Mobile for iOS (iPhone/Ipad) and Android. This is great news because it means Office 365 Windows/Mac workbooks can be fully compatible with Excel on mobile devices. You can create or edit formula with XLookup() and refresh existing data that
Get a hi-res version of Canadian National flag into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help applies for any other national flag, just look for a different source. Get the Canadian Flag Image There are many, many copies of the Canada flag available.
Here’s some more detail about the Excel Subscriptions Manager, how it’s put together, what you can change and extras to consider. See also Starting with the Excel Subscriptions Manager about how to setup the spreadsheet. Table The whole thing is an Excel Table cunningly called Subscriptions. Formatting, especially alternating row shading
Here’s what to do once you’ve downloaded our Excel Subscriptions Manager to organize the many subscriptions now available. After opening there’s a few things to do first: Currency prefix Change the currency if $ doesn’t apply e.g. change to STG ₤, Euro € etc. We’ve made that easy with two
Maybe there will be ads in a future release of WordPad. Microsoft is testing the waters with some Office 365 ads in some test versions of Windows. There’s been a lot of hyperventilating coverage about WordPad ads as if it’s a done deal to appear in Windows soon. The idea
Microsoft has an Office extension for the Google Chrome browser which adds links to the online versions of Word, Excel, PowerPoint, OneNote and OneDrive. This free Office extension has been available for some time. Not to be confused with ‘Microsoft Search in Bing quick access’ that’s being forcibly added to
Courtesy of the good folks at Popbitch comes this groaner; To the person who stole my copy of Microsoft Office, I will find you. You have my Word. Joker from Office 365/2019 Icons with some extra formatting Boom, boom. We’re here all week. Try the chicken. Don’t forget to
It’s the Chinese Year of the Rat, to celebrate in Word, PowerPoint or Office generally is easy with an Icon or Online Pictures search. Not interested in the Chinese New Year? These same tips apply to many other events or festivals. Rat Icon Insert | Icons has many graphics including
Microsoft is planning to force Office 365 ProPlus users to use Bing Search with their Chrome browser. A heavy-handed move that’s annoying IT admins but is also misunderstood, so here’s what definitely happening and NOT happening. This applies to the volume licence version of Office 365, called Office 365 ProPlus.
A ‘new’ Office 365 feature is ‘Save As Picture’ to save Office objects like shapes, icons, images and charts as a picture. It also comes with a mystery because this ‘new’ feature isn’t new at all in Office 365 and Office 2019. It’s a useful little trick, right-click on any
There are many ways to edit a logo or graphic in Microsoft Office; recolor, outline, shadow, reflection plus Shape options. All demonstrated here using the Star Trek logo ready for Word, PowerPoint or Excel. We’ve found the iconic logo in the best form to use in Office. Even if you’re
Microsoft Office, especially PowerPoint and Word, have simple and easy ways to ‘jazz up’ a simple image, flag or logo with one of the many framing options. Instead of just copying a graphic into a document or slide, try one of these variations. They retain the original image but give
If Office for Windows shows Unlicensed Product errors, there’s a bewildering range of errors and prompts appearing. Here’s what to do, and in what order, to solve the problem. Starting Office for Windows and you’re greeted with various warnings like this. Subscription Expired may or may not be true. This
One of the sillier online debates is an argument about the usefulness of algebra and other maths skills in a world where Excel is available on almost any screen. To us this is silly because it’s not a simple either/or choice. It’s about balance, a concept that’s not fashionable these
