You have been asked by the Director of the Employment Development Department for the city of Seattle, to analyze the employment sectors in the city. Employment data for the previous two years is listed below:
Job Sector |
2016 Employment |
2017 Employment |
Government |
1,795 |
1,524 |
Healthcare |
2,832 |
2,952 |
Retail |
2,525 |
2,480 |
Food Service |
3,961 |
3,753 |
Industrial |
1,477 |
1,595 |
Professional |
2,515 |
2,802 |
Create a workbook to provide the employment information for each sector and the total employment for each year. Insert a column to calculate the percent change from 2016 to 2017. Note that some of the results will be negative numbers. Format the percentages with two decimal places. Insert a chart (your choice) in its own sheet that illustrates the 2017 employment figures and format the chart attractively. Format both the chart and the worksheet so that they are professional and easy to read and understand. Insert a footer with the file name and add appropriate document properties. Save the file as LastName_FirstName_Seattle. Submit the spreadsheet through Canvas Module 6 Excel Capstone.
You have been asked by the Director of the Employment Development Department for the city of Seat...
You are the systems manager for Blue City Movies Rentals and you have been asked to create a report on historical sales data. To complete your task you will combine and edit data from multiple sources using Excel’s Power add-ins, XML, and text functions.Instructions:For the purpose of grading the project you are required to perform the following tasks:StepInstructionsPoints Possible1Open e10c2MovieRentals.xlsx and save the workbook with the name e10c2MovieRentals_LastFirst.02Import the movie data from the delimited file e10c2Movies.txt and rename the new worksheet Inventory.Hint: On the Data tab,...