Скачать или смотреть End of Module Project 1 Excel Module 10 | Peak Partners

#New Perspectives Excel 365/2021 | Module 10: End of Module Project 1
#newperspectivesexcel3652021Module10endofmoduleproject1#EndofModuleProject1ExcelModule10#EndofModuleProject1#ExcelModule10
#Project1#NP_EX365_2021_EOM10-1

Contact me for your assighnments and full course:

Email : [email protected]
WhatsApp Direct Chat : https://wa.me/+923025881332
WhatsApp Number : +923025881332


PROJECT STEPS
1. Go to the Revenue History worksheet, where Roshana wants to view how sales have changed since the business was founded in the year 2003. She has a text file that already contains this data. Create a new query that imports data from the Support_EX365_2021_EOM10-1_Annual.csv text file. Edit the query to remove the first four rows of data and to use the titles in the fifth row as column headers. Close and load the query data to a table in cell B3 of the existing worksheet. Apply the Dark Green, Table Style Medium 3 table style to the new table to coordinate with the Peak Partners logo.
2. Roshana asks you to create a chart that compares the revenue for each business year. Create a scatter chart of the Business Year and Annual Revenue data (range C3:D25). Move and resize the chart so that its upper-left corner is in cell E3 and its lower-right corner is in cell K16. Add a Linear Forecast trendline to the chart, and then forecast the trendline forward 2 periods.
3. Go to the Monthly Sales worksheet, where Roshana has already imported monthly sales data from a text file and loaded it into the worksheet as a table. She now wants to forecast the monthly sales data for the next year. Create a Forecast sheet based on the data in the range B3:C27. Forecast sales through 12/31/2025. Set the seasonality to 12 months. Name the new worksheet 2025 Forecast. Move and resize the forecast chart so that the upper-left corner is within cell C2 and the lower-right within cell E25.
4. Go to the Positions Pivot worksheet. Roshana wants to display information about Peak Partners' clients, contracts, and positions. She has been maintaining this data in an Access database. Create a new query importing data from the Support_EX365_2021_EOM10-1_Peak.accdb database, selecting all five tables in the database for import. Only create a connection to the data and add the data to the Data Model. Use the Power Pivot window to add a PivotTable to the Positions Pivot worksheet in cell B3.
5. Add the Category field from the Positions table to the Values area to count the number of positions in each category.
6. Roshana wants to view the position data organized as a hierarchy. Maximize the Power Pivot window, display the imported tables in Diagram view, and then add a hierarchy named Position List to the Positions table. Add the Category, Group, and Position fields to the Position List hierarchy. (Hint: You might need to scroll the Power Pivot window to display all the tables.) Return to the Positions Pivot worksheet. Add the Position List hierarchy to the Rows area of the PivotTable and then remove the Position field from the Rows area (if necessary).
7. Roshana wants to display the same position information as a chart, and then display only positions in the three groups in the Technology category. Create a clustered bar PivotChart based on the PivotTable on the Positions Pivot worksheet. Hide the field buttons and legend, and then move and resize the chart so that the upper-left corner is within cell D3 and the lower-right corner within cell I15. Drill down the bar chart through the Technology category to display the number of positions in each Technology group.
8. Go to the Revenue by State worksheet, where Roshana wants to view recruiting revenue by state and office specialty. Use Power Pivot to insert a PivotTable in cell B3 of the Revenue by State worksheet. Add the State field from the Offices table to the Rows area. Add the Type field from the Offices table to the Columns area. Add the Charge field from the Invoices table to the Values area.
9. In order to relate the data in the Offices and Invoices tables to make a proper comparison, use the Power Pivot window to create a relationship between the Invoices and Offices tables based on the Office ID field.