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.
Character Map is a Windows feature that’s very useful for Microsoft Office users. It lets you insert symbols and, importantly, find them which is not possible within apps like Word. Windows Character Map has been around for as long as we’d like to remember and it’s mostly done right. If
Google has a color selector among the many features in their home page. It’s free, works in any browser and it’s easy to copy color codes into Office. Search for ‘Color picker’ or https://www.google.com/?q=color+picker then move the two circles to choose the exact color and shade you want. The HEX
Gridlines are on every spreadsheet in Microsoft Excel workbooks. Did you know those grey lines can be colored to make them fancy, more obvious or more discreet? Let’s look at two ways you can make colored gridlines in Excel. Here’s what it looks like with the pink, black and red
Microsoft Word can generate a list of all the images, graphs, tables or equations in a document – called a Table of Figures. Just like a table of contents, this list can include page references or links to each figure or picture. A Table of Figures can be useful for
Word has settings to automatically change the case of words that you type, fix common capitalization typing problems add items of your own to have capitalized the way you want them as you type. Word also has options to manually Change Case in Microsoft Word. The settings are in the
Styles can be saved in a Word document but are most effective when saved in a template. Changing the style in a template will affect any document that uses the same template. At the bottom of the Modify Style dialog are two choices for where to save the style. Microsoft
Here’s how to make a lookalike for the Law & Order TV show title card in either PowerPoint or Word. Last week we showed how to make the Law & Order opening screen image and how to use that look in slides or documents. Many readers asked why Office-Watch.com didn’t
One way to open a PowerPoint presentation could be to copy the opening of the Law & Order TV shows. Here’s how to get the same look in your PPT slides or Word documents plus the distinctive sound. The same formatting can be used in Word, maybe as a callout
Sometimes a document can’t be edited in Teams for no good reason. Here’s some things to try and workaround the problem. Teams uses SharePoint to manage documents and sometimes the technology doesn’t behave the way it should. A document that you should have full access to, can only be viewed.
Here’s how to convert an older .doc .xls or .ppt into a safer and smaller .docx .xlsx .pptx even if you don’t have Microsoft Office. Any smart computer user is wary of documents received in the old .doc .xls .ppt formats because they are regularly used to transmit viruses. The
Flash Fill is a simple way to split and join text automatically in Excel for Windows or Mac. Flash Fill was added in Excel 2013 for Windows. It’s both useful and looks good in the demonstrations. In Excel there’s often need to join, separate or reformat strings of text. Flash
How to add footnotes just below a photo in Microsoft Word The trick is similar to adding Footnotes to a Word table. Use Endnotes, instead of Footnotes (assuming you don’t use Endnotes elsewhere in the document). Add a Continuous Section Break and change the Endnotes settings to put them at
Moving the selected lines/s to a different numbering level in Microsoft Word is officially done from the Numbering Gallery | Change list level but there’s are quicker keyboard shortcuts. The faster way to do this is shortcuts: Alt + Shift + RIGHT arrow Down / right one level Alt +
Microsoft Excel Series allows users to automatically insert a list or series of values. You probably know the easy ‘drag and drop’ method but there’s a lot more possible with linear, growth, dates and autofill. All possible with the fill handle or with more control via the Series dialog. Whatever
Inserting an .ics iCalendar item into Outlook is typical Microsoft Office. Seemingly easy if you believe the simplistic ‘help’ from Redmond but a little more involved in practice. iCalendar .ics files are small text files which contain an appointment or event. It’s a common standard so they can be used
Type the Pound Sterling £ currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. £ symbol is easy on a UK keyboard but for other keyboards there’s no specific key for Pound. Pound is used for British Pounds Sterling and also
Immersive Reader, as seen in Word and older versions of OneNote, is returning to the latest releases of OneNote It’s a worthwhile tool to use, designed for those with dysgraphia or dyslexia, but perfect as well for those wanting to improve their reading experience. Here we’ll be using OneNote for
Excel has an Accessibility Ribbon to help you make changes to ensure that worksheets are easier for people with disabilities to read and edit. For some time, there’s been a Check Accessibility feature on the Excel Review tab. That opens a side-pane with suggestions for improving the worksheet. Go to
“You say Kiev, I say Kyiv” for the capital of the Ukraine. How does Microsoft Word handle the different spellings and how to pronounce the name with Read Aloud. See also Ukraine flag & colors in Word, Excel or PowerPoint Is it Kiev or Kyiv? Kyiv is the Ukrainian spelling
It’s vexing that the numbering features in Word aren’t all in the one place. Instead they’re spread across different dialog boxes including “Adjust List Indents … ” and “Set Numbering Value…”. Those two bland names hide some useful Word tricks. Numbering can also be set as a style. The main
Word has at least seven in-built numbering for common uses in documents, some that you know and appear automatically with others hidden away and little understood. We’ve told you about Word Numbered List tricks and Hidden Numbering options in Word plus Faster Numbered and Multi-Level Level changes Headings have numbering options at
There’s more to making subtitles for a PowerPoint (or any) video. Converters from .srt subtitles, using Microsoft Transcribe or using online tools to make your own subtitles from scratch. Webvtt vs Srt files Webvtt files (used by PowerPoint) are similar to the standard .srt subtitle files (used by Windows Movies
Insert the Black Chess King ♚ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Black Chess King ♚symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. Or perhaps as general symbol of
You can combine Excel cell formatting into a style, but not like in Word. Excel has Styles … truly it does. Word has a way to combine formatting attributes of a letter, word or paragraph into a single block with a name like ‘Heading 1’. Excel has a feature also
