7. Go to the Employees worksheet. Winoma wants to compare the data on this worksheet with delivery data, stored on the D
Posted: Mon Jul 11, 2022 9:57 am
7. Go to the Employees worksheet. Winoma wants to compare thedata on this worksheet with delivery data, stored on the Deliveriesworksheet. She wants to analyze the delivery charges by manager.Add the data in the range A3:D27 to the data model, specifying thetable you are creating has headers. Go to the Deliveries worksheet,and then add the data in the range A3:D27 to the data model,specifying the table you are creating has headers. In Power Pivot,rename Table1 using Employees as the new table name. Rename Table2using Deliveries as the new table name. Create a PivotTable on anew worksheet named Deliveries by Manager based on the Employeesand Deliveries tables.