please

i want know how i can apply these steps below in excel .

Business Analytics

Assignment

In this assignment, you are creating PivotTables and PivotCharts. You are required to use appropriate formatting for the PivotTables and PivotCharts. This should include column names, number formatting, color scheme, etc.

Copy Business Analytics Assignment.xlsx from Blackboard, Assignments, Excel Analysis Assignment.

Use the Daily Stock tabCreate a Daily Stock PivotTable: Determine the total daily_stock_level by product_type, storage_location, and sim_date across product_descriptionSliced by product_type, storage_location, and week

Select Finished Product (product_type)

Select 02 (storage_location)

Select 7 (week)

Name the worksheet: Daily Stock Report

Create a chart from your daily stock pivot

Chart Type: Clustered Column

Chart Layout: Quick Layout: Layout 5 (includes the table of data with the chart)

Format the chart

Hide the field buttons

Increase the height and width

Hide the Daily Stock Data worksheet

Use the Purchasing tabCreate a Purchasing PivotTable: Determine the total quantity purchased, unit_cost (create this calculated field), and raw_material_cost by receipt_date and product_description

Formula: Unit_Cost = raw_material_cost /quantity

Format: For #Div/0! show a 0

Name the worksheet: Purchasing Report

Hide the Purchasing Data worksheet

Use the Sales tabCreate a PivotTable: Determine the total quantity sold by sales_order_date across product_descriptionSliced by week, region, distribution_channel

Select 11 (week)

Select north (region)

Select grocery chain (distribution_channel)

Name the worksheet: Daily Quantity Sold Report

Create a chart from your daily quantity sold report

Chart Type: Stacked Bar

Chart Layout: Quick Layout: Layout 3

Format the chart

Hide the field buttons

Increase the height and width

Use the Sales tabCreate a PivotTable: Determine the gross_profit_margin (create this calculated field) by product_description and sales_order_date across regionFormula: Gross Profit Margin = (revenue standard_cost)/revenue

Format: Percent, 2 decimals

Format: For #Div/0! show a 0

Sliced by week

Select 3 (week)

Name the worksheet: GP Margin by Region Report

Create a chart from your GP margin by region report

Chart Type: Line

Chart Layout: Quick Layout: Layout 3

Format the chart

Hide the field buttons

Increase the height and width

Use the Sales tabCreate a PivotTable: Determine the total revenue by product_description

Filter by: Top 2 Products

Sliced by Region and Distribution Channel

Select West (region)

Select Grocery Chain (distribution channel)

Name the worksheet: Sales Performance Report

Copy the pivot table and paste the pivot table below the top 2 products pivot

Remove the filter

Apply Conditional Formatting to select the records Above Average (Green Fill, Dark Green Text)

Use the Sales tab

Create a PivotTable: Place the pivot on the Sales Performance Report worksheet below the Above Average PivotTable

Determine the total revenue, total quantity, and average price by price (grouping: by 1.00) and product_description

Create a chart from your pivottableChart Type: Combo

Revenue and Quantity Sold: Clustered Column

Price: Line, Secondary Axis

Format the chart

Hide the field buttons

Increase the height and width

Use the Sales tab

Create a PivotTable: Place the pivot on the Sales Performance Report worksheet to the right of the top 2 products

Determine the total market share (use quantity sold) by product_description

Create a chart from your pivottable

Chart Type: Pie

Chart Layout: Quick Layout: Layout 7

Format the chart

Hide the field buttons

Increase the height and width

Hide the Sales Data worksheet

Use the Product Profitability tabCreate a PivotTable: Determine the net_profit by week across productSliced by area name

Select West (area name)

Name the worksheet: Product Profitability Report

Create a chart from your product profitability pivot

Chart Type: Stacked Column

Format the chart

Hide the field buttons

Increase the height and width

Hide the Product Profitability Data worksheet

Upload the file to blackboard, Assignments, Business Analytics Assignment

- ACCOUNT NAME CREDIT OR DUMT AMOUNT-LURUS - 200CC00 Bikings Accumu ated depreciation & Eui dinas Accumu ated depreciation & Luidings Accumulated depreciation & Eudines Accumu aled depreciation & Euiding Accumu aled depreciation & Buildings Accumu atcd depreciation & Buildings Accumulated depreciation & Buildings 0220 Long term at- Ca0 Faii nin & 0 1) * n] | II IIIan C0 Ne A 03/15 | Long-Am Austs 1 LUTAPANYCOLUL - SIM DATE-SIM ROUND - VDAY WELK - ACCOUNT ID-CATEGORY I cannD0-100D 0c000000000 3 0000002010 Assets SC000102010 Aceste 6 A I conDCZ1110 7 A Ce/15 C000002010 A 10 0000002010 9 A 11 0000002010 Asest: 10 A 12 c00032010 13 Ca00002010 Assets 03/20 16 0000000010 13 A 17 0000002010 14 A A10 Aanets 15 A 01005 4 cannbc2010 14 A 01710 2 c0000:2010 Asset: 17 A 01/120 4c000002010 0120 i CgooD02010 Assets 02/10 8 cannoc2010 20 A 09/10 14 CC00002010 Assets 15 CC00002010 22 A 04.05 19 C000002010 Assets 23 A OM/15 24 cannbc2010 24 A 04720 22 c000002010 25 A 24 0000000010 Asset: 2G COODC2010 05/15 27 connbc2010 28 A 28 0000002010 Assels 32 c000002010 30 A 0615 13 c000002010 Aceste cannoc21110 32 A 0630 36 C000002010 0705 37 C000002010 34 A 0710 30 C000002010 8 A 07/15 39 campo2110 35 A 0721 40 C000002010 37 A 41 0000002010 38 A 44 0000002010 Asset: 08.05 43 coupDC2110 40 A 0730 42 c000002010 Assets 41 A 35 C000002010 42 A 06.06 31 0000002010 0630 30 coUODC2010 Assets 44 A 05125 29 connoce010 AgRat = 05/06 25 C000002010 Aspets | Daly stock Production Soles Sales Summary Market share ACCOUNT TYPE - ACCOUNT 1 ' al LUI HII Hels Builcie Longsem assets Buicinas Buildings Lang-m Arsats Bangs Lo Building Long-term 35sela Euicing Buildings 1 m assis Hings Lonem assets Building Logem 35sela Eucinga Long term ascts Buildings Lang-Am Ansats Buildings iuFe 1 skswls Buildings Lungim Buildings Long termas: Buildings Lang-R'm assets Buildings inFi akawls Buildings Lue35els Buildings Long term a52cts Buicing Buildings Buildings LUI. II 85sela Eitige Long termas:c Builcinas Long-term assets Buildings | ' 8l Buildings LIKHETI ela Buiting Long term 15 Euicing Long term assets Buildings lang-Am Arata Buildings Lunem assets Building Long-term 35:els Buicinas Long term assets Buildings Bangs Lonem assets Building Long-term 35:el: ELicinas Long Term a53ct Builcinas Lang-term Aracts Huidings Building Lua-GPm 35ela Builcima Long term as:cts Buildings Lang-R'm assets Buildings inFe i skzwls Buildings Lungern assets Buicinas Product Frofitability Financial (+ Accumulated depreciation & Buildings Accumu atcd depreciation & Buildings Accumulated depreciation & Bu dinas Accumulated depreciation & Buildings Accumulated depreciation & Buildings Accumu atcd depreciation & Eui dinos Accumulated depreciation & Buildings Accumulated depreciation & Buildings Accumulated depreciation & Building Accumu atcd depreciation & Eui dinas Accumulated depreciation & Buildings Accumulated depreciation & Buildings Accumulated decision & Evidira: Accumu ated depreciation & Eui dinos Accumulated depreciation & Lui dinas Accumulated depreciation & Fluidings Accumulated depresiunion & Buildings Accumu aled depreciation & Eui dinos Accumu ated depreciation & Lui dinas Accumulated deraciation & Buildings Accumu aled deprecision & Euiding Accumu aled depreciation & Eui dinos Accumu ated depreciation & Lui dinas Accumulated depreciation & Buildings Accumulated depreciation & Buildina Accumulated depreciation & Eui dinas Accumu atcd depreciation & Buildings Accumulated depreciation & Buildings Accumulated depreciation & Building Accumu aled depreciation & Eui dinos Accumulated depreciation & Euidings Accumulated depreciation & Buildings Accumulated depreciation & Euidin Accumulated depreciation & Euiding OD 1 DO 3 DE DE CODECS DELS 10000000 10000000 11363.64 1135364 11369.GA 113.64 11363 64 11353 54 11363. 64.11353.64 11363.64 -11383.64 11363.GA 11363 64 416 113636411353 64 11363. 64 11353.64 11353.64 11363.64 -1135.64 41363 64.1353 11363.64 -11353.64 11363.64 11353.64 11353. 11351 64 11363 KM .1383 FA 11363.64 -11353.64 1139.64 -11333.G4 11363.G4 -11351.64 11363 64.1353 FA 11363.64 -11353.64 11363.64 -11383.64 11363.G4 -11351.64 11363 64 -11353 64 11363.64 11353.64 11363.64-11353.64 11363.G4 -11351.64 11363 64.1353 54 11363. 64 -11353.64 11363.64 -11353.64 11363.G4 -11351.64 1135364.11353 54 11363 64.1383 64 11363.64-11363.64 11363.G4 11351.64 11363 411 151 64 11363 64 -11353 64 11363.64.11353.64 11309.04 11351.64 113E3.64 1135.64 11363 64 11353 64 11363.64.11353.64 : = LATIF IT 06.25 45 A - ACCOUNT NAME CREDIT OR DUMT AMOUNT-LURUS - 200CC00 Bikings Accumu ated depreciation & Eui dinas Accumu ated depreciation & Luidings Accumulated depreciation & Eudines Accumu aled depreciation & Euiding Accumu aled depreciation & Buildings Accumu atcd depreciation & Buildings Accumulated depreciation & Buildings 0220 Long term at- Ca0 Faii nin & 0 1) * n] | II IIIan C0 Ne A 03/15 | Long-Am Austs 1 LUTAPANYCOLUL - SIM DATE-SIM ROUND - VDAY WELK - ACCOUNT ID-CATEGORY I cannD0-100D 0c000000000 3 0000002010 Assets SC000102010 Aceste 6 A I conDCZ1110 7 A Ce/15 C000002010 A 10 0000002010 9 A 11 0000002010 Asest: 10 A 12 c00032010 13 Ca00002010 Assets 03/20 16 0000000010 13 A 17 0000002010 14 A A10 Aanets 15 A 01005 4 cannbc2010 14 A 01710 2 c0000:2010 Asset: 17 A 01/120 4c000002010 0120 i CgooD02010 Assets 02/10 8 cannoc2010 20 A 09/10 14 CC00002010 Assets 15 CC00002010 22 A 04.05 19 C000002010 Assets 23 A OM/15 24 cannbc2010 24 A 04720 22 c000002010 25 A 24 0000000010 Asset: 2G COODC2010 05/15 27 connbc2010 28 A 28 0000002010 Assels 32 c000002010 30 A 0615 13 c000002010 Aceste cannoc21110 32 A 0630 36 C000002010 0705 37 C000002010 34 A 0710 30 C000002010 8 A 07/15 39 campo2110 35 A 0721 40 C000002010 37 A 41 0000002010 38 A 44 0000002010 Asset: 08.05 43 coupDC2110 40 A 0730 42 c000002010 Assets 41 A 35 C000002010 42 A 06.06 31 0000002010 0630 30 coUODC2010 Assets 44 A 05125 29 connoce010 AgRat = 05/06 25 C000002010 Aspets | Daly stock Production Soles Sales Summary Market share ACCOUNT TYPE - ACCOUNT 1 ' al LUI HII Hels Builcie Longsem assets Buicinas Buildings Lang-m Arsats Bangs Lo Building Long-term 35sela Euicing Buildings 1 m assis Hings Lonem assets Building Logem 35sela Eucinga Long term ascts Buildings Lang-Am Ansats Buildings iuFe 1 skswls Buildings Lungim Buildings Long termas: Buildings Lang-R'm assets Buildings inFi akawls Buildings Lue35els Buildings Long term a52cts Buicing Buildings Buildings LUI. II 85sela Eitige Long termas:c Builcinas Long-term assets Buildings | ' 8l Buildings LIKHETI ela Buiting Long term 15 Euicing Long term assets Buildings lang-Am Arata Buildings Lunem assets Building Long-term 35:els Buicinas Long term assets Buildings Bangs Lonem assets Building Long-term 35:el: ELicinas Long Term a53ct Builcinas Lang-term Aracts Huidings Building Lua-GPm 35ela Builcima Long term as:cts Buildings Lang-R'm assets Buildings inFe i skzwls Buildings Lungern assets Buicinas Product Frofitability Financial (+ Accumulated depreciation & Buildings Accumu atcd depreciation & Buildings Accumulated depreciation & Bu dinas Accumulated depreciation & Buildings Accumulated depreciation & Buildings Accumu atcd depreciation & Eui dinos Accumulated depreciation & Buildings Accumulated depreciation & Buildings Accumulated depreciation & Building Accumu atcd depreciation & Eui dinas Accumulated depreciation & Buildings Accumulated depreciation & Buildings Accumulated decision & Evidira: Accumu ated depreciation & Eui dinos Accumulated depreciation & Lui dinas Accumulated depreciation & Fluidings Accumulated depresiunion & Buildings Accumu aled depreciation & Eui dinos Accumu ated depreciation & Lui dinas Accumulated deraciation & Buildings Accumu aled deprecision & Euiding Accumu aled depreciation & Eui dinos Accumu ated depreciation & Lui dinas Accumulated depreciation & Buildings Accumulated depreciation & Buildina Accumulated depreciation & Eui dinas Accumu atcd depreciation & Buildings Accumulated depreciation & Buildings Accumulated depreciation & Building Accumu aled depreciation & Eui dinos Accumulated depreciation & Euidings Accumulated depreciation & Buildings Accumulated depreciation & Euidin Accumulated depreciation & Euiding OD 1 DO 3 DE DE CODECS DELS 10000000 10000000 11363.64 1135364 11369.GA 113.64 11363 64 11353 54 11363. 64.11353.64 11363.64 -11383.64 11363.GA 11363 64 416 113636411353 64 11363. 64 11353.64 11353.64 11363.64 -1135.64 41363 64.1353 11363.64 -11353.64 11363.64 11353.64 11353. 11351 64 11363 KM .1383 FA 11363.64 -11353.64 1139.64 -11333.G4 11363.G4 -11351.64 11363 64.1353 FA 11363.64 -11353.64 11363.64 -11383.64 11363.G4 -11351.64 11363 64 -11353 64 11363.64 11353.64 11363.64-11353.64 11363.G4 -11351.64 11363 64.1353 54 11363. 64 -11353.64 11363.64 -11353.64 11363.G4 -11351.64 1135364.11353 54 11363 64.1383 64 11363.64-11363.64 11363.G4 11351.64 11363 411 151 64 11363 64 -11353 64 11363.64.11353.64 11309.04 11351.64 113E3.64 1135.64 11363 64 11353 64 11363.64.11353.64 : = LATIF IT 06.25 45 A