Further to my previous post about this, we have managed to get this working successfully now with a variety of guest users (with email addresses which are outlook.com, or associated with Azure Active Directory or Azure ADB2C accounts).
Why is this so useful? Because it means that in order to collaborate with users outside your organisation (including being able to share files, hold online conversations, video chats, do online voting within your team), all you need is one of the following Office 365 subscriptions (see this Microsoft link)
Guest access is included with all Office 365 Business Premium, Office 365 Enterprise, and Office 365 Education subscriptions. No additional Office 365 license is necessary. Guest access is a tenant-level setting in Microsoft Teams and is turned off by default.
This should not only be much cheaper than alternative collaboration software (e.g. box.com) but also allows your staff and guest users to use tools that they will increasingly become familiar with (Office 365).
(Posted by Patrick Lee on 10 August 2017 at a different location, but migrated here on 05 Feb 2018).
You may not know that Excel 2016 added some useful new charts for analysing data. I particularly like the Treemap, Box & Whisker and Pareto charts. (The images below are taken from this Microsoft post, please see that link for more detail on these and other charts).
The Treemap gives you a quick view of which categories are most significant:
(Posted by Patrick Lee on 8 August 2017 at a different location, but migrated here on 05 Feb 2018).
I have long thought it would be useful for there to be a standard format for exchange of data files for DB (Defined Benefit, i.e. final salary or career average revalued) pension plans, at least in the UK initially.
This would make it easier for pension plans to share information (with actuarial consultants, but also other advisers e.g. buyout companies, investment analysts), not just in mergers and acquisitions, but also in risk transfers (longevity, or pensions buyouts) and would improve the comparability of analysis across companies by investors etc. It should also reduce costs for trustees and plan sponsors, and may increase the quality of the data held.