Dropbox document sharing with Microsoft Office
Here’s how to share Microsoft Office documents (Word, Excel or PowerPoint) for viewing or editing via Dropbox. Document collaboration works a little differently in Dropbox compared to OneDrive. There are different methods and limitation for sharing on Dropbox. We’ve already shown how to install Dropbox, enabled the Microsoft Office Online features and use the Dropbox […]
Dropbox Badge, a collaborative tool in Microsoft Office Windows and Mac
Dropbox Badge is their document collaboration option that provides Dropbox specific features inside Microsoft Office programs, It works with a refreshingly wide range of Office version. Microsoft Word, Excel and PowerPoint for Windows and Macintosh. Office 2007 to 2016 for Windows. Office 2011 and 2016 for Mac. It only works with ‘modern’ Office document formats […]
ShurL0ckr ransomware gets past Microsoft and Google to infect cloud
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 addition, Bitglass tested VirusTotal, a […]
Dropbox Folders and Versions
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 that I have been working […]
Open an Office document from the Dropbox web site
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. Microsoft Word Online – opens […]
Adding Dropbox to Office Online
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 from OneDrive’. Select Dropbox. You will […]
Installing Dropbox into Microsoft Office
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 Dropbox folder on your hard […]
Better OneDrive and Office apps iPhone and iPad
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 ‘excited’ there are some changes […]
Improved Office translation for Hindi, Bengali/Bangla and Tamil
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, Bangla and Tamil, according to […]
Office desktop now available via Microsoft Store for Windows 10
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 2016, PowerPoint 2016, Outlook 2016, […]
What happened to Flash Fill in 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 example in a neighboring cell […]
Rank.AVG() and how it’s different from Rank() and Rank.EQ() in Excel
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 of ranks 3 and 4 […]
Two ways to show equal rankings with Excel’s Rank() or Rank.EQ()
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 in this example, both have […]
January 2018 Office updates roundup
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 patching going on, just how […]
What are Excel Tables and why you should use them
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 the name of the Tables […]
Excel Slicers beyond PivotTables into Tables
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. Making a Table Slicer is […]
