Multiple Holiday lists in Networkdays()
Here’s a limited solution to the problem of excluding multiple holidays or vacation lists to use in NetworkDays() or NetworkDays_Intl() Read More
Office for Mac
Using NetworkDays.intl to count working days step-by-step
Here’s a step-by-step example of Networkdays.Intl() in an Excel worksheet. We suggest using that improved function over the older NetworkDays() Read More
Count your working days in Excel with NETWORKDAYS()
The NETWORKDAYS function in Microsoft Excel will calculate the number of working days between two dates. It will automatically exclude Read More
Excel merge arrays into a single array with VBA
One annoying omission from Excel and VBA is a simple way to combine various arrays into a single array. It’s Read More
PowerPoint makes animated GIFs of your slides
PowerPoint 365 is now able to create animated GIF’s from presentations. It’s a little limited but the basics are there, Read More
Use Icon/SVG as Bullet in Word list
It’s possible to use an Icon or SVG graphic as a bullet mark in Word or PowerPoint, you just have Read More
Starting with Archive in Microsoft Outlook
It’s too easy to start using the Archive folder in Outlook. Most likely all the setup is done, so you Read More
Rename the Outlook Archive folder
For many mailboxes it’s not possible to rename the Outlook Archive folder. But non-Microsoft mailboxes can rename Archive to anything Read More
Manually moving Outlook messages to Archive
Move a message to the Archive folder with any of the usual ways to move an item between Outlook folders Read More
About Outlook Archive, Online Archive and AutoArchive
Outlook has three features called ‘Archive’ with the newer versions (Archive and Online Archive) much better than older ‘AutoArchive’. We’ll Read More
Line Ends on Dashed Picture Borders in Word and PowerPoint
One of the more obscure settings when putting a frame around a picture in Word or PowerPoint is the Cap Read More
Picture Frame Corner Types in Word and PowerPoint
Join Type is what Microsoft calls the corners of the picture frames – the place where the horizontal and vertical Read More
Special Offers for Office 365 customers
Microsoft has released some limited time, introductory offers for Office 365 subscriber. They’ll mostly interest parents or people wanting some Read More
Coronavirus, Buttigieg and other topical words in Word & Office
One of the quiet improvements in Office is the regular updates to the Office dictionary used mostly in Word and Read More
Multi-Line Picture Borders in Word or PowerPoint
Word and PowerPoint have some great ways to add a border or frame around an image, graphic or logo. We Read More
Office Picture formatting tricks – Fit, Fill and Positioning
Hiding in plain sight are some useful tricks for picture formatting within a shape. It’s possible to fit or fill Read More
Transparency Color problem and fix for Microsoft Office
The picture option ‘Set Transparency Color’ doesn’t always work properly in Microsoft Office. We’ll explain the problem and suggest some Read More
Make a transparent shape to mask a photo in Word, PowerPoint and more
Here’s how to mask a photo with any Microsoft Office shape or icon and do it with full control over Read More
Three ways to crop a picture with an Office shape
Here are three options for putting a photo inside any Microsoft Office Shape or Icon (Word, Powerpoint etc.). Photographers call Read More
PivotTables ebook extra now available
Our ebook PivotTables and PivotCharts from scratch now has a bonus extra for all readers, new and existing. Our Subscriptions Read More
Office Watch
Office for Mere Mortals
Twitter
Facebook
Instagram