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)
It's no longer good enough to create a high-quality product at a reasonable cost.
That is why we have created 9 compelling warranties to make your usage of our service pleasant, simple, and secure.
You must be completely confident in the quality of your products in order to provide a money-back guarantee. This is precisely how custom paper writing services work. We double-check that there are no hidden issues with this promise and that you are completely happy with the quality of your purchase.Read more
Our writers do not employ others’ writing tricks, because we are aware that plagiarism may cost a lot to our clients and take away their reputation.Read more
We want you to be satisfied with your order, so we offer a free revision policy. If you are not completely happy with your order, let us know and we will revise it for free.Read more
We care about our customers and always strive to keep their trust. That’s why Customwritingspapers.com guarantees privacy and safety of your personal information. To ensure total security, we take the following measures:Read more
Our team of editors works tirelessly to ensure that all papers meet our high standards for quality. They check for the instructions, grammar, punctuation, and spelling mistakes as well as for plagiarism.Read more
We would never want to jeopardize our relationship with you, and that is why we offer a fair-cooperation guarantee: If for any reason you are not satisfied with your order, you can always get your money back.Read more
We only hire the best, most qualified professionals to work on your order. Each writer is a degree holder with extensive experience in their field. You can be assured that your project will be handled by a true expert.Read more
Our quality assurance department ensures that each paper is of excellent quality before it is sent to you. You can be sure that your paper will meet all of the requirements that you set. Our experts are highly skilled and will follow your specific instructions to the letter.Read more
We have a highly professional and qualified customer support team that is available 24/24, 365 days a year. They will be more than happy to answer any questions or concerns that you may have about our company or products. You can contact them by phone, email, or chat on our website.Read more