{"presentation":{"slides":[{"elements":[{"x":3.2679738562091503,"y":4.301075268817204,"width":65.359477124183,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Create a PivotTable to analyze worksheet data<\/h3>\n"},"subContentId":"f9de6062-d6a2-4cde-88d4-677fd4d177d8","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":5.446623093681917,"y":14.963032258064517,"width":91.50326797385621,"height":83.87096774193547,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. In this training, we will learn about the following<\/p>\n\n
\n\t
\n\t
Create a PivotTable to analyze worksheet data<\/p>\n\t<\/li>\n\t
\n\t
Use the Field List to arrange fields in a PivotTable<\/p>\n\t<\/li>\n\t
\n\t
Group or ungroup data in a PivotTable<\/p>\n\t<\/li>\n\t
\n\t
Filter data in a PivotTable<\/p>\n\t<\/li>\n<\/ol>\n\n
Data format tips and tricks<\/strong><\/p>\n\n
\n\t
\n\t
Use clean tabular data for best results.<\/p>\n\t<\/li>\n\t
\n\t
Organize your data in columns, not rows.<\/p>\n\t<\/li>\n\t
\n\t
Make sure all columns have headers, with a single row of unique, non-blank labels for each column. Avoid double rows of headers or merged cells.<\/p>\n\t<\/li>\n<\/ol>\n"},"subContentId":"2a77d65e-b684-49ed-86f0-86191260994b","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091503,"y":4.301075268817203,"width":65.359477124183,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Create a PivotTable to analyze worksheet data<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"dd32a9f0-feaa-4ae7-9eeb-f6d6238096e7"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":4.357298474945534,"y":15.033591397849461,"width":69.71677559912854,"height":77.41935483870967,"action":{"library":"H5P.Video 1.6","params":{"visuals":{"fit":true,"controls":true},"playback":{"autoplay":false,"loop":false},"l10n":{"name":"Video","loading":"Video player loading...","noPlayers":"Found no video players that supports the given video format.","noSources":"Video is missing sources.","aborted":"Media playback has been aborted.","networkFailure":"Network failure.","cannotDecode":"Unable to decode media.","formatNotSupported":"Video format not supported.","mediaEncrypted":"Media encrypted.","unknownError":"Unknown error.","invalidYtId":"Invalid YouTube ID.","unknownYtId":"Unable to find video with the given YouTube ID.","restrictedYt":"The owner of this video does not allow it to be embedded."},"sources":[{"path":"https:\/\/eus-streaming-video-rt-microsoft-com.akamaized.net\/870b93ed-3bad-45b3-8a5f-d26d155451a3\/a18ea0af-cb5c-4d19-9b84-69b1209e_3400.mp4","mime":"video\/mp4","copyright":{"license":"U"}}]},"subContentId":"f2faf1d2-94fa-425a-b795-c710d93b79bb","metadata":{"contentType":"Video","license":"U","title":"Create a Pivot table"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091507,"y":4.29436559139785,"width":76.25272331154684,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Use the Field List to arrange fields in a PivotTable<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"1b9c61e3-bd9f-4240-a14c-009fe9e6974a"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":12.852817204301076,"width":92.5925925925926,"height":79.56989247311827,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
After you create a PivotTable, you'll see the Field List. You can change the design of the PivotTable by adding and arranging its fields. <\/p>\n\n
The Field List should appear when you click anywhere in the PivotTable.<\/p>\n\n
If you click inside the PivotTable but don't see the Field List, open it by clicking anywhere in the PivotTable.<\/p>\n\n
Then, show the PivotTable Tools on the ribbon and click Analyze> Field List.<\/p>\n"},"subContentId":"7ffa3e42-700a-4c27-a5fc-14f8c941a599","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091503,"y":53.76344086021505,"width":65.32286643270193,"height":26.666666666666664,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","alt":"Image","file":{"path":"images\/file-673d76312a96d.png","mime":"image\/png","copyright":{"license":"U"},"width":600,"height":124}},"subContentId":"c019056e-e408-4ca2-8271-9ba7aa66134d","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091507,"y":4.294365591397851,"width":76.25272331154684,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Use the Field List to arrange fields in a PivotTable<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"116dbd26-001f-4a52-8f7a-2da56f0487dc"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":12.822580645161292,"width":61.00217864923747,"height":70.96774193548387,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
The Field List has a field section in which you pick the fields you want to show in your PivotTable, and the Areas section (at the bottom) in which you can arrange those fields the way you want.<\/p>\n\n
Use the field section of the Field List to add fields to your PivotTable, by checking the box next to field names to place those fields in the default area of the Field List.<\/p>\n\n
Use the areas section (at the bottom) of the Field List to rearrange fields the way you want by dragging them between the four areas.<\/p>\n"},"subContentId":"3d5a0cd1-65bb-4bd0-838f-b1008aa538ed","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":67.53812636165577,"y":10.75268817204301,"width":20.697167755991288,"height":84.94623655913978,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","file":{"path":"images\/file-673d76a0bc852.png","mime":"image\/png","copyright":{"license":"U"},"width":297,"height":648},"alt":"Image"},"subContentId":"8e8aa189-a231-4085-b444-cef871d4812e","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091507,"y":4.294365591397852,"width":76.25272331154684,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Use the Field List to arrange fields in a PivotTable<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"e14d6c5d-5feb-4140-a172-f0badeb97b11"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091503,"y":12.903225806451612,"width":81.69934640522877,"height":6.451612903225806,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Filters area fields are shown as top-level report filters above the PivotTable, like this:<\/p>\n"},"subContentId":"e4eba77d-8963-4a86-a458-4e5ee98176ef","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":10.893246187363834,"y":19.354838709677416,"width":55.55555555555556,"height":78.06451612903226,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","file":{"path":"images\/file-673e8b516d732.png","mime":"image\/png","copyright":{"license":"U"},"width":520,"height":370},"alt":"Image"},"subContentId":"15bb3d73-c22b-4830-a85b-1d04937ab030","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091507,"y":12.872989247311828,"width":81.69934640522877,"height":6.451612903225806,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Columns area fields are shown as Column Labels at the top of the PivotTable, like this<\/p>\n"},"subContentId":"1b04e254-1a9c-4a5c-9087-5a8dead36584","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":5.446623093681917,"y":19.354838709677416,"width":53.37690631808279,"height":79.35483870967741,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","file":{"path":"images\/file-673e8b9e0e5ab.png","mime":"image\/png","copyright":{"license":"U"},"width":520,"height":391}},"subContentId":"c4d47e79-d82d-47be-837e-38f58cffccb4","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":61.00217864923747,"y":19.31451612903226,"width":37.03703703703704,"height":19.354838709677416,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Depending on the hierarchy of the fields, columns may be nested inside columns that are higher in position.<\/p>\n"},"subContentId":"25878e65-f874-46e3-ba1e-53bd29790fbc","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":4.294365591397852,"width":76.25272331154684,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Use the Field List to arrange fields in a PivotTable<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"6a11e1a7-1b05-4940-b687-de9edbec1021"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091503,"y":11.61290322580645,"width":90.41394335511983,"height":6.451612903225806,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Rows area fields are shown as Row Labels on the left side of the PivotTable, like this:<\/p>\n"},"subContentId":"95981ace-8ef5-4e73-8640-d7047ae21cc2","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091503,"y":18.494623655913976,"width":56.64488017429194,"height":81.29032258064515,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","file":{"path":"images\/file-673e8c1249fdc.png","mime":"image\/png","copyright":{"license":"U"},"width":520,"height":377},"alt":"Image"},"subContentId":"f0e8f94d-240c-4154-8d47-0e0f18be62ac","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":62.091503267973856,"y":19.354838709677416,"width":34.64052287581699,"height":40,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Depending on the hierarchy of the fields, rows may be nested inside rows that are higher in position.<\/p>\n"},"subContentId":"46e4ccde-71cc-417e-b9c9-c0403d35b587","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":4.294365591397852,"width":76.25272331154684,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Use the Field List to arrange fields in a PivotTable<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"20c85a75-8df8-42e8-90a9-cc334ccd1490"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091503,"y":13.333333333333332,"width":90.41394335511983,"height":6.451612903225806,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Values area fields are shown as summarized numeric values in the PivotTable, like this:<\/p>\n"},"subContentId":"543972e6-932c-40d5-ae1b-bf9db8f47691","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":4.294365591397852,"width":76.25272331154684,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Use the Field List to arrange fields in a PivotTable<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"f11ec352-86fb-4ac6-a589-fdecf776de99"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":19.327956989247312,"width":50.10893246187364,"height":78.9247311827957,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","alt":"Image","file":{"path":"images\/file-673e8c888dedc.png","mime":"image\/png","copyright":{"license":"U"},"width":520,"height":414}},"subContentId":"b50e2e5c-35b8-4700-9891-d9f502c64fdb","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":55.55555555555556,"y":19.354838709677416,"width":40,"height":40,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
If you have more than one field in an area, you can rearrange the order by dragging the fields into the precise position you want.<\/p>\n\n
To delete a field from the PivotTable, drag the field out of its areas section. You can also remove fields by clicking the down arrow next to the field and then selecting Remove Field.<\/p>\n"},"subContentId":"d7fba909-f688-49e9-b03c-07dafafa7e1d","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091503,"y":4.301075268817203,"width":65.359477124183,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Create a PivotTable to analyze worksheet data<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"97a37437-fa1a-47d7-8870-b3c0ce7e4532"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":12.883053763440861,"width":75.16339869281046,"height":83.87096774193547,"action":{"library":"H5P.Video 1.6","params":{"visuals":{"fit":true,"controls":true},"playback":{"autoplay":false,"loop":false},"l10n":{"name":"Video","loading":"Video player loading...","noPlayers":"Found no video players that supports the given video format.","noSources":"Video is missing sources.","aborted":"Media playback has been aborted.","networkFailure":"Network failure.","cannotDecode":"Unable to decode media.","formatNotSupported":"Video format not supported.","mediaEncrypted":"Media encrypted.","unknownError":"Unknown error.","invalidYtId":"Invalid YouTube ID.","unknownYtId":"Unable to find video with the given YouTube ID.","restrictedYt":"The owner of this video does not allow it to be embedded."},"sources":[{"path":"https:\/\/eus-streaming-video-rt-microsoft-com.akamaized.net\/e4b0e40d-b4b3-409a-beaf-3791d70f5bca\/99af8c01-a09a-4f41-9de3-e6f7154c_3400.mp4","mime":"video\/mp4","copyright":{"license":"U"}}]},"subContentId":"57d37b41-ad40-4ddb-92c1-b71d320fae9f","metadata":{"contentType":"Video","license":"U","title":"Use the Field List to arrange fields in a PivotTable"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091503,"y":4.301075268817204,"width":65.359477124183,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Working with values in Pivot tables<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"721214cf-4795-4cbe-b185-e09916f8dfbe"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":13.313161290322581,"width":65.359477124183,"height":27.956989247311824,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
By default, PivotTable fields placed in the Values area are displayed as a SUM.<\/p>\n\n
If Excel interprets your data as text, the data is displayed as a COUNT.<\/p>\n\n
You can change the default calculation by first selecting the arrow to the right of the field name, and then select the Value Field Settings option.<\/p>\n"},"subContentId":"75d1c15c-4a44-447c-8d1e-9b35fc9a6bf3","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":70.80610021786492,"y":15.033591397849461,"width":26.143790849673202,"height":80,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","alt":"Image","file":{"path":"images\/file-673e92368bc55.png","mime":"image\/png","copyright":{"license":"U"},"width":194,"height":300}},"subContentId":"3a209a6d-a31c-4ce6-bc24-aa78e42f1f37","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091503,"y":4.301075268817204,"width":65.359477124183,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Working with values in Pivot tables<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"0fca8415-ecfa-466c-a468-877a885c7392"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091503,"y":17.204301075268816,"width":49.01960784313726,"height":45.16129032258064,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Next, change the calculation in the Summarize Values By section. <\/p>\n\n
Next, change the calculation in the Summarize Values By section. Note that when you change the calculation method, Excel automatically appends it in the Custom Name section, like \"Sum of FieldName\", but you can change it. If you select Number Format, you can change the number format for the entire field.<\/p>\n"},"subContentId":"e63e314b-143e-4864-a12f-46017d2a62df","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":54.46623093681917,"y":17.204301075268816,"width":40.30501089324619,"height":68.17204301075269,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","alt":"Image","file":{"path":"images\/file-673e92cb0e5d6.png","mime":"image\/png","copyright":{"license":"U"},"width":375,"height":321}},"subContentId":"ff2166e5-a9ef-48f7-a8e9-11f915de8a98","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":3.2679738562091503,"y":4.301075268817203,"width":65.359477124183,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Change the source data for a PivotTable<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"b50f208b-ccbf-4d56-896c-26ad102bbf3c"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":12.832666666666666,"width":93.68191721132898,"height":25.806451612903224,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
After you create a PivotTable, you can change the range of its source data. For example, you can expand the source data to include more rows of data. <\/p>\n\n
However, if the source data has been changed substantially\u2014such as having more or fewer columns, consider creating a new PivotTable.<\/p>\n"},"subContentId":"2867acfa-24c7-4319-85b7-9e2b1669da8a","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":4.357298474945534,"y":36.46494623655914,"width":37.03703703703704,"height":60.21505376344086,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
\n\t
\n\t
Click the PivotTable report.<\/p>\n\t<\/li>\n\t
\n\t
On the Analyze tab, in the Data group, click Change Data Source, and then click Change Data Source.<\/p>\n\n\t
The Change PivotTable Data Source dialog box is displayed.<\/p>\n\t<\/li>\n\t
\n\t
Click Select a table or range, and then enter the first cell in the Table\/Range text box, and click OK.<\/p>\n\t<\/li>\n<\/ol>\n"},"subContentId":"648ace72-fda8-4414-a67e-0a9c634a95af","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":42.48366013071895,"y":43.01075268817204,"width":52.832244008714596,"height":53.76344086021505,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","alt":"Image","file":{"path":"images\/file-673e8f77b1ca1.png","mime":"image\/png","copyright":{"license":"U"},"width":559,"height":288}},"subContentId":"c633f098-c5bb-48d7-a6e7-f5db502a79b0","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":4.357298474945534,"y":6.451612903225806,"width":65.359477124183,"height":8.602150537634408,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Refresh PivotTable data<\/h3>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"b306c491-d5bd-436b-afb0-4ed91487251d"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":4.357298474945534,"y":17.174064516129032,"width":89.32461873638344,"height":75.26881720430107,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
At any time, you can select Refresh to update the data for the PivotTables in your workbook. <\/p>\n\n
Select the PivotTable to show the PivotTable Analyze tab<\/p>\n\n
Select Refresh in the Data group, or press Alt+F5.<\/p>\n\n
<\/p>\n\n
<\/p>\n\n
<\/p>\n\n
Or, you can right-click the PivotTable and select Refresh.<\/p>\n"},"subContentId":"59267a17-00b0-4266-a196-e75326fb446d","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":10.893246187363834,"y":34.40860215053763,"width":1.8508145489265546,"height":3.6559139784946235,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","file":{"path":"images\/file-673e90a7289d2.png","mime":"image\/png","copyright":{"license":"U"},"width":17,"height":17},"alt":"Image"},"subContentId":"1dc1ef6c-8399-4d07-aafd-35843369ed41","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":7.625272331154684,"y":43.01075268817204,"width":13.507625272331156,"height":19.78494623655914,"action":{"library":"H5P.Image 1.1","params":{"decorative":false,"contentName":"Image","expandImage":"Expand Image","minimizeImage":"Minimize Image","alt":"Image","file":{"path":"images\/file-673e90bf5d223.jpg","mime":"image\/jpeg","copyright":{"license":"U"},"width":178,"height":132}},"subContentId":"c47a5ae5-2ec4-4cee-b0cc-e731cc0780e8","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}}],"keywordListEnabled":true,"globalBackgroundSelector":{},"keywordListAlwaysShow":false,"keywordListAutoHide":false,"keywordListOpacity":90},"override":{"activeSurface":false,"hideSummarySlide":false,"summarySlideSolutionButton":true,"summarySlideRetryButton":true,"enablePrintButton":false,"social":{"showFacebookShare":false,"facebookShare":{"url":"@currentpageurl","quote":"I scored @score out of @maxScore on a task at @currentpageurl."},"showTwitterShare":false,"twitterShare":{"statement":"I scored @score out of @maxScore on a task at @currentpageurl.","url":"@currentpageurl","hashtags":"h5p, course"},"showGoogleShare":false,"googleShareUrl":"@currentpageurl"}},"l10n":{"slide":"Slide","score":"Score","yourScore":"Your Score","maxScore":"Max Score","total":"Total","totalScore":"Total Score","showSolutions":"Show solutions","retry":"Retry","exportAnswers":"Export text","hideKeywords":"Hide sidebar navigation menu","showKeywords":"Show sidebar navigation menu","fullscreen":"Fullscreen","exitFullscreen":"Exit fullscreen","prevSlide":"Previous slide","nextSlide":"Next slide","currentSlide":"Current slide","lastSlide":"Last slide","solutionModeTitle":"Exit solution mode","solutionModeText":"Solution Mode","summaryMultipleTaskText":"Multiple tasks","scoreMessage":"You achieved:","shareFacebook":"Share on Facebook","shareTwitter":"Share on Twitter","shareGoogle":"Share on Google+","summary":"Summary","solutionsButtonTitle":"Show comments","printTitle":"Print","printIngress":"How would you like to print this presentation?","printAllSlides":"Print all slides","printCurrentSlide":"Print current slide","noTitle":"No title","accessibilitySlideNavigationExplanation":"Use left and right arrow to change slide in that direction whenever canvas is selected.","accessibilityCanvasLabel":"Presentation canvas. Use left and right arrow to move between slides.","accessibilityProgressBarLabel":"Choose slide to display","containsNotCompleted":"@slideName contains not completed interaction","containsCompleted":"@slideName contains completed interaction","slideCount":"Slide @index of @total","containsOnlyCorrect":"@slideName only has correct answers","containsIncorrectAnswers":"@slideName has incorrect answers","shareResult":"Share Result","accessibilityTotalScore":"You got @score of @maxScore points in total","accessibilityEnteredFullscreen":"Entered fullscreen","accessibilityExitedFullscreen":"Exited fullscreen","confirmDialogHeader":"Submit your answers","confirmDialogText":"This will submit your results, do you want to continue?","confirmDialogConfirmText":"Submit and see results","slideshowNavigationLabel":"Slideshow navigation"}}

Search

Spreadsheets: Summarizing data using Pivot Tables

Content Status

Type

Linked Node

Spreadsheets: Summarizing data using Pivot Tables

Content Creator

Reviewer