Have you ever come across situation where you assiged a just an exchange license out of the E3 stack and your organiation now wants to get a detailed report of all the licenses assigned? Now, this might appear simple to a beginner and the a simple answer to this problem will be to run the command Get-MSOLUser -all | select UserPrincipalName,DisplayName,Licenses .Ironically this won't give you the granular information you are looking for and would state the entire stack for the license which is applied.
Office 365 treats each license as a stock keeping unit (SKU) and a SKU might contain more than one offering e.g. E3 license contains sevices like Sharepoint, Exchange, Yammer, Delve, Sway etc. As an administrator you might choose not to provide all the services to an individual which is an advantage for an administrator as he/she gets the liberty to control the users but this comes at a cost of reporting license details and its not an easy task till you know powershell.
I have compiled a script to make this job easy. you will need to run the following script in Powershell ISE** (you can run the script in powershell, but since I have formatted the script. Chances are you might miss the formatting and may not able able to run it properly)
Once you run the script you will be prompted to enter your office 365 global admin credentials. This script might take some time to fetch details so be patient. It will prompt you to save the file as csv in a location. Select the path and you shall get the report as a CSV file.