Use Power Query to create a query and load data from a CSV file into a new table
Jacob Sherman is the director of sales for Lighting Designs, a store and website that cater to building contractors in five locations in the Seattle area. Jacob asks for your help in producing a sales report. He wants to analyze sales for the past year and project future sales for all the stores. To create the report, you need to import data from various sources and use Excel Power tools.
Go to the Sales Summary worksheet, where Jacob wants to display a summary of the company's annual sales since the first store opened in the year 2003. He has a text file that already contains this data.
Use Power Query to create a query and load data from a CSV file into a new table as follows:
a. Create a new query that imports data from the Support_EX365_2021_CT10c_Summary.csv text file.
b. Edit the query to remove the Units Sold and Notes columns.
c. Close and load the query data to a table in cell A2 of the existing worksheet.
