As part of your duties you generate weekly reports that detail new customer contacts, online sales rep information, and sales.

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.