It’s always been possible to email a document for reviewing or editing. Modern versions of Office make that easier by letting you email from the document directly, instead of an email program like Outlook. Instead of opening your email to send an attachment, click on Send as an attachment from
The Share pane in modern Office is fine within an organization or with people who are familiar with document collaboration. But what if you want to share a document link with more detail in the email or using a non-email method like Instant Messaging? Well, you want to get just
Ever since Microsoft added shared, collaborative documents via OneDrive, they’ve had problems with saving and sign-in. Here’s how to deal with some of those persistent bugs. These bugs can happen in Word, Excel, PowerPoint or OneNote. Most commonly with documents saved to OneDrive but also Dropbox or other cloud storage.
It was a small but long awaited addition to Excel for Windows but now it’s disappeared? Why did the Chart option “Show #N/A as an empty cell” go missing? There was a small cheer in the Excel charting community when Microsoft put this extra option in the Chart | Hidden
A list with groupings (like Product Type, Country, Region or Staff pay level) can become a nested PivotTable. The sub-totals are created with + – signs to show/hide the groupings. We’re using the same source list as in our Basic PivotTable and Two-dimensional PivotTable examples. Doing that is simple, just
We started with a simple Excel PivotTable, now let’s move on to a multi-column or two dimensional PivotTables. They aren’t a lot more complicated than a basic PivotTable, just add a few more fields. We’ll start with the same sales list that we used for our PivotTables 101 article. This
PivotTables really are great and we’re not just saying that because it was one of Bill Gate’s favorite features. The original PivotTable feature was clumsy and difficult so you’re forgiven for trying them and giving up in disgust. Mayurakshi wants to show you some of the nifty parts of PivotTables
Make smarter decisions with Excel’s tables and lists. Excel is a great place for comparison shopping or deciding which product to buy. Unlike Word or OneNote, Excel has tools to sort, filter and do calculations to help you narrow down many choices to just a few or one. In this
Excel 2016 for Windows is getting some welcome ‘under the hood’ performance improvements. It’s great to see some work on the fundamentals of Office instead of the apparent focus on flashy new features that look great in demonstrations. Word and Outlook teams: please follow suit. The Problems The aim is
We’re delighted to announce that our champion Office 2016 ebook has been updated, yet again, to include new and added features for the main Windows version of Microsoft Office. A bit like Office itself, Office 2016: the real startup guide is updated to keep pace with the improvements in Office
Microsoft has released another version of Office 2016 for Windows to be tested by insiders. This one is bought and installed from the Windows 10 Store. Naturally Office-Watch.com dived in to check it out. At the moment, only some Windows Insiders and users of Windows 10S can get Office in
If you love digging into US election details you’ll love these spreadsheets with US Presidential Election results, by County and Party from 1836 to 2016 Unleash your inner Nate Silver, see how your county or state voted over the years, starting at Google Docs There are tabs for each state
Logitech has a new Craft keyboard with a control wheel that works with Word, Excel and PowerPoint. It’s a high end keyboard that seems to have a lot of interesting points. Source for all images: Logitech It has more than one wireless connection, instead of the usual one. Either Bluetooth
The Microsoft Office Championships are done for 2017 with talented young people from all over the planet among the winners. We have the full list of winners. The competition is for students 13-22 years with categories for Word, Excel and PowerPoint in 2013 or 2016 versions. Outlook, Access, Visio and
The free office suite, LibreOffice, has released with better Microsoft Office compatibility and a sly dig at their bigger rival. LibreOffice 5.4 has its own Open Document Format (.odt etc.) which is similar to Microsoft’s .docx format. LibreOffice can work with both formats. v5.4 has improvements in the Microsoft Office
The Word, Excel and PowerPoint apps for Windows 10 computers are hiding from the Microsoft Store. Here’s how to get them. Word, Excel and PowerPoint have ‘mobile’ versions that run on Windows 10 devices for full PC’s, tablets and Windows phones. Here are the links you need, since Microsoft has
Microsoft’s annual giveaway of ebooks is on again. Thousands of free downloads, including Office related ebooks. The full list is on the Microsoft blog. We’ve copied the Microsoft Office related titles into a easily searchable list below. Most are in PDF format with a few in MOBI (Kindle), EPUB
Excel is main focus of this month’s security patches from Microsoft. It’s a familiar story, so Microsoft recycles their stock phrases from similar security lapses in the past. A ‘specially crafted’ document can cause a ‘memory corruption’ in Office. The July 2017 patches fix not one, but two separate design
Microsoft proudly added accessibility features to Office 2016 for Windows, in particular ‘Alt Text’. Pity it’s not been refined and fixed once the hype died down. Earlier this year, Microsoft added an ‘Alt Text’ feature to Office which tries to automatically suggest alternative text for visually impaired readers. Right click
Images inserted into your Word documents are being automatically uploaded to Microsoft for the accessibility ‘Alt Text’ feature. Even if the image and document are saved on your computer, not cloud storage. It’s a hidden ‘feature’ in Office 2016 for Windows desktop (Office 365 subscribers). Earlier this year, Microsoft added
Get Microsoft Office for no money, nil, ziltch, nada, bugger all. It’s legal, easy and this article explains the many options available. We’ve not talking about ‘Office wannabes’ but Word, Excel, PowerPoint or OneNote from Microsoft itself. They won’t have all the features of Office 2016 for Windows desktop. There’s
It’s expected that today (15 June 2017), Microsoft will release ‘Office in the Windows Store’ as a new way to buy Office. Understand the differences between it and ‘Office 2016 for Windows’ or the Windows 10 / Modern apps for Word, Excel, PowerPoint and OneNote. The new release is not
Most color printers have a secret tracking or forensic code added to every page that lets governments and others know when and where the page was printed. It’s just one result of last week’s NSA leak and later arrest. One piece of evidence against Reality Winner was the secret code
This is a really screwy error message. You try to start an Office desktop program and are stopped with the message ‘This app can’t run on your PC’. Here’s the fix. To make it even stranger, some Office programs will work while others say they can’t run? We’ve seen the
