Mastering Excel: Power Pack Bundle by Mark Moore

Author:Mark Moore
Language: eng
Format: azw3, epub
Published: 2016-06-09T07:00:00+00:00

In Excel, go to the SalesData worksheet.

Find a data point that is in the Pivot Table.

For example, I want to change Gold Game Confectioners. The Clients worksheet tells me that it is ClientID 7. I use Autofilter to find the rows that have ClientID =7 in Sales Data.

I’m changing D81 to another number. I’m adding a few zeros to make it 4125000.

Click back on the Pivot Table.

Right-click on a Pivot Table cell and Select Refresh.

The Pivot Table values and the KPI should update. If they do, all your data linkages are working.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.