New Perspectives Excel 365 Module 6 SAM Project A | Five Points Group скачать в хорошем качестве

New Perspectives Excel 365 Module 6 SAM Project A | Five Points Group

   • New Perspectives Excel 365  Module 6 SAM C...      • Excel 365  Module 6 End of Module Project ...   ‪@MylabCommunity‬ #New_Perspectives_Excel365_Module6_SAM_ProjectA_Five_Points_Group #Excel365_Module6_SAM_ProjectA_Five_Points_Group #Excel_Module6_SAM_ProjectA_Five_Points_Group #Five Points Group #FivePointsGroup #Five_Points_Group #NP_EX365_6A #SAM_Project_A #SAMProjectA #Excel3652021_Module6_SAM_Project1a #SAM_Project_A_Excel365_Module6_Five_Points_Group #MANAGINGYOURDATAWITHDATATOOLS #New_Perspectives #ShellyCashman #Excel365 #excel3652021 #excel2019 Contact me for your assighnments and full course: Email : mylabcommunity@gmail.com WhatsApp : +923017351754 WhatsApp Direct Chat : https://tinyurl.com/4e2emedu PROJECT STEPS 1. Bao Sang is a project assistant for the Five Points Group, a management consulting company in Chicago, Illinois. She tracks the consultants' projects and billings in an Excel workbook and asks for your help in updating and analyzing the data. Go to the Kang Projects worksheet, which lists project data for Kendra Kang. Bao asks you to format the data as follows to match the data for the other consultants: a. Format the range B3:G13 as an Excel table with headers using the Gold, Table Style Medium 5 table style. b. Use Kang as the name of the table. 2. Bao wants you to add a new project for Kendra Kang 3. She also wants you to focus on Kendra Kang's projects with contract totals over $600,000. Use a custom Number filter to display only projects with contract totals greater than 600,000. 4. Go to the Valles Projects worksheet, which contains a table named Valles for Gabriel Valles' consulting projects. Unfreeze the panes in the worksheet because the worksheet is not long or wide enough to scroll. 5. Bao asks you to organize the projects by project type and contract amount and to display the average amount of contracts and billings. Modify the Valles table as follows: a. Remove the filter from the Valles table to display all of the data. b. Sort the data in ascending order first by the Project Type field and then in descending order by the Contract Total field. c. Insert a Total row in the Valles table. d. Use the Total row to calculate the average contract total and average billed to date amounts. e. In cell B12, change the text to Average to indicate what the amounts represent. 6. Go to the Wasem Projects worksheet. Hania Wasem manages more projects than any other consultant. Bao wants you to summarize the Wasem project data using subtotals to show the value of the projects in each industry. Modify the Wasem project data as follows: a. Sort the Wasem table in ascending order by the Industry field. b. Convert the table to a normal range. c. Insert subtotals into the range B3:G18, with the subtotals appearing at each change in the Industry column value. d. Add subtotals using the SUM function to the Contract Total and Billed to Date columns. 7. Go to the Yonas Projects worksheet. The Yonas table on this worksheet lists consulting projects for Ezra Yonas. Format the table to match others in the workbook as follows: a. Apply the Gold, Table Style Medium 5 table style to the Yonas table. b. Display the filter buttons. 8. Bao knows that the Yonas table includes a duplicate record and asks you to remove it. Use a table tool to remove the duplicate record based on the values in all the columns in the table. #New_Perspectives_Excel365_Module6_SAM_ProjectA_Five_Points_Group #Excel365_Module6_SAM_ProjectA_Five_Points_Group #Excel_Module6_SAM_ProjectA_Five_Points_Group #Five Points Group #FivePointsGroup #Five_Points_Group #NP_EX365_6A #SAM_Project_A #SAMProjectA #Excel3652021_Module6_SAM_Project1a #SAM_Project_A_Excel365_Module6_Five_Points_Group #MANAGINGYOURDATAWITHDATATOOLS #New_Perspectives #ShellyCashman #Excel365 #excel3652021 #excel2019 #Module6, #ShellyCashman_Excel365_Module6_SAM_ProjectA #ShellyCashman_Excel365_Module6_SAM_ProjectB #NP_EX365_6A #NP_EX365_6B #NP_EX365_7A #NP_EX365_7B #NP_EX365_8A #NP_EX365_8B #NP_EX365_9A #NP_EX365_9b #NP_EX365_10A #NP_EX365_10B #NP_EX365_11A #NP_EX365_11B #NP_EX365_12A #NP_EX365_12B #NP_EX365_2021_6a #NP_EX365_2021_6b #NP_EX365_2021_7a #NP_EX365_2021_7b #NP_EX365_2021_8a #NP_EX365_2021_8b #NP_EX365_2021_9a #NP_EX365_2021_9b #NP_EX365_2021_10a #NP_EX365_2021_10b #NP_EX365_2021_11a #NP_EX365_2021_11b #NP_EX365_2021_12a #NP_EX365_2021_12b #Five Points Group #Five_Points_Group #FivePointsGroup ‪@MylabCommunity‬