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.
Baskerville has been decreed the most persuasive font after an experiment by Errol Morris and the New York Times. Happily, a very similar font is available to all Microsoft Office for Windows users. In an interview in Fast Company, Errol Morris talks about the experiment where people were asked to
Get started and understand Microsoft’s Power BI using the free desktop app. Here’s how to setup Power BI and some of its nifty tricks to delve into and make sense of data. All without the hassle of a ‘free’ trial. With plenty of buzzwords such as data-driven culture, business intelligence,
What causes blank spaces in the Word navigation pane and how to fix them. The Navigation Pane in Word shows the Headings in a document but sometimes has the unexpected. Blank lines or text not in a heading. But sometimes blank spaces appear, like between London and Paris above. Why
Insert the Checkered Flag 🏁 into Microsoft Word, Excel, PowerPoint or Outlook. Plus other alternatives available in modern Microsoft Office like icons or stock images. As its name suggests, the Checkered Flag emoji 🏁 shows a flag with a black-and-white checkerboard pattern. It’s often used to represent vehicle racing, challenges,
Any Excel worksheet that has lists with headings on the top row can quickly get pull-down menus to filter or sort the data. For a regular Excel worksheet, go to the Data tab and click the Filter button. This adds extra pull-down menus to each of the headings. For an
You can translate a Pantone PMS code or name into something Microsoft Office; Word, Excel or PowerPoint understands? Sometimes you’re given a specific color using the Pantone color scheme. Most commonly this happens for a corporate logo. The Ford car company specifies ‘PMS 294C’ for their blue logo. McDonald’s uses
As part of Word’s Autocorrect settings, some simple fractions will show as a symbol when you. For example, if you type in 1/4 and then space straight afterwards it’ll show as ¼. It’s done automatically from File | Options | Proofing | AutoCorrect Options | AutoFormat as you type |
Fractions like 1/2 1/4 3/4 can look better in Word and Outlook as ½ ¼ ¾ that can be done for other common fractions too ⅘ ⅚ ⅐ ⅛ among many. Either type directly with a shortcut or using AutoCorrect. We have a full table of the fractions available as
There’s an easy way to make a good looking symbol for any fraction, no matter how unusual it might be. There are symbols and shortcuts for common fractions but beyond that you need a little Word trickery. But not very tricky because all you need is on the Home tab.
Thumbs Down or Dislike 👎 can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Thumbs Down symbol 👎 or emoji is used to suggest disapproval or dislike. Partnered against Thumbs Up / Like 👍 symbol. How Thumbs Down Sign 👎
The serious Windows and Office security bug is now used to target organizations in Europe and USA. Despite plenty of warnings, Microsoft still doesn’t have a fix, just ‘mitigations’. Last week Office-Watch.com told you about “Follina, or CVE-2022–30190” a relatively simple hack that exploits a security bug in Microsoft’s own Microsoft
All you need is a birth date or starting date and Excel can figure out the age, next birthday, days to next birthday or when you reach a milestone like 10,000 or 15,000 days. That’s just some clever tricks with DateDif(). How old is someone or something? To calculate the
Here’s a quick look at some of the modest Excel tricks we used to make the Schengen Visa Calculation worksheet. Table Making the itinerary list an Excel Table lets us make use of some features. Formatting It’s a lot easier to format as a table with banded rows. We’ve turned
Our annual Microsoft Word vs the Spelling Bee Champions contest is on again for 2022. Word has done better than in the past but was still beaten by another extraordinary 14 year-old. 2022’s Spelling Bee Champ is Harini Logan, 14, from San Antonio TX who narrowly beat Vikram Raju a
A large security risk has appeared in Microsoft Word, a zero-day security problem which can infect even fully updated Word. Microsoft has taken at least 14 months and still hasn’t fixed the security hole. We’ll explain the problem and what you can do. It’s a relatively simple hack which takes
Sometimes you need to convert a date from the Excel cell saved format to a particular format. There are at least five ways to do that. DateValue(), Date() or converting Unix dates to Excel. Simply typing dates into a cell also works but there are traps for the unwary. Excel’s
Another way to convert text to dates is by adding zero to the text. This is a trick which forces Excel to convert the text into an Excel value so it can then add the zero. Since adding zero doesn’t change the value, you end up with text converted to
Excel has some nifty and simple options for color highlights the extremes in a list of values. It’s called Conditional Formatting and you can do all sorts of clever things with it. First let’s look at the simple presets that Microsoft has given us, some of the obvious choices they’ve
It’s easy to share appointment details with other people, whether they use Outlook or not. No need to type in appointments when you can send and receive the details right in your calendar. We’ll explain how it works for both sender and receiver (organizer and invitees) on various platforms, including
An IF statement might sound like a complicated thing that programmers do, but it’s actually fairly easy to do in Excel. An IF statement basically puts something into a cell depending on certain conditions – if A is true, put X in this cell. You can even use what’s called a nested
Windows 11 is getting a way to view your Microsoft 365, Office 2021 and Office 2019 licence details within the Windows Settings app. At Windows Settings | Accounts | Your Microsoft account … it shows a lot of the details from the Office.com account web pages. Windows 11 for Microsoft
The Elizabeth Line (aka Crossrail) is now open in London, a major new tube line crossing the city. Here’s the roundel and color scheme for the new line in a format ready for Word, PowerPoint and Office. The same design elements can be used for any other London Tube line
Type the fun Otter 🦦 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Otter 🦦 emoji represents a light-brown otter (a member of the weasel family) on its back with its paws held together. But the emoji can just be used
OneNote is finally getting the Office Dictation (speech to text) feature that’s already in other Office programs. That’s in addition to the long-standing Look for Dictation in OneNote for Windows Home tab, way off at the right-side. Also, in OneNote in a web browser … Dictation and Read Aloud in
