The Dictation controls in Word 365 for Windows are moving to another place and getting a lot smaller. The new Dictation toolbar appears on top-right of the document, often just below the Dictate button. That’s the same location as the Read Aloud toolbar. Dictate – when dictation is ‘listening’ the
Sometimes you need to convert a date from the Excel cell saved format to a particular format. There are at least five ways to do that. DateValue(), Date() or converting Unix dates to Excel. Simply typing dates into a cell also works but there are traps for the unwary. Excel’s
Another way to convert text to dates is by adding zero to the text. This is a trick which forces Excel to convert the text into an Excel value so it can then add the zero. Since adding zero doesn’t change the value, you end up with text converted to
Excel has some nifty and simple options for color highlights the extremes in a list of values. It’s called Conditional Formatting and you can do all sorts of clever things with it. First let’s look at the simple presets that Microsoft has given us, some of the obvious choices they’ve
It’s easy to share appointment details with other people, whether they use Outlook or not. No need to type in appointments when you can send and receive the details right in your calendar. We’ll explain how it works for both sender and receiver (organizer and invitees) on various platforms, including
It’s now possible to make an Excel PivotTable directly from PowerBI data in Excel 365 for Windows and Excel on the web. Microsoft PowerBI is a cloud-based data accumulation then reporting and visualization (dashboards etc). BI stands for “Business Intelligence”. PowerBI is a separately licensed product for businesses so it’s
Windows 11 is getting a way to view your Microsoft 365, Office 2021 and Office 2019 licence details within the Windows Settings app. At Windows Settings | Accounts | Your Microsoft account … it shows a lot of the details from the Office.com account web pages. Windows 11 for Microsoft
Microsoft Word has many different ways to view a document and now three primary options are available on a single menu; Editing, Reviewing plus Viewing which is a simple ‘read only’ mode to stop accidental changes while reading. The new menu appears on the top-right between the existing Comments and
The Elizabeth Line (aka Crossrail) is now open in London, a major new tube line crossing the city. Here’s the roundel and color scheme for the new line in a format ready for Word, PowerPoint and Office. The same design elements can be used for any other London Tube line
What Microsoft euphemistically calls ‘gaps’ in the beta release of the New Outlook should really be called ‘enormous chasms’ of missing features and core functions. Let’s look at what Microsoft admits is missing plus other obvious omissions. As the supposedly ‘new’ features of the New Outlook are being hyped, these
OneNote is finally getting the Office Dictation (speech to text) feature that’s already in other Office programs. That’s in addition to the long-standing Look for Dictation in OneNote for Windows Home tab, way off at the right-side. Also, in OneNote in a web browser … Dictation and Read Aloud in
A first look at the new “New Outlook” which Microsoft (deliberately?) leaked ahead of an official announcement. It’s interesting but with one major and very disappointing omission. This article has been updated now “New Outlook” (as it’s now called) has been released to Office 365 Insider users. As you can
There are two ways to try New Outlook — either as a Office 365 Insider on the beta track or direct download (Intel and ARM based devices). Here’s how to do it and the hidden ‘gotchas’. Beware the New Outlook because it’s VERY crippled. Only Microsoft hosted commercial or education
Let’s look at the good or at least interesting parts of the New Outlook that Microsoft are calling ‘new’. As we’ll explain, Loop Components, fast @document links, My Day, Board views, RSVP options, pinned messages and Sweep aren’t really new. We’ve already noted the severe limitations in New Outlook, core
Microsoft has released a new Outlook for Windows which is so limited that we feel it’s necessary to warn people about trying to use it. Beware! Even for Insiders on the ‘beta’ channel this new Outlook is no replacement for the real Windows version of Outlook – not even close.
There are two different ways to access a Microsoft Office document that’s saved on OneDrive. We’ll explain both and why it’s sometimes important. Microsoft’s OneDrive stores documents on servers. Programs (like Office) can open those files directly from the cloud service. Or the OneDrive app can copy (synchronize) files from
A simple question – what characters can you put in an email address? Like many things to do with the Internet the answer isn’t as simple or direct as you might think. We’ll look at what makes a valid email address, both in theory and in practice. A simple question
Excel 365 for Windows is getting three performance boosts that you might not notice but speed up your work on less powerful computers. All these Excel 365 for Windows tweaks are designed for what Microsoft politely calls “resource-constrained devices”. That means: CPUs with two cores or less 8GB of RAM
What are the real words for really big numbers, waaay over a trillion? Does Microsoft Word’s dictionary recognize them? (Answer: most but not all and there’s even a spelling mistake in Word!). How many is a billion anyway? We’ve looked at the informal words for vague large numbers such as
Does Microsoft Word recognize the nicknames for ‘big numbers’ like zillion, jillion etc? There are many informal words to describe a non-specific but really large numbers. Word’s dictionary (at least in English) recognizes them as correct spellings. If you want to be more specific see Real words for really big
A small but important change is coming to Word mobile app for iPhone, iPad or Android. You’re able to continue listening to a ‘Read Aloud’ document from the lock screen. At the moment, Word will stop reading a document to you if the lock screen is enabled (usually because there’s
Does Office 2021 or Office 2019 insist on a Microsoft account Sign-In (login) to use the software and edit documents? We’ve done some tests to check and we’ll explain the details too. It’s a good question. Microsoft 365 software does require a Microsoft account login but what about the ‘perpetual
Office apps in a browser have caught up with an important feature in Office 365 for Windows – quick account switching is now available. Almost three years ago, Microsoft added quick account switching to Office 365 for Windows. You can save logins to several Microsoft 365 accounts; work, school, home
We’ve seen many cheap Microsoft Office 365 Family, Personal and other plans sold as ‘lifetime’, ‘perpetual’ or ‘never-ending’. It’s all lies. Some deals are obviously scams, like this one for just US$3 but others have more plausible prices. They are priced just under the regular street price to seem like
