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
Bluetiful will be the new Crayola color. It’ll be generally available from January 2018 or you can use it right now in Microsoft Office with these tips. Office-Watch.com told you about the demise of Dandelion, the now defunct Crayola color. And we showed how to keep Dandelion in your Office
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
10 October 2017 was an important date for Microsoft Office. It marks the end of support and updates for all ‘flavors’ of Office 2007. From now on there’ll be no updates or patches. Not even security patches to fix vulnerabilities available to hackers. It applies to the entire Office 2007
The October bundle of Office security patches includes one for a bug that’s already known and being used by hackers. Known as CVE-2017-11826, this is a Word bug which allows a malicious RTF/DOCX combination to access your computer. The attack uploaded all the documents, images etc that it could find
Here’s how to control what Outlook does when it gets a Read Receipt request with an incoming email. The setting is at File | Options | Mail | Tracking, just below where you set the options for outgoing Read Receipts. That’s Outlook for Windows, see below about Outlook for Mac.
It’s possible to run Microsoft Office on a Linux computer and Zorinos makes that easier than most. The Linux operating system can be combined with ‘WINE’ which allows many Windows programs to be run on Linux directly. Zorinos comes with WINE ‘baked in’ to the operating system, saving the hassle
A new vulnerability in Word was discovered and patched by Microsoft earlier this month. Again, the source was an RTF (Rich Text Format) document. There’s still a widespread myth that RTF files are ‘safe’ supposedly because RTF’s can’t contain macros. That’s FALSE. .RTF documents aren’t designed to accept code, they
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
A new bit of spam or phishing got past our multiple spam filters and into our Outlook 2016 Inbox. It’s a good example of what check in an unexpected message. The message uses the name and link from a real law firm but they’re not to blame. It appears to
Outlook for iOS and Android has a of plugin with support for animated GIF’s which is very strange indeed. Gfycat has released a plugin for Outlook iOS and Android that lets you choose animated GIF’s to insert into your messages. Source: Microsoft/Gfycat You can add animated GIF’s to emails from
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
A hidden trap in the 64-bit versions of Microsoft Office 2016 or 2013, they can’t work with MPEG-4 video .mp4, audio .m4a, nor QuickTime .mov . If you’ve ever seen this error message: “PowerPoint cannot insert a video from the selected file. Verify that the necessary 64-bit codec for this
By Mayurakshi Mohapatra Adding a picture to an Outlook contact is a good way to make the contact more identifiable. If you are bored seeing the initials or boring graphic next to the Outlook contact name, no worries, at all. Outlook lets you add, change or remove an existing picture
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
Organizing your time at a busy conference, arts festival or other composite event is easier with Microsoft Outlook. Either for yourself or coordinating with others. Here’s how. These are ‘real world’ Office suggestions you can use for any busy conference, festival or event. Not just the official Microsoft advice but
Ransomware hasn’t gone away, it’s just not making headlines. MalwareBytes reports that two more variations of the Locky ransomware have appeared in the last few weeks. Beware DOC and DOCM They spread in ZIP files or the hackers favorite way to infect a computer, Microsoft Office files, most likely Word
The New York Times has a nifty new calendar of upcoming space related events including eclipses, meteor showers, launches etc. Here’s how to add the NYT Astronomy and Space Calendar into Outlook software. The service is directly linked to Google and Apple iOS devices (iPhone / iPad ) with Outlook
Can you believe it, PowerPoint is 30 years old? Originally called ‘Presenter’, in 1987 it was renamed to ‘PowerPoint’ by Robert Gaskins. Later in 1987, Microsoft bought the software out of petty cash (i.e. $14 million). 22 May 1990 was the first release of Microsoft PowerPoint for Windows, the birthday
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
Where does Outlook hide its main data files? The .PST or .OST files which have your email, calendar, contacts and more. Outlook data files can be anywhere on your computer, but the default location is usually in a hidden folder: \Users\<username>\AppData\Local\Microsoft\Outlook \Users\<username>\Roaming\Local\Microsoft\Outlook The location can vary a lot, depending on
A common Windows Indexing / Search problem is Outlook itself. Windows Search stops while indexing Outlook data and never reaches the end. Here’s some suggestions on how to fix it. An indexing problem means your Outlook data can’t be searched or not everything has been indexed (partial search results). Even
The British Library has a collection of over a million copyright free images for use in Word documents and PowerPoint presentations. They are on Flickr and a good place to start is the albums. A few that caught our eye are: Women of the World Illustrated Letters and Typography –
