BitGlass and Cylance have found some new ransomware called Shurl0cker that managed to fool both Google and Microsoft’s scans to arrive on their customers cloud storage. According to the researchers: “Two well-known cloud platforms with built-in malware protection, Google Drive and Microsoft Office 365, failed to identify the ransomware. In
Dropbox stores not just your current documents but past versions too. Let’s drill down and see how to dump your files in the Dropbox and what does Dropbox do to make life easy? I have created a folder in my Dropbox named “Projects”. It contains some of my work assignments
If you’re browsing your Dropbox account at their web site, select a document then look at the Open menu for options. Copy to Paper – Paper is Dropbox’s own online collaboration tool. Open in Word 2016 – the Dropbox site has detected the presence of Office 2016 on the computer.
Adding Dropbox to your Word Online, Excel Online or PowerPoint Online place list saves some extra steps. Then you can quickly open, create, modify and saves files to your Dropbox. To add Dropbox to Office Online: Go to OfficeOnline.com (https://www.office.com/), open Word, Excel, or PowerPoint Online. Click Add a place, under ‘Open
Dropbox has integration direct into Microsoft Office 2016 for Windows It’s best to install the Dropbox app (https://www.dropbox.com/install) on your devices. Of course, you can always access the Dropbox website https://www.dropbox.com from any laptop, computer or smartphones and tablets. Once Dropbox is installed on your desktop, you’ll notice a new
The latest Word, Excel, PowerPoint and OneDrive apps for iPhone and iPad have some genuinely good and useful changes. iPad users are the main beneficiaries of the changes. If you push past the usual Redmond buzzwords ‘collaboration’, ‘co-authoring’, ‘create’, ‘experience’, ‘delight’, ‘productivity’, ‘from the ground up’ and the ever present
Microsoft has announced better Hindi, Bengali (Bangla) and Tamil online translation using AI enhancements in Microsoft Office, Bing and other online services. The company has dropped their latest buzzwords like “artificial intelligence” and “deep neural networks” but what does it really mean for Microsoft’s customers? Our headline translated into Hindi,
After a seven month testing period, Microsoft Office desktop programs are available for Windows 10, especially Windows 10 S users via the Microsoft Store. Until now, the cheaper Windows 10 S machines could only run the ‘Mobile’ or UWP apps not the full-featured Office desktop programs. Now Word 2016, Excel
Back in Excel 2013, Flash Fill was added, a nifty way to join or separate a string from other cells by example. If its seems to have disappeared from Excel 2016 for Windows, here’s how to get it back. In Excel 2013, Flash Fill worked automatically. Just typing the first
We’ve talked, at length about Excel’s Rank()/Rank.EQ functions and coping with joint or equal rankings. What about Rank.AVG()? Rank.AVG() works differently for equal rankings because it returns an average of the combined rankings. For example, joint 3rd place getters will return the value ‘3.5’ by Rank.AVG() which is the average
Rank() and Rank.EQ() are fine while each value/score is different but in the real world you’ll see cells with the same value and ranking. We’ll show you how to detect equal rankings, display a note when there are equal rankings. Let’s start with an example of equal rankings. See Venus/Vulcan
So many patches for Microsoft Office and Windows in this month’s package of bug fixes. Few parts of Windows or Office aren’t patched this month, either directly or indirectly. According to Microsoft there’s ‘only’ 56 patched security holes in their products, this month alone. In reality there’s a lot more
Back in Excel 2007, Tables were added. That simple name hides a quite different and powerful Excel option that, in our view, Microsoft hasn’t explained very well. Excel is often used for lists and Excel Tables make managing and extending those lists a lot easier. In fact, ‘Excel Lists’ was
Slicers are a better and easier way to filter lists and it’s available in Excel Tables as well as PivotTables. From Office 2013 Slicers appeared in the Tables tab, before that Slicers were only for PivotTables. Which is great because it makes filtering an Excel table a lot more obvious.
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
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
