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.
Why keyboard shortcuts are harder on Office for Mac
Office for Mac has keyboard shortcuts to speed up work but they are a lot hard to find than they should be. There’s no direct mapping of Office for Windows shortcuts into Office for Mac. Partly because the Mac has keys that aren’t on a regular Windows keyboard ( ⌘/Command and Option) . Conversely Windows […]
Office is becoming Microsoft 365 – or is it?
Microsoft has announced that “Microsoft Office” is now “Microsoft 365” – big deal. That already happened back in 2019 and the Office name will still be used. Is it really a name change or a bit of hype? What’s really changed? There’s a new logo – that’s all. As I said, “big deal”. Office has […]
Yen ¥ symbol in Word, Excel, PowerPoint and Outlook
Type the Yen ¥ currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Yen is used for Japanese currency and the Chinese Renminbi / Yuan. Microsoft Excel also offers the Yen symbol for Mongolia even though the tögrög currency uses another symbol. ¥ symbol is easy […]
PowerPoint ending slide ideas
More ideas and a wish list for ending a PowerPoint presentation with a different slide. After our article on the ending slide options for PowerPoint, Vivian from the UK writes: “… it’s really very easy to do what I always do at the end of PPT presentations. Just add a new blank slide – which […]
Avoid the black slide at the end of a PowerPoint slideshow
The blank black slide which appears usually at the end of a slideshow is a default setting in PowerPoint. But it can be changed. The blank black slide which appears usually at the end of a slideshow is a default setting in PowerPoint. But it can be changed. Open PowerPoint 365, PowerPoint 2021 back to […]
Murphy Brown look in Word or PowerPoint
Recreate the Murphy Brown TV show’s look as a design inspiration for Word and PowerPoint – the fonts, colors and lines. You may not want to use the exact look of the Murphy Brown title card, but it’s a starting point for design variations of your own. We’ll show how to make a similar look […]
Change default slide number in PowerPoint
How to change the PowerPoint slide numbering to a different start number. In PowerPoint, slides are numbered by default from 1 but that’s not always what you need. For example, you’re working on some slides which are just part of a set of slides eg. working on slides from number 15 to 20 separately. To […]
Record Narration and Timings in PowerPoint
In PowerPoint you can record narration and comments during or after a slideshow. This makes the presentation more interesting and interactive. This feature is especially useful when you convert presentation to video. With narration the video would seem complete and the process of doing this is quite simple and easy. This feature is available in […]
Powerpoint: make your mouse like a Laser Pointer
One of the eye-catching features since PowerPoint 2010 right up to PowerPoint 365 is turning your mouse into a virtual laser pointer. A ‘laser pointer’ transforms the boring mouse pointer to something striking and easier to see on the screen. This is especially useful while delivering presentations as it eliminates the need to carry additional […]
Array Formula with IF filter in Excel
Excel Array formulas are useful for getting the result from a filtered list quickly with a single, simple formula. Continuing our series on Excel array formulas. Here’s a list of stocks with industries aka Table3. How many stocks are in the ‘Shop’ industry? The array formula in G5 has the answer from the formula: =COUNTIF(Table3[Industry],G4) […]
Excel Array formulas for everyone
Array formulas are an important part of Excel and they are a lot more important now that dynamic array formulas are around. Don’t ignore arrays because they’re an unavoidable part of Excel for everyone. This is the start of a series to help you understand arrays in Excel. At the very least, you’ll know what […]
Make a List or Table of tables in a Word document
Word can generate a list of all the tables in a document. Like a Table of Contents, this list of tables or Table of tables can include page references or links to each table. A Table of tables can be useful for creating a proper appendix or reference within more formal documentation. It can be […]
Three ways to view multiple Outlook calendars
Outlook can handle more than one calendar and has three options for easily viewing them, either individually or combined. Calendars can be displayed side-by-side or the more useful Overlay option. There’s also the ‘New Window’ option. Choosing the Outlook calendars to view In Outlook calendar view, use the check boxes in the calendar list to […]
Add an Internet shared calendar to Outlook
Outlook can link to external, shared, calendars and copy any updates to that calendar using either a .ics tile or a webcal link. An Internet calendar can be for public events, holidays, sporting fixtures etc. They can be a one-time copy of event details or you can setup Outlook to check for updates to […]
Pilcrow Sign ¶ emoji in Word, Excel, PowerPoint and Outlook
Type the Pilcrow Sign ¶ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Pilcrow Sign ¶ is a typographical symbol sometimes called a paraph, or blind P In typography ¶ marks the start of a paragraph but in Microsoft Word the Pilcrow Sign ¶ marks the END of a paragraph. […]
Better Excel formula converts days into Years, Months, Days
Here’s a better Excel formula for converting a number of days into text for year, months and days. This formula leaves out zero values and proper singular/plural (e.g. not “1 Year 0 Months 27 Days” but “1 Year 27 Days”). And we’ll show an even better way to write the formula in Excel 365, 2021/LTSC […]
