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.
XMatch() function in Excel locates an item in an array or range of cells, then returns its position relative to the item. It’s similar to XLookup() which returns the cell value while XMatch returns a relative position in the array. Syntax =XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) Arguments Lookup_value – the value to find. Lookup_array
Excel can use past data to project possible future results with the Forecast feature. It’s a very simple version of statistical ‘modelling’. The Forecast function will let you predict future values and data trends, such as consumer trends, future sales and or inventory needs, based on seasonality. Here’s a simple guide on how to use the Forecast feature. Although
Previously we talked about How to add a Drop-down List in Word, but you can also work more efficiently in Excel worksheets by making use of drop-down or pull-down lists. We will show you how to use Microsoft Excel’s data validation function to create useful lists within your spreadsheets. How to avoid the trap that lies waiting for the unwary
In addition to the general Office 2021/LTSC features there are some useful additions to Excel 2021/LTSC including the dynamic array functions, improved XLookup()/XMatch() and Let() but sadly no Lambda(). All these features are in Excel 2021 and Excel LTSC for both Windows and Mac in addition to the overall updates
In addition to the general Office 2021/LTSC features there are some useful additions to Outlook 2021/LTSC including a better search box, translation of emails. See all about Office 2021 for Windows & Mac plus The good and bad in Office LTSC Here’s what’s new/changed in Outlook 2021 in addition to
In addition to the general Office 2021/LTSC features there are some useful additions to PowerPoint 2021/LTSC including recording presenter videos and changing the reading order for accessibility. See all about Office 2021 for Windows & Mac plus The good and bad in Office LTSC Here’s what’s new/changed in PowerPoint 2021
There’s another way you can force a page break before a paragraph in Microsoft Word. By setting this up, the page breaks can automatically appear without you having to worry. This is particularly useful if you have long documents with several different headings. Just simply modify the style to include
Microsoft has publicly released Office LTSC or Long Term Servicing Channel. It’s the ‘fixed feature’ Office suite for volume licence customers. It’s a replacement for Office 2019 but only available to business and government customers. Office 2021 is the personal and small business equivalent which will be out on 5
Interactive checkboxes can easily be added to your Word document for a variety of uses. Perhaps you need to create a to-do checklist to help monitor the completion of tasks on top of a collaboration document, or make it simpler for users to read and complete surveys or forms. Either way, we will provide
Microsoft has released a patch for the MSHTML security bug that’s being used with Office documents to infect computers. The bug is in MSHTML, the browser rendering engine used by Microsoft Office. If someone is tricked into opening a hacked Office document with ActiveX control, they could infect their computer
There are many API’s available on the Internet that can provide great and timely data in ways that Excel can understand, here’s how you can do it. We’ve recently received emails asking how to use Excel to import data from specific API’s. Always we have the same answers because most
Outlook’s Folder Pane displays all folders which lets you quickly move between folders and views. Minimise the Folder pane, you will no longer be able to see your folders. As a result, some users get puzzled as to how they can bring back the expanded Folder Pane view. There are a few ways that
Printing email messages is something that we all do at various times, and in theory it should be as simple as clicking the Print icon in your email program – but what if the message won’t print out properly? Sometimes the printed version of an email message (or web page)
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
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.
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
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
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
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
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
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
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
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
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
