Open the file in Excel. Review the data. This file contains a listing of your expenses over the past six months

  1. 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)

Category of Expenses (Rows)

Payment Date (Columns) – in order to have the table summarize expenses by each month, you will need to drag the “Payment Date” field from the field list into the Columns area of the Pivot Table design grid. If you simply check the box in front of the field name, it will not summarize the dates into months.

Split with Roommates? (Filters)

Compare your PivotTable with the following image to ensure that you have selected the correct fields. (SEE PROJECT 8 PART 1 ATTACHMENT)

Part 2: Format the PivotTable

Rename the labels in your PivotTable:

“Row Labels” should be “Expense Categories”

“Column Labels” should be “Months”

Change the PivotTable design style to any color in the Medium color palette.

Apply the Accounting Number format to the numerical data in your PivotTable.

Rename the PivotTable sheet to Analysis.

Use the Filter to only show expenses that are shared with your roommates.

After viewing the data, remove the filter so that the data shows all expenses.

Insert a Slicer for the “Pay To” field.

Move the Slicer to the right of the PivotTable so that it does not overlap the PivotTable.

Use the Slicer to filter the data in the PivotTable to only show expenses at Starbucks.

Select a Slicer Style that matches the colors in your PivotTable.

Change the Page Layout for the Analysis worksheet to Landscape and the margins to Narrow.

Save the file. Compare your worksheet to the image below. (Your colors may be different.) (SEE PROJECT 8 PART 1 ATTACHMENT)

"96% of our customers have reported a 90% and above score. You might want to place an order with us."

Essay Writing Service
Affordable prices

You might be focused on looking for a cheap essay writing service instead of searching for the perfect combination of quality and affordable rates. You need to be aware that a cheap essay does not mean a good essay, as qualified authors estimate their knowledge realistically. At the same time, it is all about balance. We are proud to offer rates among the best on the market and believe every student must have access to effective writing assistance for a cost that he or she finds affordable.

Caring support 24/7

If you need a cheap paper writing service, note that we combine affordable rates with excellent customer support. Our experienced support managers professionally resolve issues that might appear during your collaboration with our service. Apply to them with questions about orders, rates, payments, and more. Contact our managers via our website or email.

Non-plagiarized papers

“Please, write my paper, making it 100% unique.” We understand how vital it is for students to be sure their paper is original and written from scratch. To us, the reputation of a reliable service that offers non-plagiarized texts is vital. We stop collaborating with authors who get caught in plagiarism to avoid confusion. Besides, our customers’ satisfaction rate says it all.

© 2022 Homeworkcrew.com provides writing and research services for limited use only. All the materials from our website should be used with proper references and in accordance with Terms & Conditions.