Assignment Directions

Using your Pivot Table Assignment from last week, take that pivot table data and create 3 charts of your choice. Be thoughtful about your use of chart type, colors, and lines. The point of these visuals is to tell a story.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

Create a PPT

Put these charts in a PowerPoint deck that includes:

1. Title slide

2. Chart 1

3. Chart 2

4. Chart 3

In your content slides (slides 2-4), be sure to include a title and a sentence that summarizes your chart. It could be something as simple as “Organic is the largest traffic source for this website”. The sentence should represent the key point you are trying to make about the chart. Remember, the point of a visual is to tell a story.

P.S: I attached a sample excel PowerPoint on SweetStudy folder.

How to Create Excel PivotTable & PivotCharts Video Resources

How to Create a PivotTable Manually (5:37 min)

· https://support.microsoft.com/en-us/office/video-create-a-pivottable-manually-9b49f876-8abb-4e9a-bb2e-ac4e781df657

· Links to an external site.

How to Create a PivotTable (1:36 min)

· https://support.microsoft.com/en-us/office/video-create-a-pivottable-and-analyze-your-data-7810597d-0837-41f7-9699-5911aa282760

· Links to an external site.

How to Sort, Filter, and Calculate PivotTables (4:07 min)

· https://support.microsoft.com/en-us/office/video-sort-filter-summarize-and-calculate-your-pivottable-data-e3d4bee4-c5ef-4e3c-b990-61a7d540207c

· Links to an external site.

How to create formulas in a PivotTable

1. Click the PivotTable. …

2. On the Analyze tab, in the Calculations group, click Fields, Items, & Sets, and then click Calculated Field.

3. In the Name box, type a name for the field.

4. In the Formula box, enter the formula for the field. …

5. Click Add.

Use Slicers, Timelines, and PivotCharts (3:53 min)

Links to an external site.

· https://support.microsoft.com/en-us/office/video-use-slicers-timelines-and-pivotcharts-to-analyze-your-pivottable-data-4db5de3b-735e-4b03-b3b2-f2105d79dcb5

· Links to an external site.

List of Available Chart Types

· https://support.microsoft.com/en-us/office/available-chart-types-in-office-a6187218-807e-4103-9e0a-27cdb19afb90

· Links to an external site.

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Get started