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.
If you thought dividing one number by another was simple, think again. Excel has five different ways to divide numbers and we’ll explain them all. Basic Division Obviously, there is the basic concept of division in Excel using / in a formula. Like in Excel we can use the formula
Type the OK Hand sign 👌 into Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. OK Hand sign 👌 emoji is mostly used to symbolize approval, agreement, all that is well but there are other meanings. Scuba Divers use 👌 hand sign to
Microsoft replaced the Paperclip emoji with their dreaded Clippy in Windows 11. Here’s how to get a proper paperclip symbol instead of the Microsoft branded alternative. We’ve already explained how the Windows 11 emoji panel has a paperclip with eyes and a smile. Which might be OK, but what if
The dread Clippy, the paperclip with eyes, is still hiding in Windows and Office. The Windows 11 emoji panel and Segoe UI Emoji font have Clippy instead of a plain old paperclip that other apps use. Use the Emoji Panel in Windows 11 (Win + . ) and search for
It’s not necessary to convert MP3 audio to the better MP4 format for PowerPoint but, if you want to, there are various ways to do it. MPEG-4 audio (.mp4 .m4a ) is recommended by Microsoft for PowerPoint 2016 (Windows and Mac), PowerPoint 2013 and Powerpoint for mobile devices. MP4 audio
LucidChart is a very nice diagramming and flowchart tool which is integrated with Microsoft Office for Windows or Mac. Office has diagram tools via Insert | Shapes but they aren’t very elegant. They serve for simple uses but not a lot more. LucidChart is better than the inbuilt Office diagram
The Shapes feature in Microsoft Office looks the same in all the major Office apps but it’s not. The important connectors feature, essential for flowcharts, is obvious Word or Outlook but works automatically in Excel, Publisher and PowerPoint. Update: We’ve updated this article after some clever readers reminded us of
Add some Passover images and icons to your documents, slides or emails from right inside Word, PowerPoint, Outlook and Excel. If you know where to look there are images from the Jewish tradition related to Seder, Matzah and Menorah among many, Icons The SVG Icons collection (Insert | Illustrations |
How to insert the Cat Face 🐱 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Cat Face 🐱 emoji is a variant of the grinning face emoji, usually depicted as yellow on all platforms. How Cat Face 🐱 looks in different fonts.
There’s a simple way to copy a screen image into Word, PowerPoint, Excel, Outlook or OneNote. Word, PowerPoint and other Office apps for Windows (Office 2010 and later) has a Screenshot option to paste an image from any open program window into a document or email. Go to the Insert tab of
All about the \# formatting switch in Word field codes lets you change the look of numbers in many different ways. Many examples plus a guide to the formatting codes. Use these options with Word fields that return a number like SEQ, REF, PAGE, SECTION, SECTIONPAGES, AUTONUM, EDITTIME, FILESIZE and
How to compare caffeine levels in coffee, tea, soda and other drinks from an Excel spreadsheet. The Guardian’s Datablog has interesting analysis of caffeine levels in different foods. Sounds boring until you read that: reduced sugar colas have almost double the caffeine of a regular, sugared, cola. 1 cup of
Changing the case upper/lower for text through all of a Word document is easy because the default Find / Replace settings don’t need changing. We’ve already talked about the manual Change Case options in Word, now we’ll move onto bulk changes. Sometimes the spelling of a product or brand has
Change Case options in Word, like many Word features goes beyond the obvious choices from the basic shortcut. There’s up to five choices on the ribbon with a keyboard shortcut to reach it. Alter the upper/lower case of words, phrases or more. ‘change case’ can become ‘Change Case’ or ‘CHANGE
Replacing images in Word, PowerPoint, Excel and Outlook is a lot easier using the ‘Change Picture’ option, especially now you can change to insert an image on your clipboard. We’ll show you a step by step on how to do it. There might not be one simple keyboard shortcut, but
Ever been confused by the \* formatting options in Word field codes? You’re not alone, believe me. Here’s a complete guide with the \* codes and examples of how they appear. In this article we’ll look at the named formatting codes which start with \* like \* Arabic and \*
StockHistory() is an Excel function that can add historical stock price info, as well as currency exchange rates at monthly, weekly or daily intervals. Date and Closing Price plus optionally Open, High, Low and Volume. All ready to make a chart for stock price analysis. Excel 365 has Stock and
How to view Text Boundaries in Microsoft Word, why they can be useful and how the feature has changed over time. Text Boundaries put a dotted line box around each text element on a Word page. Turn on Text Boundaries to solve formatting problems. For example, in the above example,
How to show the four corner Crop or Trim marks on a Microsoft Word page. The ‘L’ shapes are a guide to the useable part of the page, inside the margins, and appear in all four corners. The four marks are called Crop Marks also known as Trim Marks. Word
If you have included equations in a document, Word can generate a list of them all for you. Like a table of contents, this list or Table of Equations can include page references or links to each equation. A Table of Equations can be useful for creating a proper appendix
Type the White or outline Chess King ♔ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. White Chess King ♔ symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. There’s also a
Word and Office have several down “pointing hand” symbols available in some fonts. Here’s the Unicode options explained and shown with the codes and shortcuts to type them in Excel, PowerPoint and Outlook too. There are various pointing hand options in Unicode: Index – a pointing index finger with palm
If you’ve ever needed to split dates in Excel into separate day, month, and year, there are several options to choose from. Excel has different functions, Text to Columns or Flash Fill which can do the job. Here’s a quick guide on several methods: Using the DAY, MONTH and YEAR
With a little Office formatting trickery, you can make a Twitter ‘message’ that looks like what you see on the Twitter web site or app to put in a Word document or PowerPoint slide. Use this trick to recreate a real Tweet that’s part of a document. Or as a
