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.
There are two official document standards – why?
Here’s what you need to know about the two official international document formats, Microsoft’s OpenXML (.docx .xlsx etc) and Open Document Format (.odt .ods etc) both supported in Microsoft Office and most other office suite software. Each format has been recognized by international bodies so there are two ‘official’ document standards for Planet Earth. Both […]
Make a new Office file within Microsoft Teams
Not only can Teams share Word, Excel or PowerPoint files, but you can also make new documents right in Teams or upload existing documents. Create a New File You can easily create a new file within Teams for Word, Excel, PowerPoint or OneNote from the New pull-down list at left. Or make a new folder. […]
How to Filter Data in a PivotTable
Excel’s PivotTable allows you to evaluate trends, comparisons, and patterns within datasets. Once a PivotTable is setup, you can filter “Drill down” into it to focus on key information. These days there are several ways to filter a PivotTable, Slicers (which Microsoft loves to boast about), AutoFilter and by Field List. All these options mean […]
Warning! Older Outlook soon stop links to Microsoft mailboxes
Soon older versions of Outlook won’t be able to connect to Microsoft hosted mailboxes, even though both the software and service come from the same company. Here’s what’s happening, why, who is affected and what to do. Microsoft is finally ending older, insecure, ‘Basic’ authentication connections to their Microsoft 365 mailboxes including Outlook.com. The change […]
How to open Office files with Microsoft Teams
Teams makes it simple to share files and collaborate. If you are working with Word, Excel, PowerPoint, or Visio files, your coworkers may read, edit, and collaborate on them directly from Teams. The different ways to open a document in Teams. Files Access Within Microsoft Teams, each Channel has a Files folder where you can […]
Share and collaborate on Office files with Teams
Teams makes it simple to share files and collaborate. If you are working with Word, Excel, PowerPoint, or Visio files, your coworkers may read, edit, and collaborate on them directly from Teams. Co-edit files Each team member has access to files that have been uploaded and shared on Teams. You and your team members can […]
Free ways to convert WAV and other formats to MP3 audio for PowerPoint
Simple, easy and free ways to convert audio files like WAV, FLAC and many others into a format that PowerPoint or your smartphone prefers such as MP3, MP4 or AAC. The BBC Sound effect downloads are in WAV format. That’s a good, high-fidelity and uncompressed format that works in PowerPoint for Windows but it also […]
Make Outlook’s spam filter allow Office Watch newsletters
How to stop your Office Watch newsletters going to the Junk E-mail folder. To make sure your Office Watch newsletters don’t end up in your Junk Email folder you need to set us up as a ‘Safe Sender’. Here’s how to do that in Outlook. Keep in mind that Outlook software is NOT the primary […]
Can your computer run Windows 11 properly or at all?
The hardware requirements for Windows 11 are surprisingly high especially the increased security requirements. Some brand-new computers, even Microsoft’s own high-priced Surface computers bought today might not be compatible with Windows 11. See all the Office-Watch.com coverage of Windows 11 Unlike previous major Windows releases, you can’t assume that a recently bought computer will be […]
Why font selection is important for lawyers
If you think font selection is hard, spare a thought for lawyers who have to deal with different official rules, recommendations and accepted practice for court submissions. Jason Steed at JDSupra sets out the complications for US lawyers. The D.C Circuit court started ‘discouraging’ use of Garamond font but no change in the actual rules. […]
Clever ways to use Checkboxes in Excel
Now you know how to insert checkboxes in Excel, here are some ways to use check box cells in Excel. Counting the checked/unchecked boxes, calculate percentage checked and even showing a separate list of items based on their checked status. A cell with a check box has two values: TRUE – checked FALSE – UNchecked You can use the values […]
Office now supports ODF version 1.3 documents
Microsoft has updated the Office programs to support the OpenDocument format (ODF) to version 1.3. Most people use Office Open XML format (OOXML) which is the official name for what is usually called the ‘new’ Microsoft Office formats, .docx .xlsx .pptx etc. OpenDocument files .odt .ods .odp etc are also supported in Office 365 and […]
OneDrive sync ending soon for older MacOS
OneDrive on Mac computers won’t be supported on older macOS from mid-September 2021. The latest macOS and last two releases will continue work and be supported. Microsoft’s general policy for supporting Office on Mac computers is to support the most recent version of macOS and the two versions before that. So, from time to time, […]
Document collaboration with Office in a browser
Here’s how to collaborate on a ‘live’ file (Word document, Excel workbook, PowerPoint deck or OneNote notebook) saved on OneDrive or other cloud service. It’s part of our series on accept a sharing request and collaborating on a ‘live’ document saved online. Microsoft spends a lot of energy getting people to share documents, but little […]
How to accept an Office document share or collaboration
Microsoft spends a lot of time explaining how to share a file (Word document, Excel workbook, PowerPoint deck or OneNote notebook) but very little on how to accept a sharing request and collaborate on a ‘live’ document saved online. Live or real-time collaboration lets two or more people work on a document (Word, Excel, PowerPoint […]
Make your own wedding stationery in Word
Save-the-date cards, invitations, place cards and other wedding paperwork can be made in Word. Reduce stress and expenses, by creating your invites digitally through Word. Creating your own invites is a great approach, adding a personal and unique touch to proceedings. Usually, you’ll find Wedding Invites are in A5 size. Simply open your new document, go to the Layout Tab | Size | A5. […]
