New Perspectives Excel 365 | Module 10: SAM Project B OPR Photography скачать в хорошем качестве

New Perspectives Excel 365 | Module 10: SAM Project B OPR Photography

#New Perspectives Excel 365 | Module 10: SAM Project B #New Perspectives Excel 365 | Module 10: SAM Project B Contact Us: WhatsApp Number:+923187569415 Chatting Link :https://tinyurl.com/yzpfk6fm I am providing help in all online courses like Excel, Word, Access, PowerPoint, Accounting , Management Courses, Finance Courses, Computer Science Courses, Information Technology Courses, All Writing Assignments etc. I can do your Quizzes, Exams , Mid-Term, Final Exams. In short I can get you A grade in your courses. If you want me do your courses My WhatsApp number and Email is given you can contact me through that. Thanks PROJECT STEPS 1. Lerissa Marsh is the C.E.O. of OPR Photography. Based in Seattle, Washington, the company owns five franchises that sell photographic equipment. Lerissa asks for your help in producing a sales report. She wants to analyze sales for the past year and project future sales for all the franchises. To create the report, you need to import data from various sources and use the Excel Power tools. Go to the Sales History worksheet, where Lerissa wants you to display a summary of the company's annual sales since the first franchise opened in 2010. She has a text file that already contains this data. Use Power Query to create a query and load data from a CSV file into a new table as follows: a. Create a new query that imports data from the Support_EX365_10B_History.csv text file. b. Transform the data to remove the Units Sold and Milestones columns. c. Close and load the query data to a table in cell B3 of the existing worksheet. 2. Go to the Monthly Sales worksheet, which lists the sales per month for the previous year in a table and compares the sales in a chart. Lerissa imported this data from the Orders table in an Access database. She wants you to provide a way to track the changes in monthly sales and project the first six months of next year's monthly sales. Create a forecast sheet as follows to provide the data Lerissa requests: a. Based on the data in the range B3:C15, create a forecast sheet. b. Use 6/1/2030 as the Forecast End date to forecast the next six months. c. Use Six Month Forecast as the name of the new sheet. d. Resize and move the forecast chart so that the upper-left corner is within cell C2 and the lower-right corner is within cell E13. 3. Go to the Franchise Analysis worksheet. Lerissa asks you to display information about the types of photographic equipment purchased from each franchise. She has been tracking this data in an Access database. Import the data from the Access database as follows: a. Create a new query that imports data from the Support_EX365_10B_Orders.accdb database. b. Select the 2029_Orders, Equipment, and Sales tables for the import. c. Only create a connection to the data and add the data to the Data Model. On the Franchise Analysis worksheet, Lerissa wants to show the categories of products sold in each of the company's five franchises during 2029. d. In cell B3 of the Franchise Analysis worksheet, use Power Pivot to insert a PivotTable based on the data in the 2029_Orders table. 4. Edit the PivotTable as follows to provide this information for Lerissa: a. Use the following fields from the 2029_Orders table in the PivotTable: · Category field for the row headings · FranchiseState field for the column headings · ItemQty field for the values b. Use Equipment Sold as the custom name of the Sum of ItemQty field. c. In cell B4, use Equipment Types to replace "Row Labels", and then resize column B to its best fit. d. In cell C3, use Franchises to replace "Column Labels". 5. Lerissa occasionally likes to focus on the number of photographic equipment items sold in the five franchises per month. Add a Timeline Slicer as follows to the Franchise Analysis worksheet: a. Insert a Timeline Slicer that uses the OrderDate field from the 2029_Orders table. b. Move and resize the Timeline Slicer so it covers the range B14:H23. c. Scroll the Timeline Slicer to display periods beginning in January and ending in October. #New Perspectives Excel 365 | Module 10: SAM Project B OPR Photography #New Perspectives Excel 365 | Module 10: SAM Project B #OPR Photography #SAM Project B #Module 10 #New Perspectives Excel 365 | Module 10: SAM Project B OPR Photography #New Perspectives Excel 365 | Module 10: SAM Project B #OPR Photography #SAM Project B #Module 10 #New Perspectives Excel 365 | Module 10: SAM Project B OPR Photography #New Perspectives Excel 365 | Module 10: SAM Project B #OPR Photography #SAM Project B #Module 10 #New Perspectives Excel 365 | Module 10: SAM Project B OPR Photography #New Perspectives Excel 365 | Module 10: SAM Project B #OPR Photography #SAM Project B #Module 10 #New Perspectives Excel 365 | Module 10: SAM Project B OPR Photography #New Perspectives Excel 365 | Module 10: SAM Project B #OPR Photography #SAM Project B #Module 10