Share a cloud stored document from Microsoft Office
Here’s how to share a Microsoft Office document that’s saved on a compatible cloud service like OneDrive or Dropbox. All you need is Office 365/2019 or 2016 for Windows or Mac. Document collaboration works in Word, Excel and PowerPoint. Sharing a single file via cloud storage is a lot faster and less trouble than exchanging […]
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 on either Windows or Mac. Side by Side or Split View is great for many situations. No fussing about switching between windows or getting lost with all the open application. For example, Word on one […]
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. Annabelle Almer started looking at NetworkDays() & NetworkDays.Intl() and we ended up deep down a geeky rabbit hole trying to get the functions working in realistic situations. The functions work, as advertised, but trying to […]
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 formula or some VBA code. We need a way to make a list of all the dates between a start and end date. Use this to make a list of all vacation days for a […]
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 frustrating experience of finding that as soon as you exit the cell, the zero disappears from the front of the number. Here’s how to stop Excel from ‘helping’ you when it’s not wanted. Because zero […]
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 promote Microsoft’s corporate agenda. We’ll explain what Microsoft has done and how regular Office users can make the Start Menu better. Make a Start Menu that suits you, not Microsoft. A new or reset Windows […]
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 enough, within a few days Office ‘all in one’ for iPhone and iPad is out. The app is a combination of Word, Excel and PowerPoint plus other tools into a single app. Individual Office apps […]
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 on fancy graphics but almost no useful information. There are lots of fancy colors, bouncing bubbles and even Office logos turning into balloons then exploding … all for no good reason. There’s more info in […]
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 Primary debate. It all started with Elizabeth Warren describing Pete Buttigieg’s health plan as ‘just a PowerPoint’. Buttigieg responded with the ad-lib that “I’m more of a Microsoft Word guy.” Which isn’t bad as an […]
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() and a request to Microsoft for an improvement in the function. NetworkDays() or NetworkDays_Intl() is OK if you only have to deal with one list of public holidays or one vacation. But in the Real […]
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 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 count the number of working […]
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() with less options. As usual, you can select the formulas tab and Excel will guide you through the process. From Formulas | Date & Time choose NETWORKDAYS.INTL . It will open a dialog box to […]
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 weekends (e.g. Saturday and Sunday) plus you can exclude public holidays and personal vacations. Most people read the function as ‘Network Days’ but it’s really ‘Net Work Days’. Figure out employee benefits from total working […]
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 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 NetworkDays() and NetworkDays_Intl() functions work […]
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 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 the Google Play Store. No […]
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 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 how to bypass a major […]
