One way to get a web table into Excel is simply to copy the page from your browser into an Excel workbook. This method works for all versions of Excel back more than a decade. It’s been superseded by Get and Transform with PowerQuery which does a much better job
The 50th anniversary of Apollo 11 is our excuse to show-off some features in Outlook for Windows/Mac. How to add past events, post events in other time zones, get reminders of upcoming anniversaries and set reminders for longer times than Outlook allows. Adding Past Events Outlook can save details of
Back in the 16th Century, italic fonts were invented and that trick can still be used today in Microsoft Word. Italics let you fit more text into the same space. An innovative Venetian publisher, Manutius, needed to make small and affordable books. Paper was expensive so anything that put more
It’s time for the July roundup of patches for yet more security bugs in Microsoft Office including Office 365 and Office 2016 for Windows plus Office 2013 and 2010. Plus the latest example of confusing documentation errors. Office 365 and Office 2019 A bug which lets Office Javascript doesn’t check
Word lets you translate an entire document in one go, either right click anywhere in the document, right click and select Translate, or go to Review | Translate | Translate Document. As with translating a selection, the Translator will open in a sidebar, where you can select the languages to
Word has a feature to translate text from one language to another. Whilst the translation may not be perfect, it does give you a starting point to understanding what the text says. You can either translate a selected piece of text, or the whole document. Translate works slightly differently depending
If you’re the sort of person who’s easily distracted, or just want to focus on the content of your document without worrying about formatting, there are a number of ways you can clear the distractions from Microsoft Word, so you can focus on the text you’re writing. Minimize the Ribbon
The US government has issued a new warning about malware which takes advantage of a security lapse in Outlook for Windows, which was patched over 18 months ago. The warning generated a lot of scary headlines, especially since there’s suspect Iranian involvement. If you’ve been taking standard precautions and updated
The Power Query exploit in Excel is a concern but one that most Excel users are already protected from. Look past some of the shock headlines (e.g “120 million users personal information at stake due to Microsoft Excel flaw”) . Mimecast did a good job tracing this security bug in
Drop-down list boxes are useful in Excel but, like many things in Office, there’s more than one way to do it and more to know that the simple examples often given. Making a pull-down list is easy and there’re many tips showing the basics. In this article we’ll go beyond
The Archive button in Outlook 2016/2019 and Outlook 365 is a very different thing than previous versions. Archive is just another folder among many in the same Outlook mailbox and data store. It’s a default folder (which can’t be changed) for Office 365 hosted, Outlook.com, and Exchange accounts. For other
Here’s some other problems with the Word Sort feature and tricks to work around them. Generally speaking, long or complex sorting is better done in Excel. Excel has much better data management features to split and sort. The final result can be copied into Word. Sort a list of names
Microsoft has released a series of pages describing their support for the new Japanese era in Windows, Office and .NET. Plus a new Windows feature to support a nicety of Japanese date formatting. Japan’s traditional dating system works around the Emperor’s reign. The abdication of the last Emperor and enthronement
As part of Microsoft’s support for the new Japanese Imperial era, they’ve added support for traditional Gannen writing of dates as well as the newer Ichinen style. Windows 10 now supports Gannen style Japanese dates but that support doesn’t flow through to Excel formatting. Normally the default date presentation in
Yet again, Microsoft Word is beaten by mere humans when we pit the software against words used in the 2019 Spelling Bee finals. We made a list of some words from the 2019 Spelling Bee finals including the last eight words which confirmed the winners. See for yourself how Microsoft
WhatsApp will starting showing ads in 2020 which is another reason to give up on the messaging app and move to a more private and secure but very similar app, Signal. WhatsApp has over 1.5Billion users which makes it a too tempting target for the owners Facebook and advertisers. Facebook
Excel has a new currency option. Bitcoin BTC is now available as a Currency symbol or text from the main list but we’ll show how to get it now on any version of Excel. There are four options available: Bitcoin symbol ₿ prefix ₿12.34 Bitcoin symbol ₿ suffix 12.34 ₿
How to easily make and receive appointments with other people using Outlook. This is a feature that’s been in Outlook for many, many years and so is often overlooked amid the hype for the latest ‘exciting’ thing from Microsoft. We’ll look at how to send an create an appointment to
There’s an important feature in Word and other Office programs that we all have, and many people use, except the US Congress … document collaboration and comparison. It’s even more amazing because most, if not all congressional offices have Microsoft Office. An article about the Select Committee on the Modernization
Word can automatically add a bibliography or list of sources or works cited in a document. Here’s how to do it with formatting to make your teacher or professor happy. To make a Bibliography, you first have to add citations and sources to your document. Once you’ve added all the
Here’s how to change the Outlook folder labels from large text labels to smaller icons. Also tricks hiding under those folder labels. Microsoft’s default in modern Outlook is large text labels across the bottom. Click on any label to switch to that folder view. The text is large and might
The WhatsApp security bug made a lot of headlines this week. As the virtual dust settles, what should you do and what is there still to worry about. A company discovered a bug in WhatsApp which they packaged up and sold to various parties. The Pegasus bug allowed hacking of
Unclear date formatting in documents, worksheets, presentations and other media is a pet peeve of ours. These days it’s bad practice to show dates in digits only such as 01-05-2019 12/3/18 etc. Yet we often see these formats used in booking confirmations and other documents. Either of those dates can
Microsoft has admitted a security breach which allowed hackers to access the accounts and data of customers. The admission from Microsoft isn’t complete and the hackers say it’s worse than the company is saying. Who is affected? Some people with a free Microsoft accounts like Outlook.com, Msn.com Hotmail.com etc. Microsoft
