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
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
If, while typing, you notice that Word has automatically changed capitalization of something you did not want changed, you can correct this easily as you type. Hover your mouse over the part of the word that has been automatically changed. A blue line will appear under the changed part. We
It’s income tax time in the USA and that means a new round of email scams and infected Excel documents to watch out for. IBM Security Intelligence reports on a series of scam emails courtesy of the Trickbot hackers. All the emails look like legitimate messages from big companies like
An update for Excel users on the upcoming new Imperial Era in Japan and how to type the Reiwa era name in Office documents The Japanese government has now announced the new Era name that will coincide with new Emperor. From 1 May 2019 we’ll be in the 令和or Reiwa
One of the first major Word viruses, the Melissa virus, is 20 years old. It’s amazing to see how much and how little has changed over two decades. Office viruses today follow much the same pattern as they did back in the 20th Century. Melissa was a Word macro virus
In Japan there are two amazing uses of Excel. Excel used for displaying train timetables and to make beautiful works of art. The Michelangelo of Excel Tatsuo Horiuchi has become the Michelangelo of Excel. On retirement he wanted to turn to art but didn’t want the expense of paint, brushes
What can you do when Outlook won’t connect to a new mailbox no matter what you try? Long time Office Watch reader, Phil, found himself with an especially stubborn Outlook which would not connect to his new mailbox. He’s changed Office 365 mail servers so had to reconnect Outlook to
Continuing our look at Excel tab/worksheet listing here’s a fully automated alternative with more control and filtering. See Make Excel tabs list in a worksheet Automatic worksheet/tabs list in Excel Fit more tabs across an Excel workbook There are many VBA code samples on the Internet, we’ve taken one we like
Does Excel have enough significant digits for Pi in the inbuilt Pi() function? Modern computing can calculate Pi to 3.14 trillion digits which is a good trick but even extreme situations only needs Pi to 15 significant digits. What’s extreme? How about interplanetary travel? JPL/NASA calculate the paths of probes
Make your own clickable list of workbook tabs in an Excel worksheet to workaround the small number of tabs that can fit in a single line. See Fit more tabs across an Excel workbook for some suggestions to squeezing more across the single line available. Those suggestions work to make
A long-standing and unpatched problem in Office provides a stealthy doorway to other security problems in Office with Equation Editor already being targeted. Mimecast discovered an undocumented behavior in OLE (Object Linking and Embedding) which is a doorway into security bugs in Office. It isn’t a security problem on its
Word for Windows has three options for saving a document to a web page, Web Page, Single Web Page or Web Page, Filtered. Here’s a look at all three and how to choose the best option for you. What you choose depends on how much similarity you need between the
The full match schedule for the 2019 Rugby World Cup can appear in Outlook calendar. Internet calendars can be added to your regular appointments or placed in a separate Outlook calendar that can be viewed side-by-side or overlaid on your regular calendar. 2019 Rugby World Cup calendar First, find an
Many new emoji are now in the official Unicode list but we’ll have to wait for them to appear in Word or Outlook emails. After the Unicode Consortium ratifies additions to the vast character list, it takes some time for Microsoft, Apple and others to add the emoji to their
Here’s a quick and easy way to totally erase file, folders or free disk space so there’s no trace of the original data. Also erasing an entire drive before handing over or selling. As you may know, deleting a file doesn’t really remove it from your computer. Even after deleting
It’s the Chinese Year of the Pig and there are some symbols in Word, Excel and PowerPoint to mark the occasion in Office for Windows or Mac. The Unicode standard has three Pig related emoji, Pig, Pig Face and Pig Nose. Once you know the names or hex value, they
Web based email is very common these days but it’s not the best way to handle your email. At worse, webmail can leave you stranded and out-of-touch. A lot of people now use webmail as the only way to access email on their computer, not realising, until it’s too late,
How can you tell if you’re reading email in a web browser or using email software like Outlook for Windows or Mac? This might seem obvious to some but many people use ’email’ without understanding the important difference between webmail and email programs. There are two ways to read and
If the Translation options in Microsoft Office don’t do it for you, try the Google Translate full document translation option instead. For a long time, Google has a word and text translation between languages. The app is a godsend to travelers around the world, and the locals dealing with them!
