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.
Thinking Face 🤔 emoji in Word and Office
Insert the Thinking Face 🤔 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Thinking Face 🤔 emoji has several other names; Thinker, Throwing Shade, Chin Thumb, puzzled and skeptic. How Thinking Face 🤔 looks in different fonts. Here’s some examples of how Thinking Face 🤔 looks in common Office fonts. Thinking Face 🤔 codes These are the important code numbers […]
Make your own live Olympics medal tally in Excel
Our readers and supporters can now download a free Excel workbook which imports the latest Tokyo Olympics medal tally into Excel. All you need is a recent Excel for Windows with Get & Transform – Excel 365, Excel 2019 or Excel 2016 for Windows. (Alas, not Excel for Mac). There’s a simple table of the […]
Check out Sound Bible for your PowerPoint decks
Sound Bible has some useful, free music and sound effects that can jazz up a PowerPoint presentation. There’s a collection of free audio clips (various rights limitations) from here. In WAV or MP3 format, both compatible with PowerPoint. Many of the text labels are deliberatly bland to avoid copyright disputes. For example Cowboy Theme is […]
Wildcard Find tricks in Microsoft Word
The wildcard is an advanced finding feature that has some powerful options beyond the standard * and ? options for Word. What Word calls ‘wildcard’ is really Regular Expressions, or at least a version of RegEx. Beginning or end of a word The beginning of a word can be represented by the “less than” symbol […]
Excel’s better Average(), try TrimMean() instead
TrimMean() function is a slightly different and useful measure than the regular Excel Average(). It’s still an average/mean but without the high and low, extreme or outlier values in the list. Average() (and its partners AverageA() and AverageIFS() use all the values in the array or list provided. TrimMean() excludes the highest and lowest extreme […]
Microsoft Word vs the 2021 Words of the Champions
How does Microsoft Word’s spell check go with the 2021 Words of the Champions list from the US annual spelling bee? Each year the Scripps National Spelling Bee releases a Words of the Champions study list to educators, featuring up to 800 new words. We grabbed a selection of the most difficult words (called “Three […]
Weary / Distraught face 😩 emoji in Word and Office
Type the Weary / Distraught face 😩 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Weary / Distraught face 😩 emoji is also called Wailing, Frustrated or Sadness. How Weary / Distraught face 😩 looks in different fonts. Here’s some examples of how Weary / Distraught face […]
Fast Word shortcuts for increase/decrease font size
Microsoft Word seems to have two pairs of shortcuts that do the same thing – increase or decrease the font size. This is how they are different. The shortcuts are: Ctrl + Shift + < or Ctrl + Shift + > – which are also buttons on the Home tab. Ctrl + [ and Ctrl […]
Office shortcut of the Week – 2005 compendium
The Office Watch “Shortcut of the Week” tips for Outlook, Excel and PowerPoint from 2005 in the one convenient place. Tip 1 – Outlook navigation The Outlook navigation shortcuts could be more intuitive but here they are: Switch to Mail CTRL+1 Switch to Calendar CTRL+2 Switch to Contacts CTRL+3 Switch to Tasks CTRL+4 Switch to […]
Office 2007-Office 365 – new look – same shortcuts
Office 2007 and later to Office 365 not only has keyboard shortcuts but in many ways they are better than previous versions of Microsoft Office. For the most part the shortcuts used in Office XP and Office 2003 still work in Office 2007 through 365 also – despite the very different look of the screen. […]
Office shortcut of the week – 2004 compendium
We place all of the “Shortcut of the Week” tips from 2004 in the one convenient place. Tip 1 – Undo The Undo function has become especially important over the years as Microsoft puts more ‘intelligence’ into their products. Sometimes it ‘corrects’ your spelling or re-formats something you were quite happy with, thank you very […]
What’s going, going and gone from Windows 11
Any major Windows or Office update focuses on the new and changed stuff. Inevitably, there are also items removed or ‘deprecated’ (meaning they won’t be improved and will eventually be removed). See all the Office-Watch.com coverage of Windows 11 Windows 11 removes or moves quite a few features, some are a little surprising. Internet Explorer […]
PrintNightmare – what it is and what you must do now
The latest and serious Windows security bug is called ‘PrintNightmare’. We’ll explain what it is, how serious the bug could be, what you should do about it balancing the ‘known unknowns’. UPDATE: Almost as predictable as the sun rising … the PrintNightmare patch caused problems for some Windows users. The July 2021 monthly security update […]
How Microsoft Word was beaten by a 14 year-old
Our annual Microsoft Word vs the Spelling Bee Champions contest has returned for 2021. Word has done better than in the past but was still beaten by an extraordinary 14 year-old. Here’s the list of words used in the final rounds, (rounds 10-18) of the Scripps Spelling Bee as they appear in Word 365. In […]
Fire 🔥 symbol in Word, Excel, PowerPoint and Outlook
Type the Fire 🔥 symbol or emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Fire 🔥 emoji has many names like Hot, Lit, Flame and Snapstreak How Fire 🔥 looks in different fonts. Here’s some examples of how Fire 🔥 looks in common Office fonts. Fire […]
50 first dates with Excel
Excel isn’t just for budgets and number crunching, you can use it for making lists and even organizing your love life! Lisa used Excel to find her True Love. She listed all her dates in Excel with details somewhat like this… Excel, combined with some personal rules. eventually led her to that special someone. Hear […]
