Data Files needed for the Review Assignments: NP_EX_10-2.xlsx, Support_EX_10_Sales01.csv, Support_EX_10_Sales02.csv, Support_EX_10_Sales03.accdb

Dmitry has another set of sales data for you to analyze. This time, you will look at the short- and long-term trends in sales from Cup and Platter's website. This data has been stored in a pair of CSV files. Dmitry has also compiled sample data on revenue generated from electric items, bakeware, and dinnerware. You will use that data to generate a revenue report and display the data on a map chart and 3D Maps tour. Complete the following:

1. Open the NP_EX_10-2.xlsx workbook located in the Excel10 > Review folder included with your Data Files. Save the workbook as NP_EX_10_StoresReport in the location specified by your instructor.

2. In the Documentation sheet, enter your name and the date.

3. Dmitry wants to view how website sales have increased over the year. Create a query to retrieve data from the Support_EX_10_Sales01.csvfile. Edit the data and use Power Query to remove the first four rows of the text file and use the titles in the fifth row as column headers. Load the three columns of data into an Excel table in cell B4 of the Website History worksheet.