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.
Making unique (not duplicated) list in Excel is possible in three ways that update automatically. One is headspinningly hard. One has some minor quibbles. The best option is a lot easier and relatively new in Excel. We’re talking here about making a list of unique (non-duplicate) values which update automatically
Microsoft Word’s Styles Gallery can be fixed to show the styles you want, rearrange to the order you want, not the collection and order decided by Microsoft. It makes sense to have the styles you use most frequently in a prominent place in this panel, and Word allows you to both add styles
Segoe Fluent Icon is a handy extra symbols font with some icons that aren’t easily available anywhere else. It’s free for Windows and Mac. Here’s how to use it in Word and Office. Segoe Fluent Icons is intended for use by developers making their Windows apps but there’s no reason
An easy way to make fancy text, especially headings, with extra style and flourish is with the OpenType Ligatures in Word for Microsoft 365, 2021 and earlier versions of Word including Word for Mac. Microsoft Word supports OpenType Ligatures. Apart from Word, OpenType Ligatures are also applicable in Publisher and,
There’s a way to convert a sentence into an Excel Formula using modern AI. You’d expect this to come from Microsoft but instead it’s the work on one smart man who has made the Excel Formula Bot. David Bressler has created a way to turn human sentences into an Excel
Once you have the basic setup for the I ♥ or I Love … sign, the fun begins. Making your own variations for a Word document or PowerPoint presentation. Start by making your own I ♥ or I Love … sign based on the original I Love NY logo. Font
It’s pretty easy to make a similar I ♥ or I Love logo, in Microsoft Word or PowerPoint. It’s even a little easier for Mac users. Check out Making the original I Love NY sign to see how the original logo is put together. We’ll show you the little subtleties
Here’s the design details of how the famous I ♥ NY / I Love NY logo was made. The font, colors, symbols and how they come together to make an iconic sign imitated all over the world. The logo was created by Milton Glasner in the back of a taxi
Type the Smiling Face with Open Mouth and Smiling Eyes 😄 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Smiling Face with Open Mouth and Smiling Eyes 😄 emoji is used to express genuine joy, laughter, or excitement. It’s just one of
There’s an interesting New York Times piece on the Unicode standard that’s used by Office, Windows, Mac and other computer systems. Unicode is the global standard for identifying letters, symbols and characters across many computer systems. It’s how very different devices can identify the letter A, Euro currency symbol or
Section Symbol § can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Section Symbol § is used for referencing numbered sections of a document, such as US legal code e.g “ 50 U.S. Code § 1861 “ . § in Footnotes
The inverted or Spanish exclamation mark ¡ is available in Microsoft Word, regardless of language setting. There’s even an in-built shortcut. ¡ is most commonly used in Spanish for the start of an exclaiming sentence. As far back as the 1660’s there have been attempts to introduce ¡ inverted exclamation
PowerPoint presentations don’t have to be full-screen, that’s the default and normal way to show a deck, but a window option is also there. A windowed presentation lets you display the slides in other software like virtual cameras or desktop capture. Go to Slide Show | Setup Slide show and
One of the many small, but annoying, limitations in Office for Mac is the Insert Symbol feature. In Word for Windows it’s quite developed with a list of recently used characters: Or open up the main dialog to scroll through many more symbols or jump to exactly the one you
How to view a .msg file in either Windows or Mac. .MSG are Outlook for Windows message files which aren’t supported on Outlook for Mac, let alone Outlook mobile or in a browser. We’ve already explained about Outlook .msg files and why they are NOT recommended. In short .msg files
Viewing an .MSG file in either Windows or Mac isn’t always easy or even possible. We’ll explain what a .msg file is and why to avoid .msg in favor of better ways to share Outlook information. What is a .msg file? .MSG files is the “Outlook Message Format” are made
We already talked about the Microsoft Word ‘Shrink One Page‘ feature and its limitations. Here’s suggestions for how to move a few orphaned lines from the top of a page in more subtle and effective ways. Obviously, every document is different so the tricks you use depend on the situation.
The Shrink to Fit or Shrink One Page option hiding in Microsoft Word might solve a common problem. Making a document that’s using part of an extra page (an ‘orphan’), fit into a single page or one less page. Shrink One Page or Shrink to Fit was added to Word
Reduce the number of pages in a Microsoft Word document and save paper, one option is to make the page margins narrower. Do that with a single click and change back to normal margins with another click. Narrower margins can make a surprisingly large difference to the number of pages.
Tucked away on the far-right of Microsoft Word’s Table Design tab is the Border Painter, a useful little tool to let you copy existing cell borders to other parts of a table. Border Painter saves the trouble of manually changing the table or cell border settings. Instead, just copy an
When it comes to inserting a background image into the Microsoft Word table, it’s possible with a little trickery. It’s not ideal but quite easy. We’ll show you how to insert a picture background into a Word table. You’ll need to be aware that it can likely go wrong when
Office for Windows comes in two flavors called Click to Run (CtR) or MSI here’s how to tell which one you have and why it, sometimes, matters. We’ll also explain the two terms. Which Office install you have (Click-to-Run or MSI) should not matter but occasionally a support page or
Microsoft Word’s language tools are more than just red or blue squiggly lines. There’s help to choose alternative words, alternate languages, check and improve grammar, hyphenate documents and even test the document for readability. You may think you know all about the language tools, but Word always has a few
Set Picture as Background in OneNote feature is a handy feature for those looking to fill in forms or wish to draw and highlight on top of images pasted into their OneNote page. It’s now available in the Web version of OneNote as well as OneNote for Windows/Mac. How to
