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
The latest ‘Fast Ring’ Insiders update to Office for Windows restores the correct versioning between the Fast and Slow Ring ‘Insiders’ releases. Normally, the latest changes and new features appear in the Fast Ring release. After the bugs have been discovered by the fearless Fast Ring testers, an update goes
Windows will automatically index and let you search Office documents on your computer or network – how can you stop that happening? Maybe the document is personal or so private you don’t want anyone to find it with a Windows Search. Or discover that the document even exists! Password Protection
It’s now possible to change the default layout for a new Excel PivotTable. PivotTable default configuration has been on the ‘wish list’ for many years. It’s now in Excel 2016 for Windows, Office 365 customers only as part of the May 2017 update. The changed defaults apply to all new
