Скачать с ютуб How to Update Excel 2010 pivot table в хорошем качестве

How to Update Excel 2010 pivot table

This tutorial will show you how to update the information in one of Excel's most powerful features, the pivot table Don't forget to check out our site http://howtech.tv/ for more free how-to videos!    / ithowtovids   - our feed   / howtechtv   - join us on facebook https://plus.google.com/1034403827176... - our group in Google+ The pivot table is certainly one of the most powerful features in Excel. Learning how to update excel pivot table is essential as it will keep your table up to date when you change the source data. Step # 1 -- Opening the Options Tab Start MS Excel. There are two main ways to update a pivot table. The first way begins by navigating to the "Options" tab. In this tab and you will be presented with a wide range of different options for you table. Step # 2 -- Refreshing the Data In this tab you need to locate the "Data" section. In here you will find a large "Refresh" icon. Click on this. The computer will process for just a moment and then the spreadsheet will flicker and the data will have been updated. Step # 3 -- Alternative Update Method Alternatively, you can update the pivot table in a different way. Both of these methods do the same thing so it does not matter which you choose when learning how to update excel pivot table. Right click anywhere on the pivot table and in the menu that appears, click on the "Refresh" button. As before the table will flicker for a moment and the data will be updated.