The inverted or Spanish question mark ¿ is available in Microsoft Word, regardless of language setting. There’s even an in-built shortcut. ¿ is most commonly used in Spanish for the start of an question sentence. This guide is mostly for people without a Spanish keyboard or who only occasionally need the inverted question mark. See […]
You might think the simple ! exclamation mark is obvious in Microsoft Word or Office but there’s more possible even with this humble symbol. We’ll show you ways to insert FIVE different exclamation marks into Office, as characters, symbols and emoji with infinite variations possible on those five base symbols. We’re not including the inverted […]
We’re delighted to announce a new ebook from Office Watch — all about Office 365 for Windows: Straight Talk. In-depth with Word, Excel, PowerPoint and Outlook 365 plus buying and configuration. For anyone with Office for Windows on an Office 365 subscription. It’s a truly independent guide to Office 365 for Windows. We take the […]
Microsoft’s PR department must be laughing themselves silly this week. A press release for an existing Excel feature is getting wide coverage even though there’s nothing new and the feature is at least six months old. The blog posting on 5 June 2019 announces Microsoft is working with “Nasdaq and Refinitiv to pull current financial […]
It’s now possible to quickly switch accounts while using Office 365 for Windows and even have different logins in separate programs. Many people wear different ‘hats’ while using Office. There’s a Work ‘hat’ or ‘hats’ with more than one job. Plus your personal or home role. Sometimes even more hats/roles like a volunteer task running […]
Excel Mobile’s Data from Picture has one big problem, it can’t figure out what’s intended to be in one cell and puts text in many cells. Cell discernment is Data from Picture’s biggest weakness and the Review process makes it hard to fix those problems. For example, text using Excel’s own Accounting format which puts […]
Excel 365’s new ‘Data from Picture’ feature is now available for iPhone and iPad. It converts a photo into a spreadsheet grid you can work from. We told you about ‘Data from Picture’ back in March when it became available in Excel for Android. Data from Picture is on the Insert tab between Table and […]
How does Excel 365’s Data from Picture work outside the carefully selected demos shown by Microsoft? Data from Picture converts a photo of a document or table into an Excel worksheet. It does that by sending the image to Microsoft’s cloud servers for interpretation. The converted table comes back to your device for review and […]
Microsoft has announced that the Office apps for Android won’t update for older versions of Android. These are the Word, Excel, PowerPoint and Outlook apps for Android. Quietly, the system requirements were changed to cover only the last four major versions of Android. Misleading news alert Despite what you may have read, the Office apps […]
Word’s Sort feature is OK, up to a point but has its limitations.We humans insist on variations of the simple ‘first and last’ name that confuse a computer. For short lists, it’s probably enough to do a Word surname sort then manually adjust the list for any anomalies. Longer lists need the power of Excel […]
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 of Emperor Naruhito meant a […]
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 Excel uses the Windows defaults, […]
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 ₿ Bitcoin code BTC prefix BTC […]
The benchmarking software PCMark 10 has added a new test that directly checks the performance of Microsoft Office programs on various hardware and software configurations. There are three separate Office Applications tests: Word covers typical word processing tasks for office workers. The test measures PC performance when opening, editing, and saving a document. Excel test […]
Office 365 documents can be autosaved to OneDrive or SharePoint Online but there’s a major exception which Microsoft needs to fix. AutoSave is prominent in Word, Excel and PowerPoint for Office 365, on the left of the top bar. It will regularly save your document for you but only if it’s saved to OneDrive or […]
WOFF are a new-ish type of font that you might have seen mentions or downloads. Here’s how to use them in Microsoft Office; Word, Excel or PowerPoint. WOFF is Web Open Font Format designed to be compact and easy to download. WOFF is for web sites and mobile apps, not desktop programs like Office. Despite […]
Reston, VA, May 16, 2019 – Visual Crossing Corporation is proud to announce the release of the next component of its Weather Services platform, Weather Data Services immediately available for Microsoft Excel, interactive web, and web services API. Users can choose between an interactive add-in for Microsoft Excel, a web page, and a web services API […]
A few of the May 2016 patches Microsoft Office caught our eye with embarrassing bug fixes, previously not disclosed to customers. They all apply to older Office releases: Office 2016 and before. It’s a long-standing Microsoft trick to hide embarrassing bugs from customers until they have a fix. In the meantime, customers waste time and […]
Excel 365 for Windows and Mac has a clever way to add the latest stock prices into spreadsheets in a truly quick and easy way. Stock data type has been in Excel 365 for Windows since late last year but has gradually improved as the development team react to feedback and changeover to a better […]
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 be misunderstood by a global […]
Office 365 for Windows has new look privacy settings, hidden deep in the menus where, presumably, Microsoft hopes customers won’t find them. These changes are in conjunction with the renamed Office cloud features now called ‘Connected Experiences’. They apply to Office 365 for Windows build 1904 and later. A series of opening screens may appear […]
Office 365 customers will be seeing a set of opening screens about how Microsoft gathers and uses customer data. Those screens are carefully worded to avoid some hard truths about modern cloud connections and cover Microsoft from legal liability. Cloud features can be great and very useful. Companies do their best to hide the problems, […]
Microsoft has something ‘new’ in Office 365 they call ‘Connected Experiences’. It’s really a new, fancy name for things we already have. Connected Experiences is the new catchphrase for the cloud services already in Office 365 software or apps. It’s the various features which require customer data sent to Microsoft’s servers. According to Microsoft: “Office […]
There’s a TV show just starting its last season, maybe you’ve heard of it <g>? Here’s how to get the Game of Thrones look in Word documents and PowerPoint slides. Plenty of people have borrowed the Game of Thrones or GoT look, including a certain US President. All these uses are contrary to various trademarks […]
The May 2019 update to Windows 10 includes a long-awaited and important addition, an updated Emoji Panel. What a pity that it totally sucks and is incredibly dumb. Emoji Panel is better than what we had before (nothing) but not by a lot. We’re talking about the Emoji Panel or ‘keyboard’ which appears in Windows […]
Google has announced that their G Suite customers will be able to edit and collaborate with Microsoft Office documents. It will be available to all G Suite users by the end of May 2019. Source: Google. Until now, a clumsy Office compatibility app for Chrome allowed Microsoft Office documents to be edited in Google Docs, […]
Slack, the popular collaboration service, has added better integration with Office 365 hosting and OneDrive. Office 365 tools were inevitable because Microsoft now has Teams, its own rival to Slack. There are two new tools, Outlook email and calendar plus nice previews of Microsoft Office documents. Office document preview Now included in Slack is better […]
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 Paychex, a payroll provider and […]
Microsoft continues to struggle with their support for Japanese Era date format in Excel. The new Imperial Era, ‘Reiwa’ is known but the necessary changes for Excel aren’t released yet. New Japanese Imperial Era changes in Excel and Office explains how to add the new Reiwa era without waiting for Microsoft’s patch. Meantime, yet more […]
How to insert the different Ellipsis … marks into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Ellipsis … symbol is used for a gap or break in some text, usually to drop out some irrelevant text or speech. The same applies in maths e.g. 1,1,2,3 …. 377 […]
Microsoft has never been great about documenting patches and bug fixes but this month they have sunk to a new low. Maybe it’s a delayed April Fool’s prank with Microsoft ‘taking the Mickey‘ or treating Office customers with contempt? Sustained Engineering isn’t sustained Maintaining Office software is the thankless job of the Office Sustained Engineering […]
The current Google Drive plug-in for Microsoft Office will stop working near the end of June. There’s an improved update already available for some customers and an alternative for the rest. If you’re using the Google Drive plug-in, you’ll start seeing a warning about the plugins death on 26 June 2019. Source: Google There are […]
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 era. This might not seem […]
Converting SVG icons into JPG is essential for older Word and Office versions that don’t have native icon/SVG support. SVG’s are great with many advantages for Office 365 and Office 2019 users. Not everyone has the latest Microsoft Office or shares documents with others who have earlier versions of Office. Scalable Vector Graphics (SVG) are […]
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 etc. He turned to his […]
Laundry care symbols you see on clothes tags can be typed or inserted into Word, Excel or PowerPoint in various different ways. Laundry care symbols can be for laundry area signs or for fun like this t-shirt. T-shirt seen in a Zurich clothing store Or alternative symbols in a PowerPoint slide. All five symbols were […]
Which font to use if emulating a true laundry care or clothing text label in Word, PowerPoint or other Office program? We’ve already talked about how to put standard laundry care symbols in Word, Excel or PowerPoint but what about the text that usually goes with the icons? In our research we couldn’t find any […]
Thanks to everyone who tried out Microsoft Forms by filling out our example survey. Here are the results. Our form was mainly an example of what’s possible in Microsoft Forms as part of Microsoft Forms – a quick look and sample We took the opportunity to get a better idea of what Office software our […]
Microsoft Forms can export survey/quiz results to an Excel workbook, here’s how to do that easy and efficiently. The current method of getting Microsoft Forms results into Excel isn’t very elegant. Surprisingly, it doesn’t make use of Excel’s excellent data import and update features. At the moment, you have to download an Excel worksheet with […]
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 and added some extras based […]
