{"id":1435,"date":"2023-07-26T10:01:41","date_gmt":"2023-07-26T10:01:41","guid":{"rendered":"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/"},"modified":"2023-07-26T10:01:41","modified_gmt":"2023-07-26T10:01:41","slug":"excelde-birden-cok-sutuna-gore-siralama","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/","title":{"rendered":"Excel&#39;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama nas\u0131l yap\u0131l\u0131r"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Genellikle Excel&#8217;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama yapmak isteyebilirsiniz. Neyse ki, <strong>\u00d6zel S\u0131ralama<\/strong> se\u00e7ene\u011fini kullanarak bunu yapmak kolayd\u0131r.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14194 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple3.png\" alt=\"\" width=\"645\" height=\"358\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu e\u011fitimde, \u00f6zel s\u0131ralaman\u0131n pratikte nas\u0131l kullan\u0131laca\u011f\u0131na ili\u015fkin ad\u0131m ad\u0131m bir \u00f6rnek sunulmaktad\u0131r.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>1. Ad\u0131m: Verileri olu\u015fturun<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">\u00d6ncelikle \u00e7al\u0131\u015fmak i\u00e7in sahte bir veri k\u00fcmesi olu\u015ftural\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14192 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple1.png\" alt=\"\" width=\"466\" height=\"511\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>2. Ad\u0131m: Birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Daha sonra verileri \u015fu \u015fekilde s\u0131ralayaca\u011f\u0131z:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">\u00d6ncelikle <strong>hane b\u00fcy\u00fckl\u00fc\u011f\u00fcne<\/strong> g\u00f6re en b\u00fcy\u00fc\u011f\u00fcnden en k\u00fc\u00e7\u00fc\u011f\u00fcne do\u011fru s\u0131ralay\u0131n.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Daha sonra A&#8217;dan Z&#8217;ye <strong>soyad\u0131na<\/strong> g\u00f6re s\u0131ralay\u0131n.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in ba\u015fl\u0131klar da dahil olmak \u00fczere her bir s\u00fctunu vurgulay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14193 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple2.png\" alt=\"\" width=\"519\" height=\"553\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra <strong>Giri\u015f<\/strong> sekmesinin <strong>D\u00fczenleme<\/strong> b\u00f6l\u00fcm\u00fcnde <strong>S\u0131rala ve Filtrele<\/strong> se\u00e7ene\u011fine t\u0131klay\u0131n. A\u00e7\u0131l\u0131r men\u00fcde <strong>\u00d6zel S\u0131ralama&#8217;y\u0131<\/strong> t\u0131klay\u0131n.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14194 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple3.png\" alt=\"\" width=\"645\" height=\"358\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A\u00e7\u0131lan pencerede <strong>hane b\u00fcy\u00fckl\u00fc\u011f\u00fcne<\/strong> g\u00f6re s\u0131ralay\u0131n ve <strong>en b\u00fcy\u00fc\u011f\u00fcnden en k\u00fc\u00e7\u00fc\u011f\u00fcne do\u011fru<\/strong> se\u00e7im yap\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra sol \u00fcst k\u00f6\u015fedeki <strong>D\u00fczey Ekle&#8217;ye<\/strong> t\u0131klay\u0131n, <strong>soyad\u0131na<\/strong> g\u00f6re s\u0131ralay\u0131n ve <strong>A&#8217;dan Z&#8217;ye&#8217;yi<\/strong> se\u00e7in.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14195 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple4.png\" alt=\"Excel'de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama\" width=\"616\" height=\"399\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Tamam&#8217;a<\/strong> t\u0131klad\u0131\u011f\u0131n\u0131zda veriler otomatik olarak s\u0131ralanacakt\u0131r:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14196 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple5.png\" alt=\"Excel'de birden \u00e7ok s\u00fctunu s\u0131ralama\" width=\"458\" height=\"557\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Sat\u0131rlar\u0131n <strong>hane b\u00fcy\u00fckl\u00fc\u011f\u00fcne<\/strong> g\u00f6re en b\u00fcy\u00fckten en k\u00fc\u00e7\u00fc\u011fe do\u011fru s\u0131raland\u0131\u011f\u0131n\u0131 unutmay\u0131n; bu nedenle hane b\u00fcy\u00fckl\u00fc\u011f\u00fc 7 ilk s\u0131rada g\u00f6r\u00fcn\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra A&#8217;dan Z&#8217;ye <strong>soyad\u0131na<\/strong> g\u00f6re s\u0131ral\u0131yoruz. Bu, ayn\u0131 b\u00fcy\u00fckl\u00fckteki t\u00fcm haneler i\u00e7in A&#8217;dan Z&#8217;ye s\u0131ralama yaparak s\u0131ralamalar\u0131n\u0131 belirledi\u011fimiz anlam\u0131na geliyor.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin 4 b\u00fcy\u00fckl\u00fc\u011f\u00fcndeki hanelerin her biri A&#8217;dan Z&#8217;ye s\u0131ralanm\u0131\u015ft\u0131r:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14197 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple6.png\" alt=\"\" width=\"471\" height=\"537\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu \u00f6rnekte iki s\u00fctuna g\u00f6re s\u0131ralama yapt\u0131\u011f\u0131m\u0131z\u0131, ancak <strong>\u00d6zel S\u0131ralama<\/strong> se\u00e7ene\u011fini kullanarak istedi\u011finiz kadar s\u00fctuna g\u00f6re s\u0131ralama yapabilece\u011finizi unutmay\u0131n.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Genellikle Excel&#8217;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama yapmak isteyebilirsiniz. Neyse ki, \u00d6zel S\u0131ralama se\u00e7ene\u011fini kullanarak bunu yapmak kolayd\u0131r. Bu e\u011fitimde, \u00f6zel s\u0131ralaman\u0131n pratikte nas\u0131l kullan\u0131laca\u011f\u0131na ili\u015fkin ad\u0131m ad\u0131m bir \u00f6rnek sunulmaktad\u0131r. 1. Ad\u0131m: Verileri olu\u015fturun \u00d6ncelikle \u00e7al\u0131\u015fmak i\u00e7in sahte bir veri k\u00fcmesi olu\u015ftural\u0131m: 2. Ad\u0131m: Birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama Daha sonra verileri \u015fu \u015fekilde [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-1435","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama nas\u0131l yap\u0131l\u0131r<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#039;de birden \u00e7ok s\u00fctunun nas\u0131l s\u0131ralanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama nas\u0131l yap\u0131l\u0131r\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#039;de birden \u00e7ok s\u00fctunun nas\u0131l s\u0131ralanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T10:01:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple3.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/\",\"url\":\"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/\",\"name\":\"Excel&#39;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama nas\u0131l yap\u0131l\u0131r\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-26T10:01:41+00:00\",\"dateModified\":\"2023-07-26T10:01:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#39;de birden \u00e7ok s\u00fctunun nas\u0131l s\u0131ralanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama nas\u0131l yap\u0131l\u0131r\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama nas\u0131l yap\u0131l\u0131r","description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#39;de birden \u00e7ok s\u00fctunun nas\u0131l s\u0131ralanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama nas\u0131l yap\u0131l\u0131r","og_description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#39;de birden \u00e7ok s\u00fctunun nas\u0131l s\u0131ralanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/","og_site_name":"Statorials","article_published_time":"2023-07-26T10:01:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/triermultiple3.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/","url":"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/","name":"Excel&#39;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama nas\u0131l yap\u0131l\u0131r","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-26T10:01:41+00:00","dateModified":"2023-07-26T10:01:41+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnek de dahil olmak \u00fczere Excel&#39;de birden \u00e7ok s\u00fctunun nas\u0131l s\u0131ralanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excelde-birden-cok-sutuna-gore-siralama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de birden \u00e7ok s\u00fctuna g\u00f6re s\u0131ralama nas\u0131l yap\u0131l\u0131r"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/1435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=1435"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/1435\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=1435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=1435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=1435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}