{"text_format":"3","workbook":"xlsx","n_sheets":26,"sheets":["Algus","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","Lisateave"],"not_rendered":{"images":24,"defined_names":5,"pivot_tables":19},"read":"whole","date_system":"1900"}

{"sheet":"Algus","index":0,"n_rows":5,"n_cols":1,"rows_kept":5}
["Tere tulemast!\nEkraanilugeri juhised: PivotTable-liigendtabelid pakuvad rohkem võimalusi. Lihtne PivotTable-liigendtabel annab teile andmetest üldkokkuvõtte, kuid vahel on teil vaja üksikasjalikke vastuseid konkreetsetele küsimustele. Siin tulebki appi veeruväljade ja reaväljade lisamine. \nJuhised näitavad, millistesse lahtritesse liikuda, et leida teavet funktsiooni kasutamise kohta või edasist lugemist.\nAlustamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN."]
["PivotTable-liigendtabelid \npakuvad rohkem võimalusi"]
["Lihtne PivotTable-liigendtabel annab teile andmetest üldkokkuvõtte,\nkuid vahel on teil vaja üksikasjalikke vastuseid konkreetsetele küsimustele.\nSiin tulebki appi veeruväljade ja reaväljade lisamine."]
["TASUB TEADA\nKas tegite esimese õppetüki läbi? Kui ei teinud, valige Fail > Uus ja otsige üles õppetükk „Looge PivotTable-liigendtabel“."]
["Minge tagasi algusse, vajutades klahvikombinatsiooni CTRL + HOME. Tutvustusega alustamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN."]

{"sheet":"1","index":1,"n_rows":16,"n_cols":9,"rows_kept":16}
["Esimeses õppetükis tutvustasime teile PivotTable-liigendtabelite mõistet. Samuti selgitasime, kuidas saab reavälja kasutada väärtusevälja tükeldava tingimusena.   "]
["Lahtrites H10 kuni I14 asub lahtrite B8 kuni E16 andmeid kokkuvõttev PivotTable-liigendtabel. PivotTable-liigendtabelis on kaks veergu: „Ostja“ ja „Summa kogusummast Summa“. Veerg „Ostja“ sisaldab väärtusi „Isa“, „Ema“, „Kersti“ ja „Üldkokkuvõte“; veerg „Summa kogusummast Summa“ sisaldab väärtusi 220 €, 270 €, 810 € ja 1 300 €. Veerg „Ostja“ koosneb reaväljast ja veerg „Summa kogusummast Summa“ koosneb väärtuseväljast."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[]
[]
[null,"Kuupäev","Ostja","Tüüp","Summa"]
["See näide näitab, kuidas reaväli...","2017-01-01","Isa","Kingitused",{"v":95,"d":"95 €"}]
["...tükeldab väärtusevälja.","2017-01-15","Ema","Toit",{"v":325,"d":"325 €"},null,null,"Ostja","Summa kogusummast Summa"]
[null,"2017-01-17","Ema","Piletid",{"v":250,"d":"250 €"},null,null,"Isa",{"v":220,"d":"220 €"}]
[null,"2017-01-21","Isa","Toit",{"v":125,"d":"125 €"},null,null,"Kersti",{"v":270,"d":"270 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"},null,null,"Ema",{"v":810,"d":"810 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"},null,null,"Grand Total",{"v":1300,"d":"1,300 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-02-25","Kersti","Sport",{"v":125,"d":"125 €"}]

{"sheet":"2","index":2,"n_rows":108,"n_cols":7,"rows_kept":108}
["PivotTable-liigendtabelile esimese pilgu heitmisel võite aga otsustada, et soovite sealt rohkem vastuseid leida."]
["Kui vaatate PivotTable-liigendtabelit, võite endalt küsida näiteks järgmist: „Millal need ostud tehti?“, „Millele iga inimene raha kulutas?“ või „Mida ema ostis, mis nii palju maksis?“."]
["Selles näites on lahtrites F11 kuni G15 kuvatud varasemaga sama kaheveeruline PivotTable-liigendtabel. Veerg „Ostja“ on reaväli ning sisaldab väärtusi „Isa“, „Ema“, „Kersti“ ja „Üldkokkuvõte“; veerg „Summa kogusummast Summa“ on väärtuseväli ning sisaldab väärtusi 220 €, 270 €, 810 € ja 1 300 €. "]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Ostja","Summa kogusummast Summa"]
[{"$nulls":5},"Isa",{"v":220,"d":"220 €"}]
[{"$nulls":5},"Kersti",{"v":270,"d":"270 €"}]
[{"$nulls":5},"Ema",{"v":810,"d":"810 €"}]
[{"$nulls":5},"Grand Total",{"v":1300,"d":"1,300 €"}]
{"$rows_empty":84}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-01","Isa","Kingitused",{"v":95,"d":"95 €"}]
[null,"2017-01-15","Ema","Toit",{"v":325,"d":"325 €"}]
[null,"2017-01-17","Ema","Piletid",{"v":250,"d":"250 €"}]
[null,"2017-01-21","Isa","Toit",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-02-25","Kersti","Sport",{"v":125,"d":"125 €"}]

{"sheet":"3","index":3,"n_rows":108,"n_cols":7,"rows_kept":108}
["Kõik need on head küsimused, kuid alustuseks tuleks keskenduda ühele neist."]
["Millele iga inimene raha kulutas?"]
["Lahtrites F11 kuni G15 on varasemaga sama kaheveeruline PivotTable-liigendtabel. Veerg „Ostja“ on reaväli ning sisaldab väärtusi „Isa“, „Ema“, „Kersti“ ja „Üldkokkuvõte“; veerg „Summa kogusummast Summa“ on väärtuseväli ning sisaldab väärtusi 220 €, 270 €, 810 € ja 1 300 €. "]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Ostja","Summa kogusummast Summa"]
[{"$nulls":5},"Isa",{"v":220,"d":"220 €"}]
[{"$nulls":5},"Kersti",{"v":270,"d":"270 €"}]
[{"$nulls":5},"Ema",{"v":810,"d":"810 €"}]
[{"$nulls":5},"Grand Total",{"v":1300,"d":"1,300 €"}]
{"$rows_empty":84}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-01","Isa","Kingitused",{"v":95,"d":"95 €"}]
[null,"2017-01-15","Ema","Toit",{"v":325,"d":"325 €"}]
[null,"2017-01-17","Ema","Piletid",{"v":250,"d":"250 €"}]
[null,"2017-01-21","Isa","Toit",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-02-25","Kersti","Sport",{"v":125,"d":"125 €"}]

{"sheet":"4","index":4,"n_rows":108,"n_cols":9,"rows_kept":108}
["Viimati esitasime küsimuse „Millele iga inimene raha kulutas?“."]
["Sellele küsimusele vastamiseks lisasime tüübi jaoks omaette veeruvälja. Seetõttu on PivotTable-liigendtabelis nüüd viis uut veergu, milles on kuvatud iga inimese tehtud ostude tüüp. "]
["Meie uus PivotTable-liigendtabel võtab nüüd enda alla lahtrid C10 kuni I15 ning sisaldab veerge Ostja, Toit, Muusika, Sport, Piletid, Kingitused ja Üldkokkuvõte. Ostja ja Üldkokkuvõte on samad, mis enne. Uued üksikasjaveerud asuvad nende vahel."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[]
[]
[]
[null,null,"Summa kogusummast Summa","Tüüp"]
[null,null,"Ostja","Toit","Muusika","Sport","Piletid","Kingitused","Grand Total"]
[null,null,"Isa",{"v":125,"d":"125 €"},{"$nulls":3},{"v":95,"d":"95 €"},{"v":220,"d":"220 €"}]
[null,null,"Kersti",null,{"v":20,"d":"20 €"},{"v":125,"d":"125 €"},{"v":125,"d":"125 €"},null,{"v":270,"d":"270 €"}]
[null,null,"Ema",{"v":560,"d":"560 €"},null,null,{"v":250,"d":"250 €"},null,{"v":810,"d":"810 €"}]
[null,null,"Grand Total",{"v":685,"d":"685 €"},{"v":20,"d":"20 €"},{"v":125,"d":"125 €"},{"v":375,"d":"375 €"},{"v":95,"d":"95 €"},{"v":1300,"d":"1,300 €"}]
{"$rows_empty":84}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-01","Isa","Kingitused",{"v":95,"d":"95 €"}]
[null,"2017-01-15","Ema","Toit",{"v":325,"d":"325 €"}]
[null,"2017-01-17","Ema","Piletid",{"v":250,"d":"250 €"}]
[null,"2017-01-21","Isa","Toit",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-02-25","Kersti","Sport",{"v":125,"d":"125 €"}]

{"sheet":"5","index":5,"n_rows":108,"n_cols":9,"rows_kept":108}
["Kui PivotTable-liigendtabelit on raske mõista, proovige seda: lugege tabelit vasakult, seejärel ülevalt ja siis alla. Allpool asuvas näites on isa lahtris C12, 125 € toitu lahtris D12, 95 € eest kingitusi lahtris E12 ja üldkokkuvõte 220 € lahtris I12. Ridades 13 ja 14 kuvatakse Kersti ja ema üksikasjad ning reas 15 on kuvatud üldkokkuvõte."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
{"$rows_empty":7}
[null,null,"Summa kogusummast Summa","Tüüp"]
[null,null,"Ostja","Toit","Kingitused","Muusika","Sport","Piletid","Grand Total"]
[null,null,"Isa",{"v":125,"d":"125 €"},{"v":95,"d":"95 €"},{"$nulls":3},{"v":220,"d":"220 €"}]
[null,null,"Kersti",null,null,{"v":20,"d":"20 €"},{"v":125,"d":"125 €"},{"v":125,"d":"125 €"},{"v":270,"d":"270 €"}]
[null,null,"Ema",{"v":560,"d":"560 €"},{"$nulls":3},{"v":250,"d":"250 €"},{"v":810,"d":"810 €"}]
[null,null,"Grand Total",{"v":685,"d":"685 €"},{"v":95,"d":"95 €"},{"v":20,"d":"20 €"},{"v":125,"d":"125 €"},{"v":375,"d":"375 €"},{"v":1300,"d":"1,300 €"}]
{"$rows_empty":84}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-01","Isa","Kingitused",{"v":95,"d":"95 €"}]
[null,"2017-01-15","Ema","Toit",{"v":325,"d":"325 €"}]
[null,"2017-01-17","Ema","Piletid",{"v":250,"d":"250 €"}]
[null,"2017-01-21","Isa","Toit",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-02-25","Kersti","Sport",{"v":125,"d":"125 €"}]

{"sheet":"6","index":6,"n_rows":3,"n_cols":1,"rows_kept":3}
["Ärge seda veel tehke. Tööd PivotTable-liigendtabeliga olete valmis alustama pärast mõnda täiendavat toimingut. Esimese asjana tuleb teil luua veeruväljal üksikasjad. Selleks paigutage veeruvälja alasse väli Tüüp."]
["PivotTable-liigendtabeli väljad pildil lohistab noolekursor välja „Tüüp“ alale „Väärtused“."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]

{"sheet":"7","index":7,"n_rows":108,"n_cols":8,"rows_kept":108}
["1. PivotTable-liigendtabeli ala on selles näites lahtrivahemikus B13 kuni C17. Liikuge mõnda nendest lahtritest."]
["2. Vajutage PivotTable-liigendtabeli väljad avamiseks klahve ALT + JS ja seejärel klahve L ja 2. Fookuse vaikevalik on otsingutekstiväli: otsi"]
["3. Vajutage välja „Tüüp“ valimiseks nooleklahve. Kui see on valitud, vajutage välja „Tüüp“ lisamiseks ridade alale tühikuklahvi. "]
["4. Välja „Tüüp“ valimiseks vajutage tabeldusklahvi (TAB). Vajutage sisestusklahvi (ENTER), seejärel vajutage nooleklahve, et valida käsk „Teisalda Veerusiltide hulka“, ja vajutage sisestusklahvi (ENTER), et lisada väli „Tüüp“ veerualale. Vajutage PivotTable-liigendtabeli väljapaanist väljumiseks klahvikombinatsiooni ALT + JS + L2."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"Ostja\",$H$17=810),\"Tubli töö! Olete oma esimese\",\" \")","v":" "}]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"Ostja\",$H$17=810),\"veeruvälja kohale paigutanud.\",\" \")","v":" "}]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"Ostja\",$H$17=810),\"Jätkamiseks klõpsake nuppu Edasi...\",\" \")","v":" "}]
[]
[null,"Ostja","Summa kogusummast Summa"]
[null,"Isa",{"v":220,"d":"220 €"}]
[null,"Kersti",{"v":270,"d":"270 €"}]
[null,"Ema",{"v":810,"d":"810 €"}]
[null,"Üldkokkuvõte",{"v":1300,"d":"1,300 €"}]
{"$rows_empty":82}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-01","Isa","Kingitused",{"v":95,"d":"95 €"}]
[null,"2017-01-15","Ema","Toit",{"v":325,"d":"325 €"}]
[null,"2017-01-17","Ema","Piletid",{"v":250,"d":"250 €"}]
[null,"2017-01-21","Isa","Toit",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-02-25","Kersti","Sport",{"v":125,"d":"125 €"}]

{"sheet":"8","index":8,"n_rows":108,"n_cols":9,"rows_kept":108}
["Vaatame äsja loodud PivotTable-liigendtabeli nüüd üle. Seekord oleme lisanud värvid, et rea-, veeru- ja väärtuseväljadel paremini vahet teha."]
["Reaväli asub lahtrites C10 kuni C13 ja on kollast värvi."]
["Veeruväli asub lahtrites D9 kuni H10 ja on oranži värvi."]
["Väärtuseväli asub lahtrites D11 kuni H13 ja on sinist värvi."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[]
[null,null,"Summa kogusummast Summa","Tüüp"]
[null,null,"Ostja","Toit","Kingitused","Muusika","Sport","Piletid","Grand Total"]
[null,null,"Isa",{"v":125,"d":"125 €"},{"v":95,"d":"95 €"},{"$nulls":3},{"v":220,"d":"220 €"}]
[null,null,"Kersti",null,null,{"v":20,"d":"20 €"},{"v":125,"d":"125 €"},{"v":125,"d":"125 €"},{"v":270,"d":"270 €"}]
[null,null,"Ema",{"v":560,"d":"560 €"},{"$nulls":3},{"v":250,"d":"250 €"},{"v":810,"d":"810 €"}]
[null,null,"Grand Total",{"v":685,"d":"685 €"},{"v":95,"d":"95 €"},{"v":20,"d":"20 €"},{"v":125,"d":"125 €"},{"v":375,"d":"375 €"},{"v":1300,"d":"1,300 €"}]
{"$rows_empty":85}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-01","Isa","Kingitused",{"v":95,"d":"95 €"}]
[null,"2017-01-15","Ema","Toit",{"v":325,"d":"325 €"}]
[null,"2017-01-17","Ema","Piletid",{"v":250,"d":"250 €"}]
[null,"2017-01-21","Isa","Toit",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-02-25","Kersti","Sport",{"v":125,"d":"125 €"}]

{"sheet":"9","index":9,"n_rows":3,"n_cols":1,"rows_kept":3}
["Sellele võib mõelda ka teisiti: reaväli asub vasakul ja veeruväli üleval. Mõlemad väljad annavad tingimuse väärtuseväljale, mis need kokku liidab."]
["Pildil on kujutatud nelja jaotisega nelinurkne ala, kus rea väli asub vasakpoolses allnurgas ja on kollane, veeru väli parempoolses ülanurgas ja on oranž ning väärtuseväli parempoolses allnurgas ja on sinine."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]

{"sheet":"10","index":10,"n_rows":3,"n_cols":1,"rows_kept":3}
["Väljaloendi kasutamisel mõelge sellele nii: reaväli asub vasakul ja veeruväli üleval. Mõlemad väljad annavad tingimuse väärtuseväljale, mis need kokku liidab."]
["Pildil on kujutatud PivotTable-liigendtabeli väljad, kus rea väli asub vasakpoolses allnurgas ja on kollane, veeru väli parempoolses ülanurgas ja on oranž ning väärtuse väli parempoolses allnurgas ja on sinine."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]

{"sheet":"11","index":11,"n_rows":121,"n_cols":24,"rows_kept":121}
["Üks asi, millest tuleks teadlik olla: kui veeruväli lisab PivotTable-liigendtabelisse palju veerge, muutub tabel väga laiaks. "]
["Selles näites ulatub PivotTable-liigendtabel nüüd lahtrist C10 lahtrisse X15, kuna veeruväli lisas 20 uut veergu. Seda on päris palju! Inimesed peavad hakkama tabelit kerima..."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[]
[]
[]
[]
[null,null,"Summa kogusummast Summa","Tüüp"]
[null,null,"Ostja","Autokindlustus","Einestamine","Elekter","Elektroonika","Hambaravi","Kodukindlustus","Kütus","Lennukulud","Liikmemaksud","Maksud","Meditsiinitarbed","Muusika","Muusikakool","Parkimine","Piletid","Raamatud","Riided","Sport","Tervisekindlustus","Toit","Grand Total"]
[null,null,"Isa",{"$nulls":7},{"v":500,"d":"500 €"},null,{"v":500,"d":"500 €"},{"$nulls":7},{"v":1000,"d":"1,000 €"},null,null,{"v":2000,"d":"2,000 €"}]
[null,null,"Kersti",null,{"v":20,"d":"20 €"},null,{"v":125,"d":"125 €"},{"$nulls":7},{"v":20,"d":"20 €"},{"v":250,"d":"250 €"},{"v":20,"d":"20 €"},{"v":125,"d":"125 €"},{"v":250,"d":"250 €"},{"v":125,"d":"125 €"},{"$nulls":3},{"v":935,"d":"935 €"}]
[null,null,"Ema",{"v":74,"d":"74 €"},null,{"v":70,"d":"70 €"},null,{"v":235,"d":"235 €"},{"v":235,"d":"235 €"},{"v":74,"d":"74 €"},null,{"v":125,"d":"125 €"},null,{"v":74,"d":"74 €"},{"$nulls":7},{"v":70,"d":"70 €"},{"v":470,"d":"470 €"},{"v":1427,"d":"1,427 €"}]
[null,null,"Grand Total",{"v":74,"d":"74 €"},{"v":20,"d":"20 €"},{"v":70,"d":"70 €"},{"v":125,"d":"125 €"},{"v":235,"d":"235 €"},{"v":235,"d":"235 €"},{"v":74,"d":"74 €"},{"v":500,"d":"500 €"},{"v":125,"d":"125 €"},{"v":500,"d":"500 €"},{"v":74,"d":"74 €"},{"v":20,"d":"20 €"},{"v":250,"d":"250 €"},{"v":20,"d":"20 €"},{"v":125,"d":"125 €"},{"v":250,"d":"250 €"},{"v":125,"d":"125 €"},{"v":1000,"d":"1,000 €"},{"v":70,"d":"70 €"},{"v":470,"d":"470 €"},{"v":4362,"d":"4,362 €"}]
{"$rows_empty":84}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-17","Isa","Sport",{"v":1000,"d":"1,000 €"}]
[null,"2017-01-17","Isa","Lennukulud",{"v":500,"d":"500 €"}]
[null,"2017-01-17","Isa","Maksud",{"v":500,"d":"500 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-01-21","Kersti","Raamatud",{"v":250,"d":"250 €"}]
[null,"2017-02-20","Kersti","Einestamine",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Riided",{"v":125,"d":"125 €"}]
[null,"2017-01-21","Kersti","Muusikakool",{"v":250,"d":"250 €"}]
[null,"2017-02-20","Kersti","Parkimine",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Elektroonika",{"v":125,"d":"125 €"}]
[null,"2017-01-01","Ema","Kütus",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-01-21","Ema","Liikmemaksud",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-01-01","Ema","Meditsiinitarbed",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Elekter",{"v":70,"d":"70 €"}]
[null,"2017-02-02","Ema","Hambaravi",{"v":235,"d":"235 €"}]
[null,"2017-01-01","Ema","Autokindlustus",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Tervisekindlustus",{"v":70,"d":"70 €"}]
[null,"2017-02-02","Ema","Kodukindlustus",{"v":235,"d":"235 €"}]

{"sheet":"12","index":12,"n_rows":119,"n_cols":5,"rows_kept":119}
["Ülilaiadele PivotTable-liigendtabelitele on siiski olemas ka alternatiiv: võite kasutada hoopis teist reavälja. Teine reaväli kuvatakse taandatuna esimese reavälja all."]
["Selles näites võtab PivotTable-liigendtabel enda alla lahtrivahemiku D8 kuni E32. Esimeses reaväljas veerus D on kirjas Isa, Kersti ja Ema. Seejärel kuvatakse nende all teise rea väljadena kulutüübid: sport, lennupiletite kulud, väljas einestamine jne."]
["TASUB TEADA\nTeine reaväli muudab PivotTable-liigendtabeli horisontaalse asemel vertikaalseks. Mõne inimese jaoks on vertikaalseid PivotTable-liigendtabeleid lihtsam lugeda, kuna siis pole vaja nii palju horisontaalsuunas kerida."]
["EXCELI SÕNAVARA\nVahel nimetatakse teist reavälja ka teiseseks reaväljaks."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[{"$nulls":3},"Row Labels","Summa kogusummast Summa"]
[{"$nulls":3},"Isa",{"v":2000,"d":"2,000 €"}]
[{"$nulls":3},"Lennukulud",{"v":500,"d":"500 €"}]
[{"$nulls":3},"Maksud",{"v":500,"d":"500 €"}]
[{"$nulls":3},"Sport",{"v":1000,"d":"1,000 €"}]
[{"$nulls":3},"Kersti",{"v":935,"d":"935 €"}]
[{"$nulls":3},"Einestamine",{"v":20,"d":"20 €"}]
[{"$nulls":3},"Elektroonika",{"v":125,"d":"125 €"}]
[{"$nulls":3},"Muusika",{"v":20,"d":"20 €"}]
[{"$nulls":3},"Muusikakool",{"v":250,"d":"250 €"}]
[{"$nulls":3},"Parkimine",{"v":20,"d":"20 €"}]
[{"$nulls":3},"Piletid",{"v":125,"d":"125 €"}]
[{"$nulls":3},"Raamatud",{"v":250,"d":"250 €"}]
[{"$nulls":3},"Riided",{"v":125,"d":"125 €"}]
[{"$nulls":3},"Ema",{"v":1427,"d":"1,427 €"}]
[{"$nulls":3},"Autokindlustus",{"v":74,"d":"74 €"}]
[{"$nulls":3},"Elekter",{"v":70,"d":"70 €"}]
[{"$nulls":3},"Hambaravi",{"v":235,"d":"235 €"}]
[{"$nulls":3},"Kodukindlustus",{"v":235,"d":"235 €"}]
[{"$nulls":3},"Kütus",{"v":74,"d":"74 €"}]
[{"$nulls":3},"Liikmemaksud",{"v":125,"d":"125 €"}]
[{"$nulls":3},"Meditsiinitarbed",{"v":74,"d":"74 €"}]
[{"$nulls":3},"Tervisekindlustus",{"v":70,"d":"70 €"}]
[{"$nulls":3},"Toit",{"v":470,"d":"470 €"}]
[{"$nulls":3},"Grand Total",{"v":4362,"d":"4,362 €"}]
{"$rows_empty":65}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-17","Isa","Sport",{"v":1000,"d":"1,000 €"}]
[null,"2017-01-17","Isa","Lennukulud",{"v":500,"d":"500 €"}]
[null,"2017-01-17","Isa","Maksud",{"v":500,"d":"500 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-01-21","Kersti","Raamatud",{"v":250,"d":"250 €"}]
[null,"2017-02-20","Kersti","Einestamine",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Riided",{"v":125,"d":"125 €"}]
[null,"2017-01-21","Kersti","Muusikakool",{"v":250,"d":"250 €"}]
[null,"2017-02-20","Kersti","Parkimine",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Elektroonika",{"v":125,"d":"125 €"}]
[null,"2017-01-01","Ema","Kütus",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-01-21","Ema","Liikmemaksud",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-01-01","Ema","Meditsiinitarbed",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Elekter",{"v":70,"d":"70 €"}]
[null,"2017-02-02","Ema","Hambaravi",{"v":235,"d":"235 €"}]
[null,"2017-01-01","Ema","Autokindlustus",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Tervisekindlustus",{"v":70,"d":"70 €"}]
[null,"2017-02-02","Ema","Kodukindlustus",{"v":235,"d":"235 €"}]

{"sheet":"13","index":13,"n_rows":3,"n_cols":1,"rows_kept":3}
["Järgmisel lehel lisate teise reavälja. Selleks tuleb väli „Tüüp“ lohistada reaväljal välja „Ostja“ alla."]
["PivotTable-liigendtabeli väljad pildil lohistab noolekursor välja „Tüüp“ reaalale."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]

{"sheet":"14","index":14,"n_rows":122,"n_cols":9,"rows_kept":122}
["1. PivotTable-liigendtabeli ala on selles näites lahtrivahemikus B13 kuni C17. Liikuge mõnda nendest lahtritest. "]
["2. Vajutage PivotTable-liigendtabeli väljad avamiseks klahve ALT + JS ja seejärel klahve L ja 2. Fookuse vaikevalikuks on tekstiväli „Otsi“. Redigeeritav väli „Tippige otsitavad sõnad“. Ärge tippige midagi, vaid vajutage ühe korra tabeldusklahvi (TAB). MÄRKUS. Kui väljaloendit ei kuvata, vajutage uuesti klahve ALT+JS, L2."]
["3. Vajutage väljale „Tüüp“ liikumiseks nooleklahve. Vajutage välja „Tüüp“ lisamiseks reaalale tühikuklahvi. "]
["4. Vajutage paani „PivotTable-liigendtabeli väljad“ sulgemiseks paoklahvi (ESC). "]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP.",{"$nulls":7},{"$f":"IF(AND($B$15=\"Lennukulud\",$C$36=470),\"Tubli. Olete PivotTable- \",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"Lennukulud\",$C$36=470),\"liigendtabelisse lisanud teise\",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"Lennukulud\",$C$36=470),\" reavälja. Liikuge kerides allapoole\",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"Lennukulud\",$C$36=470),\"ja klõpsake nuppu Edasi…\",\" \")","v":" "}]
[]
[]
[]
[]
[null,"Row Labels","Summa kogusummast Summa"]
[null,"Isa",{"v":2000,"d":"2,000 €"}]
[null,"Kersti",{"v":935,"d":"935 €"}]
[null,"Ema",{"v":1427,"d":"1,427 €"}]
[null,"Grand Total",{"v":4362,"d":"4,362 €"}]
{"$rows_empty":83}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-17","Isa","Sport",{"v":1000,"d":"1,000 €"}]
[null,"2017-01-17","Isa","Lennukulud",{"v":500,"d":"500 €"}]
[null,"2017-01-17","Isa","Maksud",{"v":500,"d":"500 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-01-21","Kersti","Raamatud",{"v":250,"d":"250 €"}]
[null,"2017-02-20","Kersti","Einestamine",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Riided",{"v":125,"d":"125 €"}]
[null,"2017-01-21","Kersti","Muusikakool",{"v":250,"d":"250 €"}]
[null,"2017-02-20","Kersti","Parkimine",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Elektroonika",{"v":125,"d":"125 €"}]
[null,"2017-01-01","Ema","Kütus",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-01-21","Ema","Liikmemaksud",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-01-01","Ema","Meditsiinitarbed",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Elekter",{"v":70,"d":"70 €"}]
[null,"2017-02-02","Ema","Hambaravi",{"v":235,"d":"235 €"}]
[null,"2017-01-01","Ema","Autokindlustus",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Tervisekindlustus",{"v":70,"d":"70 €"}]
[null,"2017-02-02","Ema","Kodukindlustus",{"v":235,"d":"235 €"}]

{"sheet":"15","index":15,"n_rows":121,"n_cols":7,"rows_kept":121}
["Kui teil on vaja PivotTable-liigendtabelit lihtsustada, saate teise reavälja andmed „üles“ ja eest ära ahendada. "]
["Selles näites asub PivotTable-liigendtabel lahtrivahemikus F7 kuni G31. Valige lahter F8, et valida esimene rea väli – Isa. Seejärel vajutage teise välja laiendamiseks klahve Alt + JS > EA või ahendamiseks klahvi A."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[{"$nulls":5},{"$f":"IF(AND($F$9=\"Kersti\",$G$9=935),\"Ilus!\",\" \")","v":" "}]
[{"$nulls":5},"Row Labels","Summa kogusummast Summa"]
[{"$nulls":5},"Isa",{"v":2000,"d":"2,000 €"}]
[{"$nulls":5},"Lennukulud",{"v":500,"d":"500 €"}]
[{"$nulls":5},"Maksud",{"v":500,"d":"500 €"}]
[{"$nulls":5},"Sport",{"v":1000,"d":"1,000 €"}]
[{"$nulls":5},"Kersti",{"v":935,"d":"935 €"}]
[{"$nulls":5},"Einestamine",{"v":20,"d":"20 €"}]
[{"$nulls":5},"Elektroonika",{"v":125,"d":"125 €"}]
[{"$nulls":5},"Muusika",{"v":20,"d":"20 €"}]
[{"$nulls":5},"Muusikakool",{"v":250,"d":"250 €"}]
[{"$nulls":5},"Parkimine",{"v":20,"d":"20 €"}]
[{"$nulls":5},"Piletid",{"v":125,"d":"125 €"}]
[{"$nulls":5},"Raamatud",{"v":250,"d":"250 €"}]
[{"$nulls":5},"Riided",{"v":125,"d":"125 €"}]
[{"$nulls":5},"Ema",{"v":1427,"d":"1,427 €"}]
[{"$nulls":5},"Autokindlustus",{"v":74,"d":"74 €"}]
[{"$nulls":5},"Elekter",{"v":70,"d":"70 €"}]
[{"$nulls":5},"Hambaravi",{"v":235,"d":"235 €"}]
[{"$nulls":5},"Kodukindlustus",{"v":235,"d":"235 €"}]
[{"$nulls":5},"Kütus",{"v":74,"d":"74 €"}]
[{"$nulls":5},"Liikmemaksud",{"v":125,"d":"125 €"}]
[{"$nulls":5},"Meditsiinitarbed",{"v":74,"d":"74 €"}]
[{"$nulls":5},"Tervisekindlustus",{"v":70,"d":"70 €"}]
[{"$nulls":5},"Toit",{"v":470,"d":"470 €"}]
[{"$nulls":5},"Grand Total",{"v":4362,"d":"4,362 €"}]
{"$rows_empty":68}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-17","Isa","Sport",{"v":1000,"d":"1,000 €"}]
[null,"2017-01-17","Isa","Lennukulud",{"v":500,"d":"500 €"}]
[null,"2017-01-17","Isa","Maksud",{"v":500,"d":"500 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-01-21","Kersti","Raamatud",{"v":250,"d":"250 €"}]
[null,"2017-02-20","Kersti","Einestamine",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Riided",{"v":125,"d":"125 €"}]
[null,"2017-01-21","Kersti","Muusikakool",{"v":250,"d":"250 €"}]
[null,"2017-02-20","Kersti","Parkimine",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Elektroonika",{"v":125,"d":"125 €"}]
[null,"2017-01-01","Ema","Kütus",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-01-21","Ema","Liikmemaksud",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-01-01","Ema","Meditsiinitarbed",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Elekter",{"v":70,"d":"70 €"}]
[null,"2017-02-02","Ema","Hambaravi",{"v":235,"d":"235 €"}]
[null,"2017-01-01","Ema","Autokindlustus",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Tervisekindlustus",{"v":70,"d":"70 €"}]
[null,"2017-02-02","Ema","Kodukindlustus",{"v":235,"d":"235 €"}]

{"sheet":"16","index":16,"n_rows":121,"n_cols":7,"rows_kept":121}
["PivotTable-liigendtabeli lihtsustamiseks saate terve teise reavälja ahendada või laiendada."]
["Nõks on selline"]
["Valige PivotTable-liigendtabeli andmevahemik lahtrites F7 kuni G31. Seejärel valige terve rühma ahendamiseks ALT+JS > A. ALT+JS > EA seevastu laiendab terve rühma."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[{"$nulls":5},{"$f":"IF(AND($F$9=\"Kersti\",$G$9=935),\"Väga hea!\",\" \")","v":" "}]
[{"$nulls":5},"Row Labels","Summa kogusummast Summa"]
[{"$nulls":5},"Isa",{"v":2000,"d":"2,000 €"}]
[{"$nulls":5},"Lennukulud",{"v":500,"d":"500 €"}]
[{"$nulls":5},"Maksud",{"v":500,"d":"500 €"}]
[{"$nulls":5},"Sport",{"v":1000,"d":"1,000 €"}]
[{"$nulls":5},"Kersti",{"v":935,"d":"935 €"}]
[{"$nulls":5},"Einestamine",{"v":20,"d":"20 €"}]
[{"$nulls":5},"Elektroonika",{"v":125,"d":"125 €"}]
[{"$nulls":5},"Muusika",{"v":20,"d":"20 €"}]
[{"$nulls":5},"Muusikakool",{"v":250,"d":"250 €"}]
[{"$nulls":5},"Parkimine",{"v":20,"d":"20 €"}]
[{"$nulls":5},"Piletid",{"v":125,"d":"125 €"}]
[{"$nulls":5},"Raamatud",{"v":250,"d":"250 €"}]
[{"$nulls":5},"Riided",{"v":125,"d":"125 €"}]
[{"$nulls":5},"Ema",{"v":1427,"d":"1,427 €"}]
[{"$nulls":5},"Autokindlustus",{"v":74,"d":"74 €"}]
[{"$nulls":5},"Elekter",{"v":70,"d":"70 €"}]
[{"$nulls":5},"Hambaravi",{"v":235,"d":"235 €"}]
[{"$nulls":5},"Kodukindlustus",{"v":235,"d":"235 €"}]
[{"$nulls":5},"Kütus",{"v":74,"d":"74 €"}]
[{"$nulls":5},"Liikmemaksud",{"v":125,"d":"125 €"}]
[{"$nulls":5},"Meditsiinitarbed",{"v":74,"d":"74 €"}]
[{"$nulls":5},"Tervisekindlustus",{"v":70,"d":"70 €"}]
[{"$nulls":5},"Toit",{"v":470,"d":"470 €"}]
[{"$nulls":5},"Grand Total",{"v":4362,"d":"4,362 €"}]
{"$rows_empty":68}
[null,"Kuupäev","Ostja","Tüüp","Summa"]
[null,"2017-01-17","Isa","Sport",{"v":1000,"d":"1,000 €"}]
[null,"2017-01-17","Isa","Lennukulud",{"v":500,"d":"500 €"}]
[null,"2017-01-17","Isa","Maksud",{"v":500,"d":"500 €"}]
[null,"2017-02-20","Kersti","Muusika",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Piletid",{"v":125,"d":"125 €"}]
[null,"2017-01-21","Kersti","Raamatud",{"v":250,"d":"250 €"}]
[null,"2017-02-20","Kersti","Einestamine",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Riided",{"v":125,"d":"125 €"}]
[null,"2017-01-21","Kersti","Muusikakool",{"v":250,"d":"250 €"}]
[null,"2017-02-20","Kersti","Parkimine",{"v":20,"d":"20 €"}]
[null,"2017-02-25","Kersti","Elektroonika",{"v":125,"d":"125 €"}]
[null,"2017-01-01","Ema","Kütus",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-01-21","Ema","Liikmemaksud",{"v":125,"d":"125 €"}]
[null,"2017-02-02","Ema","Toit",{"v":235,"d":"235 €"}]
[null,"2017-01-01","Ema","Meditsiinitarbed",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Elekter",{"v":70,"d":"70 €"}]
[null,"2017-02-02","Ema","Hambaravi",{"v":235,"d":"235 €"}]
[null,"2017-01-01","Ema","Autokindlustus",{"v":74,"d":"74 €"}]
[null,"2017-01-15","Ema","Tervisekindlustus",{"v":70,"d":"70 €"}]
[null,"2017-02-02","Ema","Kodukindlustus",{"v":235,"d":"235 €"}]

{"sheet":"17","index":17,"n_rows":107,"n_cols":13,"rows_kept":107}
["Veeruvälju võib olla ka rohkem kui üks. Samuti saab neid nii ahendada kui ka laiendada."]
["Selles näites hõlmab PivotTable-liigendtabel lahtrivahemikku B13 kuni M19. Jaotises Veerud on kategooria Tüüp, mis sisaldab toit ja kommunaalid üksusi."]
["PROOVIGE SEDA\nTerve välja ahendamiseks valige Toit lahtris C14 ja seejärel ALT+JS > A. ALT+JS > EA laiendab välja."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
{"$rows_empty":7}
[null,null,{"$f":"IF(AND($C$16=398,$D$15=\"Jaan\"),\"Hästi tehtud!\",\" \")","v":" "}]
[null,"Summa kogusummast Summa","Column Labels"]
[null,null,"Toit",{"$nulls":3},"Toit Total","Kommunaalid",{"$nulls":3},"Kommunaalid Total","Grand Total"]
[null,"Row Labels","Jaan","Veebr","Märts","Apr",null,"Jaan","Veebr","Märts","Apr"]
[null,"Kersti",{"v":74,"d":"74 €"},{"v":74,"d":"74 €"},{"v":125,"d":"125 €"},{"v":125,"d":"125 €"},{"v":398,"d":"398 €"},{"$nulls":5},{"v":398,"d":"398 €"}]
[null,"Isa",{"v":235,"d":"235 €"},{"v":235,"d":"235 €"},{"v":235,"d":"235 €"},{"v":74,"d":"74 €"},{"v":779,"d":"779 €"},{"$nulls":5},{"v":779,"d":"779 €"}]
[null,"Ema",{"$nulls":5},{"v":1000,"d":"1,000 €"},{"v":1000,"d":"1,000 €"},{"v":20,"d":"20 €"},{"v":70,"d":"70 €"},{"v":2090,"d":"2,090 €"},{"v":2090,"d":"2,090 €"}]
[null,"Grand Total",{"v":309,"d":"309 €"},{"v":309,"d":"309 €"},{"v":360,"d":"360 €"},{"v":199,"d":"199 €"},{"v":1177,"d":"1,177 €"},{"v":1000,"d":"1,000 €"},{"v":1000,"d":"1,000 €"},{"v":20,"d":"20 €"},{"v":70,"d":"70 €"},{"v":2090,"d":"2,090 €"},{"v":3267,"d":"3,267 €"}]
{"$rows_empty":75}
[null,"Kuu","Ostja","Tüüp","Summa"]
[null,"Jaan","Kersti","Toit",{"v":74,"d":"74 €"}]
[null,"Jaan","Isa","Toit",{"v":235,"d":"235 €"}]
[null,"Jaan","Ema","Kommunaalid",{"v":1000,"d":"1,000 €"}]
[null,"Veebr","Kersti","Toit",{"v":74,"d":"74 €"}]
[null,"Veebr","Isa","Toit",{"v":235,"d":"235 €"}]
[null,"Veebr","Ema","Kommunaalid",{"v":1000,"d":"1,000 €"}]
[null,"Märts","Kersti","Toit",{"v":125,"d":"125 €"}]
[null,"Märts","Isa","Toit",{"v":235,"d":"235 €"}]
[null,"Märts","Ema","Kommunaalid",{"v":20,"d":"20 €"}]
[null,"Apr","Kersti","Toit",{"v":125,"d":"125 €"}]
[null,"Apr","Isa","Toit",{"v":74,"d":"74 €"}]
[null,"Apr","Ema","Kommunaalid",{"v":70,"d":"70 €"}]

{"sheet":"18","index":18,"n_rows":146,"n_cols":5,"rows_kept":146}
["Pidage meeles: kui soovite rohkem üksikasju, saab lisada veel palju muid reavälju või veeruvälju. Selles näites on kolm reavälja."]
["PivotTable-liigendtabel hõlmab lahtrivahemikku D8 kuni E29. Veerus D on aastaaeg, ostja ja tüüp väljad, veerus E aga Summa kogusummast Summa."]
["EKSPERDI NÕUANNE\nSee, et välju saab lisada, ei tähenda, et peaksite seda kindlasti tegema. Käesolevas näites toimib kõik hästi. Ent vahel võib liiga suur hulk välju koos kõigi taanetega muuta PivotTable-liigendtabeli liiga keeruliseks, et teised inimesed sellest aru saaksid. "]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[]
[{"$nulls":3},"Row Labels","Summa kogusummast Summa"]
[{"$nulls":3},"Kevad",{"v":4760,"d":"4,760 €"}]
[{"$nulls":3},"Isa",{"v":4760,"d":"4,760 €"}]
[{"$nulls":3},"Kindlustus",{"v":1040,"d":"1,040 €"}]
[{"$nulls":3},"Kommunaalid",{"v":1320,"d":"1,320 €"}]
[{"$nulls":3},"Üür",{"v":2400,"d":"2,400 €"}]
[{"$nulls":3},"Suvi",{"v":3473,"d":"3,473 €"}]
[{"$nulls":3},"Ema",{"v":3473,"d":"3,473 €"}]
[{"$nulls":3},"Kindlustus",{"v":1080,"d":"1,080 €"}]
[{"$nulls":3},"Kommunaalid",{"v":1133,"d":"1,133 €"}]
[{"$nulls":3},"Üür",{"v":1260,"d":"1,260 €"}]
[{"$nulls":3},"Sügis",{"v":5425,"d":"5,425 €"}]
[{"$nulls":3},"Ema",{"v":5425,"d":"5,425 €"}]
[{"$nulls":3},"Kindlustus",{"v":1272,"d":"1,272 €"}]
[{"$nulls":3},"Kommunaalid",{"v":933,"d":"933 €"}]
[{"$nulls":3},"Üür",{"v":3220,"d":"3,220 €"}]
[{"$nulls":3},"Talv",{"v":4100,"d":"4,100 €"}]
[{"$nulls":3},"Isa",{"v":4100,"d":"4,100 €"}]
[{"$nulls":3},"Kindlustus",{"v":1030,"d":"1,030 €"}]
[{"$nulls":3},"Kommunaalid",{"v":1650,"d":"1,650 €"}]
[{"$nulls":3},"Üür",{"v":1420,"d":"1,420 €"}]
[{"$nulls":3},"Grand Total",{"v":17758,"d":"17,758 €"}]
{"$rows_empty":68}
[null,"Ostja","Aastaaeg","Tüüp","Summa"]
[null,"Isa","Talv","Kindlustus",{"v":300,"d":"300 €"}]
[null,"Isa","Talv","Üür",{"v":200,"d":"200 €"}]
[null,"Isa","Talv","Kommunaalid",{"v":400,"d":"400 €"}]
[null,"Isa","Talv","Kindlustus",{"v":300,"d":"300 €"}]
[null,"Isa","Talv","Üür",{"v":800,"d":"800 €"}]
[null,"Isa","Talv","Kommunaalid",{"v":400,"d":"400 €"}]
[null,"Isa","Talv","Kindlustus",{"v":200,"d":"200 €"}]
[null,"Isa","Talv","Üür",{"v":300,"d":"300 €"}]
[null,"Isa","Talv","Kommunaalid",{"v":450,"d":"450 €"}]
[null,"Isa","Talv","Kindlustus",{"v":230,"d":"230 €"}]
[null,"Isa","Talv","Üür",{"v":120,"d":"120 €"}]
[null,"Isa","Talv","Kommunaalid",{"v":400,"d":"400 €"}]
[null,"Isa","Kevad","Kindlustus",{"v":210,"d":"210 €"}]
[null,"Isa","Kevad","Üür",{"v":300,"d":"300 €"}]
[null,"Isa","Kevad","Kommunaalid",{"v":400,"d":"400 €"}]
[null,"Isa","Kevad","Kindlustus",{"v":230,"d":"230 €"}]
[null,"Isa","Kevad","Üür",{"v":900,"d":"900 €"}]
[null,"Isa","Kevad","Kommunaalid",{"v":300,"d":"300 €"}]
[null,"Isa","Kevad","Kindlustus",{"v":200,"d":"200 €"}]
[null,"Isa","Kevad","Üür",{"v":1000,"d":"1,000 €"}]
[null,"Isa","Kevad","Kommunaalid",{"v":220,"d":"220 €"}]
[null,"Isa","Kevad","Kindlustus",{"v":400,"d":"400 €"}]
[null,"Isa","Kevad","Üür",{"v":200,"d":"200 €"}]
[null,"Isa","Kevad","Kommunaalid",{"v":400,"d":"400 €"}]
[null,"Ema","Suvi","Kindlustus",{"v":100,"d":"100 €"}]
[null,"Ema","Suvi","Üür",{"v":30,"d":"30 €"}]
[null,"Ema","Suvi","Kommunaalid",{"v":123,"d":"123 €"}]
[null,"Ema","Suvi","Kindlustus",{"v":300,"d":"300 €"}]
[null,"Ema","Suvi","Üür",{"v":350,"d":"350 €"}]
[null,"Ema","Suvi","Kommunaalid",{"v":230,"d":"230 €"}]
[null,"Ema","Suvi","Kindlustus",{"v":120,"d":"120 €"}]
[null,"Ema","Suvi","Üür",{"v":640,"d":"640 €"}]
[null,"Ema","Suvi","Kommunaalid",{"v":530,"d":"530 €"}]
[null,"Ema","Suvi","Kindlustus",{"v":560,"d":"560 €"}]
[null,"Ema","Suvi","Üür",{"v":240,"d":"240 €"}]
[null,"Ema","Suvi","Kommunaalid",{"v":250,"d":"250 €"}]
[null,"Ema","Sügis","Kindlustus",{"v":62,"d":"62 €"}]
[null,"Ema","Sügis","Üür",{"v":600,"d":"600 €"}]
[null,"Ema","Sügis","Kommunaalid",{"v":340,"d":"340 €"}]
[null,"Ema","Sügis","Kindlustus",{"v":205,"d":"205 €"}]
[null,"Ema","Sügis","Üür",{"v":500,"d":"500 €"}]
[null,"Ema","Sügis","Kommunaalid",{"v":403,"d":"403 €"}]
[null,"Ema","Sügis","Kindlustus",{"v":503,"d":"503 €"}]
[null,"Ema","Sügis","Üür",{"v":2000,"d":"2,000 €"}]
[null,"Ema","Sügis","Kommunaalid",{"v":140,"d":"140 €"}]
[null,"Ema","Sügis","Kindlustus",{"v":502,"d":"502 €"}]
[null,"Ema","Sügis","Üür",{"v":120,"d":"120 €"}]
[null,"Ema","Sügis","Kommunaalid",{"v":50,"d":"50 €"}]

{"sheet":"19","index":19,"n_rows":55,"n_cols":5,"rows_kept":55}
["Kas olete valmis uuteks harjutusteks? Vaadake läbi allpool lahtrivahemikus B7 kuni E55 asuvad andmed. Kui olete valmis, minge järgmisele lehele ja asuge seni õpitut ise järele proovima. "]
["Kõiki andmeridu pole vaja läbi vaadata. Vaadake läbi rea 7 väljanimed. Nendega asutegi järgmisel lehel tööle. "]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[]
[null,"Aastaaeg","Müügiesindaja","Toode","Müüdud ühikud"]
[null,"Talv","Kristiina","Apelsinid",300]
[null,"Talv","Georg","Greibid",200]
[null,"Talv","Oliver","Õunad",400]
[null,"Talv","Kristiina","Banaanid",300]
[null,"Talv","Georg","Apelsinid",800]
[null,"Talv","Oliver","Greibid",400]
[null,"Talv","Kristiina","Õunad",200]
[null,"Talv","Georg","Banaanid",300]
[null,"Talv","Oliver","Apelsinid",450]
[null,"Talv","Kristiina","Greibid",230]
[null,"Talv","Georg","Õunad",120]
[null,"Talv","Oliver","Banaanid",400]
[null,"Kevad","Kristiina","Peet",210]
[null,"Kevad","Georg","Kartulid",300]
[null,"Kevad","Oliver","Lehtsalat",400]
[null,"Kevad","Kristiina","Redised",230]
[null,"Kevad","Georg","Peet",900]
[null,"Kevad","Oliver","Kartulid",300]
[null,"Kevad","Kristiina","Lehtsalat",200]
[null,"Kevad","Georg","Redised",{"v":1000,"d":"1,000"}]
[null,"Kevad","Oliver","Peet",220]
[null,"Kevad","Kristiina","Kartulid",400]
[null,"Kevad","Georg","Lehtsalat",200]
[null,"Kevad","Oliver","Redised",400]
[null,"Suvi","Kristiina","Mustikad",100]
[null,"Suvi","Georg","Maasikad",30]
[null,"Suvi","Oliver","Greip",123]
[null,"Suvi","Kristiina","Kõrvitsad",300]
[null,"Suvi","Georg","Mustikad",350]
[null,"Suvi","Oliver","Maasikad",230]
[null,"Suvi","Kristiina","Greip",120]
[null,"Suvi","Georg","Kõrvitsad",640]
[null,"Suvi","Oliver","Mustikad",530]
[null,"Suvi","Kristiina","Maasikad",560]
[null,"Suvi","Georg","Greip",240]
[null,"Suvi","Oliver","Kõrvitsad",250]
[null,"Sügis","Kristiina","Pudelkõrvits",62]
[null,"Sügis","Georg","Suvikõrvits",600]
[null,"Sügis","Oliver","Õunad",340]
[null,"Sügis","Kristiina","Apelsinid",205]
[null,"Sügis","Georg","Pudelkõrvits",500]
[null,"Sügis","Oliver","Suvikõrvits",403]
[null,"Sügis","Kristiina","Õunad",503]
[null,"Sügis","Georg","Apelsinid",{"v":2000,"d":"2,000"}]
[null,"Sügis","Oliver","Pudelkõrvits",140]
[null,"Sügis","Kristiina","Suvikõrvits",502]
[null,"Sügis","Georg","Õunad",120]
[null,"Sügis","Oliver","Apelsinid",50]

{"sheet":"20","index":20,"n_rows":17,"n_cols":11,"rows_kept":17}
["1. PivotTable-liigendtabeli ala on selles näites lahtrivahemikus B12 kuni C17. Liikuge mõnda nendest lahtritest. \n\n"]
["2. Vajutage PivotTable-liigendtabeli väljad avamiseks klahve ALT + JS ja seejärel klahve L ja 2. Fookuse vaikevalikuks on tekstiväli „Otsi“. Redigeeritav väli „Tippige otsitavad sõnad“. Ärge tippige midagi, vaid vajutage ühe korra tabeldusklahvi (TAB). MÄRKUS. Kui väljaloendit ei kuvata, vajutage uuesti klahve ALT+JS, L2."]
["3. Vajutage väljale „Müügiesindaja“ liikumiseks nooleklahve. Vajutage välja „Müügiesindaja“ lisamiseks reaalale tühikuklahvi. Kui soovite müügiesindaja üksikasjad veerualas kuvada, liikuge tabeldusklahviga reaala müügiesindaja väljale, vajutage siis tühikuklahvi ja valige „Teisalda veerusiltide hulka“. Vajutage paani „PivotTable-liigendtabeli väljad“ sulgemiseks paoklahvi (ESC). "]
["4. Tehke kindlaks, kes müüs sügisel kõige rohkem kaupa. Seejärel tehke valik lahtris K8. "]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[{"$nulls":10},"Valige üks:"]
[]
[{"$nulls":10},{"$f":"IF($K$8=\"Georg\",\"Teil on õigus!\",IF($K$8=\"Oliver\",\"Proovige uuesti...\",IF($K$8=\"Kristiina\",\"Mitte päris nii...\",IF($K$8=\" \",\" \",\" \"))))","v":" "}]
[]
[]
[null,"Row Labels","Summa kogusummast Müüdud ühikud"]
[null,"Kevad",{"v":4760,"d":"4,760"}]
[null,"Suvi",{"v":3473,"d":"3,473"}]
[null,"Sügis",{"v":5425,"d":"5,425"}]
[null,"Talv",{"v":4100,"d":"4,100"}]
[null,"Grand Total",{"v":17758,"d":"17,758"}]

{"sheet":"21","index":21,"n_rows":14,"n_cols":10,"rows_kept":14}
["1. Klõpsake lahtrit B13, et aktiveerida PivotTable-liigendtabel nimega „Summa kogusummast Müüdud ühiku“.\n\n"]
["2. Vajutage PivotTable-liigendtabeli väljad avamiseks klahve ALT + JS ja seejärel klahve L ja 2. Fookuse vaikevalikuks on tekstiväli „Otsi“. Redigeeritav väli „Tippige otsitavad sõnad“. Ärge tippige midagi, vaid vajutage ühe korra tabeldusklahvi (TAB). MÄRKUS. Kui väljaloendit ei kuvata, vajutage uuesti klahve ALT+JS, L2."]
["3. Laiendage näide nooleklahvide ja tühikuklahvi abil vertikaalseks PivotTable-liigendtabeliks, kus aastaaeg on vasakul ja müügiesindajad taandatuna aastaaeg all. PivotTable-liigendtabeli väljadpaanilt väljumiseks vajutage paoklahvi ESC. "]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"Kevad\",$C$17=1320),\"Tubli töö! Olete kohale paigutanud\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"Kevad\",$C$17=1320),\"teisese reavälja. Liikuge nüüd kerides\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"Kevad\",$C$17=1320),\"allapoole ja klõpsake nuppu Edasi.\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,"Summa kogusummast Müüdud ühikud"]
[null,{"v":17758,"d":"17,758"}]

{"sheet":"22","index":22,"n_rows":14,"n_cols":10,"rows_kept":14}
["1. Klõpsake lahtrit B13, et aktiveerida PivotTable-liigendtabel nimega „Summa kogusummast Müüdud ühiku“."]
["2. Vajutage PivotTable-liigendtabeli väljad avamiseks klahve ALT + JS ja seejärel klahve L ja 2. Fookuse vaikevalikuks on tekstiväli „Otsi“. Redigeeritav väli „Tippige otsitavad sõnad“. Ärge tippige midagi, vaid vajutage ühe korra tabeldusklahvi (TAB). MÄRKUS. Kui väljaloendit ei kuvata, vajutage uuesti klahve ALT+JS, L2."]
["3. Muutke näidet nooleklahvide ja tühikuklahvi abil nii, et iga toode kuvataks omaette real ja iga aastaaeg omaette veerus."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP.",{"$nulls":8},{"$f":"IF(AND($B$15=\"Apelsinid\",$G$28=1683),\"Tubli töö! Paigutasite\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Apelsinid\",$G$28=1683),\"vasakule reavälja ja lisasite\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Apelsinid\",$G$28=1683),\"nelja uue veeruga veeruvälja.\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Apelsinid\",$G$28=1683),\"Liikuge kerides allapoole \",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Apelsinid\",$G$28=1683),\"ja klõpsake nuppu Edasi...\",\" \")","v":" "}]
[]
[]
[]
[]
[null,"Summa kogusummast Müüdud ühikud"]
[null,{"v":17758,"d":"17,758"}]

{"sheet":"23","index":23,"n_rows":16,"n_cols":18,"rows_kept":16}
["1. Klõpsake lahtrit B13, et aktiveerida PivotTable-liigendtabel nimega „Summa kogusummast Müüdud ühiku“.\n\n"]
["2. Vajutage PivotTable-liigendtabeli väljad avamiseks klahve ALT + JS ja seejärel klahve L ja 2. Fookuse vaikevalikuks on tekstiväli „Otsi“. Redigeeritav väli „Tippige otsitavad sõnad“. Ärge tippige midagi, vaid vajutage ühe korra tabeldusklahvi (TAB). MÄRKUS. Kui väljaloendit ei kuvata, vajutage uuesti klahve ALT+JS, L2."]
["3. Muutke näidet tabeldusklahvi, nooleklahvide ja tühikuklahvi abil nii, et müügiesindajad kuvataks vasakul ja aastaajad taandatuna nende all."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"Oliver\",$C$14=5036),\"Tubli töö! Andmeid on nüüd\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"Oliver\",$C$14=5036),\"lihtsam lugeda. Liikuge kerides\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"Oliver\",$C$14=5036),\"allapoole ja klõpsake nuppu Edasi...\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,null,"Column Labels"]
[null,null,"Oliver",{"$nulls":3},"Oliver Total","Georg",{"$nulls":3},"Georg Total","Kristiina",{"$nulls":3},"Kristiina Total","Grand Total"]
[null,null,"Sügis","Kevad","Suvi","Talv",null,"Sügis","Kevad","Suvi","Talv",null,"Sügis","Kevad","Suvi","Talv"]
[null,"Summa kogusummast Müüdud ühikud",933,{"v":1320,"d":"1,320"},{"v":1133,"d":"1,133"},{"v":1650,"d":"1,650"},{"v":5036,"d":"5,036"},{"v":3220,"d":"3,220"},{"v":2400,"d":"2,400"},{"v":1260,"d":"1,260"},{"v":1420,"d":"1,420"},{"v":8300,"d":"8,300"},{"v":1272,"d":"1,272"},{"v":1040,"d":"1,040"},{"v":1080,"d":"1,080"},{"v":1030,"d":"1,030"},{"v":4422,"d":"4,422"},{"v":17758,"d":"17,758"}]

{"sheet":"24","index":24,"n_rows":14,"n_cols":9,"rows_kept":14}
["1. Klõpsake lahtrit B13, et aktiveerida PivotTable-liigendtabel nimega „Summa kogusummast Müüdud ühikud“."]
["2. Vajutage PivotTable-liigendtabeli väljad avamiseks klahve ALT + JS ja seejärel klahve L ja 2. Fookuse vaikevalikuks on tekstiväli „Otsi“. Redigeeritav väli „Tippige otsitavad sõnad“. Ärge tippige midagi, vaid vajutage ühe korra tabeldusklahvi (TAB). MÄRKUS. Kui väljaloendit ei kuvata, vajutage uuesti klahve ALT+JS, L2."]
["3. Muutke näidet tabeldusklahvi, nooleklahvide ja tühikuklahvi abil nii, et igal müügiesindajal oleks oma veeruväljad, kus aastaajad on vasakul ja tooted taandatuna nende all."]
["4. Valige lahter I9. Seejärel valige, mitu greipi Oliver talvel müüs."]
["Õpetusega jätkamiseks vajutage klahvikombinatsiooni CTRL + PAGE DOWN. Eelmisele lehele liikumiseks vajutage klahvikombinatsiooni CTRL + PAGE UP."]
[]
[]
[{"$nulls":8},"Valige üks:"]
[]
[{"$nulls":8},{"$f":"IF($I$9=400,\"Teil on õigus!\",IF($I$9=530,\"Proovige uuesti...\",IF($I$9=123,\"Mitte päris nii...\",\" \")))","v":" "}]
[]
[]
[null,"Summa kogusummast Müüdud ühikud"]
[null,{"v":17758,"d":"17,758"}]

{"sheet":"Lisateave","index":25,"n_rows":8,"n_cols":1,"rows_kept":8}
["Tubli töö! PivotTable-liigendtabelid on lahedad, kas pole?"]
["Katsetage kindlasti edasi. Avastamist jätkub veel küllaga."]
["Liigendtabeli lisateave\nLugege artiklit, mis sisaldab kasulikku lisateavet PivotTable-liigendtabeli funktsioonide kohta."]
["Värskendamine\nSellest artiklist leiate olulist teavet PivotTable-liigendtabelite värskendamise kohta. "]
["Meie tegevus\nVõtke ühendust teiste Exceli fännidega. Te saate üksteist aidata."]
[]
[]
[" "]