I love the idea of ArcGIS Pro, especially for non-GIS analysts to get one-off maps done easily and quickly.
The big question is: Does ArcGIS Pro join to excel worksheets like ArcMap does?
At this time ArcGIS Pro cannot see or use Excel spreadsheets. This functionality might be added later, but I haven't seen any firm indication of when that might be. It is currently in Pre-release and due to come out with ArcGIS 10.3.
Yes it does now but it's not as robust (compared to mapinfo which does this very easily). See https://community.esri.com/groups/esri-training/blog/2017/05/26/working-with-excel-data-in-arcgis-pro