I have an Excel 2013 workbook with some raw data tables on a few sheets and I want to make several pivot tables from it and then some pivot charts and display them nicely in a dashboard or two.
I know exactly what queries I want from the data but have no time to study how to make pivot tables/charts properly.
Also, I have to manage it in the future - add more raw data, maybe add another chart etc. - So I want someone to :
1. Build me the pivot tables and charts in a logical way
2. Add in a simple data entry form to the raw data tables
2. Explain how it works and how to manage it in future (user documentation?)
I don't want macros/VBA, Access functions like MS Query or anything that needs tech. support as the data entry and dashboard will be looked after by someone with no excel skills. So it must be simple.
This project probably be done in a few hours by someone expert with PT.