{"id":3369,"date":"2022-07-05T20:22:03","date_gmt":"2022-07-05T20:22:03","guid":{"rendered":"https:\/\/infinitcenter.com\/en\/?page_id=3369"},"modified":"2022-09-12T13:44:36","modified_gmt":"2022-09-12T13:44:36","slug":"microsoft-excel-basic","status":"publish","type":"page","link":"https:\/\/infinitcenter.com\/en\/microsoft-excel-basic\/","title":{"rendered":"Microsoft Excel &#8211; Basic"},"content":{"rendered":"<section class=\"wpb-content-wrapper\"><p>[vc_row css=&#8221;.vc_custom_1473328990059{margin-bottom: 50px !important;}&#8221;][vc_column width=&#8221;2\/3&#8243;][stm_title title_tag=&#8221;h2&#8243; title=&#8221;Q\u00ebllimi i trajnimit &amp; P\u00ebrfitimet e nx\u00ebn\u00ebsit&#8221;][\/stm_title][vc_column_text css=&#8221;.vc_custom_1657051934385{margin-bottom: 30px !important;}&#8221;]Q\u00ebllimi kryesor i k\u00ebtij\u00eb kursi \u00ebsht\u00eb q\u00eb kandidat\u00ebt do t\u00eb jen\u00eb n\u00eb gjendje t\u00eb mesojne dhe praktikojne ne nivel bazik programin Excel, pjes\u00ebt p\u00ebrb\u00ebr\u00ebse t\u00eb tij dhe rregullimin e parametrave bazike, t\u00eb menaxhojn\u00eb librin punues, krijimin e fajllit t\u00eb ri dhe ruajtjen e tij, t\u00eb b\u00ebjn\u00eb kalimin nga nj\u00eb dritare n\u00eb tjetr\u00ebn dhe kalkulumin e tabelave me t\u00eb dh\u00ebna bazike, shkruarjen n\u00eb qeliza dhe kopjimin, barjtjen dhe rikthimin e t\u00eb dh\u00ebnave, formatizimin e qelizave. Do t\u00eb jen\u00eb n\u00eb gjendje t\u00eb m\u00ebsojn\u00eb dhe praktikojn\u00eb fshehjen dhe shfaqjen e kolonave dhe rreshtave, do t\u00eb m\u00ebsojn\u00eb shembuj t\u00eb ndrysh\u00ebm duke praktikuar funksionet matematikore, trigonometrike, statistikore, financiare, logjike, dat\u00eb dhe koh\u00eb, tekstuale dhe t\u00eb tjera, duke marr\u00eb shembuj bazik t\u00eb t\u00eb dh\u00ebnave. Do t\u00eb b\u00ebjn\u00eb filtrimin e t\u00eb dh\u00ebnave, krijimin e diagrameve dhe shembuj bazik t\u00eb makrove, pivote table.<\/p>\n<ul>\n<li><em><strong>Q\u00ebllimi kryesor i kursit \u00ebsht\u00eb q\u00eb kandidat\u00ebt t\u00eb p\u00ebrdorin programin Excel p\u00ebr nevojat bazike t\u00eb bank\u00ebs..\u00a0 <\/strong><\/em><\/li>\n<\/ul>\n<p>[\/vc_column_text][stm_title title_tag=&#8221;h4&#8243; title=&#8221;Metodologjia p\u00ebr realizimin e temave m\u00ebsimore:&#8221;][\/stm_title][vc_column_text]Kursi \u00ebsht\u00eb kombinim i ligj\u00ebratave, diskutimeve, bisedave dhe ushtrimeve praktike.[\/vc_column_text][stm_title title_tag=&#8221;h4&#8243; title=&#8221;Kushtet p\u00ebr realizimin e temave m\u00ebsimore:&#8221;][\/stm_title][vc_column_text]Literatura adekuate, tabela, kompjuteri, projektori dhe mjetet tjera TI p\u00ebr m\u00ebsim dhe ushtrime.[\/vc_column_text][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_single_image image=&#8221;3370&#8243; img_size=&#8221;full&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_tta_accordion active_section=&#8221;1&#8243;][vc_tta_section title=&#8221;Ligj\u00ebratat&#8221; tab_id=&#8221;1655673861840-0964b3e5-af9f&#8221;][vc_column_text]Studenti\/nx\u00ebn\u00ebsi duhet t\u00eb jet\u00eb i rregullt n\u00eb ligj\u00ebrata dhe ushtrime, t\u00eb shfryt\u00ebzoj t\u00eb gjitha mund\u00ebsit\u00eb p\u00ebr nx\u00ebnie t\u00eb dijes, t\u00eb p\u00ebrdor\u00eb literatur\u00ebn e obliguar dhe m\u00eb t\u00eb gjer\u00eb, t\u00eb jet\u00eb aktiv dhe t\u00eb respektoj rregullat e \u201cINFINIT\u201d.[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Ushtrimet&#8221; tab_id=&#8221;1655673861857-91175ce0-02d0&#8243;][vc_column_text]Studenti\/nx\u00ebn\u00ebsi duhet t\u00eb jet\u00eb aktiv n\u00eb ushtrime dhe t\u00eb reflektoj gatishm\u00ebri dhe dije p\u00ebr iniciativa, ide dhe demonstrim t\u00eb njohurive t\u00eb marra n\u00eb ligj\u00ebrata.[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Hapat e par\u00eb n\u00eb Microsoft Excel&#8221; tab_id=&#8221;1655674532152-5e8601a1-e272&#8243;][vc_column_text]<\/p>\n<ul>\n<li>\u00c7ka \u00ebsht\u00eb Excel-i ?<\/li>\n<li>P\u00ebrdorimi i Excel \u2013 it<\/li>\n<li>Startimi dhe p\u00ebrfundimi i programit EXCEL<\/li>\n<li>Dritarja e Excel-it<\/li>\n<li>Shiritat e funksioneve<\/li>\n<li>Menyja e kontekstit<\/li>\n<li>Ndihma e Excelit \u2013 Help<\/li>\n<li>P\u00ebrshtatja e parametrave t\u00eb Excel-it- Excel Options<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Libri punues dhe flet\u00ebt e pun\u00ebs&#8221; tab_id=&#8221;1655674637597-8d1c634d-38c1&#8243;][vc_column_text]<\/p>\n<ul>\n<li>Menaxhimi i librit punues<\/li>\n<li>Krijimi i librit t\u00eb ri<\/li>\n<li>Ruatja e librit punues<\/li>\n<li>Hapja dhe mbyllja e librit punues<\/li>\n<li>Identifikimi i librit punues<\/li>\n<li>Kalimi prej nj\u00eb libri punues n\u00eb tjetrin<\/li>\n<li>Menaxhimi i flet\u00ebve punuese<\/li>\n<li>Shtimi, riem\u00ebrtimi dhe fshirja e flet\u00ebve punuese<\/li>\n<li>Kopjimi dhe zhvendosja e flet\u00ebve punuese<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Puna me qeliza&#8221; tab_id=&#8221;1655674716990-6720877b-8ec5&#8243;][vc_column_text]<\/p>\n<ul>\n<li>Shkruarja dhe p\u00ebrpunimi i t\u00eb dh\u00ebnave<\/li>\n<li>Zhb\u00ebrja dhe p\u00ebrs\u00ebritja e hapave<\/li>\n<li>K\u00ebrkimi dhe z\u00ebvend\u00ebsimi i t\u00eb dh\u00ebnave<\/li>\n<li>Zgjedhja e qelizave<\/li>\n<li>Kopjimi dhe zhvendosja e qelizave<\/li>\n<li>Zhvendosja dhe kopjimi me metod\u00ebn Drag &amp; Drop<\/li>\n<li>Kopjimi dhe zhvendosja p\u00ebrmes Clipboard<\/li>\n<li>Kopjimi dhe zhvendosja me an\u00eb t\u00eb m\u00ebnys\u00eb s\u00eb kontekstit<\/li>\n<li>Formatimi i qelizave<\/li>\n<li>Formatimi i paraqitjes s\u00eb qelizave<\/li>\n<li>Shembuj t\u00eb ndrysh\u00ebm tabelash p\u00ebr formatizim<\/li>\n<li>Formatimi i vlerave t\u00eb qelizave<\/li>\n<li>Stilet e formatimit<\/li>\n<li>Shembuj t\u00eb ndrysh\u00ebm tabelash p\u00ebr formatizim<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Puna me rreshta dhe shtylla&#8221; tab_id=&#8221;1655675678770-0693f36f-b2a6&#8243;][vc_column_text]<\/p>\n<ul>\n<li>Shtimi dhe largimi i rreshtave ose shtyllave<\/li>\n<li>Ndryshimi i lart\u00ebsis\u00eb s\u00eb rreshtave dhe gjer\u00ebsis\u00eb s\u00eb shtyllave<\/li>\n<li>Fshehja e rreshtave dhe shtyllave<\/li>\n<li>Shembuj t\u00eb ndrysh\u00ebm tabelash<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Formulat dhe funksionet&#8221; tab_id=&#8221;1655675679812-35d29c43-021c&#8221;][vc_column_text]<\/p>\n<ul>\n<li>Bazat llogaritjeve me formula<\/li>\n<li>Shkruarja dhe editimi i formulave<\/li>\n<li>Mbushja e qelizave<\/li>\n<li>Adresimi absolut dhe relativ<\/li>\n<li>Problemet dhe mesazhet e gabimeve<\/li>\n<li>Funksionet ( basic )<\/li>\n<li>Funksionet matematikore &amp; trigonometrike<\/li>\n<li>Funksionet financiare<\/li>\n<li>Funksionet logjike<\/li>\n<li>Funksionet tekstuale<\/li>\n<li>Funksionet Dat\u00eb &amp; Koh\u00eb<\/li>\n<li>Funksionet Lookup &amp; Referenciale<\/li>\n<li>Funksionet Statistikore<\/li>\n<li>Funksione t\u00eb tjera<\/li>\n<li>Shembuj praktik\u00eb t\u00eb nd\u00ebrlidhjes s\u00eb funksioneve dhe tabelave t\u00eb ndryshme<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Analizimi i t\u00eb dh\u00ebnave&#8221; tab_id=&#8221;1655675772935-4d886a20-17f3&#8243;][vc_column_text]<\/p>\n<ul>\n<li>Nd\u00ebrtimi i tabel\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Sortimi dhe filtrimi i t\u00eb dh\u00ebnave<\/li>\n<li>Krijimi i tabel\u00ebs s\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Shnd\u00ebrrimi i tabel\u00ebs n\u00eb varg t\u00eb t\u00eb dh\u00ebnave<\/li>\n<li>Shembuj praktik\u00eb t\u00eb sortimit dhe filtrimit t\u00eb t\u00eb dh\u00ebnave<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Rregullimi i faqeve dhe shtypja&#8221; tab_id=&#8221;1655675753686-be284041-4fcf&#8221;][vc_column_text]<\/p>\n<ul>\n<li>Rregullimi i faqeve<\/li>\n<li>Kreu dhe fundi i faqeve ( Header &amp; Footer )<\/li>\n<li>P\u00ebrshtatja e faqeve<\/li>\n<li>Ndryshimi i pamjes<\/li>\n<li>Paraqitja dhe organizimi i flet\u00ebve punuese<\/li>\n<li>Opsionet e flet\u00ebve punuese<\/li>\n<li>Kontrollimi i dokumentit<\/li>\n<li>Shtypja<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Diagramet&#8221; tab_id=&#8221;1655675808253-b2ba4ce8-f95e&#8221;][vc_column_text]<\/p>\n<ul>\n<li>\u00c7ka \u00ebsht\u00eb diagrami ?<\/li>\n<li>Krijimi i diagramit<\/li>\n<li>Elementet e diagramit<\/li>\n<li>Dizajnimi i diagramit<\/li>\n<li>Formatimi i elementeve t\u00eb diagramit<\/li>\n<li>Em\u00ebrtimi i elementeve t\u00eb diagramit<\/li>\n<li>Formatimi i boshteve dhe rrjetit ndar\u00ebs<\/li>\n<li>Prapavija dhe hij\u00ebzimi i diagramit<\/li>\n<li>P\u00ebrdorimi i diagrameve<\/li>\n<li>Shtypja e diagramit<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][\/vc_tta_accordion][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"excerpt":{"rendered":"<p>[vc_row css=&#8221;.vc_custom_1473328990059{margin-bottom: 50px !important;}&#8221;][vc_column width=&#8221;2\/3&#8243;][stm_title title_tag=&#8221;h2&#8243; title=&#8221;Q\u00ebllimi i trajnimit &amp; P\u00ebrfitimet e nx\u00ebn\u00ebsit&#8221;][\/stm_title][vc_column_text css=&#8221;.vc_custom_1657051934385{margin-bottom: 30px !important;}&#8221;]Q\u00ebllimi kryesor i k\u00ebtij\u00eb kursi \u00ebsht\u00eb q\u00eb kandidat\u00ebt do t\u00eb jen\u00eb n\u00eb gjendje t\u00eb mesojne dhe praktikojne ne nivel bazik programin Excel, pjes\u00ebt p\u00ebrb\u00ebr\u00ebse t\u00eb tij dhe rregullimin e parametrave bazike, t\u00eb menaxhojn\u00eb librin punues, krijimin e fajllit t\u00eb ri [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3369","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/pages\/3369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/comments?post=3369"}],"version-history":[{"count":3,"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/pages\/3369\/revisions"}],"predecessor-version":[{"id":3528,"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/pages\/3369\/revisions\/3528"}],"wp:attachment":[{"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/media?parent=3369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}