{"id":238,"date":"2016-04-25T23:37:36","date_gmt":"2016-04-25T20:37:36","guid":{"rendered":"http:\/\/helia.ee\/koolitus\/?page_id=238"},"modified":"2016-05-02T14:05:18","modified_gmt":"2016-05-02T11:05:18","slug":"microsoft-excel-2016-salvestamine-ja-printimine","status":"publish","type":"page","link":"https:\/\/helia.ee\/koolitus\/?page_id=238","title":{"rendered":"Microsoft Excel 2016 &#8211; Salvestamine ja Printimine"},"content":{"rendered":"<p>Kui t\u00f6\u00f6 on valmis, siis oleks vaja Exceli dokument salvestada v\u00f5i hoopis v\u00e4ljaprintida. Antud peat\u00fckis vaatame kuidas lihtsalt salvestada dokument oma arvutisse. Jah, Excel 2016 v\u00f5imaldab salvestada erinevatesse pilveteenusega seotud veebirakendustesse ning neid jagada, kuid nendes j\u00e4llegi edaspidi, kui Excel natuke rohkem selge on. Ja siin p\u00f6\u00f6rame suuremat t\u00e4helepanu ka printimisele.<\/p>\n<p><strong>Salvestamine<\/strong><\/p>\n<p>Oma t\u00f6\u00f6 uuesti kasutamiseks v\u00f5i kellelegi jagamiseks on see vaja kindlasti salvestada. Ja mitte lihtsalt salvestada vaid\u00a0<strong>\u00f5igesse kohta ja \u00f5ige nimega!\u00a0<\/strong>T\u00f6\u00f6le \u00f5ige nime andmine lihtsustab hiljem endal v\u00f5i teie kaast\u00f6\u00f6tajatel fail kiiresti \u00fcles leida.\u00a0Faili salvestamisel pea meeles, et faili nimi ei \u00fcletaks 255 t\u00e4hem\u00e4rki \ud83d\ude42 ja ei kasutaks eris\u00fcmboleid nagu \/ \\ &lt; &gt; * ? &#8221; | : jne<\/p>\n<p>T\u00f6\u00f6 salvestamiseks liigu men\u00fc\u00fcs\u00a0<strong>Fail,<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-284\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel1-1.jpg\" alt=\"excel1\" width=\"234\" height=\"180\" \/><\/strong><br \/>\nmille alt leiad kaks k\u00e4sku:<\/p>\n<ul>\n<li>Salvesta<\/li>\n<li>Salvesta nimega<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-285\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel2-1.jpg\" alt=\"excel2\" width=\"122\" height=\"100\" \/><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Esimest korda salvestamisel pole vahet, kumma valid. Kuid hiljem, kui soovid aktiivset faili salvestada siis vali\u00a0<strong>Salvesta<\/strong>\u00a0v\u00f5i vajuta kiiresti klaviatuuril\u00a0<strong>Ctrl+S<\/strong>. Juhul, kui soovid aktiivset faili salvestada uue nimega, vali\u00a0<strong>Salvesta nimega<\/strong>\u00a0(F12) ning avaneb salvestamise aken, kus saad valida salvestuskoha.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-286\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel3-1.jpg\" alt=\"excel3\" width=\"607\" height=\"508\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel3-1.jpg 607w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel3-1-300x251.jpg 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/p>\n<p>ning peale salvestuskoha valikut saad lisada failile uue nime.<\/p>\n<p>Vaikimisi pakutakse Excel 2013 faililaiendiks\u00a0<strong>xlsx<\/strong>.<\/p>\n<p><strong>Salvestamine parooliga<\/strong><\/p>\n<p>Microsoft Excel 2016 v\u00f5imaldab salvestamisel kaitsta oma t\u00f6\u00f6d parooliga. Aga kui tulevikus hakkad oma dokumente parooliga kaitsma, siis m\u00f5tle, kas on ikka vaja. Miks? Reeglina ei suudeta palju erinevaid paroole meelde j\u00e4tta ning seep\u00e4rast kahjuks kasutatakse samu paroole igal pool ja\/v\u00f5i kirjutavad need kuhugi \u00fcles. Aga kui oled otsustanud dokumenti parooliga kaitsta, siis pea meeles:<\/p>\n<ul>\n<li>parool on t\u00f5stutundlik, st. et suurtel ja v\u00e4ikestel t\u00e4htedel tehakse vahet<\/li>\n<li>parooli maksimumpikkus on 15 t\u00e4hem\u00e4rki<\/li>\n<li>\u00e4ra unusta parooli, sest muidu ei saa dokumenti avada<\/li>\n<li>\u00e4ra kasuta eris\u00fcmboleid\u00a0\/ \\ &lt; &gt; * ? &#8221; | : jne<\/li>\n<li>parooli v\u00f5ib dokumendi avamisel sisestada mitu korda, ilma et dokument blokeeritaks<\/li>\n<\/ul>\n<p>Parooliga salvestamiseks vali \u00a0<strong>Fail <\/strong>men\u00fc\u00fc, j\u00e4rgnevalt <strong>Salvesta nimega, <\/strong>j\u00e4rgnevalt vali koht kuhu salvestada. Avanenud aknas &#8216;<strong>Salvesta<\/strong>&#8216; nupu k\u00f5rval on valik\u00a0<strong>T\u00f6\u00f6riistad, <\/strong>sellele klikkides on men\u00fc\u00fcs kolmas k\u00e4sk <strong>\u00dcldsuvandid<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-288\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel4-1.jpg\" alt=\"excel4\" width=\"601\" height=\"410\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel4-1.jpg 601w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel4-1-300x205.jpg 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><br \/>\n<\/strong><\/p>\n<p>Seej\u00e4rel avatakse <strong>\u00dcldsuvandite aken<\/strong>, kuhu saame lisada:<\/p>\n<ul>\n<li><strong>Avamisparool<\/strong>&#8211; lisades selle parooli, ei n\u00e4e keegi faili sisu enne kui parool on \u00f5ige. Kui soovid, et kasutaja n\u00e4eks dokumenti aga muuta ei saa, siis j\u00e4ta see v\u00e4li t\u00fchjaks.<\/li>\n<li><strong>Muutmisparool<\/strong>&#8211; lisades parooli siia, siis kaitseme dokumenti muudatuste eest. Kui kasutaja on sisestanud avamisparooli ja muutmisparooli ei tea, siis ta n\u00e4eb ainult dokumendi sisu aga midagi muuta ei saa.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel5-1.jpg\" alt=\"excel5\" width=\"315\" height=\"183\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel5-1.jpg 315w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel5-1-300x174.jpg 300w\" sizes=\"auto, (max-width: 315px) 100vw, 315px\" \/><\/li>\n<\/ul>\n<p>Olles lisanud parooli(d), k\u00fcsitakse kinnitust, et v\u00e4ltida vigu paroolis.<\/p>\n<p>&nbsp;<\/p>\n<p>N\u00fc\u00fcd kui dokument uuesti avada, siis k\u00fcsitakse parooli et dokument avada.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-290\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel6-1.jpg\" alt=\"excel6\" width=\"255\" height=\"129\" \/><\/p>\n<p>Kui te lisasite ka muutmisparooli siis k\u00fcsitakse n\u00fc\u00fcd ka selle sisestamist<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-291\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel7-1.jpg\" alt=\"excel7\" width=\"322\" height=\"163\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel7-1.jpg 322w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel7-1-300x152.jpg 300w\" sizes=\"auto, (max-width: 322px) 100vw, 322px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Salvestamine teistesse formaatidesse<\/strong><\/p>\n<p>Tihti on juhtumeid, kus dokument tuleks salvestada vanemasse\u00a0<strong>xls\u00a0<\/strong>(Excel 97-2003) v\u00f5i\u00a0<strong>pdf\u00a0<\/strong>versiooni. V\u00f5i koguni\u00a0<strong>veebilehena (html)<\/strong>! Iseenesest on see sama lihtne kui lihtsalt salvestamine. Ava men\u00fc\u00fc\u00a0<strong>Fail, <\/strong>seal vali<strong> Salvesta nimega<\/strong>\u00a0ning avanenud aknas vali salvestuskoht. Ja j\u00e4lgi \u00a0<strong>Salvestust\u00fc\u00fcp<\/strong>\u00a0valikut.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-292\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel8-1.jpg\" alt=\"excel8\" width=\"609\" height=\"327\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel8-1.jpg 609w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel8-1-300x161.jpg 300w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><br \/>\nVahel, kui kasutad m\u00f5nda dokumenti ikka ja j\u00e4lle, siis on see otstarbekas\u00a0<strong>salvestada mallina<\/strong>. N\u00e4iteks pead koostama arveid, mille p\u00f5hi on kogu aeg sama. Sel juhul vali salvestust\u00fc\u00fcbiks\u00a0<strong>Exceli mall (*.xltx).<\/strong>\u00a0V\u00e4ga kasulik on see siis, kui faili kasutavad erinevad inimesed ning algfaili ei &#8220;rikuta&#8221; \u00e4ra. Seda sellep\u00e4rast, et mallina salvestatud failist tehakse alati uus fail.<\/p>\n<p><strong>Printimine<\/strong><\/p>\n<p>Printimine on nagu salvestamine, aga seda just paberile v\u00f5i n\u00e4iteks kilele. Vaatame kuidas printida, millised on printimise seaded ning kus asuvad kasutaja jaoks peidus olevad p\u00e4is ja jalus.<\/p>\n<p>Printimiseks vali men\u00fc\u00fcst\u00a0<strong>Fail <\/strong>ja sealt k\u00e4sk<strong> Prindi.<\/strong>\u00a0See avab printimise akna, kus keskel asuvad k\u00f5ik printimisega seotud seaded ja paremal n\u00e4ete kohe\u00a0<strong>eelvaadet<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-294\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel9.jpg\" alt=\"excel9\" width=\"426\" height=\"484\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel9.jpg 426w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel9-264x300.jpg 264w\" sizes=\"auto, (max-width: 426px) 100vw, 426px\" \/><\/p>\n<p>Kui oled valmis oma dokumenti printima, siis vali <strong>\u00f5ige printer<\/strong> ja kliki nupul\u00a0<strong>Prindi<\/strong>. Kui vaja mitu eksemplari printida vali prinditavate dokumentide arv.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-295\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel10.jpg\" alt=\"excel10\" width=\"501\" height=\"247\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel10.jpg 501w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel10-300x148.jpg 300w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/><\/p>\n<p><strong>Selekteeritud ala printimine<\/strong><\/p>\n<p>Teatud osa dokumendis printimiseks tuleb sul esmalt soovitud osa hiirega \u00e4ra selekteerida.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-296\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel11.jpg\" alt=\"excel11\" width=\"537\" height=\"135\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel11.jpg 537w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel11-300x75.jpg 300w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/><\/p>\n<p>Seej\u00e4rel vali men\u00fc\u00fcst\u00a0<strong>Fail, valik Prindi<\/strong>\u00a0ning\u00a0<strong>S\u00e4tete alt &gt;Prindi valik<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-297\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel12.jpg\" alt=\"excel12\" width=\"356\" height=\"208\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel12.jpg 356w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel12-300x175.jpg 300w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><br \/>\n<\/strong><\/p>\n<p><strong>Excel 2016 <\/strong>on veel \u00fcks hea ja kasulik asi, vajutades men\u00fc\u00fcle<strong> Fail <\/strong>ja valides sealt<strong> Ekspordi, <\/strong>avaneb teile allj\u00e4rgnev men\u00fc\u00fc<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-298\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel13.jpg\" alt=\"excel13\" width=\"547\" height=\"239\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel13.jpg 547w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel13-300x131.jpg 300w\" sizes=\"auto, (max-width: 547px) 100vw, 547px\" \/><\/p>\n<p>Vajutades <strong>Loo PDF\/XPS<\/strong> nupule saate luua otse olemas olevast failist PDF dokumendi, teil k\u00fcsitakse kuhu pdf dokument salvestada ning v\u00f5ite ka faili nime muuta.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-299\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel14.jpg\" alt=\"excel14\" width=\"443\" height=\"395\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel14.jpg 443w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel14-300x267.jpg 300w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/p>\n<p><strong>Printimisega seotud<\/strong><\/p>\n<p>Veel seadeid printimiseks asuvad Printimise paneeli alumises servas\u00a0<strong>Lehek\u00fclje h\u00e4\u00e4lestus<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-300\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel15.jpg\" alt=\"excel15\" width=\"543\" height=\"110\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel15.jpg 543w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel15-300x61.jpg 300w\" sizes=\"auto, (max-width: 543px) 100vw, 543px\" \/><br \/>\n<\/strong><\/p>\n<p>See avab vastava akna, kus saate m\u00e4\u00e4rata:<\/p>\n<ul>\n<li>lehek\u00fclje omadused<\/li>\n<li>veeriste suurused (t\u00fchi ala paberi servast sisuni)<\/li>\n<li>p\u00e4ise ja jaluse sisu<\/li>\n<li>t\u00f6\u00f6lehe printimise seaded<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-301\" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel16.jpg\" alt=\"excel16\" width=\"424\" height=\"417\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel16.jpg 424w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/04\/excel16-300x295.jpg 300w\" sizes=\"auto, (max-width: 424px) 100vw, 424px\" \/><\/li>\n<\/ul>\n<p>Antud teema on tihedalt seotud Exceli lehek\u00fclje seadetega ja seep\u00e4rast kavatsen sellest t\u00e4psemalt r\u00e4\u00e4kida vastavas teemas. Seni edukat iseseisvalt uurimist.<\/p>\n<p><a href=\"http:\/\/helia.ee\/koolitus\/dokumendid\/Excel2016_5_Salvestamine_ja_Printimine.pdf\">Allalaaditav PDF<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kui t\u00f6\u00f6 on valmis, siis oleks vaja Exceli dokument salvestada v\u00f5i hoopis v\u00e4ljaprintida. Antud peat\u00fckis vaatame kuidas lihtsalt salvestada dokument oma arvutisse. Jah, Excel 2016 v\u00f5imaldab salvestada erinevatesse pilveteenusega seotud veebirakendustesse ning neid jagada, kuid nendes j\u00e4llegi edaspidi, kui Excel natuke rohkem selge on. Ja siin p\u00f6\u00f6rame suuremat t\u00e4helepanu ka printimisele. Salvestamine Oma t\u00f6\u00f6 uuesti [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":177,"menu_order":2,"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-238","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/238","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=238"}],"version-history":[{"count":9,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/238\/revisions"}],"predecessor-version":[{"id":303,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/238\/revisions\/303"}],"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=238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}