So, I am trying to organize data for a startup company in Excel so it's more presentable. Currently, a lot of our data is being collected by 3 different CRMs and Google analytics. I just want to organize a lot of this data in Excel for the time-being until we can set up an organized and consolidated CRM. So here's the situation:
1) We have 5 different cities that we operate in (Let's say NYC, Boston, Chicago, LA, and Seattle)
2) We have a bunch of different metrics that I want to see by city (Bookings (number), avg booking revenue, Pageviews, Conversion rate from web traffic, Conversion rate from referrals, Conversations (number).
3) I also want to see this data by month (I want to see the January 2014 data, the February 2014 data, etc.). How do I do this?
Does Excel have 3 dimensional tables? How do I create one of these? Is my question clear?
1) We have 5 different cities that we operate in (Let's say NYC, Boston, Chicago, LA, and Seattle)
2) We have a bunch of different metrics that I want to see by city (Bookings (number), avg booking revenue, Pageviews, Conversion rate from web traffic, Conversion rate from referrals, Conversations (number).
3) I also want to see this data by month (I want to see the January 2014 data, the February 2014 data, etc.). How do I do this?
Does Excel have 3 dimensional tables? How do I create one of these? Is my question clear?
