Excel (Pivot Table Wizard). ð (Data ð Pivot Table Report) . (. 4), .
:
* Excel. . Excel 97 65 535 ´ 256 .
* . Query.
* ʳ . ᒺ ( ), .
* . .
ϳ 볓 . . 4.
. 4. .
. . ð - , Excel , . . 5 , Microsoft Excel.
. 5. .
(. 6), . () , , . :
. 6. .
* . .
* . .
* . , .
* . .
- . . , , ר, . . . , . .
|
|
, , (. 7).
. 7. .
(Finish).
ᒺ. . (Pivot Table). :
* (, ). - ( (pivoting)). Excel , .
* , . ´ . ϳ .
* , ð , .
* , :
ð (Data ð Refresh Data).
- , , (Refresh Data).
(Refresh Data), .
(Pivot Table Field). , , (Field), . :
(Name) .
(Orientation) .
(Subtotals) . , . ( Ctrl) . . , ͳ (None).
(Hide Items) . , .
. , , . ð ð (Data ð Group and utine ð Group) (Group) . Excel . , . ϳ .
|
|
. , . . Excel , , ( , ).
ꅔ
Excel , . , , ꅔ. ꅔ .
ꅔ
, . , , , .
ֳ | $ 201 900 20% 8% |
$ 161 520 | =ֳ*(1-_) | |
̳ | $ 1 185 | =(_/12;_;-_ ) |
$ 426 664 | =̳_*_ | |
$ 224 764 | =_-ֳ |
:
* ?
* 20% ?
* 40- ?
* 7,5%?
³ , .
, . . . . , , .
ꅔ Excel :
* ꅔ . , .
* ꅔ . .
* . , .
* . .
ꅔ
ꅔ : , . ϳ , , . .
|
|