Hire Me For Complete Course
For Help Contact Me on
WhatsApp Number : +994 40 158 33 14
Whatsapp Link : wa.link/fvv75z
#Excel_Module_10_SAM_Project_A #ExcelModule10SAMProjectA #NP
#Excel_Module_10_SAM_Project_A #ExcelModule10SAMProjectA #NP #EX19 #NP_EX19_10a #ExcelModule10SAMProject1a #Excel_Module_10 #ExcelModule10 #Excel_Module_10_SAM_Project_1a #NP_EX19_10a_FirstLastName_1.xlsx #Lighting_Designs #LightingDesigns
#Excel Module 10 SAM Project A
#Excel_Module_10_SAM_Project_A
#ExcelModule10SAMProjectA
#LeeStewart
#Excel Module 10 SAM Project 1a
#Excel_Module_10_SAM_Project_1a
#ExcelModule10SAMProject1a
#LeeStewart
#Excel Module 10 SAM Project A Lighting Designs
#Excel_Module_10_SAM_Project_A_Lighting_Designs
#ExcelModule10SAMProjectALightingDesigns
#LeeStewart
#New Perspectives Excel 2019 Module 10 SAM Project 1a
#New_Perspectives_Excel_2019_Module_10_SAM_Project_1a
#NewPerspectivesExcel2019Module10SAMProject1a
#LeeStewart
#shelly cashman excel 2019 module 10 sam project 1a
#shellycashmanexcel2019module10samproject1a
#shelly_cashman_excel_2019_module_10_sam_project_1a
#LeeStewart
#Lighting Designs
#Lighting_Designs
#LightingDesigns
#LeeStewart
#ANALYZE DATA WITH POWER TOOLS
#ANALYZE_DATA_WITH_POWER_TOOLS
#ANALYZEDATAWITHPOWERTOOLS
#LeeStewart
#NP_EX19_10a_FirstLastName_1.xlsx
#NP_EX19_10a_FirstLastName_2.xlsx
#NP_EX19_10a
#cengage
#np
#EX19
#Cengage_Excel_Module_10_SAM_Project_A
#Sales Summary Worksheet
#Sales_Summary_Worksheet
#SalesSummaryWorksheet
#Six_Month_Forecast_Worksheet
#SixMonthForecastWorksheet
#Six Month Forecast Worksheet
#Previous_Year_Worksheet
#PreviousYearWorksheet
#Previous Year Worksheet
#Product_Data_Worksheet
#ProductDataWorksheet
#Product Data Worksheet
#Stores_Worksheet
#StoresWorksheet
#Stores Worksheet
#Manufacturers_Worksheet
#ManufacturersWorksheet
#Manufacturers Worksheet
3. Go to the Stores worksheet. Jacob wants to display information about lighting products purchased according to store and manufacturer. He has received this data in a text file. Import the data as follows:
.
b. Start loading the data at row 1, and separate the columns using tab delimiters.
c. Load the data to a new worksheet, using Product Data as the name of the new worksheet.
d. Format the imported data as a table with headers using the Table Style Medium 7 table style.
e. Rename the table using Products as the name.
Go back to the Stores worksheet. Jacob wants to show the categories of products sold in each of the company's five stores during 2021.
f. In cell A2 of the Stores worksheet, insert a PivotTable based on the data in the Products table.
4. Edit the PivotTable as follows to provide this information for Jacob:
a. Use the following fields from the Products table in the PivotTable:
· Category field for the row headings
· StoreCity field for the column headings
· ItemQty field for the values
b. Use Products Sold as the custom name of the Sum of ItemQty field.
c. In cell A3, use Lighting Products to replace "Row Labels", and then resize column A to its best fit.
d. In cell B2, use Stores to replace "Column Labels
5. Jacob occasionally would like to focus on the number of lighting products sold in the five stores per month.
Add a Timeline Slicer as follows to the Stores worksheet:
a. Insert a Timeline Slicer that uses the OrderDate field from the Products table.
b. Move and resize the Timeline Slicer so it covers the range A12:H18.
c. If necessary, clear the filter on the Timeline Slicer to display all periods.
6. Jacob also wants to examine the percentage each type of lighting product contributed to total sales in each store. Create a PivotChart as follows:
a. Based on the PivotTable on the Stores worksheet, create a 100% Stacked Column PivotChart.
b. Move and resize the PivotChart so that its upper-left corner is in cell J2 and its lower-right corner is in cell P16.
7. Go to the Manufacturers worksheet. Jacob wants to compare products sold by category and manufacturer.
Create a PivotTable as follows that provides the products sold by manufacturer information for Jacob:
· Manufacturer field for the row headings
· Category field for the column headings
· ItemQty field for the values
8. Jacob asks for another way to visualize the products sold by manufacturer. Create a PivotChart as follows:
a. Based on the PivotTable on the Manufacturers worksheet, create a Stacked Bar PivotChart.
b. Move and resize the PivotChart so that its upper-left corner is within cell I2 and its lower-right corner is within cell O25.
Hide all the field buttons in the PivotChart, if necessary.
9. Jacob also wants to be able to focus on a single category of product at a time.
Add a slicer to the PivotChart as follows:
a. Add a slicer based on the Category field from the Products table.
b. Move the slicer below the PivotChart so that it covers the range I26:K38.
c. Use the slicer to filter the PivotTable and PivotChart to show only products in the Commercial category.
Негізгі бет Excel Module 10 SAM Project 1a | Lighting Designs | New Perspectives Excel 2019 | NP_EX19_10a
Пікірлер