Options to easily import live data about stocks and locations into Excel are coming. Microsoft is uncharacteristically quiet about these new features and not using their usual hype. Microsoft is soft pedaling these features by talking about ‘new data types’ which sounds very dry and complicated. It looks more interesting
Should you even bother bulk converting old documents (.doc .xls .ppt) into the newer Office formats (.docx .xlsx .pptx etc.)? It’s tempting to look at your older documents (doc etc) and think about converting them into the newer Office formats. There’s some advantages to conversion but it’s more difficult than
If we’ve said it once, we’ve said it a thousand times … ignore or delete any .DOC .XLS .PPT files you get via email or shared. The main carrier of virus infection is Microsoft Office documents, a fact that Microsoft doesn’t like to talk about. What Microsoft doesn’t say is
What should you do when Microsoft asks to see one of your documents? Submit the files or not? There’s no easy answer when Microsoft asks to see a file from your computer for their anti-virus system, Windows Defender. Do you send the files or not? This can happen with Defender
You’ve all heard about “The Cloud” as if everyone knows what it is. It’s clear from recent reader messages that not everyone knows about The Cloud. Or they think they know. Or they don’t realize how much the cloud can and will do. Office-Watch.com explains the cloud and how it
Timeline was a new feature in Windows 10. It was a way to see which documents and files you’ve opened across all your devices. What you won’t hear is that Office already has a similar feature. The Office team has already synchronized the Open / Recent Documents lists across Word,
A new report confirms what most Microsoft Office customers know; there’s more security patches in Microsoft products, despite years of promises. Not just the latest Word, Excel and Powerpoint but even new products like the Edge browser are increasingly vulnerable. An Avecto report shows 87 vulnerabilities in 2017 – a
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
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
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
