How to run Office 2016 for Windows on a Mac
Crossover, the Windows emulation for Mac computers, has released v17 which adds support for Office 2016 for Windows. With Crossover v17, the default compatibility has changed from Windows XP to Windows 7. That’s a big improvement and opens the way for a lot more recent programs to run like Quicken 2017. There are also some […]
Paul Manafort was trapped by Microsoft Word and how he could have prevented it
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 is on the little known […]
Using Slicer and Timeline together
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 slicer dialog box, choose the […]
Timelines for date filtering Excel PivotTables
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 only results from a single […]
Click here to see Aussie accounting magic in Excel
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. The “Corporate Tax Transparency” report […]
Office now available on Chromebooks
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 exactly shouted about this extension […]
Tamil language comes to Microsoft Office
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 language is also on “Bing […]
Multiple Selections in Slicers for Excel PivotTables
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 Windows, hold down the Ctrl […]
Excel Slicers for PivotTables
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 can help you figure out […]
PivotTable Filters in Excel
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 narrowed down to what you […]
PivotTable Manual Sorting in Excel
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 or column) to move it. […]
PivotTable Custom Sort Orders in Excel
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. Excel has a Custom sort […]
Automatic sorting of PivotTables in Excel
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 the name suggests ‘AutoSort’ automatically […]
Sorting PivotTable Fields
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 on any cell in a […]
Same Sex Marriage Results in Excel
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 get us started …) It’s […]
Rename Excel PivotTable headings
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. Click on the column heading […]
