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
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.
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
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
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
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
Microsoft has updated their Online Services Terms to clarify some privacy issues but concerns remain. They’ve also added yet another document to the confusing mix of legalese customers are expected to understand. Back in August 2019 the Dutch Ministry of Justice released a report that recommended against using Office online
The US National Security Agency (NSA) discovered a serious security bug in Windows and, for the first time, told Microsoft so the company could fix it. That bug could also affect Microsoft Office or other programs. It’s important to update your Windows 10 asap, that’s not our opinion, it’s the
Here are two options to stop Microsoft Office for Windows from automatically updating itself and why you might want to do that. Office for Windows All versions of Office that have current support (currently Office 2010 and later) get: updates to fix bugs in the software patches to stop security
He’s done it again, David Peel has quickly made up a new version of his Excel Year Planner that starts the year from any month you choose. Great for academic years (start in August) or financial years (e.g. Aussie start in July). The year selector is top left of the
PivotTables and PivotCharts from scratch in a new edition strips away the techobabble so you can make your own PivotTables and make sense of any list of numbers or information. We do that with plenty of step-by-step instructions and, crucially, Excel worksheets you can open and try for yourself. Understand PivotTables by looking at expert examples,
Nested IF statements can be hard to understand and manage but there are alternatives which can be easier to handle, fix and change. We’ll start with the relatively simple example we used for demonstrating IF and nested IF. =IF(C2>89,"HIGH DISTINCTION",IF(C2>79,"DISTINCTION",IF(C2>69,"CREDIT",IF(C2>49,"PASS","FAIL")))) This example has only five levels of nesting, we’ve seen
Microsoft has added Dynamic Array functions to Excel for iOS (iPhone and iPad) and done it in an uncharacteristically low-key way. Dynamic Arrays are now available across all Office 365 platforms; Excel 365 for Windows and Mac, Excel for Android, Excel Online (web) and now Excel for Apple devices. That’s
The Office apps on Windows 10 Mobile devices have now ended main support and will end security updates, hotfixes and support in 2021. It’s an unsurprising announcement and another death notice for the failed Windows 10 Mobile platform and phones. Source: Microsoft, from happier days when Win10 phones were ready
In a recent blog post Microsoft explained some of their thinking behind the redesigned Office mobile apps like the new ‘all in one’ Office app. The company has done a lot of research into the way people use their mobile devices, including the many people who only use a smartphone
Pantone has announced its Color of the Year for 2020 here’s how to get it in Microsoft Office – Word, Excel, PowerPoint, Outlook etc. The color of 2020 is … Classic Blue Source: Pantone As usual what’s more amazing than the color is the description from the ‘Pantone Institute’. Classic
