Tarih Biçimlendirme

WEBVTT 00:00:01.024 --> 00:00:05.267 Freunde, hier wurde uns zum Beispiel ein Bereich gegeben. 00:00:05.667 --> 00:00:07.869 Wir sind in den A7-Datums- und Kalendereinstellungen. 00:00:10.311 --> 00:00:21.039 Wir möchten diese uns gegebene Daten zum Beispiel ordentlich schreiben und dann nach Tag, Monat, Jahr und Tageseinstellungen sortieren. 00:00:23.681 --> 00:00:27.543 Eine der Operationen, die wir hier durchführen werden, ist wie folgt. 00:00:29.827 --> 00:00:33.909 Fügen wir eine Spalte hinzu, damit dieser Bereich nicht zusammengeführt wird. 00:00:35.411 --> 00:00:46.378 Dann sagen wir hier Tag, Monat und Jahr. 00:00:47.199 --> 00:00:52.442 Zuerst formatieren wir diesen Bereich. 00:00:53.519 --> 00:00:54.480 Wir haben die Jahre genommen. 00:00:55.200 --> 00:00:57.301 Von 2013 bis 2026 waren sie ordentlich. 00:00:57.361 --> 00:00:58.042 Ich habe eine Kopie gemacht. 00:00:58.722 --> 00:01:00.043 Ich habe es in das Jahresfeld gebracht. 00:01:01.604 --> 00:01:04.806 Dann waren die Monate ebenfalls ordentlich. 00:01:05.465 --> 00:01:06.907 Wir haben die Monate genommen, gebracht. 00:01:11.310 --> 00:01:17.534 Dann sind die Tage hier als Zahlen angegeben, für mich sind die Tage als Zahlen wichtig. 00:01:19.654 --> 00:01:21.575 nicht als Tagname. 00:01:21.635 --> 00:01:26.078 Weil der 5. Januar 2013 möglicherweise kein Montag ist. 00:01:27.938 --> 00:01:33.902 Jetzt, nachdem ich das so geschrieben habe, werde ich eine weitere Spalte hinzufügen. 00:01:35.824 --> 00:01:36.563 Zusammengesetzte Schreibweise. 00:01:42.267 --> 00:01:44.629 Jetzt, worauf müssen wir hier achten? 00:01:45.349 --> 00:01:57.077 Wenn Sie in Türkisch und in der Türkei Geschichte schreiben, sind die in Excel definierten Datumsformate Tag, Monat, Jahr, also mit Trennzeichen. 00:01:57.918 --> 00:01:58.838 Was haben wir hier zum Beispiel? 00:01:58.838 --> 00:02:15.945 Wenn ich zum Beispiel den 5. Januar 1. Monat 2013 eingebe und auf Enter drücke, wird das Datum, das ich eingegeben habe, von Excel automatisch erkannt. 00:02:18.627 --> 00:02:20.848 Lassen Sie uns alle Daten genauso eingeben. 00:02:20.848 --> 00:02:32.936 7-2-2014. Freunde, wir haben hier die ersten beiden Zeilen als Beispiel genommen. 00:02:32.996 --> 00:02:36.599 Sie können die anderen ausprobieren, aber es ist nicht unbedingt notwendig. 00:02:36.639 --> 00:02:37.639 Weil die Logik folgende ist. 00:02:38.320 --> 00:02:41.362 Wir haben Tag, Jahr, Datum hier eingegeben. 00:02:44.419 --> 00:02:44.939 Was war der Tag? 00:02:44.939 --> 00:02:50.121 5, 5., 7., Januar, Februar 2013 und 2014. 00:02:50.222 --> 00:02:50.962 Was haben wir hier gemacht? 00:02:51.062 --> 00:02:53.463 Wie Sie sehen, haben wir das Datumsformat ausgewählt. 00:02:54.883 --> 00:02:59.685 Wenn wir türkische Daten eingeben, verwenden wir das Trennzeichen, also den Schrägstrich. 00:03:00.425 --> 00:03:03.687 Danach ist das Format der Zelle Datum. 00:03:03.687 --> 00:03:05.048 Wir haben 2013 geschrieben. 00:03:06.228 --> 00:03:07.108 Das Datum ist hier definiert. 00:03:07.188 --> 00:03:08.949 Wir haben auch das andere genauso geschrieben. 00:03:08.949 --> 00:03:08.949 7. Februar 2014.

WEBVTT 00:00:01.024 --> 00:00:05.267 Here, for example, we are given a field. 00:00:05.667 --> 00:00:07.869 We are in the A7 date settings and calendar. 00:00:10.311 --> 00:00:21.039 We want to write this data in an organized way and then sort it according to the day, month, year, and day settings. 00:00:23.681 --> 00:00:27.543 One of the operations we will do here is as follows. 00:00:29.827 --> 00:00:33.909 Let's add a column or two so that this field does not merge. 00:00:35.411 --> 00:00:46.378 Then let's say day, month, and year here. 00:00:47.199 --> 00:00:52.442 First, let's format this field. 00:00:53.519 --> 00:00:54.480 We took the years. 00:00:55.200 --> 00:00:57.301 They were organized from 2013 to 2026. 00:00:57.361 --> 00:00:58.042 I copied it. 00:00:58.722 --> 00:01:00.043 I brought it to the year field. 00:01:01.604 --> 00:01:04.806 Then the months were organized in the same way. 00:01:05.465 --> 00:01:06.907 We took the months, brought them. 00:01:11.310 --> 00:01:17.534 Then the days are given here as numbers, the important thing for me will be the days given as numbers. 00:01:19.654 --> 00:01:21.575 Not the day name. 00:01:21.635 --> 00:01:26.078 Because January 5, 2013, Monday may not be acceptable. 00:01:27.938 --> 00:01:33.902 Now, after writing this, one of the things I need is to add one more column. 00:01:35.824 --> 00:01:36.563 Unified writing. 00:01:42.267 --> 00:01:44.629 Now, what do we need to pay attention to here? 00:01:45.349 --> 00:01:57.077 When writing history in Turkish and in Turkey, the date settings in Excel divide the date into day, month, and year, using a slash as a separator. 00:01:57.918 --> 00:01:58.838 What is it here, for example? 00:01:58.838 --> 00:02:15.945 When I enter 5 January 1st Month 2013 like this and press enter, if it aligns to the right, it means Excel automatically recognizes the date I entered. 00:02:18.627 --> 00:02:20.848 Let's enter all the dates in the same way. 00:02:20.848 --> 00:02:32.936 7-2-2014 For example, here we took the first two rows as an example. 00:02:32.996 --> 00:02:36.599 You can try the others if you want, but it's not very necessary. 00:02:36.639 --> 00:02:37.639 Because the logic is this. 00:02:38.320 --> 00:02:41.362 We entered day, year, and date here. 00:02:44.419 --> 00:02:44.939 What was the day? 00:02:44.939 --> 00:02:50.121 5, 5th, 7th, January, February 2013 and 2014 years. 00:02:50.222 --> 00:02:50.962 What did we do here? 00:02:51.062 --> 00:02:53.463 As you can see here, we selected the date format. 00:02:54.883 --> 00:02:59.685 When entering Turkish dates, we use a slash as a separator. 00:03:00.425 --> 00:03:03.687 Then the format of the cell is set to date. 00:03:03.687 --> 00:03:05.048 We wrote 2013. 00:03:06.228 --> 00:03:07.108 The date is defined here. 00:03:07.188 --> 00:03:08.949 Similarly, we wrote the other one. 00:03:08.949 --> 00:03:08.949 7 February 2014.

WEBVTT 00:00:01.024 --> 00:00:05.267 Arkadaşlar burada bize mesela bir alan verilmiş. 00:00:05.667 --> 00:00:07.869 A7 tarih ayarları ve takvimdeyiz. 00:00:10.311 --> 00:00:21.039 Bize verilen bu veriyi mesela biz düzenli bir şekilde yazıp daha sonra güne göre, aya göre, yıla göre ve gün ayarlarına göre sıralandırmak istiyoruz. 00:00:23.681 --> 00:00:27.543 Burada yapacağımız işlemlerden bir tanesi şöyle olsun. 00:00:29.827 --> 00:00:33.909 Kolon ekleyelim bir iki tane ki bu alan birleşmesin. 00:00:35.411 --> 00:00:46.378 Sonra diyelim ki buraya gün, ay ve yıl diyelim. 00:00:47.199 --> 00:00:52.442 İlk olarak bu alanı biçimlendirelim. 00:00:53.519 --> 00:00:54.480 Yılları aldık. 00:00:55.200 --> 00:00:57.301 2013'den 2026'ya kadar düzenlilerdi. 00:00:57.361 --> 00:00:58.042 Kopya aldım. 00:00:58.722 --> 00:01:00.043 Yıl alanına getirdim. 00:01:01.604 --> 00:01:04.806 Daha sonra aylar aynı şekilde düzenliydi. 00:01:05.465 --> 00:01:06.907 Ayları aldık, getirdik. 00:01:11.310 --> 00:01:17.534 Sonra günlerde burada sayı olarak verili, benim için önemli olan sayı olarak verili günler olacak. 00:01:19.654 --> 00:01:21.575 gün ismi değil. 00:01:21.635 --> 00:01:26.078 Çünkü 5 Ocak 2013 Pazartesi yatıya kabul etmeyebilir. 00:01:27.938 --> 00:01:33.902 Şimdi bunu bu şekilde yazdıktan sonra benim ihtiyacım olan şeylerden bir tanesi de bir kolon daha ekleyeceğim. 00:01:35.824 --> 00:01:36.563 Birleşik yazım. 00:01:42.267 --> 00:01:44.629 Şimdi burada dikkat etmemiz gereken şey ne? 00:01:45.349 --> 00:01:57.077 Türkçe'de ve Türkiye'ye tarih yazarken Excel'de tanımlı tarih ayarları gün taksim, ay taksim yıl olarak yani böl işareti. 00:01:57.918 --> 00:01:58.838 Burada nedir mesela? 00:01:58.838 --> 00:02:15.945 5 Ocak 1. Ay 2013 Bu şekilde girip enter'e bastığımda sağa yaslanırsa eğer yazdığım tarih Excel otomatik olarak tanımlıyor demek bunu. 00:02:18.627 --> 00:02:20.848 Aynı şekilde bütün tarihleri girelim. 00:02:20.848 --> 00:02:32.936 7-2-2014 Arkadaşlar örnek olarak mesela burada ilk iki satırı örnek olarak aldık. 00:02:32.996 --> 00:02:36.599 Diğerlerini isterseniz deneyebilirsiniz ama çok gerekli değil. 00:02:36.639 --> 00:02:37.639 Çünkü mantık şu. 00:02:38.320 --> 00:02:41.362 Gün, yıl, tarih olarak biz bunları buraya girdik. 00:02:44.419 --> 00:02:44.939 Gün neydi? 00:02:44.939 --> 00:02:50.121 5, 5'i, 7'si, Ocak, Şubat 2013 ve 2014 yılları. 00:02:50.222 --> 00:02:50.962 Burada ne yaptık? 00:02:51.062 --> 00:02:53.463 Şurada gördüğünüz gibi tarih formatını seçtik. 00:02:54.883 --> 00:02:59.685 Türkçe tarih girerken taksim işareti yani bölme işareti kullanıyoruz. 00:03:00.425 --> 00:03:03.687 Ondan sonra hücrenin içerisinin formatı tarih. 00:03:03.687 --> 00:03:05.048 2013 yazdık. 00:03:06.228 --> 00:03:07.108 Tarih burada tanımlı. 00:03:07.188 --> 00:03:08.949 Aynı şekilde diğerini de yazdık. 00:03:08.949 --> 00:03:08.949 7 Şubat 2014.