We looked at the handy NetworkDays.Intl() function in Excel and mentioned that the Holidays parameter is a lot more complicated that it appears. Let’s look at how Holidays works and how it gets messy when faced with real world applications. Quick Recap of NetworkDays.Intl() Just to recap, NetworkDays.Intl() lets Excel
Arrays have more powerful options than simple Excel ranges but, happily, it’s very easy to convert a range of cells into an array. Or sometimes you have a mix of arrays and ranges that need to be managed as a collection of arrays. That’s what we’ve needed to make the
PowerPoint 365 is now able to create animated GIF’s from presentations. It’s a little limited but the basics are there, and we’ll explain how to get even more from ‘Export to Animated GIF’. Animated GIF’s have long been wanted in PowerPoint. They make simple animations or mini-videos which are widely
The plan to force Office 365 ProPlus users to Bing Search has come to a halt with Microsoft announcing a backtrack on their original ham-fisted plan. As we told you last month, they wanted to add a Microsoft Search extension for Google Chrome which also changed the default search engine
The ‘all in one’ Office app combining Word, Excel, PowerPoint with Office Lens and PDF support is now available for all comers with Android phones. Office Watch did a comprehensive look at the Office app back in November when it was available to insiders. Now it’s available to all at
Our award for ‘Unhelpful Office error message of the week’ goes to this remarkable effort in Word 365’s Read Aloud feature which is just the start of Microsoft’s uselessness. We were trying to demonstrate Read Aloud in Word 365 when this singularly useless dialog appeared! “Read Aloud isn’t available because
A new Office app for Android a single ‘all in one’ app for Microsoft Office. We’ve done our own look at the new app, not relying on Microsoft’s hype to check out the Home panel, Actions, Word, Excel and PowerPoint features, PDF viewing and options, ‘image to text’ features and
It’s too easy to start using the Archive folder in Outlook. Most likely all the setup is done, so you can start using it. If not, the setup is just a few clicks. Archive is a way to set aside selected messages away from the main Inbox or other folders.
For many mailboxes it’s not possible to rename the Outlook Archive folder. But non-Microsoft mailboxes can rename Archive to anything maybe ‘Miscellaneous’, ‘Store’ or just ‘Old Stuff’. In modern Outlook with Microsoft hosted mailboxes (Outlook.com, Office 365 hosted or recent Exchange Server) the Archive folder is an in-built folder like
Move a message to the Archive folder with any of the usual ways to move an item between Outlook folders plus three dedicated special options only for the Archive folder. See Starting with Archive in Microsoft Outlook Archive in Outlook 365 and Outlook 2016/2019 for Windows Archive button Most obvious is
Outlook has three features called ‘Archive’ with the newer versions (Archive and Online Archive) much better than older ‘AutoArchive’. We’ll explain the difference, how to use Archive and why to avoid AutoArchive. Each form of Archive sets aside older messages or emails you’ve finished with. It does that in two
Outlook for iPad gets split-screen support which goes a small way towards making the much-hyped app an effective tool for email, calendar and contact management. Sadly, no similar options for other Office Mobile apps. Source: Microsoft plus a little border cropping … According to Microsoft … “ Multi-task like a
Peter Deegan used to tell people that a simple digital watch could beat the crap out of the Apollo 11 lunar landing computer. And that was before modern smartwatches. He was wrong … It turns out that a humble USB-C charger has more ‘grunt’ than the rope memory computer on ‘Eagle’. Forest Heller
Microsoft has released some limited time, introductory offers for Office 365 subscriber. They’ll mostly interest parents or people wanting some digital learning. These aren’t permanent Office 365 benefits like OneDrive storage or Skype minutes. Microsoft calls these ‘Partner Offers’, in other words promotional, trial lures to joining (yet) another service.
One of the quiet improvements in Office is the regular updates to the Office dictionary used mostly in Word and Outlook but also other Office programs. They even handle new terms like Coronavirus or names such as Buttigieg. In olden days the main dictionary was only updated with major revisions
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
People are right to be angry at Microsoft for f….ing up just a simple search of their own computer. Here’s how to fix the problem, in case it happens again with the bonus that it stops Microsoft getting details of each search you make. The problem started when innocent Windows
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
