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.
Excel 4 macros are now blocked and about time too
At long last, Excel v4 macros are being blocked from running in Excel 365 by default. A move that greatly reduces the security risk from infected attachments in Excel 365 and Excel 2021. Excel v4 macros are a very old form of programming, literally 30 years old. It allowed macros to be embedded into cells. […]
Two ways to circle text in Word documents
In Microsoft Word, circling around text can place emphasis or enhance the text appearance. There are a few methods you can choose in Word documents and you’re not limited to circles. We’ll show how to add a simple circle like this, plus a lot more. Add shape to document Go to Insert | Illustrations | […]
Rainbow 🌈 emoji in Word, Excel, PowerPoint, and Outlook
How to insert the Rainbow 🌈 into Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Rainbow 🌈 emoji depicts a colorful arc of a rainbow, usually used to express positivity, hope, good fortune. The rainbow flag was designed and has been adopted by the LGBT community, there SVG […]
Starting Word Page numbers from a specific page number
Here’s how to start page numbering at any point in a Word document. There’s no rule which says that visible page numbering has to start with Page 1, there are many situations where the first page in Word isn’t ‘Page 1’ as labelled in the header or footer. Some opening pages like a cover page, […]
Five ways to divide numbers in Excel
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 =[@[Total Sales]/@[Number of Tickets Sold]]. […]
OK Hand sign 👌 emoji in Word, Excel, PowerPoint, and Outlook
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 confirm they are ‘OK’ and […]
How to avoid the Clippy Paperclip emoji in Windows
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 you need a plain, old, […]
Beware! Clippy is hiding in Windows and Office
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 ‘paper’ you’ll see various options […]
Converting MP3 to MP4 audio for PowerPoint
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 gives you better sound and, […]
LucidChart in Microsoft Office
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 tools and not as expensive […]
Why can’t Word connect shapes?
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 the Windows only Word trickery […]
Passover images and more in Microsoft Office
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 | Icons) has only one option, […]
Cat Face 🐱 emoji in Word, Excel, PowerPoint and Outlook
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. Here’s some examples of how […]
Fast screen shot or clipping in Office
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 the programs, there’s a Screenshot […]
Word number \# field code formatting explained
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 MERGEFIELD . The \# codes […]
Caffeine level easy comparison in Excel
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 coffee can have as much […]
