ANALYZE DATA WITH PIVOTTABLES

GETTING STARTED

$-$ Open the file IL$\_$EX$19\_8$a$\_$FirstLastName$\_1.$xlsx$,$ available for download from the SAM website.

$-$ Save the file as IL$\_$EX$19\_8$a$\_$FirstLastName$\_2.$xlsx by changing the $"1"$ to a $"2".$

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

$-$ With the file IL$\_$EX$19\_8$a$\_$FirstLastName$\_2.$xIsx still open, ensure that your first and last name is displayed in cell B$6$ of the Documentation sheet.

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

$$ PROJECT STEPS

$1.$ Sandra Russo is an account manager at M$\backslash$&K Merchants Bank, where she consults with businesses of all sizes to help them be successful and profitable. Sandra is using an Excel workbook to analyze the financial performance of Home Chef, the market leader in producing midrange kitchen utensils. She asks for your help in creating PivotTables and PivotCharts to provide an overview of Home Chef's customers, regional sales, pricing, and product line.

Go to the Orders worksheet, which contains a table of data named Orders.

Add a new order as the last record in the Orders table using the data shown in Table $1.$

Table $1$: New Record for the Orders Table