Excel Module 5 End of Module Project 2 | Home Project Supply | MANAGE AND ANALYZE #illustratedexcel

Excel Module 5 End of Module Project 2 | Home Project Supply | MANAGE AND ANALYZE #illustratedexcel

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6NMKKBKUFYN1?autoload=1&app_absent=0

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
singhal.agrawal.bharati@gmail.com

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.

PROJECT STEPS
1. Suong Nguyen works in the Accounting Department of Home Project Supply, a growing chain of hardware stores in the Midwest. She is developing an Excel workbook to track the company's inventory stored in warehouses in Chicago, Illinois and Toledo, Ohio. She asks for your help in managing and analyzing the inventory data.
Go to the Chicago worksheet. Suong wants to review the data on the worksheet, which lists the Chicago warehouse inventory data. Format the range A3:I61 as a table with headers using the Orange, Table Style Medium 9 table style.
2. Apply a table style option to bold and shade the item IDs in the first column of the table to contrast them with the other data.
3. Sort the table in ascending order by the values in the Item ID column so that Suong can find items quickly.
4. Find and remove a record with a duplicate Item ID number to list only unique records in the table.
5. Suong wants to analyze the inventory data on power tools separate from the complete inventory list. In cell K4, she has already entered "Power" as the condition to use in an advanced filter. Create an advanced filter that copies the results to another location, using the table of inventory data (range A3:I60) as the List range. Use the information in the range K3:K4 as the Criteria range. Copy the results to the range starting in cell K6. Resize column L to a width of 21.00. Resize columns M:S to a width of 9.00.
6. Go to the Toledo worksheet, which includes a filtered table named Toledo. Remove the filter from the Toledo table to display all the records.
7. Apply the Orange, Table Style Medium 9 table style to the Toledo table to use a format similar to other tables in the workbook.
8. Remove the record for Item ID B428 from the table because the record is incomplete.
9. Suong wants to calculate the total value of a specific type of tool. She has already entered the tool type in cell A4. In cell A6, enter a formula using the DSUM function that specifies a structured reference to the entire Toledo table including the headers and the data (Toledo[#All]) as the formula database. Use the Value field header (Toledo[[#Headers],[Value]]) as the field to summarize. Use the values in the range A3:A4 as the criteria.
10. Suong also wants to identify the number of items that need to be reordered. In cell B6, enter a formula using the DCOUNTA function that specifies a structured reference to the entire Toledo table (Toledo[#All]) as the formula database. Use the Reorder? field header (Toledo[[#Headers],[Reorder?]]) as the field to count. Use the values in the range B3:B4 as the criteria.
11. Go to the Full Inventory worksheet, which includes a table named Full_Inventory. Apply banded rows to the table to make it easier to read. Add a total row to the table, and then use the total row to sum the values in the Unit Price and Value columns.
12. Suong wants to list the tools that have a unit price more than $70 to identify the most expensive tools. Use a number filter to show only tools with unit prices greater than 70.
13. Prepare the Full Inventory worksheet for printing by using the data in row 3 as the print titles. Change the top and bottom worksheet margins to 1".
14. Go to the Suppliers worksheet, which includes information about the company's preferred and new suppliers. Suong included a table named Preferred in the range A4:C9 but does not plan to filter or sort the data or use any other table features with it. Convert the Preferred table to a range.
15. She also wants to insert a table listing shipping options each supplier offers. In the range A11:C14, insert a new table, specifying that the table has headers, and then use Shipping as the name of table. Enter the data shown in Table 1.

Видео Excel Module 5 End of Module Project 2 | Home Project Supply | MANAGE AND ANALYZE #illustratedexcel канала AssignmentsHelp