{"id":251,"date":"2016-04-26T09:15:17","date_gmt":"2016-04-26T06:15:17","guid":{"rendered":"http:\/\/helia.ee\/koolitus\/?page_id=251"},"modified":"2016-05-03T10:25:36","modified_gmt":"2016-05-03T07:25:36","slug":"microsoft-excel-2016-loendite-koostamine","status":"publish","type":"page","link":"https:\/\/helia.ee\/koolitus\/?page_id=251","title":{"rendered":"Microsoft Excel 2016 &#8211; Loendite koostamine (HARJUTUS 2)"},"content":{"rendered":"<p>Excel 2016 v\u00f5imaldab erinevaid v\u00f5imalusi lahtrite kiireks ja automaatseks t\u00e4itmiseks, et hoida kokku aega ja v\u00e4hendada eksimusi.<\/p>\n<p><strong>Andmete kopeerimine<\/strong><\/p>\n<p>Lahtrite automaatseks t\u00e4itmiseks kasutame aktiivse lahtri all paremas nurgas olevat\u00a0<strong>t\u00e4itepidet<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-311\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel19.jpg\" alt=\"excel19\" width=\"196\" height=\"50\" \/><\/p>\n<p>Lihtsalt andmete kopeerimiseks mitmesse lahtrisse lisa tekst ja haara hiirega lahtri <strong>t\u00e4itepidamisest<\/strong> ja lohista alla.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-312\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel20.jpg\" alt=\"excel20\" width=\"233\" height=\"155\" \/><\/p>\n<p>Kopeerida on v\u00f5imalik nii \u00fclevalt alla kui alt \u00fcles ning vasakult paremale ja paremalt vasakule.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-313\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel21.jpg\" alt=\"excel21\" width=\"330\" height=\"111\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel21.jpg 330w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel21-300x101.jpg 300w\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" \/><\/p>\n<p><strong>Tekstiloend<\/strong><\/p>\n<p>Juhul kui oled \u00e4ra sisestanud n\u00e4iteks kolm nime, selekteerid need nimed ning <strong>lohistad t\u00e4itepidemest,<\/strong> siis andmeid korratakse esimese loendi j\u00e4rgi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-314\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel22.jpg\" alt=\"excel22\" width=\"270\" height=\"163\" \/><\/p>\n<p>See on v\u00e4ga hea v\u00f5imalus koostada n\u00e4iteks t\u00f6\u00f6 vms graafikuid.<\/p>\n<p><strong>Numbriloend<\/strong><\/p>\n<p>T\u00f5eliselt mugav on aga Excelis koostada numberloendeid. Ja tegelikult kasutatakse neid \u00fcpris tihti. Numbriloendi koostamiseks on oluline j\u00e4rjekord:<\/p>\n<ol>\n<li>lisa\u00a0<strong>esimene number<\/strong>millest soovid alustada<\/li>\n<li>lisa loendi\u00a0<strong>j\u00e4rgmine number<\/strong>&#8211; see on oluline, sest see n\u00e4itab mitme kaupa numbrid suurenevad<\/li>\n<li><strong>selekteeri\u00a0<\/strong>m\u00f5lemad arvud<\/li>\n<li>lohista t\u00e4itepidemest<\/li>\n<\/ol>\n<p>N\u00e4iteks loome loendi 1-&gt;10ni. Selleks paneme kirja arvud 1 ja 2. M\u00e4rgistame arvud ja lohistame pidemest.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-315\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel23.jpg\" alt=\"excel23\" width=\"273\" height=\"191\" \/><\/p>\n<p>Kui soovid\u00a0<strong>loendit j\u00e4tkata<\/strong>, siis m\u00e4rgista kaks viimast arvu ja sikuta samamoodi t\u00e4itepidemest<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-316\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel24.jpg\" alt=\"excel24\" width=\"181\" height=\"265\" \/><\/p>\n<p>Veel numberloenditest:<\/p>\n<ul>\n<li>loendid v\u00f5ivad olla ka kahanevad; n\u00e4iteks 10-&gt;1<\/li>\n<li>loendid v\u00f5ivad olla negatiivsed; n\u00e4iteks -5-&gt;-10<\/li>\n<li>paarisarvude loendi tegemiseks kasuta arve 2 ja 4<\/li>\n<li>m\u00e4rgistades kogu loendi ning lohistades t\u00e4itepidet vastassuunas, saad loendit l\u00fchendada<\/li>\n<\/ul>\n<p><strong>Kuup\u00e4eva ja kellaaja loendid<\/strong><\/p>\n<p>Erinevad kuup\u00e4eva ja kellaaja loendid toimivad samamoodi kui numbrid.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-317\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel25.jpg\" alt=\"excel25\" width=\"163\" height=\"173\" \/><\/p>\n<p>Pisikesed erip\u00e4rad &#8211; n\u00e4iteks sisestades ainult \u00fche kuup\u00e4eva ja lohistades t\u00e4itepidet, suurendatakse j\u00e4rgmist kuup\u00e4eva \u00fche p\u00e4eva v\u00f5rra. Sisestades kellaaja, suurendatakse automaatselt tunde \u00fche v\u00f5rra.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-318\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel26.jpg\" alt=\"excel26\" width=\"256\" height=\"191\" \/><\/p>\n<p><strong>T\u00f6\u00f6p\u00e4evade loend<\/strong><\/p>\n<p>Nagu n\u00e4gite, v\u00f5imaldab Excel luua kiiresti loendeid hiire abil. Julgustan seda ka edaspidi kasutama kuid t\u00e4nu t\u00f6\u00f6p\u00e4evade loendi loomisele, peame vaatame, kus see asub men\u00fc\u00fcst\u00a0<strong>Avaleht, <\/strong>sildi pealt <strong>Redigeerimine, <\/strong>k\u00e4sk<strong> T\u00e4ide<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-319\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel27.jpg\" alt=\"excel27\" width=\"290\" height=\"98\" \/><br \/>\n<\/strong><\/p>\n<p><strong>T\u00f6\u00f6p\u00e4eva loendi<\/strong>\u00a0loomiseks pead kirja panema alustuskuup\u00e4eva. Hoia kuup\u00e4eva lahter aktiivsena ja vali\u00a0<strong>T\u00e4ide&gt;Sari<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-320\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel28.jpg\" alt=\"excel28\" width=\"166\" height=\"225\" \/><\/strong><\/p>\n<p>Avanenud aknas tee j\u00e4rgmised valikud: sari veergudesse, kuup\u00e4ev, n\u00e4dalap\u00e4ev, samm 1 ja viimane kuup\u00e4ev.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-321\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel29.jpg\" alt=\"excel29\" width=\"446\" height=\"250\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel29.jpg 446w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel29-300x168.jpg 300w\" sizes=\"auto, (max-width: 446px) 100vw, 446px\" \/><\/p>\n<p>Vajutades OK, luuake n\u00e4dalap\u00e4evade loend, kust on kenasti v\u00e4lja j\u00e4etud laup\u00e4evad ja p\u00fchap\u00e4evad.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-322\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel30.jpg\" alt=\"excel30\" width=\"81\" height=\"187\" \/><\/p>\n<p><strong><br \/>\n<\/strong><\/p>\n<p><strong>Kohandatud loendid<\/strong><\/p>\n<p>Kohandatud loendid on loendid, mida saab ise luua vastavalt soovile. Kohandatud loendid v\u00f5ib jagada kaheks &#8211;\u00a0<strong>valmis- ja kohandatud loendid<\/strong>.<\/p>\n<p><strong>Valmisloend<\/strong><\/p>\n<p>Valmisloend on juba programmi sisseehitatud ja seda kasutaja muuta ei saa. N\u00e4iteks n\u00e4dalap\u00e4evad v\u00f5i kuude nimetused. Sisestad soovitud v\u00e4\u00e4rtuse ja lohistad t\u00e4itepidet.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-323\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel31.jpg\" alt=\"excel31\" width=\"156\" height=\"265\" \/><\/p>\n<p><strong>Kohandatud loend<\/strong><\/p>\n<p>Kohandatud loendeid saavad kasutajad ise luua. N\u00e4iteks suur, keskmine, v\u00e4ike v\u00f5i JAN, VEB, MAR jne. Kohandatud loendi loomiseks kliki\u00a0<strong>Fail&gt;Suvandid<\/strong>. Avanenud aknas vali\u00a0<strong>T\u00e4psemalt&gt;Redigeeri kohandatud loendeid&#8230;<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-324\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel32.jpg\" alt=\"excel32\" width=\"550\" height=\"454\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel32.jpg 550w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel32-300x248.jpg 300w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><br \/>\n<\/strong><\/p>\n<p>Avaneb aken, kus n\u00e4eme valmisloendeid. Uue loendi lisamiseks<\/p>\n<ol>\n<li>vali\u00a0<strong>UUS LOEND<\/strong><\/li>\n<li>lisa soovitud loendikirjed (uue kirje lisamiseks vajuta Enter)<\/li>\n<li>kui loend valmis, kliki\u00a0<strong>Lisa<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-325\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel33.jpg\" alt=\"excel33\" width=\"539\" height=\"356\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel33.jpg 539w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel33-300x198.jpg 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><br \/>\n<\/strong><\/li>\n<\/ol>\n<p>N\u00fc\u00fcd kui Excelis lisada loendist \u00fcks kirje, siis saab t\u00e4itepideme abil lisada kiiresti ka \u00fclej\u00e4\u00e4nud.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-326\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel34.jpg\" alt=\"excel34\" width=\"42\" height=\"223\" \/><\/p>\n<p><strong>NB! Loendid on t\u00f5stutundlikud!<\/strong><\/p>\n<p>Loendi\u00a0<strong>kustutamiseks\u00a0<\/strong>liigu uuesti\u00a0<strong>Fail&gt;Suvandid<\/strong>. Avanenud aknas vali\u00a0<strong>T\u00e4psemalt&gt;Redigeeri kohandatud loendeid&#8230;<\/strong>\u00a0Avanenud aknas vali soovitud loend ja kliki\u00a0<strong>Kustuta.<\/strong><\/p>\n<p><a href=\"http:\/\/helia.ee\/koolitus\/dokumendid\/Harjutus_2_loendid.pdf\">Harjutus 2<\/a><\/p>\n<p><a href=\"http:\/\/helia.ee\/koolitus\/dokumendid\/Excel2016_9_loendid.pdf\">Allalaaditav PDF<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel 2016 v\u00f5imaldab erinevaid v\u00f5imalusi lahtrite kiireks ja automaatseks t\u00e4itmiseks, et hoida kokku aega ja v\u00e4hendada eksimusi. Andmete kopeerimine Lahtrite automaatseks t\u00e4itmiseks kasutame aktiivse lahtri all paremas nurgas olevat\u00a0t\u00e4itepidet. Lihtsalt andmete kopeerimiseks mitmesse lahtrisse lisa tekst ja haara hiirega lahtri t\u00e4itepidamisest ja lohista alla. Kopeerida on v\u00f5imalik nii \u00fclevalt alla kui alt \u00fcles ning vasakult [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":177,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-251","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=251"}],"version-history":[{"count":4,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/251\/revisions"}],"predecessor-version":[{"id":327,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/251\/revisions\/327"}],"up":[{"embeddable":true,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/177"}],"wp:attachment":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}