Do some Excel Work

I have a project that I need help with ASAP.

I am looking for someone who can not only do the work, but can help explain the process as well. It would be great if you could show your work in the Excel file and build it to be logical and easy to update with new information. This will be an ongoing piece of support provided The technical back-end of the file is very important.

Here is a description of the project:

Your manager has has asked for a quick way to measure, compare, and rank the financial performance of 6 stores.

The metrics are

• Metrics: Sales $, Gross Margin $ (GM), # of Dine In and To Go Customers.

• Timeframe by week and year.

• Store name / number.

• Product Category

Deliverable #1:

Add a 1 page ‘summary report’ tab to the attached dataset in Excel.

• The ‘summary report’ tab needs to print on one page

• The ‘report tab’ needs dynamic drop down menus to toggle between store, week, and any other functionality you would like to showcase. No Pivot Tables!!!

• Areas of interest are growth and margin profitability for each store, as well as the entire market. Trends are important.

数据输入 数据处理 Excel 财务分析

项目ID： #11085507

关于项目