Lesson 8 Project

Open the file in Excel. Review the data. This file contains a listing of your expenses over the past six months. ( SEE ATTACHMENT L8 DATAFILE) Part 1: Create the PivotTable Save the data file as CIS105_Lesson8Project1_MEID.xlsx. Insert a PivotTable on a new worksheet using data from A1:E246. Use the following fields in your PivotTable: Amount Paid (Values) … Read more