Job Requires using a already created pivot table in excel.
We require all data to be sorted by categories. Then within each category we need the data put into summaries comparing:
- Monthly comparisons
- Seasonal comparison
- Annual comparison
All summaries, must include:
We need to be able to look at the data summaries and demonstrate:
- the rankings of the products in that category - By revenue or QTY
- the top supplier for the month - By revenue or QTY
- the items that sold the most units for that Period - month, season, year
Also if you feel there are other summaries we can create to analyze the data, we will consider that as well.
YOU MUST KNOW HOW TO USE EXCEL AND WORK WITH A PIVOT TABLE.