Microsoft has started its usual sales campaign to go with the end of support for Office 2010 in a year from now. There are alternatives beyond what Microsoft is selling. In a self-serving blog headed “Support for Office 2010 is ending—get current with Office 365 ProPlus” we see the tiresomely familiar marketing strategy playing out. Encouraging customers […]
Over time there’s been a change in the way email programs login to your mail host. It’s mostly hidden from us mere humans but important to understand. Here’s how to use oAuth and how to bypass it, if your email program doesn’t support it. Older versions of Outlook don’t know about Open Authentication but there’s […]
Like it or loath it but the comma ellipsis has arrived ,,, as an alternative to the more common ellipsis with dots. Here’s how to use it in Word and Office. The comma ellipsis is a modern, more casual version. It’s used as a more dramatic, even annoyed trailing off of a thought, compared to […]
Excel has a huge range of charts available and endless ways to customize them, but after working to get it just right, you don’t want to have to go through the whole process again next time you want to make a similar chart. Fortunately, you don’t have to because Excel allows you to save your […]
Here in the UK there’s a very good deal on Office 365 Home, saving more than ₤10 on the street price or 50% off the full retail price. Use this offer to extend your Office 365 plan for a lot less than Microsoft will charge. Office 365 Home is the 6 user annual plan and […]
The new iPad has a great price tag and good features but a hidden price trap for Microsoft Office users. It has a 10.2” screen with support for important accessories like an external keyboard and Apple Pencil. Source: Apple. The trap is in the screen size, at 10.2” it’s 0.1 inches more than Microsoft allows […]
It’s time again for the monthly drop of security updates for Windows and Office. Here’s what caught our eye; two Excel security bugs and a Windows update which kills VMWare Workstation. Commentators are calling this a ‘light’ month for security patches because there are a mere 59 patches instead of the usual 80 or more. […]
Mac users can now update their computers to MacOS Catalina release but there’s important things to do before updating and some good reasons to wait a little while. Microsoft Office compatibility As we warned back in June, older Office for Mac will not work with MacOS Catalina. If you have Office 2011 for Mac or […]
The Washington Post has a useful tip for anyone with Apple AirPods that aren’t maintaining a decent battery life. Use the right wording to Apple support and you should be able to get replacement AirPod’s a little cheaper than retail. Now that AirPods are a few years old, customers are finding the little white plugs […]
You can add text that appears smaller and slightly below (subscript) or above (superscript) your main text quite easily in Word. This kind of text is commonly used in mathematics (e.g. X2) and other technical fields (e.g. H2O), but can also be used for something as simple as a date or other ordinal number (e.g. […]
There are options in Word to limit access a document in different ways. It’s more fine-grained control of what people can do in the document rather than the entire document permissions options we’ve mentioned before. Restrict Editing options let you collaborate on a document more broadly without the risk that important parts will be changed […]
Here’s how to add a taste of the logo or text from ‘Friends’ to a Word document, PowerPoint slide or other document. All you need is available online plus a little Office trickery. Note for old-timers (like Peter, our Editor-in-Chief). ‘Friends’ was a televisual entertainment shown on broadcast networks in full color. The plots revolved […]
Outlook on the web is now blocking another 38 email attachments because they can be carriers of viruses. But Microsoft doesn’t block the most commonly used files for infecting computers. Far and away the most common infected email attachment is old-style Word documents, with .doc extensions. Excel .xls worksheets and PowerPoint .ppt presentations are similarly […]
Here’s a complete, searchable and sortable list of all the email attachments that are or soon will be blocked by various types of Microsoft Outlook. There’s confusion and inconsistencies in the Microsoft documentation and application of these new blocks. They have a list of blocked attachments for Outlook in “Office 365,, Outlook 2019 Outlook 2016, […]
NewsBiscuit.com is reporting that Microsoft will release a new Word template for Death Threats. ‘Grammar Nazis are welcoming the news that death threats issued by actual Nazis will soon be correctly spelt and with fewer redundant words after Microsoft announced a new Death Threat template to the latest version of Microsoft Word. A spokesman explained; […]
This is where the Excel Name Box gets really interesting. You can select a cell or range of cells, and give them a name. That name can then be used to find that data again, or in formulas instead of typing in the cell range. It’s the same as going to Formulas | Define Name […]
The Name Box is an unassuming little box at the top of your Excel worksheet that you may not have thought about much, but it has an amazing range of uses. The box is next to the formula bar, and usually displays the address of the cell that you are in. The Name Box can […]
A recent forced disclosure by the US government demonstrates the use of NSL’s which access your personal data from Microsoft OneDrive and Outlook without a warrant or regular oversight, let alone notice to you. Microsoft, Google, Facebook and many other tech companies (including gaming services) have received National Security Letters which demand information about a […]
Office for Windows is now getting an extra on the Home pane – Recommended Documents which tries to suggest documents you’re involved with. Source: Microsoft Recent Documents has been in Office for a long time. That’s a longer list of recently opened documents. It’s quite different from the new ‘Recommended Documents’. Who gets Recommended Documents? […]
As we suspected, there are more holes in the Office Document Inspector. Our clever readers came up with some possibilities for revealing secrets in documents, worksheets and presentations. Document Inspector is good but could be better. As you’ll see, there really should be a warning about objects with multiple layers. The biggest problem with Document […]
Typing or formatting cells of repetitive data can be very boring, but Excel has an Auto Fill feature to make it easier by automatically filling in data for you. We thought we knew Auto Fill but it has some surprising and useful tricks. Auto Fill goes beyond simple incrementing numbers or dates which is what […]
Slowly but surely we’ve moving towards another name change for Office 365. The main Office consumer products are likely to be renamed ‘Microsoft 365’ and here’s just four indicators that a change is coming. This has been looming for some time. Microsoft has been mostly successful getting organizations and consumers onto annual payments ‘subscriptions’ for […]
Word 365 for Mac is getting what’s called the ‘Edit PDF’ feature, already available in Word for Windows. Don’t get too excited, Word can’t really edit a PDF file and the results might not be what you want. The ‘editing PDF’ feature is now available to Office for Mac insiders (v 16.29 build 190830 and […]
Tucked away in Microsoft Office is a little used tag ‘Content Status’ or just ‘Status’ that could help manage and find Word, Excel and PowerPoint documents in organizations. Unfortunately, Content Status is only used once in Office features. It’s supported in Windows Explorer if you know where to look. On the Mac it’s all but […]
In long overdue news, Microsoft has finally agreed to synchronize email signatures between Outlook on different platforms. The news came in the form of a post on the Uservoice site: “We’re happy to report that we’re working on sync’ing signatures across devices. More details to come as we have them.” It’s not much. No timeline, […]
A funny story from satirical ‘The Chaser’ shows what could happen when corporate PowerPoint presentations are taken too far. LinkedIn executive presents moving PowerPoint eulogy at mother’s funeral “Before a packed congregation of relatives and friends, the senior executive paid tribute to his mother through a series of bullet points, graphic charts and bold-font mission […]
Here’s a list of the known Office install/update error codes with possible fixes. All thanks to a diligent and long-suffering Office Watch reader. Ron S has compiled these lists from web sites and forums based on experiences of other people. Doesn’t Microsoft have all this? Yes, they probably do but not for public consumption. Microsoft […]
Just as there is a Handout Master to control how slide printouts look, there is also a Notes Master which has more control over how PowerPoint printed notes with slides will look. If you’ve used the Handouts Master, Notes Master will be warmly familiar to you. Notes Master is like a simplistic template with some […]
One of the most commonly used and confusing Excel functions is getting a major revamp. Vlookup() is getting a new, better and easier replacement Xlookup(). It’s a truly good and useful addition to Excel, some might call it a godsend. Xlookup is now available to Insider releases Excel for Windows/Mac/Apple/Android. It’s a big deal and […]
Better to stick with a stable, known Microsoft Office instead of monthly updates with new and changed features. That rational customer approach isn’t understood at Microsoft who push the regular Office 365 changes on the assumption that’s a universal good which suits all customers. Brian X Chen in The New York Times has a thoughtful […]
While printing PowerPoint handouts for your audience with just the slides can be useful, sometimes you may want to give them your notes as well as the slides, which is where Notes Print comes in. Contrary to its name, Notes Print includes slides as well as your notes underneath them. To print the slides with […]
Consider switching to SumIFS, it’s much the same as the older Excel function, SumIf() but easier to expand as your needs change. It can add up values according to more than criteria like a name and date range. We’ve talked about SUMIF and how its parameter order is a little strange. SumIF has filter/criteria […]
There are two a simple ways to make a list of unique or non-duplicate entries from a longer list. Unlike the many automatic ‘unique’ options in Excel, these options work only once but it’s available in many Excel release, old and new. Advanced Filter One is hiding at Data | Sort & Filter | Advanced […]
Microsoft Word’s dictionary is updated more regularly, especially for Office 365 customers. A good example of that is the addition of Brexit related words. We typed into Word various words that the people of the UK are too familiar with, just to see what’s in the Microsoft dictionary. The same results in Word 365 for […]
A Word document and a floppy disk caught a serial killer back in 2010. There are current lessons for anyone wanting to keep their personal or business data confidential. Known as the ‘BTK killer’, he murdered 10 people in Kansas between 1974 and 1991. The murderer was finally caught in 2004. He liked sending notes […]
Making a list of unique or not duplicated names from a longer Excel list with duplicates is possible in three ways that update automatically. One is headspinningly hard and one has some minor quibbles. The best option is a lot easier but not yet available to everyone. We’re talking here about making a list of […]
Handout Master lets you customize your presentation handouts more than the basics; changing the position and formatting of headers/footers, adding a background color or gradient. Maybe you can help uncover some unexplained mysteries of Handout Master, see below? Our Quick PowerPoint Handouts article showed you how to go to File | Print to print out […]
There are many ways to make a paper/PDF version of a PowerPoint slide deck, this is the quick ‘only a few clicks’ option. There are other choices that we’ll cover in upcoming articles. PowerPoint has some ‘Handouts’ features but they aren’t all in the same place and some aren’t even called ‘Handouts’! Why handouts? It’s […]
The venerable SUM() function in Excel is simple, really too simple. It just adds up a range of cells with no way to filter or limit what’s included. SumIF selects what to add-up from a longer list. SumIf sometimes confuses people because they, understandably, expect the range to be SUMmed to come first followed by […]
A supposedly ‘new’ feature in PowerPoint 365 for Windows is already in regular PowerPoint? The latest Insiders version of Office 365 for Windows has no truly new features. The only ‘new’ feature is something that’s already in Office 365. As we looked down the list of changes in version 1909 build 16.0.12013.20000 it was all […]
