Lesson 8 project | Accounting homework help

 

  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)

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
vulkan vegas, vulkan casino, vulkan vegas casino, vulkan vegas login, vulkan vegas deutschland, vulkan vegas bonus code, vulkan vegas promo code, vulkan vegas österreich, vulkan vegas erfahrung, vulkan vegas bonus code 50 freispiele, 1win, 1 win, 1win az, 1win giriş, 1win aviator, 1 win az, 1win azerbaycan, 1win yukle, pin up, pinup, pin up casino, pin-up, pinup az, pin-up casino giriş, pin-up casino, pin-up kazino, pin up azerbaycan, pin up az, mostbet, mostbet uz, mostbet skachat, mostbet apk, mostbet uz kirish, mostbet online, mostbet casino, mostbet o'ynash, mostbet uz online, most bet, mostbet, mostbet az, mostbet giriş, mostbet yukle, mostbet indir, mostbet aviator, mostbet casino, mostbet azerbaycan, mostbet yükle, mostbet qeydiyyat
×

Contact Us on WhatsApp

× How can I help you?