” How can I enter a duration in Excel with the format days:hours:minutes:seconds ? If I enter 5:32 Excel converts that to 5:32am but I want to record 5 hours and 32 minutes.” Time durations aren’t very clear in Excel, but they are possible. The time features are mostly aimed
Microsoft hasn’t had a good week with their hosted email with two breakdowns of Exchange Online and Outlook.com services. One stopped emails in and out, the other prevented messages from being read. Both Exchange Online (Microsoft 365 hosted email) and Outlook.com run on the same or very similar systems. Usually
Flipgrid now joins YouTube, Vimeo, Stream and SlideShare as supported services for PowerPoint online videos. Microsoft’s Flipgrid is an education service for teachers to record videos to share with a class. Students can respond with their own recorded video segments. Drawing, text, emoji and other rich media are available for
A much-wanted feature is coming to PowerPoint, the ability to lock an object into position so it can’t accidently be moved out of place. Objects in a slide can too easily move out of place with an accidental tap of a mouse or finger. The problem is even worse with
Use Sequence() to get an ordered list of numbers either increasing or decreasing and with your choice of increments. Sequence is possibly the least understood of the dynamic array functions but combined with other functions it greatly extends Excel’s power. Sortby(), Filter(), Unique() and RandArray() all have obvious uses but
There are a few strange, non-standard, behaviors to the FollowedHyperlink style that Word uses for visited links. FollowedHyperlink is a hidden style which Word uses for any link which has been clicked or visited by the current user. Because it’s automatically applied it has some peculiarities that don’t apply to
Word has special styles for hyperlinks which you can change from the standard blue, underlined look. Word link styles have some special behaviors to keep in mind. Word links can look very different or appear no different to regular text. All these are hyperlinks, believe it or not. Hyperlink and
About the RAND() function to make random numbers in Excel plus related functions RandBetween() and RandArray() plus some tricks for getting whole numbers only and even rolling ‘dice’ made in Excel. By Michael Barden Typing the =rand() function into a cell in an Excel spreadsheet will return a random number
A reader asks about sabotaging a random number generator. Steven H writes … The article on randomness in Excel was quite interesting, and the link to random.org was neat. Two thoughts come to mind almost immediately though: If you have an application where you absolutely need true random numbers, it
With Random.org you can get truly random numbers for Excel plus options not available in the spreadsheet program like random but unique numbers with no repeats and random dates. Using ‘True’ Random numbers in Excel Our article on Random Numbers in Excel continues to surprise us by being one of
Bahnschrift is a Windows font which is a little special and not fully compatible within Office. We’ll explain why it’s special, the extra care needed and the workaround. While it’s listed as an Office Cloud Font, Bahnschrift was originally included with the 2017 ‘Creators’ update of Windows 10. So, it
There are two a simple ways to make a list of unique or non-duplicate entries from a longer list. Unlike the many automatic ‘unique’ options in Excel, these options work only once but it’s available in many Excel releases, old and new. Advanced Filter One is hiding at Data |
Since we’re talking about Star Wars, how does Microsoft Office 2016 for Windows handle the words and names from the famous films? A mixed bag. Most of the common names are in the MS Office dictionary but some surprising omissions. The evil Emperor isn’t included. Planet Tatooine has a major
Coming to Microsoft 365 for Windows is the Subscription Benefits Center, a new way to introduce innovations in Word, Excel, PowerPoint and Outlook. It appears as a diamond icon at top right. That opens a pane over your existing document with three tabs, Home, Apps & Benefits and Premium Features.
The new Unique() dynamic array function doesn’t let you do anything new in Excel, but it makes a once-complicated task into simplicity itself. Unique or distinct, no-duplicate lists, counting and sorting the results are all possible with easy formulas that won’t confuse. For as long as there’s been Excel, people
Excel’s Unique() function itself can’t show distinct values that appear more than once in a list. Repeated only items in a distinct list are possible with a simple extended formula. We’ve already shown the basics of Unique() either getting a list of Distinct values or values that only appear once
Microsoft has decided that Calibri is getting a little tired, so it’s asking customers to vote on which font will replace it. Calibri has been the default font since Office 2007. It’s familiar to most people whether they realise it or not because it appears in many Word documents. The
The new iOS 14.5 has hundreds of new emoji but beware using them in emails and documents because they can look very different on other computers. We have examples of how a simple emoji can look very different in Word or Outlook. The new version of iOS for iPhone and
Thanks to Office-Watch.com reader, Pierre B. we can tell about a good deal on Microsoft 365 Personal or Family, now available from Amazon in Canada. Microsoft 365 Personal cheaper The usual price for Microsoft 365 Personal (12 month, one user) is CDN$79.99, but Amazon.ca has it for CDN$48.99. Here’s the
Microsoft is updating their Services Agreement, the rules we call agree to live with when using Microsoft’s many services. We found a few interesting things in the changes. The Summary of Changes to the Microsoft Services Agreement is mercifully short. Compared to full agreement of over 15,000 words which is
Excel 365 for Windows is getting another option for importing data into PowerQuery, from a dynamic array. In many cases the original data source could be imported, sorted and filtered in many different ways. Importing a existing dynamic array is a useful extra trick for us Excel nerds. We can
Learn how to create live, dynamic sorted lists in Excel using the powerful combination of Sort()/SortBy() and Filter() functions. In Excel 365 and Office 2021+ dynamic array formulas like FILTER() let you extract a subset of data — and by wrapping that result inside SORT(), you can instantly sort the
Suggested Replies are coming to Outlook 365 for Windows. As usual, there are details that Microsoft has ‘forgotten’ to mention but we at Office Watch aren’t so forgetful! In the Outlook reading / preview pane, possible replies can be displayed. Or Microsoft’s cloud systems have scanned the message and offered
The new spelling, grammar and other suggestion Editor can now be used with selected text, not just the whole Word 365 document. It’s a little change but an important and useful one. Select a block of text, right-click and choose ‘Review selection in Editor’. Selecting text for the Editor is
