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
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.
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
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
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.”
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
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
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
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
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
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
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
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
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
Find and add the New Zealand national flag and alternatives into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help applies for any other national flag, just look for a different source. Get the New Zealand Flag Image There are many, many copies of the New Zealand flag available. We’ve opted for the Wikipedia
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.
Xlookup, the vast improvement on Vlookup/Hlookup is now available on Excel Mobile for iOS (iPhone/Ipad) and Android. This is great news because it means Office 365 Windows/Mac workbooks can be fully compatible with Excel on mobile devices. You can create or edit formula with XLookup() and refresh existing data that
Get a hi-res version of Canadian National flag into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help applies for any other national flag, just look for a different source. Get the Canadian Flag Image There are many, many copies of the Canada flag available.
Here’s some more detail about the Excel Subscriptions Manager, how it’s put together, what you can change and extras to consider. See also Starting with the Excel Subscriptions Manager about how to setup the spreadsheet. Table The whole thing is an Excel Table cunningly called Subscriptions. Formatting, especially alternating row shading
Here’s what to do once you’ve downloaded our Excel Subscriptions Manager to organize the many subscriptions now available. After opening there’s a few things to do first: Currency prefix Change the currency if $ doesn’t apply e.g. change to STG ₤, Euro € etc. We’ve made that easy with two
It’s the Chinese Year of the Rat, to celebrate in Word, PowerPoint or Office generally is easy with an Icon or Online Pictures search. Not interested in the Chinese New Year? These same tips apply to many other events or festivals. Rat Icon Insert | Icons has many graphics including
