{"id":6424,"date":"2022-12-28T09:16:00","date_gmt":"2022-12-28T09:16:00","guid":{"rendered":"https:\/\/technews.al\/?p=6424"},"modified":"2022-12-27T23:18:49","modified_gmt":"2022-12-27T23:18:49","slug":"microsoft-po-lehteson-formula-ne-excel","status":"publish","type":"post","link":"https:\/\/technews.al\/?p=6424","title":{"rendered":"Microsoft po leht\u00ebson formula n\u00eb Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"6424\" class=\"elementor elementor-6424\">\n\t\t\t\t\t\t\t\t\t<section class=\"has-el-gap el-gap-default elementor-section elementor-top-section elementor-element elementor-element-7f25493 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f25493\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2a85fd9\" data-id=\"2a85fd9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1ad46c2 elementor-widget elementor-widget-text-editor\" data-id=\"1ad46c2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.8.1 - 13-11-2022 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#818a91;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#818a91;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Kompania po shton disa ve\u00e7ori t\u00eb dobishme automatizimi n\u00eb softuerin e saj t\u00eb spreadsheeteve t\u00eb bazuara n\u00eb ueb.<\/p><p>Microsoft ka njoftuar se po e b\u00ebn kompletimin automatik t\u00eb Excel-it edhe m\u00eb t\u00eb zgjuar, t\u00eb pakt\u00ebn n\u00eb versionin ueb q\u00eb vjen me Microsoft 365 (i njohur m\u00eb par\u00eb si Office 365). Jav\u00ebn e kaluar ajo njoftoi sugjerimet e formulave dhe formulat sipas shembullit, t\u00eb cilat t\u00eb dyja mund t\u00eb ndihmojn\u00eb n\u00eb automatizimin e disa gj\u00ebrave q\u00eb duhet t\u00eb b\u00ebnit me dor\u00eb.<\/p><p>Sugjerimet e formul\u00ebs jan\u00eb pothuajse ato q\u00eb thon\u00eb n\u00eb kana\u00e7e: n\u00ebse shkruani shenj\u00ebn e barabart\u00eb n\u00eb nj\u00eb qeliz\u00eb, Excel p\u00ebr ueb do t\u00eb p\u00ebrpiqet t\u00eb sugjeroj\u00eb n\u00eb m\u00ebnyr\u00eb inteligjente se \u00e7far\u00eb lloj formule duhet t\u00eb p\u00ebrdorni, duke pasur parasysh t\u00eb dh\u00ebnat q\u00eb jan\u00eb rreth tij. P\u00ebr shembull, n\u00ebse keni nj\u00eb num\u00ebr t\u00eb plot\u00eb t\u00eb shitjeve tremujore dhe nj\u00eb kolon\u00eb n\u00eb fund t\u00eb em\u00ebrtuar &#8220;total&#8221;, Excel mund t\u00eb sugjeroj\u00eb p\u00ebrmbledhjen e gam\u00ebs s\u00eb qelizave. Sipas nj\u00eb postimi n\u00eb blog nga Microsoft, funksioni aktualisht funksionon vet\u00ebm n\u00eb anglisht dhe do t\u00eb sugjeroj\u00eb formulat shuma, mesatare, num\u00ebrimi, num\u00ebrimi, min dhe max. Nuk \u00ebsht\u00eb nj\u00eb ve\u00e7ori novatore, p\u00ebr t\u00eb qen\u00eb t\u00eb sigurt &#8211; Google Sheets ka pasur di\u00e7ka t\u00eb ngjashme p\u00ebr nj\u00eb koh\u00eb, dhe AutoSum i Excel ka qen\u00eb prej koh\u00ebsh nj\u00eb m\u00ebnyr\u00eb e shpejt\u00eb p\u00ebr t\u00eb aplikuar formula n\u00eb t\u00eb dh\u00ebna &#8211; por p\u00ebr disa raste p\u00ebrdorimi, mund t\u00eb jet\u00eb nj\u00eb kursim i mir\u00eb i koh\u00ebs.<\/p><p><iframe loading=\"lazy\" title=\"Formula by example\" width=\"788\" height=\"591\" src=\"https:\/\/www.youtube.com\/embed\/rG0MJIdav0k?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p><p>Pastaj ka Formula nga Shembull, e cila \u00ebsht\u00eb e ngjashme me funksionin Flash Fill q\u00eb mund t\u00eb zbuloj\u00eb automatikisht modelet n\u00eb t\u00eb dh\u00ebna dhe t\u00eb plot\u00ebsoj\u00eb pjes\u00ebn tjet\u00ebr t\u00eb nj\u00eb kolone. Ky funksion \u00ebsht\u00eb pak i v\u00ebshtir\u00eb p\u00ebr t&#8217;u shpjeguar shkurt, por kjo video nga Microsoft ju jep nj\u00eb ide se p\u00ebr \u00e7far\u00eb b\u00ebhet fjal\u00eb; zbulimi i nj\u00eb modeli ku po krehni informacionin nga qelizat dhe m\u00eb pas gjeneroni automatikisht nj\u00eb formul\u00eb q\u00eb do t&#8217;ju kursej\u00eb disa shkrime.<\/p><p>Un\u00eb u p\u00ebrpoqa t\u00eb provoja sugjerimet e formulave dhe formulat sipas shembullit n\u00eb ueb, por n\u00eb fakt nuk munda ta b\u00ebja t\u00eb shfaqej. Megjithat\u00eb, postimi n\u00eb blog thot\u00eb se ve\u00e7orit\u00eb tani po shfaqen, k\u00ebshtu q\u00eb \u00ebsht\u00eb e mundur q\u00eb ata thjesht t\u00eb mos ken\u00eb arritur n\u00eb llogarin\u00eb time. P\u00ebr at\u00eb q\u00eb ia vlen, kontrollova gjithashtu aplikacionin e desktopit Excel p\u00ebr Windows dhe Mac, dhe ata gjithashtu dukej se nuk kishin ve\u00e7orit\u00eb e plot\u00ebsimit automatik.<\/p><p><iframe loading=\"lazy\" title=\"Microsoft Excel World Championship 2022: Finals\" width=\"788\" height=\"443\" src=\"https:\/\/www.youtube.com\/embed\/qfDq5dlp2o4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p><p>Postimi n\u00eb blog i Microsoft p\u00ebrfshin gjithashtu disa njoftime t\u00eb tjera p\u00ebr ve\u00e7ori, megjith\u00ebse do t\u00eb pranoj se nuk jam mjaftuesh\u00ebm p\u00ebrdorues i fuqish\u00ebm p\u00ebr t&#8217;i kuptuar ato \u2013 do t&#8217;ua l\u00eb at\u00eb konkurrent\u00ebve t\u00eb esports si fusha e Kampionatit Bot\u00ebror t\u00eb Microsoft Excel 2022 t\u00eb p\u00ebrfunduar s\u00eb fundmi. .<\/p><p>Ekziston nj\u00eb funksion p\u00ebr shtimin e imazheve me tekst alt n\u00eb tabelat tuaja q\u00eb vijn\u00eb n\u00eb Windows, Mac dhe ueb, dhe kompania shton gjithashtu llojet e t\u00eb dh\u00ebnave t\u00eb nd\u00ebrlidhura t\u00eb Power Query dhe aft\u00ebsin\u00eb p\u00ebr t\u00eb marr\u00eb t\u00eb dh\u00ebna nga grupet dinamike n\u00eb versionin Insider t\u00eb aplikacionit Windows p\u00ebr duke testuar. Nj\u00eb ve\u00e7ori tjet\u00ebr potencialisht e dobishme (dhe fatmir\u00ebsisht e leht\u00eb p\u00ebr t&#8217;u kuptuar) q\u00eb vjen n\u00eb ueb \u00ebsht\u00eb &#8220;lidhjet e sugjeruara&#8221;, t\u00eb cilat automatikisht do t&#8217;ju ndihmojn\u00eb t\u00eb rregulloni lidhjet e prishura me libra t\u00eb tjer\u00eb t\u00eb pun\u00ebs t\u00eb ruajtur n\u00eb re.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Kompania po shton disa ve\u00e7ori t\u00eb dobishme automatizimi n\u00eb softuerin e saj t\u00eb spreadsheeteve t\u00eb bazuara n\u00eb ueb. Microsoft ka njoftuar se po e b\u00ebn kompletimin automatik t\u00eb Excel-it edhe m\u00eb t\u00eb zgjuar, t\u00eb pakt\u00ebn n\u00eb versionin ueb q\u00eb vjen me Microsoft 365 (i njohur m\u00eb par\u00eb si Office 365). Jav\u00ebn e kaluar ajo njoftoi<\/p>\n","protected":false},"author":4,"featured_media":6426,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-6424","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-uncategorized"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft po leht\u00ebson formula n\u00eb Excel - Technews.al<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/technews.al\/?p=6424\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft po leht\u00ebson formula n\u00eb Excel - Technews.al\" \/>\n<meta property=\"og:description\" content=\"Kompania po shton disa ve\u00e7ori t\u00eb dobishme automatizimi n\u00eb softuerin e saj t\u00eb spreadsheeteve t\u00eb bazuara n\u00eb ueb. Microsoft ka njoftuar se po e b\u00ebn kompletimin automatik t\u00eb Excel-it edhe m\u00eb t\u00eb zgjuar, t\u00eb pakt\u00ebn n\u00eb versionin ueb q\u00eb vjen me Microsoft 365 (i njohur m\u00eb par\u00eb si Office 365). Jav\u00ebn e kaluar ajo njoftoi\" \/>\n<meta property=\"og:url\" content=\"https:\/\/technews.al\/?p=6424\" \/>\n<meta property=\"og:site_name\" content=\"Technews.al\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-28T09:16:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-27T23:18:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/technews.al\/wp-content\/uploads\/2022\/12\/37c8885c8e5ba2528a5adb17936e1ea5.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"980\" \/>\n\t<meta property=\"og:image:height\" content=\"565\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Tech Expert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tech Expert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/technews.al\/?p=6424\",\"url\":\"https:\/\/technews.al\/?p=6424\",\"name\":\"Microsoft po leht\u00ebson formula n\u00eb Excel - Technews.al\",\"isPartOf\":{\"@id\":\"https:\/\/technews.al\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/technews.al\/?p=6424#primaryimage\"},\"image\":{\"@id\":\"https:\/\/technews.al\/?p=6424#primaryimage\"},\"thumbnailUrl\":\"https:\/\/technews.al\/wp-content\/uploads\/2022\/12\/37c8885c8e5ba2528a5adb17936e1ea5.jpg\",\"datePublished\":\"2022-12-28T09:16:00+00:00\",\"dateModified\":\"2022-12-27T23:18:49+00:00\",\"author\":{\"@id\":\"https:\/\/technews.al\/#\/schema\/person\/0d9ed995a903005f5e36e2bb709a98aa\"},\"breadcrumb\":{\"@id\":\"https:\/\/technews.al\/?p=6424#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/technews.al\/?p=6424\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/technews.al\/?p=6424#primaryimage\",\"url\":\"https:\/\/technews.al\/wp-content\/uploads\/2022\/12\/37c8885c8e5ba2528a5adb17936e1ea5.jpg\",\"contentUrl\":\"https:\/\/technews.al\/wp-content\/uploads\/2022\/12\/37c8885c8e5ba2528a5adb17936e1ea5.jpg\",\"width\":980,\"height\":565},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/technews.al\/?p=6424#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/technews.al\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft po leht\u00ebson formula n\u00eb Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/technews.al\/#website\",\"url\":\"https:\/\/technews.al\/\",\"name\":\"Technews.al\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/technews.al\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/technews.al\/#\/schema\/person\/0d9ed995a903005f5e36e2bb709a98aa\",\"name\":\"Tech Expert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/technews.al\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/technews.al\/wp-content\/uploads\/2023\/11\/Untitled-design-1-96x96.jpg\",\"contentUrl\":\"https:\/\/technews.al\/wp-content\/uploads\/2023\/11\/Untitled-design-1-96x96.jpg\",\"caption\":\"Tech Expert\"},\"url\":\"https:\/\/technews.al\/?author=4\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft po leht\u00ebson formula n\u00eb Excel - Technews.al","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/technews.al\/?p=6424","og_locale":"en_US","og_type":"article","og_title":"Microsoft po leht\u00ebson formula n\u00eb Excel - Technews.al","og_description":"Kompania po shton disa ve\u00e7ori t\u00eb dobishme automatizimi n\u00eb softuerin e saj t\u00eb spreadsheeteve t\u00eb bazuara n\u00eb ueb. Microsoft ka njoftuar se po e b\u00ebn kompletimin automatik t\u00eb Excel-it edhe m\u00eb t\u00eb zgjuar, t\u00eb pakt\u00ebn n\u00eb versionin ueb q\u00eb vjen me Microsoft 365 (i njohur m\u00eb par\u00eb si Office 365). Jav\u00ebn e kaluar ajo njoftoi","og_url":"https:\/\/technews.al\/?p=6424","og_site_name":"Technews.al","article_published_time":"2022-12-28T09:16:00+00:00","article_modified_time":"2022-12-27T23:18:49+00:00","og_image":[{"width":980,"height":565,"url":"https:\/\/technews.al\/wp-content\/uploads\/2022\/12\/37c8885c8e5ba2528a5adb17936e1ea5.jpg","type":"image\/jpeg"}],"author":"Tech Expert","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tech Expert","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/technews.al\/?p=6424","url":"https:\/\/technews.al\/?p=6424","name":"Microsoft po leht\u00ebson formula n\u00eb Excel - Technews.al","isPartOf":{"@id":"https:\/\/technews.al\/#website"},"primaryImageOfPage":{"@id":"https:\/\/technews.al\/?p=6424#primaryimage"},"image":{"@id":"https:\/\/technews.al\/?p=6424#primaryimage"},"thumbnailUrl":"https:\/\/technews.al\/wp-content\/uploads\/2022\/12\/37c8885c8e5ba2528a5adb17936e1ea5.jpg","datePublished":"2022-12-28T09:16:00+00:00","dateModified":"2022-12-27T23:18:49+00:00","author":{"@id":"https:\/\/technews.al\/#\/schema\/person\/0d9ed995a903005f5e36e2bb709a98aa"},"breadcrumb":{"@id":"https:\/\/technews.al\/?p=6424#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/technews.al\/?p=6424"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/technews.al\/?p=6424#primaryimage","url":"https:\/\/technews.al\/wp-content\/uploads\/2022\/12\/37c8885c8e5ba2528a5adb17936e1ea5.jpg","contentUrl":"https:\/\/technews.al\/wp-content\/uploads\/2022\/12\/37c8885c8e5ba2528a5adb17936e1ea5.jpg","width":980,"height":565},{"@type":"BreadcrumbList","@id":"https:\/\/technews.al\/?p=6424#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/technews.al\/"},{"@type":"ListItem","position":2,"name":"Microsoft po leht\u00ebson formula n\u00eb Excel"}]},{"@type":"WebSite","@id":"https:\/\/technews.al\/#website","url":"https:\/\/technews.al\/","name":"Technews.al","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/technews.al\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/technews.al\/#\/schema\/person\/0d9ed995a903005f5e36e2bb709a98aa","name":"Tech Expert","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/technews.al\/#\/schema\/person\/image\/","url":"https:\/\/technews.al\/wp-content\/uploads\/2023\/11\/Untitled-design-1-96x96.jpg","contentUrl":"https:\/\/technews.al\/wp-content\/uploads\/2023\/11\/Untitled-design-1-96x96.jpg","caption":"Tech Expert"},"url":"https:\/\/technews.al\/?author=4"}]}},"_links":{"self":[{"href":"https:\/\/technews.al\/index.php?rest_route=\/wp\/v2\/posts\/6424"}],"collection":[{"href":"https:\/\/technews.al\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/technews.al\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/technews.al\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/technews.al\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6424"}],"version-history":[{"count":4,"href":"https:\/\/technews.al\/index.php?rest_route=\/wp\/v2\/posts\/6424\/revisions"}],"predecessor-version":[{"id":6432,"href":"https:\/\/technews.al\/index.php?rest_route=\/wp\/v2\/posts\/6424\/revisions\/6432"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/technews.al\/index.php?rest_route=\/wp\/v2\/media\/6426"}],"wp:attachment":[{"href":"https:\/\/technews.al\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/technews.al\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/technews.al\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}