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.
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 Sequence() seems almost pointless. Here’s […]
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 other styles, including its partner […]
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 FollowedHyperlink Links have two modes […]
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 is most likely the type […]
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 the most popular pages on our […]
