Module 10: SAM Project 1b help
- Lucia Campos and three friends own a small business called Corvallis Group Restore, an upcycling business in Corvallis, Oregon, that sells useful and attractive products made from old or discarded materials. Lucia asks for your help in producing a sales report. She wants to analyze sales for the past year and project future sales. To create the report, you need to import data from various sources and use the Excel Power tools.
Go to the Sales History worksheet, where Lucia wants to display a summary of the company's annual sales since the business started in the year 2008. She 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_EX19_10b_History.csv text file.
- b. Edit the query to remove the Items Sold and Notes columns.
- c. Close and load the query data to a table in cell B2 of the existing worksheet.
mentalmavens asked a year ago
