The FBI is using evidence from Microsoft Word to oppose a change of release conditions for former Trump campaign chairman, Paul Manafort. We’ll show you the mistakes that were made and how to avoid them. We’re not interested in the prosecution itself nor the politics, here’s a summary. Our focus
PivotTable Slicers and Timelines can be combined to filter by time and other criteria in Excel. Let’s first add a slicer to filter the data by following the below steps: Click inside the PivotTable and go to the Analyze tab Click Insert Slicer under the filter group. From the Insert
Timelines are a special form of Excel Slicer for PivotTables, to make filtering dates easier. Timelines are slicers that allows you to filter date fields and only date fields in PivotTables. The feature shows you a series of events grouped by time. Here’s a Timeline filtering a PivotTable to show
The Australian tax authorities have released some interesting data about the biggest corporate (non) taxpayers in an Excel format. It’s raw data ready for extra calculations, charts and PivotTables. Another example of how publicly available data can be used by anyone to dig into previously obscure areas using Excel tools.
Microsoft has released Office apps that work on Chromebooks, the low cost laptops using Google’s Word, Excel, PowerPoint and OneNote apps are now available for most, if not all, Chrome OS users. There seems to be some teething troubles with the Office apps and the Google Play store. Redmond hasn’t
Tamil language has been added to Microsoft’s suite of translation apps and services. There’s about 70 million Tamil speakers mostly across Sri Lanka, India, Singapore and Malaysia. We checked with Office 2016 for Windows, Office 365 and sure enough there was Tamil among the many language choices. Beyond Office The
Rarely do you choose a single Slicer button. More likely you’ll want to select multiple filters or buttons, here’s the various ways to do that. You can press the filter icon next to Beverages and then select multiple items if you want to see both. Just like other parts of
From Excel 2010, Microsoft added Slicers to Excel’s PivotTables. From the hype, Slicers sound like some complex Excel feature but they’re really a more useable, friendly and showy way to do something already in Excel – Filtering. For me it’s more of a visual filter and a collaborative tool that
Simple PivotTable filters let you limit the table display to a part of the available data. They have a place in PivotTables, especially for semi-permanent filters that you want to apply broadly. Instead of filtering the original data feed or list, the PivotTable can use a large list which is
You’re not locked into the PivotTable sorting options provided by Microsoft. Excel lets you arrange a PivotTable into any order you like. Right-click on a PivotTable column and choose Sort | More Sort Options | Manual. How to Drag and Sort It’s not obvious how to select an item (row
Sometimes you want to sort a list or PivotTable in a special way that doesn’t fit the usual ‘A to Z’ or number order. The most common need for this are days of the week or months in a year. Neither of those orders make sense to a literal computer.
You still want to explore more Excel PivotTable sorting, there are some additional options like Click More options button on the Sort dialog box. The More Sort Options dialog box appears for your Sorting list of the Pivot Table. Let’s see what these additional features can do for you: As
Excel allows you to sort a PivotTable in alphabetical order or from largest to smallest values. They are similar to the standard Excel sorting options but worth looking at separately because there are automatic sorts, custom sortings and a manual sorting option. Quick PivotTable Sort Sort the PivotTable by right-click
Next Wednesday, Australia gets the results of their Same Sex Marriage survey with the details available to everyone with Excel. Here’s how to get the survey results, prepare for the announcement and when it’ll happen. We know most people won’t be interested in this singular Aussie exercise in democracy (don’t
By default, PivotTable provides custom name such as “Sum of Amounts” or Count of Numbers” etc when you add a field to the table. You may not be always happy to use these default custom names for your PivotTable, so feel free to modify the headings to something you like.
Moving or swapping fields around in a PivotTable is both amusing and addictive at the same time. You cannot stop yourself from rearranging your data in different ways. Each time you move a field, the Pivot Table will restructure to the new field configuration and you see the same data
You will always find Excel either summarizing your data by adding the values together (SUM) or Counting the number of items. Nobody is stopping you from changing the type of calculation that your work demands to include averages, maximum, minimum, standard deviation and others. Change the calculation from the Value
Apple has introduced a new image and video format for iPhone and iPad, here’s how to handle it in Microsoft Office documents. .HEIC image files are made by default in some Apple devices with iOS 11. Microsoft Office and Windows don’t support the new format yet but there’s workarounds available
OneDrive will automatically save past versions of an Office document, here how to access those revisions quickly. The advertised way to view a document history is through the Activity button, next to Share on the top right. In Office 2016 for Windows, Office 365. The Activity pane shows a list
A recent Office addition is ‘Shared with Me’, a list of the documents you’ve been invited to collaborate on with others. It’s available in Office 2016 Windows/Mac and the iPad, iPhone and Android Mobile apps. According to Microsoft ‘Shared with Me’ ” lets you see the files others have shared
Office 2016 for Mac (Office 365) has the same document sharing options as Office for Windows but they look a little different. In fact, Office for Mac has an additional sharing option not available in Windows. Just like Office 2016 for Windows, Office 2016 for Mac has a Share button
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.
