Скачать или смотреть Exp19_Excel_Ch10_Cap_Auto_Sales | Excel Chapter 10 Capstone - Auto Sales

#Exp19_Excel_Ch10_Cap_Auto_Sales #Exp19_Excel_Ch10_Cap_Auto #Exp19_Excel_Ch10_Cap #Sales #Auto_Sales #Cap_Auto_Sales #Ch10_Cap_Auto_Sales #Excel_Ch10_Cap_Auto_Sales #Exp19_Excel_Ch10 #Exp19_Excel #Excel_Ch10



Contact Me For Assignments Help

WhatsApp : +923280047170
Email : [email protected]
WhatsApp Direct Link : https://wa.link/m8uxdz



Project Description:
You are the sales manager for Oxford Auto Sales, a Web-based auto dealer that specializes in online transactions. As part of your duties you generate weekly reports that detail new customer contacts, online sales rep information, and sales. This week you have decided to overhaul your report by updating agent contact information, importing customer data stored in a text file, implementing a PivotTable using Power Pivot, and utilizing 3D Maps to track sales.



Start Excel. Download and open the file named Exp19_Excel_Ch10_Cap-AutoSales.xlsx. Grader has automatically added your last name to the beginning of the filename.
Use Get & Transform (Power Query) to import the file e10c1Agents.csv.
Rename the worksheet Agents.
Use Get & Transform (Power Query) to import the Vehicles table from the file e10c1Vehicles.accdb.
Rename the worksheet Sales.
Load the file e10c1Customer_Leads.txt in the Power Query Editor. Use the Power Query Editor to ensure the first row is used as Headers. Close and load the table.
Rename the worksheet Customer_Leads.
Add the Vehicles, e10c1Agents, and e10c1Customer_Leads tables to the data model.
Define the following relationship:
Table:
e10c1Agents
Field:
AgentID
Table:
Vehicles
Field:
AgentID
Use Power Pivot to create a PivotTable on Sheet1 starting in cell B3. Add the Last field from the e10c1Agents table to the Rows area and Price from the Vehicles table to the Values area.
Format the range C4:C20 with Accounting Number Format.
Insert a Clustered Column Pivot Chart. Position the chart so the upper left corner is in the center of cell D3.
Add the Chart Title Sales.
Rename the worksheet SalesAnalysis.
Create a 3D Map based on the Vehicles table in the Sales Worksheet. Add City and State to the Location dimension. Zoom in so Los Angeles fills the entire map.