Office 2021 is the personal and small business ‘perpetual licence’, non-subscription version of Microsoft Office. For Windows and Mac.
Office LTSC (Long Term Servicing Channel) is the volume licence ‘perpetual licence’, non-subscription version of Microsoft Office for organizations, companies and governments. Also for Windows and Mac.
The features in Office 2021 and Office LTSC are very similar, if not the same.
Hyphenating words in Word has many choices; manual, optional, compulsory (non-breaking) and fully automatic. Manual Hyphen The simple one we all know. Type the – on the keyboard (properly known as the Hypen-Minus) to hyphenate a word, e.g. choreo-animator. See Of hyphens, em-dash, en-dash and more Automatic hyphenation Word will
Here are four different ways to make a new email from an Outlook template file without the hassle of going deep into Outlook’s menus. You can choose to start a template based message from Windows or a button inside Outlook. See Email templates give you faster messages in Outlook for
Here’s how to add a taste of the logo or text from ‘Friends’ sitcom to a Word document, PowerPoint slide or other document. That includes the important dots between letters. All you need is available online plus a little Office trickery. Note for old-timers (like Peter, our Editor-in-Chief). ‘Friends’ was
For emails that you send regularly, there’s a way to have a ‘boilerplate’ email template with most of the details already filled in. Messages can be sent faster and be more consistent. Welcome to the little-known world of Outlook email templates. Outlook email templates can have all the message details
Microsoft promotes OneDrive as protection against ransomware however our tests show it’s not always as practical or complete as the company boasts. One recovery feature works fine but the other isn’t complete. While updating our book Everyday Backups, we tested the OneDrive ransomware protections, not taking Microsoft’s word about how
How to insert the Psi upper case Ψ, and Psi lower case ψ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Psi (uppercase Ψ / lowercase ψ) is the 23rd letter of the Greek alphabet. The symbols are commonly used within physics to
Insert the Xi upper case Ξ, and Xi lower case ξ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Xi (uppercase Ξ / lowercase ξ) is the 14th letter of the Greek alphabet. The symbols are used within various contexts. The uppercase letter
” 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
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 |
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
Let’s put together two dynamic array functions to get even better ‘live’ sorting. So far we’ve look at the two main Dynamic Array features in Excel 365 (and Office 2021/LTSC), Sort()/SortBy() and Filter(). Filter() can be combined with Sort() to make a sub-set of the original list/table but in whatever
Your first look at Office 2021 for Mac with Word, Excel, PowerPoint and Outlook, which is now out in public preview, showing off some of the new features. There’s only a Mac Office 2021 preview, no Office 2021 for Windows preview. Perhaps because there’s a few more innovations in a
A public preview of the next perpetual licence Microsoft Office is now available. Called Office LTSC (Long Term Servicing Channel) it’s for volume customers only. Here are the options and how to get the preview. Office LTSC is the clumsily named non-subscription version of Office for organizations with volume licence
Here’s a first peek at Office LTSC for Word, Excel, PowerPoint, Outlook, Access, Publisher and OneNote which is now out in public preview showing off some of the new features. Office LTSC in it’s current preview is underwhelming, to put it mildly. But that’s what Microsoft is aiming for. Office LTSC
Filter is another Excel 365 dynamic array formula that’s really useful and far better than similar options in earlier versions of Excel. Just like SORT() and SORTBY(), FILTER() refreshes automatically whenever the source values change. The older pull-down filter and sort choices don’t update properly. Dynamic Arrays also give you
In late 2018, Excel 365 got an important new feature, Dynamic Arrays . Here’s a simple way to use the feature to make your workbooks sort better and automatically. It also fixes a long-standing problem in Excel. We’re going to focus on a very simple and useful part of dynamic
