A better Side-by-Side document view for Windows and Mac
We highlighted Word 365’s Side to Side view but there’s another side-by-side viewing trick that works for any two windows Read More
Complete Excel NetworkDays() solution with holidays & vacations
Excel’s NetworkDays() and NetworkDays.Intl() need more help to cope with realistic situations with public holidays and more than one vacation. Read More
Excel making list of days between two dates
Making a list of all the days between two Excel dates is possible in various ways, manually, an Excel 365 Read More
Enter Numbers Starting with Zero in Excel
If you’ve ever tried to enter a number starting with zero into an Excel spreadsheet, you will have had the Read More
Fixing Office confusion and other hassles on Windows Start menu
The Start Menu on a new Windows 10 has Microsoft Office icons which are badly labelled, misleading and setup to Read More
Office all-in-one app for Apple iPhone and iPad
Last week we said it would not be long before Microsoft released their Office app for Apple devices and, sure Read More
Office ‘All in One’ Mobile app – the video!
Microsoft has released a video to promote the Office Mobile ‘all in one’ app for Apple and Android. It’s big Read More
Pete Buttigieg – a Microsoft Word guy
Apparently nothing can escape the touch of US politics*. Even Microsoft Word and PowerPoint got dragged into the latest Democratic Read More
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
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 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
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
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
Xlookup now available for all Excel 365 platforms
Xlookup is now available across all the Excel programs and apps, making it a viable alternative to Vlookup/Hlookup for Office Read More
