Excel tools to demonstrate


and when salesperson columns are added or deleted. Then use this range name to sum sales in cell B2. (Scroll across to see answer.)



Yüklə 119,95 Kb.
səhifə56/56
tarix05.01.2022
ölçüsü119,95 Kb.
#72366
1   ...   48   49   50   51   52   53   54   55   56
and when salesperson columns are added or deleted. Then use this range name to sum sales in cell B2. (Scroll across to see answer.)

A great use for dynamic range names is with pivot tables. Suppose you want to base a pivot table on a data set that is likely to expand (or even contract) as time goes on. You can create a dynamic range name such as MyData for the data set. Then when the pivot table wizard asks for the data range, enter MyData. If your data set expands or contracts in the future, all you need to do is click on the Refresh pivot table button (!) to update the pivot table with the newest data. If you show this trick to your colleagues at work, you’ll be a hero!



Chris Albright Page 8/18/2018

Yüklə 119,95 Kb.

Dostları ilə paylaş:
1   ...   48   49   50   51   52   53   54   55   56




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©muhaz.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin