A close and in-depth look at what Microsoft Word does and doesn’t flag with the sometimes controversial Gender Specific Language setting in the ‘Grammar & Refinements’ section. Microsoft doesn’t reveal much (or anything) about the Inclusiveness options in Word so we’ve decided to look closely at what they do. We
Lots of press stories about how Microsoft Word has gone ‘woke’ enforcing ‘politically correct’ words and phrases. Let’s look at what all the fuss is about, why you’ve not seen it in Word, how these ‘inclusive’ grammar checks are old news and easily ignored in several ways. In early 2020
Excel has two functions that round numbers to either the next Even or Odd numbers – these functions are called … wait for it … Even() and Odd()! Both Odd() and Even() round positive numbers UP to the next odd/even number. Negative numbers are always rounded DOWN to the next
Excel’s Ceiling() and Floor() function rounds a number up or down to the nearest specified multiple. The most common use is to match prices to denominations of coins or notes. Ceiling() is similar to MRound() except that MRound() rounds to the nearest multiple, Ceiling() always rounds UP. The reverse is
Here’s a complete list of the Outlook Function Key features from fast access to Help, jumping around your inbox, doc panes, spelling, grammar and key shortcuts. Let’s look in detail the functionality of the F-keys labelled F1 through F12 on your keyboard. F1 – Help, hide ribbon F2 – Calendar
Each paragraph style can be seen alongside the text in Microsoft Word but it’s very much an afterthought that could be much improved. The Style Area Pane appears only in Draft and Outline view on the left-side. Turn on Style Area Pane Dig into Word for the Style Area Pane.
Reading an Office Watch ebook on a portable device like an iPad or iPhone is quite easy. We’ll take you through the steps, which work for any PDF or other files, not just our ebooks. Many thousands of our Office Watch ebook readers use their iPad/tablet to read our books.
How to insert the Zero Thirds (Baseball) ↉ fraction or symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Zero Thirds ↉ symbol (officially called ‘Vulgar Fraction Zero Thirds’) is a rarely used Baseball scoring symbol. The best explanation we could find was
MROUND() is lesser known but really useful rounding function in Excel, it’s worth considering for anyone dealing with cash money. In short: MRound() rounds up or down to the nearest multiple you choose. It’s very handy for rounding prices to match the lowest coin or note you want to handle,
There’s an important difference between two seemingly similar Excel functions: Int() and Trunc() don’t always give the same results so we’ll explain how to choose wisely. Both Int() and Trunc() ‘shorten’ a number by removing digits to the right of the decimal place. Int() rounds the number, Trunc() doesn’t. And
Here’s a complete list of the PowerPoint Function Key features from fast access to Help, jumping around the presentation, doc panes, spelling, grammar and guidelines. What you can do with the F-keys labelled F1 through F12 on your keyboard. Don’t like Function Keys? KeyTips are your way to faster Microsoft Office
Office’s Document Inspector is supposed to remove or scrub information being accidentally included in Word, Excel or PowerPoint files. It’s not perfect and misses out on some critical hidden information that can give away secrets. Details in images, layers and even highlighting. Document Inspector is at File | Info in
PowerPoint has, finally, added shortcuts to quickly make bullet or numbered lists without using the ribbon. Here’s the full list of typing shortcuts and how to turn them off. In Word, you’re probably familiar with a list being automatically created if you type * or 1. at the start of
Date handling in Excel can be confusing and it’s not your fault. Microsoft could do a better job. Here’s a quick guide to how Excel handles dates and date arithmetic with the settings you should know. What you see isn’t what’s saved What Excel shows in a cell is only
How to number lines and paragraphs in Microsoft Word and format the numbers with a different font, size or color. Plus some ‘wish list’ features that are missing from Word. When you’re discussing a speech or other document ‘in progress’ you might want to number the lines or paragraphs for
How to insert the Construction or Roadwork Sign 🚧 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Construction, Roadwork or Warning Sign 🚧 symbol can be used in PowerPoint slides and in other Office documents sometimes to mark WIP or “Work in
Make better and faster images with Bing Image Creation, Dall-E and other AI tools using a few simple tricks. Here’s some ideas and comments with plenty of examples. If you’ve tried Microsoft Designer, Dall-E or other AI image makers, Bing Image Creation is nothing new and works the same way.
Microsoft has released their version of an AI image maker (like Dall-E) called, imaginatively, Bing Image Creation. We’ll explain how to access and use the preview with some examples of freshly made images and how the Content Warning/Block works. All these images are original, made by Bing Image Creation from
Microsoft Loop is coming for everyone and is now in a public preview of this new way to collaborate online. Here’s how to get into the Loop preview and how to get started exploring this new tech. Loop components are live mini-documents, worksheets or lists that people can collaborate on
According to Microsoft, their AI integration Copilot is “A whole new way to work” and will “Transform the way we work”. That’s true, but not as quickly or as well as their overstated hype suggests. Here’s why I’m cautious about the Copilot promises. Microsoft is rushing both publicity and release
Here’s what to do if you get the dreaded Microsoft 365 / Office 2021 or Office 2019 Unlicensed Product / View only error message. Assuming you have a current Office 2021/2019 or Microsoft 365 subscription (we’ll show you how to check that, below). The unlicenced product warning usually happens if
Use these Microsoft Word options to quickly find words and word variations that you might have thought impossible. Finding words that sound the same or past, present and future tenses in the one search or ignoring punctuation to find “its” and “it’s” in one search These options are in the
How to insert the Reversed Question Mark / Irony ⸮ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Reversed Question Mark / Irony ⸮ symbol has been proposed to denote irony or sarcasm within text. Or for rhetorical questions. It’s never really
Dyslexie is a special font that’s easier for dyslexic people to read than standard type. It’s free for personal use and easy to include in Microsoft Word, Excel or PowerPoint for Windows or Mac. The font is specially designed, making it easier for the eye/brain to distinguish similar letters. For
