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 […]
Like any other text in Word, the appearance of all your captions can be changed by modifying the style that is applied to them or selecting the text and formatting manually. See Adding Captions in Word Caption Style All captions use the ‘Caption’ style, so modifying that style will modify the format of all past and […]
Captions let you add autonumbered labels under most Word objects including pictures (figures), tables or equations. Captions can be combined into a list of all the figures/tables/equations in the document, along with their page numbers. As usual in Word, there are many options beyond the simple adding of captions and some ‘gotchas’ as well. See Changing […]
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 upcoming update to Windows 10 represents a major shift by Microsoft. While the company won’t admit it, the October 2018 update was a disaster. So many bugs in the update, including some that destroyed customers files. Somewhat chastened, the Win10 May 2019 update is being deployed in a much more cautious way. The May […]
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 says that a ‘limited’ number […]
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 […]
Word has settings to automatically change the case of words that you type, fix common capitalization typing problems add items of your own to have capitalized the way you want them as you type. Word also has options to manually Change Case in Microsoft Word. The settings are in the AutoCorrect dialog at File | […]
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 typed AUtomatic and Word immediately […]
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 […]
The lesser known version of SVG icons is the smaller, compressed, SVGZ format. Here’s how to use SVGZ in Office 365/2019 despite no direct support for the format. Most SVG icons arrived uncompressed in plain XML text using the .SVG extension. We’ve shown before how SVG’s can be edited in any text editor to make […]
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 […]
Change Case options in Word, like many Word features goes beyond the obvious choices on the ribbon. Alter the upper/lower case of words, phrases or more. ‘change case’ can become ‘Change Case’ or ‘CHANGE CASE’ without retyping. There are four ways to change the case of existing text in Word: Keyboard shortcut Change Case button […]
Changing the case upper/lower for text through all of a Word document is easy because the default settings don’t need changing. We’ve already talked about the manual Change Case options in Word, now we’ll move onto bulk changes. Sometimes the spelling of a product or brand has peculiar case choices like iPad, eBay or reCAPTCHA. […]
We hope you enjoy our little 1st April satire, Office 366. Office 366 was fun and, along the way, reminded people of some important points about Office 365 plans. ‘Office 366’ is the, not impossible, idea that Microsoft would make Office 365 customers pay for leap day in 2020. https://office366extra.com/ the Office 366 announcement including […]
There are shortcuts that automatically format bold and italic text in Word. The same shortcuts and more work in WhatsApp texting as well. AutoFormatting Bold and Italics as you type In Microsoft Word and Outlook it’s possible to make words bold or italic as you’re typing. For touch-typists that’s faster than stopping to highlight text […]
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 […]
Some people might be surprised about Office 366 and the loss of services for a day, but they shouldn’t be. It’s a demonstration of the much tighter control Microsoft has over Office 365 customers. Office 366 is a price slug for Office 365 customers Office 366 exclusive interview The switch to an annual payment, so-called […]
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 […]
Office Watch met with Office 365 spokesman, Morrocos Fieffit, for a few drinks and this exclusive interview about the changes and fees with Office 366. Quickly, what’s Office 366? “Office 366 is an enhancement to Office 365 to deal with the extra day in the 2020 leap year. Office 365 is a 365 day per […]
Office 366 is the latest ‘innovation’ and price gouge for Office 365 customers. It’s an important change to Office 365 with costs for everyone and dread consequences if you don’t pay. It’s horrible news to start a new week. Office 365 users are waking up to this as Monday 1st starts across the globe. Without […]
Today we’re seeing plenty of mentions of a ‘great deal’ that isn’t ‘Office 365 Home plus Amazon Gift Card for $100’ is NOT correct and NOT a good deal at all. For starters, the price is $149 not $100. Sample headline and text from just one prominent tech web site. Click through to Amazon and […]
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 […]
The Word Style Gallery doesn’t have to be left the way Microsoft supplies it. Fix the Gallery to make it work better for you. Microsoft Office often has menus and options aren’t designed for the customer. Instead they are setup for Microsoft’s needs in ‘out of the box’ demonstrations or to showcase as many choices […]
Rename Word styles or give them alternative names/aliases. Sometimes you’ve got no choice but to make an alias because the original style name is fixed. Any style can have an alternative name which appears in the Style Gallery. That’s a useful trick because there’s limited space for the style name on the Gallery and the […]
Many inbuilt Word styles are hidden until they are used but there’s a way to force hidden styles to appear right away. The most obvious example of ‘Hide until used’ styles are the Heading styles. Word initially shows only the first three headings ‘Heading 1’, ‘Heading 2’ and (drumroll) ‘Heading 3’. Hidden away are Heading […]
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 […]
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 to Mercury, Mars, Jupiter and […]
Word can check if you use a single or double space after a sentence (fullstop/period) but how can it be changed single space to double throughout a document? The Sentence Spacing settings (single, double or don’t care) is in Word’s Grammar settings see Sentence Spacing in Word. These days, sentences more commonly separate with a […]
Word can check if you use a single or double space after a sentence (fullstop/period) but how can it be changed throughout a document? Make all sentences end with a single space instead of double spaces, triple or more. The Sentence Spacing settings (single, double or don’t care) is in Word’s Grammar settings see Sentence […]
With help from major retailers, Microsoft has new ways to make people pay more for Office 365 Home or Personal. Amazon and Best Buy now offer Office 365 renewals charging full price for the first and later years. Ever since Office 365 plans started, Microsoft has enticed people with low prices in the first year […]
Excel for Android has a new trick, converting photos of tables or other documents into worksheets. As usual, some conditions and limitations apply to Insert Data from Picture that are overlooked in the usual hype. The idea is simple, take a photo of a table or grid in a document then Excel will convert it […]
