{"id":3374,"date":"2022-07-05T20:34:33","date_gmt":"2022-07-05T20:34:33","guid":{"rendered":"https:\/\/infinitcenter.com\/en\/?page_id=3374"},"modified":"2022-09-12T13:42:21","modified_gmt":"2022-09-12T13:42:21","slug":"microsoft-excel-avancuar","status":"publish","type":"page","link":"https:\/\/infinitcenter.com\/en\/microsoft-excel-avancuar\/","title":{"rendered":"Microsoft Excel &#8211; Advanced"},"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_1657052921947{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 m\u00ebsojn\u00eb dhe praktikojen ne nivel te avancuar nd\u00ebrlidhjen e fajllave t\u00eb Excel-it nga follder\u00eb t\u00eb ndrysh\u00ebm, formatizimin dhe dizajnimin e avancuar t\u00eb tabelave, rregullimin e parametrave, aspektin e siguris\u00eb, sortimin dhe filtrimin e t\u00eb dh\u00ebnave, p\u00ebrdorimin e Hyperlinqeve, krijiin e grafikoneve dhe p\u00ebrdorimin e teamplate. Kandidat\u00ebt do t\u00eb m\u00ebsojn\u00eb dhe praktikojn\u00eb formulat dhe funksionet n\u00eb nivel t\u00eb avancuar, duke b\u00ebr\u00eb nd\u00ebrlidhjen e tyre n\u00eb fajlla t\u00eb ndrysh\u00ebm dhe follder\u00eb t\u00eb ndrysh\u00ebm. Do t\u00eb m\u00ebsojn\u00eb dhe praktikojn\u00eb If statments duke marr\u00eb shembuj bazik dhe t\u00eb avancuar, Vlookup dhe Hlookup, sparklines. Do t\u00eb m\u00ebsojn\u00eb dhe praktikojn\u00eb shembuj t\u00eb ndrysh\u00ebm t\u00eb Pivot Table dhe krijimin e makrove n\u00eb nivel t\u00eb avancuar.<\/p>\n<ul>\n<li><em><strong>Q\u00ebllimi kryesor i kursit \u00ebsht\u00eb q\u00eb kandidat\u00ebt t\u00eb p\u00ebrdorin programin Excel n\u00eb nivel t\u00eb avancuar p\u00eb nevojat e bank\u00ebs<\/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;3375&#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;Puna me tabela n\u00eb follder\u00eb t\u00eb ndrysh\u00ebm&#8221; tab_id=&#8221;1655674532152-5e8601a1-e272&#8243;][vc_column_text]<\/p>\n<ul>\n<li>Nd\u00ebrlidhja e dokumenteve nd\u00ebrmjet veti nga follder t\u00eb ndrysh\u00ebm<\/li>\n<li>Formatimi i tabelave dhe dizajnimi<\/li>\n<li>Rregullimi i paramterave t\u00eb avancuara t\u00eb Excel-it<\/li>\n<li>Aspekti i siguris\u00eb s\u00eb tabelave<\/li>\n<li>Tabelat \u2013 sortimi dhe filtrimi i i avancuar<\/li>\n<li>P\u00ebrdorimi i Hyperlinqeve<\/li>\n<li>Shp\u00ebrndarja e dokumenteve &#8211; sharing<\/li>\n<li>P\u00ebrdorimi dhe nd\u00ebrlidhja e grafikoneve<\/li>\n<li>Krijimi dhe p\u00ebrdorimi i teamplate<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Formulat dhe funksionet (Avancuar)&#8221; tab_id=&#8221;1655674637597-8d1c634d-38c1&#8243;][vc_column_text]<\/p>\n<ul>\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<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;If statements&#8221; tab_id=&#8221;1655674716990-6720877b-8ec5&#8243;][vc_column_text]<\/p>\n<ul>\n<li>IF<\/li>\n<li>COUNTIF<\/li>\n<li>COUNTIFS<\/li>\n<li>IFERROR<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Vlookup and Hlookup&#8221; tab_id=&#8221;1655675678770-0693f36f-b2a6&#8243;][vc_column_text]<\/p>\n<ul>\n<li>VLOOKUP &amp; Hlookup<\/li>\n<li>Sintaksa &amp; rregullat e Vlookup\/Hlookup, Exact &amp; Closest Match, #N\/A Error, #REF! Error.<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Sparklines&#8221; tab_id=&#8221;1655675679812-35d29c43-021c&#8221;][vc_column_text]<\/p>\n<ul>\n<li>Qka jan\u00eb Sparklines ?<\/li>\n<li>Krijimi i sparklines bazike<\/li>\n<li>Krijimi i sparklines t\u00eb avancuara<\/li>\n<li>Tipet e sparklines<\/li>\n<li>Ndryshimi i pamjes s\u00eb sparklines<\/li>\n<li>Ndryshimi i gam\u00ebs s\u00eb sparklines<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Pivot Tables and charts &#8221; tab_id=&#8221;1655675772935-4d886a20-17f3&#8243;][vc_column_text]<\/p>\n<ul>\n<li>\u00c7ka \u00ebsht\u00eb PIVOT TABLE ?<\/li>\n<li>Krijimi i Pivot Table<\/li>\n<li>Si t\u00eb grupojm\u00eb Pivot Table ?<\/li>\n<li>Krijimi i Pivot Table &#8211; t\u00eb avancuar<\/li>\n<li>Si t\u00eb sortojm\u00eb Pivot Table ?<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section title=&#8221;Macro Operations&#8221; tab_id=&#8221;1655675753686-be284041-4fcf&#8221;][vc_column_text]<\/p>\n<ul>\n<li>Para se t\u00eb punojm\u00eb me Macro !<\/li>\n<li>Disa definicione t\u00eb r\u00ebnd\u00ebsishme<\/li>\n<li>Aspekti i siguris\u00eb<\/li>\n<li>Krijimi i Macros<\/li>\n<li>Gjuh\u00ebt e Macros<\/li>\n<li>Format e kontrollit t\u00eb Macrove<\/li>\n<li>P\u00ebrdorimi i formatit t\u00eb p\u00ebrdoruesit<\/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_1657052921947{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 m\u00ebsojn\u00eb dhe praktikojen ne nivel te avancuar nd\u00ebrlidhjen e fajllave t\u00eb Excel-it nga follder\u00eb t\u00eb ndrysh\u00ebm, formatizimin dhe dizajnimin e avancuar t\u00eb tabelave, rregullimin e parametrave, [&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-3374","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/pages\/3374","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=3374"}],"version-history":[{"count":3,"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/pages\/3374\/revisions"}],"predecessor-version":[{"id":3527,"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/pages\/3374\/revisions\/3527"}],"wp:attachment":[{"href":"https:\/\/infinitcenter.com\/en\/wp-json\/wp\/v2\/media?parent=3374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}