The October preview of Outlook 2016 for Mac is now out with some features from other releases now on the Mac. Version 15.27 (161003) As explained by Microsoft: More functions: In Excel, use CONCAT or TEXTJOIN to shorten your text formulas, or Excel try the forecasting functions to help you
Now Facebook has joined the race for business money with Workplace by Facebook, a non-social network for your work colleagues. How does it work with Microsoft Office? Workplace by Facebook joins Office 365, Slack and others in providing a central location for people to communicate on work matters. A team
Peter Nadin is our Excel hero. He’s gone to extraordinary lengths and used the power of Excel to save money on his electricity and gas bills. In various countries, there’s been a deregulation of the energy market which was intended to save consumers through a choice of suppliers. It’s led
Maybe you don’t want a full list of stock prices or exchange rates to lookup various values. All you want is a single stock price or exchange rate to update your worksheet. That’s certainly possible by narrowing down the query so it returns a single value and no more. Select
The last two weeks we’ve been looking at getting current information from the internet into a worksheet, like currency exchange rates and stock prices. Now let’s look at how to take that information and use it in your worksheets. For this article, we’ll be using Excel 2016 for Windows because
At the 2016 Ignite conference LucidChart received a few gongs in the Office App awards. Lucidchart Diagrams for PowerPoint Add-in won the “People’s Choice Award” and a second place award for “Most Business Value for an Office Add-in.”. Source: LucidChart Office-Watch.com had a look at Lucidchart a few months ago.
There are ‘Office Online’ plugins for both the Google Chrome and Microsoft Edge browsers. These extensions sound great and, from the hype, seem amazing but are little more than fancy links to the browser based versions of Word, Excel, PowerPoint, OneNote and Sway. The extension sits as an icon in
A more likely breach of your privacy than government intrusion is identity theft by hackers. Data stored online is a like a smorgasbord open 24/7 of personal information waiting to be stolen. LexisNexis Risk Solutions have released a survey showing how much critical personal info people are saving ‘in the
Anyone who uses email or cloud storage should be worried about some news stories of last few days. They show how email hosts and cloud storage is regularly snooped on by law enforcement who also act to keep it secret. This isn’t targeted court orders against specific people. This is
We’re in the middle of a series on getting live internet data directly into Excel and it’s been a pleasant surprise. Currency Exchange Rates and Stock/Index data can automatically update your Excel worksheets. Microsoft has been improving the data connection features in Excel, especially Excel for Windows. It’s happened gradually
Visio is coming to mobile devices, according to Microsoft. Apple, Android and Windows. The Visio for iPad preview program was started last month. The app lets you view Visio diagrams that reach your iPad from email, OneDrive, OneDrive for Business and Sharepoint. View files from OneDrive, OneDrive for Business, or
Last week we showed you how to get currency exchange rates into Excel as well as the overall method for grabbing info from the web to add to your worksheets. We had a lot of feedback (thanks) and it’s clear that many readers want a simple way to import the
Here’s another method of getting stock prices into Excel. It’s part of a series: introduction and using MSN Money in Excel. This time we’ll use the improved Query system in recent versions of Excel combined with data from Google Finance. It’s a sad indictment of Microsoft Office that the best
Here’s how to grab stock price and indexes into Excel via MSN Money. It’s part of our series on getting ‘live’ data into Excel – Introduction and the Google Finance option. Microsoft dropped the MSN stock quotes option from Excel but they are still available. Use the ‘web page scraping’
Vladimir Putin, the Russian President has called for more ‘digital sovereignty’ and the Moscow city council is obliging by uninstalling Microsoft Office. The Moscow city government will switch away from Office. Firstly, on 6,000 computers and eventually the machines for all 600,000 employees. It’ll be replaced by MyOffice from New
Last week we talked about Hewlett-Packard’s attempt to boost revenue by changing their printers to stop non-HP ink cartridges from working. Today they’ve announced a rollback of that update. In about two weeks from now they’ll release a firmware update. That update should remove the need for cartridges that have
A 2016 survey reported that 40% of organizations store passwords and login details in a Word document or Excel spreadsheet. Is that such a bad thing? The survey also says that 28% use a shared server or USB stick to retain login details. All this is being reported as a
Sometimes it seems that Outlook is automatically deleting old messages or messages you want can’t be found – where could they be? This is an occasional question and hard to answer. Let’s look at some of the possibilities for missing messages, starting with the most common problem we see. Online
Microsoft is now rolling out more of their Mentions feature showing that it goes beyond a simple addition to Outlook. Mentions uses the idea of @<username> tags (borrowed shamelessly from Twitter) to extend your options for searching within messages. The feature is in the current previews of Office for Windows
Last week had more news stories about email accounts being hacked and contents made public but don’t feel sorry for the victims, they only have themselves to blame. Colin Powell uses Gmail – which was hacked. The US Democratic Committee had their Microsoft Exchange mail server hacked releasing 19,252 emails
Outlook.com will soon get the ability to attach photos from Facebook into your messages. A slap in the face for paying Office for Windows customers. Also coming are links to Google Drive (links to OneDrive, Dropbox and Box are already available) but what sticks in our craw is the Facebook
Microsoft has opened data centers in Germany which have significant advantages over their server farms in other countries. The data centers in Frankfurt and Magdeburg (near Berlin) are being called the ‘Microsoft German Cloud’. What’s different about these data centers compared to Microsoft’s other locations in US, UK, Australia, Asia
The battle between printer makers and third-party ink/toner makers continues with news that Hewlett-Packard has added blocks to stop non-HP ink being used in their printers. Here’s how to avoid paying more than you need to. This has been going on for years. Printer manufacturers now make most of their
Coming in the next few days to Android and iPhone is Google’s entry into the world of online messaging – Google Allo. Allo has some interesting ideas but lacks two important features that disqualifies it from use for us and most Microsoft Office users. Security Allo disappoints in terms of
