Open the file NP_EX19_10b_FirstLastName_1.xlsx, available for download from the SAM website.




Open the file NP_EX19_10b_FirstLastName_1.xlsx, available for download from the SAM website.

Save the file as NP_EX19_10b_FirstLastName_2.xlsx by changing the “1” to a “2”.

If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:



With the file NP_EX19_10b_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.

If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

To complete this project, you need to add the Power Pivot tab to the ribbon as follows:

From the File tab, click the Options button. In the Data Options section of the Data tab, click the checkbox next to Enable Data Analysis add-ins: Power Pivot, Power View and 3D Map, and click OK.

When downloading Access support files, your browser may display a warning message similar to "This type of file can harm your computer." SAM Project files are always considered safe, so you can disregard this message.


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:

Instruction Files

Related Questions in others category