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 365
Excel’s NetworkDays() and Holidays in the real world
We looked at the handy NetworkDays.Intl() function in Excel and mentioned that the Holidays parameter is a lot more complicated Read More
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
Excel convert Range to Array in VBA
Arrays have more powerful options than simple Excel ranges but, happily, it’s very easy to convert a range of cells 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
Microsoft backtracks on forcing Bing into Office 365
The plan to force Office 365 ProPlus users to Bing Search has come to a halt with Microsoft announcing a 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
Office ‘all in one’ app now on Android
The ‘all in one’ Office app combining Word, Excel, PowerPoint with Office Lens and PDF support is now available for Read More
Unhelpful Office error message for Read Aloud
Our award for ‘Unhelpful Office error message of the week’ goes to this remarkable effort in Word 365’s Read Aloud Read More
Inside the Office ‘all in one’ app for Apple and Android
A new Office app for Android a single ‘all in one’ app for Microsoft Office. We’ve done our own look Read More
Difference between ‘Pickup where you left off’ and GoBack ‘Shift + F5’.
Microsoft Word’s ‘Pickup where you left off’ or ‘Welcome back’ message is different from the Shift+F5 shortcut. All the recent 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
Outlook for iPad gets split screen support
Outlook for iPad gets split-screen support which goes a small way towards making the much-hyped app an effective tool for Read More
Office Watch
Office for Mere Mortals
Twitter
Facebook
Instagram