If you are using HubSpot without the Reporting Add On, you can create Custom Views for the 4 main record types:
You can save and share your Custom View and export the data to excel.
You cannot "blend" data between these record types and you cannot publish the report or add to the dashboard. For this, you'll want to use a Professional License Hub or the Reporting Add On.
With the Reporting tool, you're able to do much more. Reports like these become possible.