Biçimlendirme Ve Kenarlıklar

WEBVTT 00:00:01.721 --> 00:00:05.223 Jetzt werden wir die Zellen formatieren. 00:00:05.723 --> 00:00:08.405 Die Übung zur Zellenformatierung ist in Lektion 12. 00:00:09.426 --> 00:00:16.029 Kopieren Sie die Seite, passen Sie die Zahlenformate an, führen Sie Dezimalstellenanpassungen durch, wenden Sie Datumsformatierungen an, 00:00:16.089 --> 00:00:18.771 formatieren Sie die Tabelle, Rahmen und Schriftart. 00:00:20.131 --> 00:00:20.471 Okay. 00:00:21.212 --> 00:00:23.694 Zuerst werden wir gebeten, die Seite zu kopieren. 00:00:23.734 --> 00:00:24.695 Wie haben wir das gemacht? 00:00:24.855 --> 00:00:29.719 Wir klicken auf die Seite, sagen verschieben oder kopieren, wählen kopieren. 00:00:29.859 --> 00:00:33.362 Nach dem Kopieren sind wir jetzt in A12. 00:00:33.402 --> 00:00:36.665 Die nächste Seite wird nach A12 erstellt. 00:00:37.104 --> 00:00:38.827 Zellenformatierung 2 ist da. 00:00:41.365 --> 00:00:43.186 Ich ziehe es per Drag & Drop. 00:00:43.246 --> 00:00:46.948 Die Zellenformatierung 2 wird hier in Klammern angezeigt. 00:00:46.988 --> 00:00:47.388 Okay. 00:00:47.889 --> 00:00:49.029 Was wird jetzt von uns verlangt? 00:00:49.149 --> 00:00:51.270 Passen Sie die Zahlenformate an. 00:00:52.091 --> 00:00:58.214 Um die Zahlenformate anzupassen, gibt es hier verschiedene Felder, wie Sie sehen können. 00:00:59.215 --> 00:01:00.095 Zuerst diese... 00:01:03.097 --> 00:01:03.897 Werkzeuge. 00:01:06.578 --> 00:01:07.699 Baumaterial. 00:01:10.061 --> 00:01:10.721 Werkzeug. 00:01:15.636 --> 00:01:24.478 Gartenzubehör und insgesamt korrigieren. 00:01:25.859 --> 00:01:30.920 Dann klicke ich auf Chip und ziehe das Feld hier auf die gewünschte Breite. 00:01:32.720 --> 00:01:36.361 Oben sehen wir die Städte nach Gesamtsumme, hier sehen wir den Prozentsatz des Bereichs. 00:01:36.881 --> 00:01:44.434 Was wir jetzt tun wollen, ist, all diese Zahlen zuerst mit einem Komma zu formatieren. 00:01:44.694 --> 00:01:47.658 Ich bestehe darauf, die beiden Dezimalstellen beizubehalten. 00:01:48.099 --> 00:01:52.906 Ebenso drücke ich hier auf das Komma, um auf zwei Dezimalstellen zu wechseln. 00:01:52.966 --> 00:01:55.008 Finanzielle zwei Dezimalstellen Prozent. 00:01:55.870 --> 00:01:58.093 Lass uns das hier als Prozent definieren. 00:01:58.093 --> 00:02:13.296 Wenn Sie es als % definieren, sehen Sie, dass %24, %53, %0.07, %0.06 und wenn wir es als % formatieren, sehen wir %24, %53, %7, %16 und dass die Summe 100 beträgt. 00:02:17.519 --> 00:02:23.883 Dann beobachten wir die Formeln, wie diese Operationen durchgeführt werden. 00:02:23.923 --> 00:02:32.810 Dann bitte markieren Sie das Verkaufsberichtsfeld in Gelb und machen es fett und berechnen den Durchschnitt. 00:02:33.391 --> 00:02:37.413 Ändern Sie dann die Schriftgröße auf 16. 00:02:38.454 --> 00:02:45.318 Dann stellen Sie sicher, dass sowohl unter A als auch unter einem Doppelklick gleichmäßig verteilt sind. 00:02:47.220 --> 00:02:59.282 Dann zentrieren Sie die Prozentsätze für Istanbul, Izmir und Samsun nach Gesamtsumme, machen sie fett und richten sie linksbündig aus, auch für Haushaltsgeräte, 00:03:00.463 --> 00:03:07.431 Ich möchte, dass Sie es zentrieren, ausrichten und fett machen. 00:03:09.218 --> 00:03:22.084 Schneiden Sie den Kilometerstand des Verkaufswagens auf 1025 Kilometer ab und bringen Sie ihn neben den Kilometerstand des Verkaufswagens, markieren Sie den Kilometerstand des Verkaufswagens fett 00:03:22.105 --> 00:03:26.227 und markieren Sie ihn über der 1025 im Zellformatierungsbereich. 00:03:29.328 --> 00:03:29.688 Hier. 00:03:31.249 --> 00:03:38.513 Es gibt allgemeine Zahlen, Währung, Finanzdatum, Uhrzeit, Prozentsatz, Bruch, wissenschaftliche, Text-, spezielle Felder. 00:03:39.520 --> 00:03:44.502 Hier können wir natürlich etwas nach Ihren Wünschen anpassen. 00:03:44.602 --> 00:03:50.504 Wenn Sie möchten, können Sie es hier zum Beispiel als Kilometer einstellen. 00:03:51.444 --> 00:03:54.965 Wie können Sie das als Kilometer einstellen? 00:03:56.746 --> 00:04:00.547 Wie Sie sehen, gibt es hier verschiedene Wege für Brüche und wissenschaftliche Darstellungen. 00:04:01.187 --> 00:04:03.108 Text speziell nach Ihren Wünschen angepasst. 00:04:03.208 --> 00:04:15.332 Wenn Sie hier nicht finden, wonach Sie suchen, empfehle ich Ihnen, "Kilometer" in die nächste Zelle zu schreiben, da Sie hier als Text 00:04:15.372 --> 00:04:18.033 eingeben, verhindern Sie, dass diese Zahl definiert wird. 00:04:18.093 --> 00:04:25.416 Wenn Text eingegeben wird, werden die Wertebereiche mit Zahlen sofort in Excel undefiniert. 00:04:27.138 --> 00:04:28.299 Erstellungsdatum. 00:04:28.738 --> 00:04:41.403 Das Datum wird hier genau als 4 zwei drei hundert siebzig fünf angezeigt. 00:04:42.123 --> 00:04:44.425 Lassen Sie uns das Erstellungsdatum fett markieren. 00:04:44.485 --> 00:04:46.666 Lassen Sie uns das Datum und die Uhrzeit fett markieren. 00:04:46.706 --> 00:04:54.711 Wenn wir uns fragen, was dieses Datum sein könnte, könnte es der vierte Monat zweitausenddreiundzwanzig sein, oder? 00:04:55.791 --> 00:05:02.336 Oder es könnte der vierte Februar zweitausenddreiundzwanzig sein. 00:05:02.396 --> 00:05:03.457 Was sollen wir damit machen? 00:05:06.303 --> 00:05:08.606 Wir gehen wieder zum Zellformatierungsbereich. 00:05:08.746 --> 00:05:09.666 Wir sagen Datum. 00:05:09.726 --> 00:05:14.410 Wenn wir Datum sagen, übersetzen wir es von Englisch aus den USA ins Türkische. 00:05:14.490 --> 00:05:16.912 Weil wir das Datum auf Türkisch haben wollen. 00:05:17.493 --> 00:05:18.433 Das Datum ist Türkei. 00:05:19.794 --> 00:05:24.878 Wie Sie sehen, wurde dies von 2015-10 auf 2023 geändert. 00:05:24.918 --> 00:05:28.321 Ich möchte das in Tag, Monat, Jahr 10 umwandeln. 00:05:30.726 --> 00:05:34.189 Ich mache diese Anpassung. 00:05:34.189 --> 00:05:36.350 Es wurde zu 23.10.2015 korrigiert. 00:05:36.410 --> 00:05:38.050 Ich möchte das auch in eine Uhrzeit umwandeln. 00:05:38.089 --> 00:05:39.571 Ich gehe zur Zellformatierung. 00:05:40.952 --> 00:05:44.573 Wenn ich Uhrzeit sage, soll es als 13:30 hier bleiben. 00:05:44.733 --> 00:05:50.656 Ja, nach der Zellformatierung sind diese als Datum 18 hier angekommen. 00:05:52.213 --> 00:05:53.714 die Werte, wie wir sie wollen. 00:05:53.754 --> 00:05:54.134 Okay. 00:05:54.494 --> 00:05:57.015 Jetzt möchte ich, dass Sie etwas anderes tun. 00:05:58.236 --> 00:06:04.638 Fügen Sie basierend auf der Summe von Istanbul, Izmir, Ankara, Adana, Samsun die untere Grenze des Prozentsatzes hinzu. 00:06:05.438 --> 00:06:12.321 Nachdem Sie die rechte Seitenleiste zur Haushaltsgeräte-Herstellungsmaterialien-Werkzeuge-Sektion hinzugefügt haben. 00:06:12.861 --> 00:06:22.180 Fügen Sie dann wie unten gezeigt eine untere Doppelrahmenlinie hinzu, basierend auf dem Gesamtprozentsatz und der Gesamtfläche. 00:06:22.300 --> 00:06:31.964 Auf diese Weise, wenn wir das Gesamt hier haben, entschuldigen Sie, sehen Sie, wie eine untere Zeile erscheint, wenn wir das Gesamtzeichen in die Zeile darüber einfügen. 00:06:32.025 --> 00:06:33.646 Fügen wir auch eine untere Rahmenlinie hinzu. 00:06:35.467 --> 00:06:36.988 Wir haben die untere Rahmenlinie hinzugefügt. 00:06:37.969 --> 00:06:40.089 Dann sehen Sie, dass die rechte Seite offen geblieben ist. 00:06:40.130 --> 00:06:42.171 Ich möchte auch eine rechte Seitenleiste hinzufügen. 00:06:43.382 --> 00:06:45.524 Natürlich können Sie dies auf verschiedene Arten tun. 00:06:45.784 --> 00:06:51.070 Lassen Sie uns nun die oberen Außenrahmen als Quadrate gestalten. 00:06:51.630 --> 00:06:55.094 Lassen Sie uns dies auch als äußere Rahmen gestalten. 00:06:55.254 --> 00:07:00.439 Auf diese Weise, wie Sie sehen, möchte ich hier sogar eine Korrektur vornehmen. 00:07:01.961 --> 00:07:05.865 Ja, ich bitte Sie, es so zu gestalten, wie Sie es sehen. 00:07:09.193 --> 00:07:15.075 Von Istanbul über Izmir, Adana bis Samsun sollen die Städtenamen in Hellblau sein. 00:07:15.435 --> 00:07:19.417 Lassen Sie uns den Gesamtprozentsatz und den Gesamtbereichsteil in Grün gestalten. 00:07:20.817 --> 00:07:24.439 Lassen Sie uns diesen Bereich zum Beispiel in Gelb gestalten. 00:07:24.479 --> 00:07:28.120 Dann lassen Sie uns den untersten Gesamtbereich in Hellgrün gestalten. 00:07:30.666 --> 00:07:36.150 Auf diese Weise haben wir verschiedene Informations- und Datenbereiche klassifiziert. 00:07:36.230 --> 00:07:43.215 Wenn Sie möchten, fügen wir auch äußere Ränder hinzu, wenn wir von allen Rändern sprechen. 00:07:43.235 --> 00:07:47.938 Durch das Hinzufügen äußerer Ränder wurde das gesamte Flächenverhältnis wie Sie sehen festgelegt. 00:07:49.235 --> 00:07:56.042 In meinem Verkaufswagen-Kilometerstand nehme ich wieder die äußeren Ränder und dann nehme ich 1025 wieder mit den äußeren Rändern. 00:07:56.362 --> 00:08:04.070 Nachdem ich das Erstellungsdatum, das Datum und die Uhrzeit hier auch wieder mit äußeren Rändern versehen habe, füge ich noch einmal äußere Ränder hinzu. 00:08:04.711 --> 00:08:10.156 Auf diese Weise habe ich alle Daten und Informationen ordentlich klassifiziert.

WEBVTT 00:00:01.721 --> 00:00:05.223 Now we will do cell formatting. 00:00:05.723 --> 00:00:08.405 Exercise 12 is for cell formatting. 00:00:09.426 --> 00:00:16.029 Copy the page, adjust the number formats, make decimal adjustments, apply date formatting, 00:00:16.089 --> 00:00:18.771 format the table, borders, and font. 00:00:20.131 --> 00:00:20.471 Okay. 00:00:21.212 --> 00:00:23.694 First, we are asked to copy the page. 00:00:23.734 --> 00:00:24.695 How do we do that? 00:00:24.855 --> 00:00:29.719 We click on the page, say move or copy, and then create a copy. 00:00:29.859 --> 00:00:33.362 After creating a copy, we are now at A12. 00:00:33.402 --> 00:00:36.665 The next page will be created after A12. 00:00:37.104 --> 00:00:38.827 Cell formatting 2 is here. 00:00:41.365 --> 00:00:43.186 I'm moving it with drag and drop. 00:00:43.246 --> 00:00:46.948 Cell formatting 2 is shown in parentheses here. 00:00:46.988 --> 00:00:47.388 Okay. 00:00:47.889 --> 00:00:49.029 What does it want from us now? 00:00:49.149 --> 00:00:51.270 Adjust the number formats. 00:00:52.091 --> 00:00:58.214 To adjust the number formats, there are various fields here as you can see. 00:00:59.215 --> 00:01:00.095 First of all, these... 00:01:03.097 --> 00:01:03.897 The tools. 00:01:06.578 --> 00:01:07.699 Building material. 00:01:10.061 --> 00:01:10.721 Equipment. 00:01:15.636 --> 00:01:24.478 Let's correct the garden supplies and the total. 00:01:25.859 --> 00:01:30.920 Then, by clicking on the chip, I adjust the width of the area to my liking. 00:01:32.720 --> 00:01:36.361 Above, we have cities according to the total, we see the percentage area here. 00:01:36.881 --> 00:01:44.434 Now, what we want to do is to initially organize all these numbers with a comma. 00:01:44.694 --> 00:01:47.658 I insist on keeping two decimal places. 00:01:48.099 --> 00:01:52.906 Likewise, I press the comma here to switch to two decimal places. 00:01:52.966 --> 00:01:55.008 Financial two decimal values are percentages. 00:01:55.870 --> 00:01:58.093 Let's define this as a percentage. 00:01:58.093 --> 00:02:13.296 As you can see when you define it as a percentage, look %24, %53, %0.07, %0.06 and when we convert it to % form, we see %24, %53, %7, %16, and the total is 100. 00:02:17.519 --> 00:02:23.883 Then we observe the formulas for how these operations are carried out. 00:02:23.923 --> 00:02:32.810 Then what I want from you is to highlight the sales report area in yellow, make it bold, and find the average. 00:02:33.391 --> 00:02:37.413 Then, set the font size to 16. 00:02:38.454 --> 00:02:45.318 Then, make sure to double-click under both A and one to distribute them equally, this is important. 00:02:47.220 --> 00:02:59.282 Then, align the percentages for Istanbul, Izmir, and Samsun according to the total, make them bold, align them to the left for household appliances, 00:03:00.463 --> 00:03:07.431 I want you to center, align, and make bold. 00:03:09.218 --> 00:03:22.084 I also want you to cut the mileage of the sales car to 1025 kilometers, bring the mileage of the sales car next to it, mark the mileage of the sales car in bold 00:03:22.105 --> 00:03:26.227 and go over 1025 to the cell formatting area. 00:03:29.328 --> 00:03:29.688 Here. 00:03:31.249 --> 00:03:38.513 There are fields such as general number, currency, financial date, time, % rate, fraction, scientific, text, special. 00:03:39.520 --> 00:03:44.502 Of course, we can perform something customized here. 00:03:44.602 --> 00:03:50.504 For example, you can adjust this as kilometers from here if you want. 00:03:51.444 --> 00:03:54.965 How will you adjust this as kilometers? 00:03:56.746 --> 00:04:00.547 As you can see, there are various ways of scientific fraction here. 00:04:01.187 --> 00:04:03.108 Text special customized. 00:04:03.208 --> 00:04:15.332 If you can't find what you're looking for here, my advice to you is to write kilometers in the next cell because if you enter text here as 1025 kilometers, 00:04:15.372 --> 00:04:18.033 you prevent this number from being defined. 00:04:18.093 --> 00:04:25.416 When text is entered, the value ranges of numbers become undefined in Excel. 00:04:27.138 --> 00:04:28.299 Creation date. 00:04:28.738 --> 00:04:41.403 The date is shown here as exactly 4 two three hundred seventy-five. 00:04:42.123 --> 00:04:44.425 Let's make the creation date bold. 00:04:44.485 --> 00:04:46.666 Let's make the date and time bold. 00:04:46.706 --> 00:04:54.711 When we look at what this date could be, it could be the fourth month of twenty twenty-three, right? 00:04:55.791 --> 00:05:02.336 Or it could be the fourth of February, twenty twenty-three. 00:05:02.396 --> 00:05:03.457 What should we do with this? 00:05:06.303 --> 00:05:08.606 We go back to the cell formatting area. 00:05:08.746 --> 00:05:09.666 We say Date. 00:05:09.726 --> 00:05:14.410 When we say Date, we convert it from English, from the USA to Turkish. 00:05:14.490 --> 00:05:16.912 Because we want the date to be in Turkish. 00:05:17.493 --> 00:05:18.433 Date for Turkey. 00:05:19.794 --> 00:05:24.878 As you can see, it was changed to 2015-10, 2023. 00:05:24.918 --> 00:05:28.321 I want to convert this to day, month, year 10. 00:05:30.726 --> 00:05:34.189 I am making this adjustment. 00:05:34.189 --> 00:05:36.350 It was corrected to 23.10.2015. 00:05:36.410 --> 00:05:38.050 I also want to make this the hour. 00:05:38.089 --> 00:05:39.571 I come to cell formatting. 00:05:40.952 --> 00:05:44.573 When I say Hour, let the type remain as 13.30 here. 00:05:44.733 --> 00:05:50.656 Yes, these are the results of cell formatting here for 18 as the date. 00:05:52.213 --> 00:05:53.714 Values as we want. 00:05:53.754 --> 00:05:54.134 Okay. 00:05:54.494 --> 00:05:57.015 Now, another thing I want you to do. 00:05:58.236 --> 00:06:04.638 Add the bottom border of the percentage according to the sum of Istanbul, Izmir, Ankara, Adana, Samsun. 00:06:05.438 --> 00:06:12.321 After adding the right margin to the household appliances construction material tools section following the addition of the bottom margin. 00:06:12.861 --> 00:06:22.180 Then, according to the assembly, I want you to add a double bottom margin below the percentage and total area as you can see. 00:06:22.300 --> 00:06:31.964 In this way, when we add the total sign to the line above, you can see that the bottom line appears. 00:06:32.025 --> 00:06:33.646 Let's also add a bottom margin. 00:06:35.467 --> 00:06:36.988 We added the bottom margin. 00:06:37.969 --> 00:06:40.089 Then, you can see the right side is open. 00:06:40.130 --> 00:06:42.171 I also want you to add a right margin. 00:06:43.382 --> 00:06:45.524 Of course, it is possible to do this in different ways. 00:06:45.784 --> 00:06:51.070 Then let's make the top side square as outer margins. 00:06:51.630 --> 00:06:55.094 Let's also make this as outer margins. 00:06:55.254 --> 00:07:00.439 This way, as you can see, I want a correction here even. 00:07:01.961 --> 00:07:05.865 Yes, I request you to make it like this after. 00:07:09.193 --> 00:07:15.075 From Istanbul to Izmir, Adana, and Samsun, city names in light blue. 00:07:15.435 --> 00:07:19.417 Let's make the total and percentage part according to the total in green. 00:07:20.817 --> 00:07:24.439 Let's make this area yellow, for example. 00:07:24.479 --> 00:07:28.120 Then let's make the bottom total area light green. 00:07:30.666 --> 00:07:36.150 In this way, we have classified various information and data fields. 00:07:36.230 --> 00:07:43.215 If you want here, when we say all borders, we will add an outer border. 00:07:43.235 --> 00:07:47.938 When we add the outer border, as you can see, the total area percentage is determined according to the total sum. 00:07:49.235 --> 00:07:56.042 In my sales car mileage, I again take the outer borders and then take 1025 with the outer borders again. 00:07:56.362 --> 00:08:04.070 Creation date, related to date and time, after making this an outer border again, I add another outer border inside. 00:08:04.711 --> 00:08:10.156 In this way, I have classified all the data and information properly.

WEBVTT 00:00:01.721 --> 00:00:05.223 Şimdi hücre biçimlendirme yapacağız. 00:00:05.723 --> 00:00:08.405 Hücre biçimlendirme için alıştırma 12'de. 00:00:09.426 --> 00:00:16.029 Sayfayı kopyalayın, sayı formatlarını uygun biçime sokun, ondalık düzenlemeleri yapın, tarih biçimlendirmesini uygulayın, 00:00:16.089 --> 00:00:18.771 tabloyu, kenarlıklar ve yazı tipiyle biçimlendirin. 00:00:20.131 --> 00:00:20.471 Tamam. 00:00:21.212 --> 00:00:23.694 İlk olarak bizden sayfayı kopyalamamız isteniyor. 00:00:23.734 --> 00:00:24.695 Bunu nasıl yapıyorduk? 00:00:24.855 --> 00:00:29.719 Sayfanın üzerine safa ödümesi tıklıyoruz, taşı veya kopyalı diyoruz, kopya oluştur diyoruz. 00:00:29.859 --> 00:00:33.362 Kopya oluşturduktan sonra şu anda A12'deyiz. 00:00:33.402 --> 00:00:36.665 Sonraki sayfa A12'den sonraki sayfayı oluşturacak. 00:00:37.104 --> 00:00:38.827 Hücre biçimlendirme 2 geldi. 00:00:41.365 --> 00:00:43.186 Sürükle bırak yöntemiyle taşıyorum. 00:00:43.246 --> 00:00:46.948 Hücre biçimlendirme 2 parantez içinde gözüküyor burada. 00:00:46.988 --> 00:00:47.388 Tamam. 00:00:47.889 --> 00:00:49.029 Şimdi ne istiyor bizden? 00:00:49.149 --> 00:00:51.270 Sayı formatlarını uygun biçime sokun. 00:00:52.091 --> 00:00:58.214 Sayı formatlarını uygun biçime sokmak için burada gördüğünüz gibi çeşitli alanlar var. 00:00:59.215 --> 00:01:00.095 İlk başta bunları... 00:01:03.097 --> 00:01:03.897 Aletleri. 00:01:06.578 --> 00:01:07.699 Yapım malzemesi. 00:01:10.061 --> 00:01:10.721 Araç gereç. 00:01:15.636 --> 00:01:24.478 bahçe malzemesi ve toplam olarak düzeltelim. 00:01:25.859 --> 00:01:30.920 Daha sonra chip tıklayarak buraya alanı istediğim genişliğe getiriyorum. 00:01:32.720 --> 00:01:36.361 Yukarıda şehirler var toplama göre, yüzde alanını görüyoruz burada. 00:01:36.881 --> 00:01:44.434 Şimdi yapmak istediğimiz şey bu sayıların hepsini İlk başta virgülle düzenli bir hale getiriyorum. 00:01:44.694 --> 00:01:47.658 İki ondalık değeri korumakta ısrarcıyım. 00:01:48.099 --> 00:01:52.906 Aynı şekilde burada da iki ondalık değere geçirmek için virgüle basıyorum. 00:01:52.966 --> 00:01:55.008 Finansal iki ondalık değer yüzde. 00:01:55.870 --> 00:01:58.093 Burayı gelin yüzde olarak tanımlayalım. 00:01:58.093 --> 00:02:13.296 % olarak tanımladığınızda gördüğünüz gibi bakın %24, %53, %0.07, %0.06 bir de % şekline getirdiğimizde %24, %53, %7, %16 toplamanın 100 olduğunu görüyoruz. 00:02:17.519 --> 00:02:23.883 Daha sonra buradaki işlemlerin nasıl gerçekleştiğine dair formülleri gözlemliyoruz. 00:02:23.923 --> 00:02:32.810 Daha sonra sizden istediğim şey satış raporu alanını sarıyla işaretleyip kalın hale getirmeniz ve ortalamanız. 00:02:33.391 --> 00:02:37.413 Daha sonra yazı tipi boyutunu 16'ya getirmeniz. 00:02:38.454 --> 00:02:45.318 Sonra hem A'nın altına hem birinin altına çift tıklayarak eşit olarak dağılından emin olmanız bu olum. 00:02:47.220 --> 00:02:59.282 Daha sonra İstanbul İzmir adına Samsun toplam toplama göre yüzde alanlarını ortalayıp Kalın hale getirmenizi ev aletleriyle ilgili de sola yaslı hale getirip, 00:03:00.463 --> 00:03:07.431 orta duruma getirip, ortaya hizalayıp kalın hale getirmenizi istiyorum. 00:03:09.218 --> 00:03:22.084 Satış arabasının kilometre kaydını da 1025 kilometreyi kesip satış arabası kilometre kaydını yanına getirmenizi, satış arabası kilometre kaydını kalın 00:03:22.105 --> 00:03:26.227 ile işaretlemenizi 1025'in üzerine gelip hücre biçimlendir alanından. 00:03:29.328 --> 00:03:29.688 Burada. 00:03:31.249 --> 00:03:38.513 Genel sayı, para birimi, finansal tarih, saat, % oranı kesir, bilimsel, metin, özel gibi alanlar var. 00:03:39.520 --> 00:03:44.502 Burada isteğe uyarlanmış bir şekilde tabii ki bir şey gerçekleştirebiliriz. 00:03:44.602 --> 00:03:50.504 İsterseniz buradan mesela kilometre olarak bunu ayarlamanız mümkün. 00:03:51.444 --> 00:03:54.965 Kilometre olarak bunu ayarlamanın yolu nasıl olacak? 00:03:56.746 --> 00:04:00.547 Gördüğünüz gibi burada kesir bilimsel çeşitli yollar var. 00:04:01.187 --> 00:04:03.108 Metin özel isteğe uyarlanmış. 00:04:03.208 --> 00:04:15.332 Eğer burada aradığınızı bulamıyorsanız kilometre olarak size tavsiyem bir sonraki Hücreye kilometre yazmanız çünkü 1025 kilometre olarak burada metinle 00:04:15.372 --> 00:04:18.033 girerseniz bu sayının tanımlı hale gelmesini engellersiniz. 00:04:18.093 --> 00:04:25.416 Metin girildiği zaman sayıların olduğu değer aralıkları bir anda ekselde tanımsız hale geliyor. 00:04:27.138 --> 00:04:28.299 Oluşturulma tarihi. 00:04:28.738 --> 00:04:41.403 Tarih burada gördüğünüz gibi tam olarak 4 iki üç yüz saat sıfır yetmiş beş olarak gösterilmiş. 00:04:42.123 --> 00:04:44.425 Oluşturulma tarihini kalınla alalım. 00:04:44.485 --> 00:04:46.666 Tarih ve saati kalın olarak alalım. 00:04:46.706 --> 00:04:54.711 Bu tarih mesela ne olabilir diye baktığımızda dördüncü ay iki bin yirmi üç olabilir, değil mi? 00:04:55.791 --> 00:05:02.336 Ya da işte dört şubat iki bin yirmi üç olur. 00:05:02.396 --> 00:05:03.457 Bunu ne yapalım? 00:05:06.303 --> 00:05:08.606 Yine hücre biçimlendiri alanına geliyoruz. 00:05:08.746 --> 00:05:09.666 Tarih diyoruz. 00:05:09.726 --> 00:05:14.410 Tarih dediğimizde buradan İngilizce, ABD'den Türkçeye alıyoruz. 00:05:14.490 --> 00:05:16.912 Çünkü Türkçe tarihi olsun istiyoruz. 00:05:17.493 --> 00:05:18.433 Tarihi Türkiye. 00:05:19.794 --> 00:05:24.878 Gördüğünüz gibi 2015-10, 2023 olarak bu değiştirildi. 00:05:24.918 --> 00:05:28.321 Ben bunu gün, ay, yıl 10 olarak çevirmek istiyorum. 00:05:30.726 --> 00:05:34.189 Bu şekilde bir düzenleme yapıyorum. 00:05:34.189 --> 00:05:36.350 23.10.2015 olarak düzeldi. 00:05:36.410 --> 00:05:38.050 Bunu da saat yapmak istiyorum. 00:05:38.089 --> 00:05:39.571 Hücre biçimlendire geliyorum. 00:05:40.952 --> 00:05:44.573 Saat dediğimde tür 13.30 olarak burada kalsın. 00:05:44.733 --> 00:05:50.656 Evet 18'e tarih olarak burada hücre biçimlendirme sonucunda bunlar geldi. 00:05:52.213 --> 00:05:53.714 değerler istediğimiz gibi. 00:05:53.754 --> 00:05:54.134 Tamam. 00:05:54.494 --> 00:05:57.015 Şimdi sizden yapmanızı istediğim diğer bir şey. 00:05:58.236 --> 00:06:04.638 İstanbul, İzmir, Ankara, Adana, Samsun toplama göre yüzdenin alt kenarlığını eklemeniz. 00:06:05.438 --> 00:06:12.321 Alt kenarlığı ekledikten sonra ev aletleri yapım malzemesi araç gereç kısmına sağ kenarlık eklemeniz. 00:06:12.861 --> 00:06:22.180 Daha sonra toplama göre yüzde ve toplam alanının altına da Gördüğünüz gibi alt çift kenarlık eklemenizi istiyorum. 00:06:22.300 --> 00:06:31.964 Bu şekilde buranın toplam olduğu, pardon, bir üst satıra toplam işaretini eklediğimizde gördüğünüz gibi alt satır belirdi. 00:06:32.025 --> 00:06:33.646 Bir de alt kenarlık ekleyelim. 00:06:35.467 --> 00:06:36.988 Alt kenarlık ekledik. 00:06:37.969 --> 00:06:40.089 Sonra bakın sağ taraf açık kaldı. 00:06:40.130 --> 00:06:42.171 Bir de sağ kenarlık ekleyelim istiyorum. 00:06:43.382 --> 00:06:45.524 Tabii ki bunu farklı şekillerde yapmanız mümkün. 00:06:45.784 --> 00:06:51.070 Sonra üst tarafı şimdi dış kenarlıklar kare olarak yapalım. 00:06:51.630 --> 00:06:55.094 Burayı da dış kenarlıklar olarak yapalım. 00:06:55.254 --> 00:07:00.439 Bu sayede gördüğünüz gibi hatta şurada bir düzeltme yapalım istiyorum. 00:07:01.961 --> 00:07:05.865 Evet gördüğünüz gibi bu hale getirmenizi rica ediyorum sizden sonra. 00:07:09.193 --> 00:07:15.075 İstanbul, İzmir, Adana, Samsun'a kadar şehir isimlerine kadar açık mavi. 00:07:15.435 --> 00:07:19.417 Toplam ve toplama göre yüzde kısmını da yeşil yapalım. 00:07:20.817 --> 00:07:24.439 Bu alanında mesela sarı yapalım. 00:07:24.479 --> 00:07:28.120 Sonra en alttaki toplam alanında açık yeşil yapalım. 00:07:30.666 --> 00:07:36.150 Bu sayede çeşitli bilgi ve veri alanlarını sınıflandırmış olduk. 00:07:36.230 --> 00:07:43.215 Buraya da isterseniz tüm kenarlıklar dediğimizde dış kenarlık koyacağız. 00:07:43.235 --> 00:07:47.938 Dış kenarlık koyduğumuzda gördüğünüz gibi toplam toplama göre yüzde bütün alan belirlenmiş oldu. 00:07:49.235 --> 00:07:56.042 Satış arabası kilometre kaydımda yine dış kenarlıkları alıp daha sonra 1025'yi yine dış kenarlıkları alıyorum. 00:07:56.362 --> 00:08:04.070 Oluşturulma tarihi, tarih ve saatle ilgili burayı da yine dış kenarlık yaptıktan sonra içeriye bir kez daha dış kenarlık koyuyorum. 00:08:04.711 --> 00:08:10.156 Bu sayede tüm veriler ve bilgileri düzgün bir şekilde sınıflandırmış oldum.