Illustrated Excel 365/2021 | Module 8: SAM Project 1b Deal Depot | IL_EX365_2021_8b_Mac

Contact Us:
WhatsApp no. : [phone]
direct link:wa.me/+9237014...
Email : [e-mail]
#Illustrated Excel 365/2021
#Module 8: SAM Project 1b
#Deal Depot
#IL_EX365_2021_8b_Mac
#SAM Project 1b
#SAM Project 1b
#Module 8:
PROJECT STEPS
1. Christine Tan has a small business called Deal Depot that buys and sells items using online auction sites. She is using an Excel workbook to analyze her sales, and asks for your help in creating PivotTables and PivotCharts to provide an overview of her buyers, sales, and pricing.
Go to the Sales worksheet, which contains a table of data named Sales.
Add a new sale as the last record in the Sales table using the data shown in Table 1.
Table 1: New Record for the Sales Table
#Illustrated Excel 365/2021
#Module 8: SAM Project 1b
#Deal Depot
#IL_EX365_2021_8b_Mac
#SAM Project 1b
#SAM Project 1b
#Module 8:
Buyer B1-11
Sales Type Auction
Sales ID 3701
Date 12/19/2024
Item Category Technology
Quantity 1
Unit Price $95.00
Shipping 3.0%
Total $97.85
#Illustrated Excel 365/2021
#Module 8: SAM Project 1b
#Deal Depot
#IL_EX365_2021_8b_Mac
#SAM Project 1b
#SAM Project 1b
#Module 8:
2. Christine wants to create a separate table displaying the types of products each buyer purchased and the total price.
To provide this information, create and format a PivotTable as follows:
a. Insert a PivotTable on a new worksheet based on the Sales table.
b. Use Sales Category Pivot as the name of the worksheet.
c. Add the Buyer field to the Rows area of the PivotTable.
d. Add the Item Category field to the Columns area of the PivotTable.
e. Add the Total field to the Values area, where it appears as Sum of Total.#Illustrated Excel 365/2021
#Module 8: SAM Project 1b
#Deal Depot
#IL_EX365_2021_8b_Mac
#SAM Project 1b
#SAM Project 1b
#Module 8:
f. Change the Value Field Settings for the Sum of Total values to apply the Accounting number format with 0 decimal places and the $ symbol.
3. Change the appearance of the PivotTable as follows to make it more attractive:
#Illustrated Excel 365/2021
#Module 8: SAM Project 1b
#Deal Depot
#IL_EX365_2021_8b_Mac
#SAM Project 1b
#SAM Project 1b
#Module 8:
a. Apply Light Green, Pivot Style Medium 11 (2nd row, 4th column in the Medium section of the PivotTable Styles gallery) to the PivotTable to use a design similar to the one applied to other PivotTables in the workbook.
b. Hide the field headers in the PivotTable to make it more compact.
4. Return to the Sales worksheet. Christine wants to display the sales totals by sales type. Create a PivotTable based on the Sales table as follows:
#Illustrated Excel 365/2021
#Module 8: SAM Project 1b
#Deal Depot
#IL_EX365_2021_8b_Mac
#SAM Project 1b
#SAM Project 1b
#Module 8:
a. Insert a PivotTable on a new worksheet based on the Sales table.
b. Use Totals by
#Illustrated Excel 365/2021
#Module 8: SAM Project 1b
#Deal Depot
#IL_EX365_2021_8b_Mac
#SAM Project 1b
#SAM Project 1b
#Module 8: