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.
2023 is the Year of the Rabbit in the Chinese calendar. There’s plenty of rabbit, bunny and other New Year related images, icons and Chinese character 兔 in Microsoft Office plus advice on the right colors to use for Chinese New Year graphics. Chinese New Year is on 22 January
The US State Department is changing from Times New Roman font for documents to Calibri. There are good reasons for the change though, as usual, there are objections and a little Microsoft Mystery. Calibri is the current default font in Microsoft Word and other Office apps. It’s been the default
Changing the font, size or style for all Word documents is remarkably easy and there’s two ways to do it. Alter the font that’s automatically used when you make a ‘blank document’. In Word 2007 and later the default font face is Calibri, font size 11 and style Normal. This
Office 2021 is the current ‘perpetual licence’ or non-subscription version of Microsoft Office for consumers and small businesses, here’s details of what’s new, prices, shorter support time and why Microsoft doesn’t want to sell Office 2021 at all! It’s what Microsoft calls a ‘perpetual licence’ version. A single payment for
Finding out the current UTC / GMT time in Excel is possible with a little VBA magic. We’ve included a full working example. Excel has two functions to give you the current date TODAY() or current date and time NOW() but it’s the local time as set on your computer.
Finding out the computers local time zone offset in Excel is possible with a little VBA magic. We’ve included a full working example of how to get the ‘nn hours from GMT’ setting from Windows into Excel. The need for the current UTC/GMT time and offset is becoming more important
Insert a Compass 🧭 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Compass 🧭 uses Segoe UI Emoji In Windows, the Compass 🧭 symbol is in the font: Segoe UI Emoji. Depending on the app and use, it’ll appear in color
There’s a way to quickly change the language setting for a multi-lingual Microsoft Word document, by adding a language selector to the Quick Access Toolbar (QAT) like this. Use this as a pull-down list to change the language setting in parts of a document. The problem is the fixed width
A clever and different year planner with a progress thermometer is now available for download as an Excel workbook. The days remaining in the year are visible with weekends shaded and each day of week shown. At the bottom is a clever use of Excel’s Chart features to make a
Excel statistical functions have many Average / Mean options including Average with IF for filtering or mean with extreme values excluded. by David Goodmanson In a world which has more and more data, statistics are really important. They help you distill lots of numbers down so that you can see
If you regularly translate text from or to the same language, you can set default languages. Once you have set the languages, Microsoft Word will automatically translate the text as soon as you hit Translate, without you having to set the text each time. To set the default languages, go
Google Docs can be handy for sharing and working on documents with other people, but sometimes you just really need that file in Microsoft Word. No problem – it’s actually really easy to convert them. All you have to do is download the file and save it as a Word doc, Excel sheet or PowerPoint deck.
Famous London streets signs are selling for big bucks … or you can make your own in Word or PowerPoint for nothing. A sale of genuine London street signs by Westminster City Council included one for Abbey Road that sold for £37,200 (US$51,000). We thought that was a lot and
Some ‘not allowed’ or ‘prohibited’ symbols, they can be used in Word, PowerPoint, Excel or Outlook. No Smoking, No Phone, No Children, No Drinking, No Pedestrians, No Bicycles, Not Drinkable Water or Mute. The Unicode symbol list includes red circle with diagonal to stop, smoking, children under 18, Mobile Phones,
How to bulk convert old documents (.doc .xls .ppt) into the newer Office formats (.docx .xlsx .pptx etc.). Microsoft has never produced a simple bulk conversion tool for the masses, much to the annoyance of users and network administrators. Redmond probably made that choice for their own self-interest but some
A little-known Word shortcut lets you type Δ Θ Δ Ω Π plus other Greek and math symbols quickly and easily. Ctrl + Shift + Q changes to the Symbol font for the next letter only. Only in Word for Windows, I’m afraid. Not Word for Mac. It’s a very
Type the micron µ, micrometer or mu μ symbol in Word, Excel, PowerPoint and Outlook. Stuart H has an AutoCorrect suggestion: ” I need to use the symbol μ for micron (1/000 mm) and use mu for this. “ The Micrometre / Micrometer is one-millionth of a meter. The μ
Type the Ohm symbol Ω into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Also the unofficial Siemens symbol, an inverted Ohm ℧ . Ohm is a measure of electical resistance with the symbol Ω It’s an official SI Unit of measurement just
Here’s some power selection tricks in Microsoft Word for text, tables, pictures and more. You might think that selecting text and other things in Word is simple. Like many things in Office, there’s a lot more available than the simple methods that we all learn. There are quick ways to
Type the Greek letter Omega in upper case Ω or lower case ω in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Omega (uppercase Ω / lowercase ω) is the twenty fourth and final letter of the Greek alphabet. It is used to often
Sometimes there’s more than one way to do something in Microsoft Word like having four blocks of text on a page with images or text breakout with flowing columns of text with a side-bar or break-out. “How can I do a magazine-like layout with four blocks of text, one in
Here are the best ways to get results from Microsoft Forms into an Excel workbook. Sadly they aren’t the elegant and efficient ways available in modern Microsoft Excel 365, 2021 or 2019 for Windows. We’ll explain how to get Microsoft Forms results into Excel for better filtering and analysis. Then
I said there are at least six tricks with the Excel Name Box and that’s before you get into using named rangers and objects. The Name Box lets you select a cells and give them a name or jump to an existing named range. It’s the same as going to
I found at least six uses for the Excel Name Box beyond just displaying the current cell address. The Name Box is an unassuming little box at the top of your Excel worksheet that you may not have thought about much, but it has a powerful range of uses for
