Query Active Directory in Excel

Excel 2016 comes with something called "Get and Transform" which allows you to query Active Directory stores. This is known as "Power Query" in other versions of Excel. Data discovery - made simple (or fairly simple).