Verileri Taşıma Ve Bağlama

WEBVTT 00:00:01.274 --> 00:00:05.535 Aber Übung sechs, Datenübertragung und Verknüpfung, meine Freunde. 00:00:06.136 --> 00:00:17.419 Wenn wir über Datenübertragung und Verknüpfung sprechen, was wir meinen, wenn wir von Buchhaltung und Audit, also Kontrolle, Prüfung sprechen, werden es diejenigen, die es tun, bereits wissen. 00:00:17.459 --> 00:00:17.819 Ansonsten werde ich Ihnen jetzt zeigen, worüber ich spreche, worum es geht. 00:00:19.220 --> 00:00:24.882 Angenommen, ich möchte bestimmte Werte von dieser Verkaufsliste in ein anderes Feld verschieben. 00:00:36.463 --> 00:00:37.543 Wie geht das? 00:00:38.325 --> 00:00:39.946 Zuerst erstelle ich eine neue Seite. 00:00:39.986 --> 00:00:43.929 Nachdem ich die neue Seite erstellt habe, sage ich Übung sechs. 00:00:44.129 --> 00:00:47.891 Wir geben unseren Seiten immer einen spezifischen Namen. 00:00:47.932 --> 00:00:51.054 Damit es später keine Verwirrung bei den durchgeführten Arbeiten gibt. 00:00:52.475 --> 00:00:59.640 A6 Datenübertragung und Verknüpfung, sagen wir, die Daten wurden übertragen und verknüpft. 00:01:02.571 --> 00:01:12.498 Nun, in Bezug auf Datenübertragung und Verknüpfung, meine Freunde, ist eine der Operationen, die wir durchführen können. 00:01:13.058 --> 00:01:18.581 Ich zeige Ihnen das Einfache, dann zeige ich Ihnen den Verknüpfungsteil. 00:01:18.602 --> 00:01:20.383 Nehmen wir zum Beispiel Spalte E. 00:01:20.903 --> 00:01:31.370 Wenn ich Spalte E ausschneide und in J einfüge, wird die Spalte E wie Sie sehen ausgeschnitten und es entsteht eine Lücke. 00:01:33.186 --> 00:01:35.108 Mit Command-Ctrl-Z habe ich es rückgängig gemacht. 00:01:35.188 --> 00:01:37.511 Gleichzeitig kann ich es kopieren und hier einfügen. 00:01:38.873 --> 00:01:46.583 Neben dem Kopieren und Einfügen kann ich es auch in einem verschobenen und verknüpften Datenbereich beispielsweise in ein neues Feld einfügen. 00:01:48.493 --> 00:01:51.234 Okay, wir haben den Kartonabschnitt auf diese Weise abgeschlossen. 00:01:51.294 --> 00:01:59.035 Aber was ist, wenn ich anstelle von Kopieren und Einfügen zwischen zwei Seiten verbunden arbeiten möchte? 00:01:59.416 --> 00:02:01.396 Eine der Operationen, die ich durchführen kann, ist folgende. 00:02:01.456 --> 00:02:02.856 Lassen Sie uns zuerst hier aufräumen. 00:02:04.717 --> 00:02:05.197 Wir haben gelernt. 00:02:05.237 --> 00:02:11.157 Nun, zum Beispiel ist A ein Produkt, B ein Datum, C ein Kundentyp. 00:02:11.258 --> 00:02:15.099 Lassen Sie mich Ihnen zunächst zeigen, wie es gemacht wird. 00:02:15.139 --> 00:02:16.419 Ich möchte die Überschriften verschieben. 00:02:16.500 --> 00:02:17.400 Gleichheitszeichen. 00:02:18.260 --> 00:02:18.720 hinzugefügt. 00:02:19.401 --> 00:02:25.223 Nach dem Hinzufügen des Gleichheitszeichens habe ich A1 ausgewählt, Enter gedrückt und wie Sie sehen, wurde das Produkt hierher verschoben. 00:02:26.163 --> 00:02:44.288 Dann, wenn ich es nach rechts ziehe, werden alle A6-Daten wie Sie sehen, verschoben und mit der Arbeitsmappe unter dem Namen der Seite verbunden. 00:02:44.407 --> 00:02:44.549 der Seite. 00:02:44.589 --> 00:02:48.192 Dann wird angezeigt, welche Zelle ich verschoben habe, C1. 00:02:48.252 --> 00:02:49.313 Was haben wir dann gemacht? 00:02:51.394 --> 00:02:58.831 Durch Doppelklicken auf die rechte Seite der Spalte haben wir alle Spaltenwerte erstellt. 00:02:58.951 --> 00:03:02.453 Wir haben die Informationen in den nicht benötigten Spalten gelöscht. 00:03:02.613 --> 00:03:04.434 Nach dem Löschen haben wir das Feld ausgewählt. 00:03:04.794 --> 00:03:05.355 Wie war es? 00:03:06.096 --> 00:03:08.017 Der Hintergrund war gelb, kursiv. 00:03:08.517 --> 00:03:09.358 Wir haben es kursiv gemacht. 00:03:09.538 --> 00:03:17.203 Was passiert, wenn wir es dann zum Beispiel nach unten ziehen? 00:03:17.403 --> 00:03:17.983 Es wurde kopiert. 00:03:18.063 --> 00:03:19.925 Es hat nicht denselben Vorgang wiederholt, oder? 00:03:20.044 --> 00:03:21.906 Was müssen wir also wieder tun? 00:03:22.006 --> 00:03:23.167 Wir sagen wieder gleich. 00:03:24.781 --> 00:03:26.743 Nachdem wir "gleich" gesagt haben, gehen wir zur nächsten Seite. 00:03:26.883 --> 00:03:28.285 Wir wählen das Getränkefeld aus. 00:03:29.586 --> 00:03:31.907 Wenn wir die Eingabetaste drücken, erscheint das Getränk. 00:03:32.089 --> 00:03:39.877 Wie Sie sehen, wenn Sie es nach unten ziehen, wird ein Feld erstellt, aber das Format war falsch, die Form war falsch, also war es auch gelb. 00:03:39.917 --> 00:03:41.198 Wir wollen nicht, dass es gelb ist. 00:03:41.218 --> 00:03:46.018 Dann ziehen wir es nach unten. 00:03:46.678 --> 00:03:49.300 Wenn wir es ziehen, erscheint Tiefkühlkost bis 45. 00:03:49.340 --> 00:03:54.523 Lassen Sie uns sehen, bis zu welcher Zeile unsere Daten vorhanden sind. 00:03:54.823 --> 00:03:55.263 Bis 59. 00:03:55.544 --> 00:04:02.988 Dann setze ich diese Ziehaktion bis zur 59. Zeile fort. 00:04:05.612 --> 00:04:09.896 Dann stelle ich die Breite der Zellen auf 59 ein. 00:04:10.216 --> 00:04:13.999 Ich ziehe den Getränkebereich nach rechts. 00:04:14.960 --> 00:04:17.541 Wie Sie sehen, sind alle Details gleich geblieben. 00:04:18.222 --> 00:04:20.104 Das Datum hat sich hier geändert. 00:04:20.204 --> 00:04:22.105 Was haben wir damals mit dem Datumformat gemacht? 00:04:22.145 --> 00:04:23.687 Wir haben die Zellen formatiert. 00:04:24.127 --> 00:04:24.928 Wir haben das Datum angepasst. 00:04:25.308 --> 00:04:26.689 Nicht Englisch, nicht USA. 00:04:27.169 --> 00:04:29.031 Unser Bereich wird Türkisch sein. 00:04:29.611 --> 00:04:31.193 Wir suchen hier Türkisch. 00:04:33.171 --> 00:04:34.472 Wir haben Türkei ausgewählt. 00:04:34.592 --> 00:04:35.752 Was haben wir dann gesagt? 00:04:35.872 --> 00:04:38.954 Hier ist das von uns gewählte Datumsformat. 00:04:39.053 --> 00:04:40.975 Lassen Sie uns hier eine beliebige Sprache auswählen. 00:04:40.995 --> 00:04:44.056 Lassen Sie es dieses Mal anders sein, zum Beispiel 14. März 2012. 00:04:44.937 --> 00:04:46.537 Das Format sieht hier so aus. 00:04:46.537 --> 00:04:56.021 Wenn wir auf den 26. Februar 2019 doppelklicken, werden alle Werte automatisch in die Zelle übernommen. 00:04:56.261 --> 00:05:05.564 Sie können dasselbe für alle Spalten tun oder alternativ drei Spalten auswählen und dies für alle drei oder sogar alle Spalten durchführen. 00:05:05.604 --> 00:05:07.045 Was haben wir als Nächstes gemacht? 00:05:09.365 --> 00:05:13.747 Wir haben die Spaltenbreite durch Doppelklicken auf die rechte Spaltenlinie angepasst. 00:05:13.927 --> 00:05:24.592 Nach der Einstellung sehen wir, dass alle Daten hier von der A6-Eltern-Transport- und Bindungsseite stammen. 00:05:24.632 --> 00:05:25.673 Wo sehen wir das? 00:05:25.733 --> 00:05:29.436 Wenn wir über eine Zelle gehen, sehen wir, dass sie von der A6-Arbeitsseite G2 stammt. 00:05:29.476 --> 00:05:34.461 Angenommen, wir haben diesen Vorgang abgeschlossen, aber möchten nicht, dass er verbunden bleibt. 00:05:35.021 --> 00:05:36.743 Wir haben den gesamten Bereich ausgewählt. 00:05:38.524 --> 00:05:39.645 Wir haben Strg-C gedrückt. 00:05:39.725 --> 00:05:44.470 Nach dem Drücken von Strg-C haben wir eine Spalte freigelassen, damit es nicht durcheinander kommt. 00:05:46.113 --> 00:05:47.634 Wir wählen die Zelle I1 aus. 00:05:47.674 --> 00:05:52.199 Nachdem wir auf Rechtsklick geklickt haben, sehen wir hier nur Zahlen, Werte. 00:05:54.473 --> 00:06:01.955 Was passiert, wenn wir nur die Werte mit dem Befehl kopieren und die erforderlichen Einstellungen vornehmen? 00:06:02.055 --> 00:06:06.516 Wir haben es geschafft, die verbundenen Daten zu kopieren und nur als Wert hierher zu kopieren. 00:06:06.576 --> 00:06:10.617 Aber was passiert, wenn Sie es als Wert kopieren? 00:06:10.677 --> 00:06:13.238 Das Datumsformat wird wieder schief. 00:06:13.898 --> 00:06:14.778 Was machen wir dann? 00:06:14.818 --> 00:06:17.619 Wir sagen "Obere Formatierung", gehen zum Datum. 00:06:18.139 --> 00:06:22.520 Wir überprüfen erneut, welches Format wir ausgewählt haben. 00:06:23.339 --> 00:06:28.044 Wenn wir feststellen, dass es richtig ist, drücken wir auf OK, um den Vorgang abzuschließen. 00:06:28.124 --> 00:06:30.065 Wir nehmen das hier wieder auf, machen es gelb. 00:06:30.526 --> 00:06:34.630 Was haben wir gemacht, um zu verbergen, woher die Originaldaten stammen? 00:06:34.730 --> 00:06:36.071 Wir haben alle Spalten ausgewählt. 00:06:36.212 --> 00:06:43.517 Wenn wir auf die Schaltfläche rechts klicken und auf Ausblenden klicken, bleiben nur die Werte in unserer Hand. 00:06:46.243 --> 00:06:48.964 Für die Arbeit, die wir hier machen werden, wiederholen wir es. 00:06:49.004 --> 00:06:53.287 Es ist möglich, erforderliche Operationen durch Hinzufügen eines Filters im Datenbereich durchzuführen. 00:06:55.688 --> 00:06:59.150 Ich habe die Änderungen mit der Strg-S-Taste gespeichert. 00:06:59.810 --> 00:07:07.234 Wenn ich zu den Datums- und Kalenderoptionen gehe, gibt es hier verschiedene Termine nach Tag, Monat, Jahr und Datumseinstellungen. 00:07:07.394 --> 00:07:12.377 Lassen Sie uns eine Arbeit machen, wie wir diese Termine erstellen können.

WEBVTT 00:00:01.274 --> 00:00:05.535 But exercise six, moving and binding data, my friends. 00:00:06.136 --> 00:00:17.419 If we have friends who are accountants and auditors, that is, those who do accounting and auditing, they will already know what we mean by moving and binding data. 00:00:17.459 --> 00:00:17.819 If not, I would like to show you what I mean by this and related to this topic. 00:00:19.220 --> 00:00:24.882 Now, let's say I want to move certain values on this sales list to a different area. 00:00:36.463 --> 00:00:37.543 What are the ways to do this? 00:00:38.325 --> 00:00:39.946 First, I create a new page. 00:00:39.986 --> 00:00:43.929 After creating a new page, I say exercise six. 00:00:44.129 --> 00:00:47.891 We always put the names of our pages specifically. 00:00:47.932 --> 00:00:51.054 So that there is no confusion in the work done later. 00:00:52.475 --> 00:00:59.640 We said A6 moving and binding data, let's say the data has been moved and bound. 00:01:02.571 --> 00:01:12.498 Now, one of the operations we can do about moving and binding. 00:01:13.058 --> 00:01:18.581 Let me show you the simple part first, then I will show you the binding part. 00:01:18.602 --> 00:01:20.383 Now, for example, we selected column E. 00:01:20.903 --> 00:01:31.370 When I cut column E and paste it to J, as you can see, column E was cut and a gap appeared in the middle. 00:01:33.186 --> 00:01:35.108 I undid it with Command-Ctrl-Z. 00:01:35.188 --> 00:01:37.511 At the same time, I can copy and paste it here. 00:01:38.873 --> 00:01:46.583 In addition to copying and pasting, I can also copy it, move it, and paste it into a new field in the moved and linked data section, for example. 00:01:48.493 --> 00:01:51.234 Okay, we completed the number of boxes part like this. 00:01:51.294 --> 00:01:59.035 So, for example, instead of copying and pasting, I want to work between two pages in a linked way. 00:01:59.416 --> 00:02:01.396 One of the operations I can do is this. 00:02:01.456 --> 00:02:02.856 First, let's clear this area. 00:02:04.717 --> 00:02:05.197 We learned. 00:02:05.237 --> 00:02:11.157 Now, for example, A is a product, B is a date, C is a customer type. 00:02:11.258 --> 00:02:15.099 First, let me show you how to do this. 00:02:15.139 --> 00:02:16.419 I want to move the titles. 00:02:16.500 --> 00:02:17.400 Equal sign. 00:02:18.260 --> 00:02:18.720 I put. 00:02:19.401 --> 00:02:25.223 After putting the equal sign, I selected A1, pressed Enter, and as you can see, the product moved here. 00:02:26.163 --> 00:02:44.288 Then, when I drag it to the right side like this, all these A6 data moving and linking exercises you see here are the name of the first worksheet 00:02:44.407 --> 00:02:44.549 page. 00:02:44.589 --> 00:02:48.192 Then, it shows which cell I moved, C1. 00:02:48.252 --> 00:02:49.313 What did we do next? 00:02:51.394 --> 00:02:58.831 By double-clicking on the right side of the column, we created all column values. 00:02:58.951 --> 00:03:02.453 We deleted the unnecessary information in the columns that were incorrect for us. 00:03:02.613 --> 00:03:04.434 After deleting, we selected the area. 00:03:04.794 --> 00:03:05.355 How was it? 00:03:06.096 --> 00:03:08.017 The background was yellow, it was italicized. 00:03:08.517 --> 00:03:09.358 We italicized it. 00:03:09.538 --> 00:03:17.203 Then, when we took it and dragged it down, what did it do? 00:03:17.403 --> 00:03:17.983 It copied. 00:03:18.063 --> 00:03:19.925 It didn't perform the same operation, did it? 00:03:20.044 --> 00:03:21.906 So, what is the operation we need to do again? 00:03:22.006 --> 00:03:23.167 We say "equals" again. 00:03:24.781 --> 00:03:26.743 After saying "equals," we go to the other page. 00:03:26.883 --> 00:03:28.285 We select the beverage area. 00:03:29.586 --> 00:03:31.907 When we press the Enter key, the beverage appeared. 00:03:32.089 --> 00:03:39.877 As you can see, when you move it downwards, a field is created, but the format was wrong, the style was wrong, it was also yellow. 00:03:39.917 --> 00:03:41.198 We don't want it to be yellow. 00:03:41.218 --> 00:03:46.018 Then we take it and drag it down. 00:03:46.678 --> 00:03:49.300 When we drag it, frozen food came up to 45. 00:03:49.340 --> 00:03:54.523 Let's see how many rows of data we have, how many entries we have. 00:03:54.823 --> 00:03:55.263 Up to 59. 00:03:55.544 --> 00:04:02.988 Then, my friends, I continue this drag operation up to the 59th row. 00:04:05.612 --> 00:04:09.896 Then I adjust the width of the cells to 59. 00:04:10.216 --> 00:04:13.999 Similarly, I take the drink area and drag it to the right. 00:04:14.960 --> 00:04:17.541 As you can see, all the details came the same way. 00:04:18.222 --> 00:04:20.104 The date is different here. 00:04:20.204 --> 00:04:22.105 What were we doing with the date format back then? 00:04:22.145 --> 00:04:23.687 We were formatting the cells. 00:04:24.127 --> 00:04:24.928 We were saying date. 00:04:25.308 --> 00:04:26.689 Not English US. 00:04:27.169 --> 00:04:29.031 Our region will be Turkish. 00:04:29.611 --> 00:04:31.193 We are looking for Turkish here. 00:04:33.171 --> 00:04:34.472 We selected Turkish Turkey. 00:04:34.592 --> 00:04:35.752 What did we say next? 00:04:35.872 --> 00:04:38.954 The format we selected as the date here. 00:04:39.053 --> 00:04:40.975 Let's make it any language here. 00:04:40.995 --> 00:04:44.056 Let it be different this time, for example, as March 14, 2012. 00:04:44.937 --> 00:04:46.537 For example, the format appeared like this here. 00:04:46.537 --> 00:04:56.021 When we double-clicked on February 26, 2019, all values automatically came to the corner of the cell. 00:04:56.261 --> 00:05:05.564 You can perform the same operations for all columns or alternatively select three columns and do it for those three, or even for all columns. 00:05:05.604 --> 00:05:07.045 What did we do next? 00:05:09.365 --> 00:05:13.747 We adjusted the column sizes by double-clicking on the column line on the right side. 00:05:13.927 --> 00:05:24.592 As we can see after setting it up, all the data here came from the A6 parents transport and attachment page. 00:05:24.632 --> 00:05:25.673 How do we see this? 00:05:25.733 --> 00:05:29.436 When we hover over a cell, we saw that it came from cell G2 of the A6 worksheet. 00:05:29.476 --> 00:05:34.461 So, let's say we completed this process but we don't want it to remain linked. 00:05:35.021 --> 00:05:36.743 We selected the entire region. 00:05:38.524 --> 00:05:39.645 We pressed Control-C. 00:05:39.725 --> 00:05:44.470 After pressing Control-C, we left a column gap so it wouldn't mix. 00:05:46.113 --> 00:05:47.634 We select cell I1. 00:05:47.674 --> 00:05:52.199 After clicking on the right mouse button, here we only have numbers, values. 00:05:54.473 --> 00:06:01.955 When we bring only the values with the command and make the necessary adjustments, what do we notice this time? 00:06:02.055 --> 00:06:06.516 We managed to copy the linked data here only as values. 00:06:06.576 --> 00:06:10.617 But what will happen when you copy as values? 00:06:10.677 --> 00:06:13.238 The date format will become plain again. 00:06:13.898 --> 00:06:14.778 So what do we do? 00:06:14.818 --> 00:06:17.619 We say format the cells, go to date. 00:06:18.139 --> 00:06:22.520 We check once again which format we selected here. 00:06:23.339 --> 00:06:28.044 After deciding that it is appropriate, when we press OK, the process is completed. 00:06:28.124 --> 00:06:30.065 We are taking this again, making it yellow. 00:06:30.526 --> 00:06:34.630 What were we doing to hide where the original data came from? 00:06:34.730 --> 00:06:36.071 We selected all columns. 00:06:36.212 --> 00:06:43.517 When we clicked on the hide button on the right side, only the values in our hands remained. 00:06:46.243 --> 00:06:48.964 For the work we will do here, let's repeat it again. 00:06:49.004 --> 00:06:53.287 It is possible to perform the necessary operations by coming to the data field and adding filters. 00:06:55.688 --> 00:06:59.150 I saved the changes I made with the Ctrl-S key. 00:06:59.810 --> 00:07:07.234 When I come to the date settings and calendar section, there are various dates here according to the day, month, year, and day settings. 00:07:07.394 --> 00:07:12.377 Let's work on how we can create these dates, for example.

WEBVTT 00:00:01.274 --> 00:00:05.535 Ama alıştırma altı, verileri taşıma ve bağlama arkadaşlar. 00:00:06.136 --> 00:00:17.419 Verileri ve taşıma ve bağlamayla ilgili bağlamadan kastettiğimiz şeyin ne olduğunu eğer muhasebe ve audit yani kontrol, denetçilik yapan arkadaşlar varsa 00:00:17.459 --> 00:00:17.819 bilecekler zaten. 00:00:19.220 --> 00:00:24.882 Değilse de ben şimdi size bu konuda ne bahsettiğimi bu konuyla ilgili göstermek isterim. 00:00:24.982 --> 00:00:36.443 Şimdi diyelim ki ben Bu satış listesi üzerinde belirli değerleri farklı bir alana geçirmek istiyorum. 00:00:36.463 --> 00:00:37.543 Bunun için yollar ne? 00:00:38.325 --> 00:00:39.946 İlk başta yeni sayfa oluşturuyorum. 00:00:39.986 --> 00:00:43.929 Yeni sayfa oluşturduktan sonra diyorum ki alıştırma altı. 00:00:44.129 --> 00:00:47.891 Her zaman sayfalarımızın ismini spesifik olarak koyuyoruz. 00:00:47.932 --> 00:00:51.054 Daha sonra yapılan çalışmalarda herhangi bir karışıklık olmasın diye. 00:00:52.475 --> 00:00:59.640 A6 verileri taşıma ve bağlama dedik ki taşınmış ve bağlanmış veri diyelim. 00:01:02.571 --> 00:01:12.498 Şimdi taşıma ve bağlanma konusunda arkadaşlar yapabileceğimiz işlemlerden bir tanesi. 00:01:13.058 --> 00:01:18.581 Ben size şey göstereyim basit olan kısmı göstereyim daha sonra bağlama kısmını göstereyim. 00:01:18.602 --> 00:01:20.383 Şimdi mesela kolon E'yi seçtik. 00:01:20.903 --> 00:01:31.370 Ben kolon E'yi alıp kes dediğimde J'ye getirip yapıştır dediğimde kolon E'ye gördüğünüz gibi kesildi ve ortada boşluk oluştu. 00:01:33.186 --> 00:01:35.108 Command-Ctrl-Z ile geriye aldım. 00:01:35.188 --> 00:01:37.511 Aynı zamanda kopyala deyip buraya alabilirim. 00:01:38.873 --> 00:01:46.583 Kopyala deyip almamın yanı sıra aynı zamanda ben bunu kopyalayıp taşınmış ve bağlanmış veri kısmında mesela yeni bir alana da yapıştırabilirim. 00:01:48.493 --> 00:01:51.234 Tamam adet koli kısmını bu şekilde gerçekleştirdik. 00:01:51.294 --> 00:01:59.035 Peki ben bunu mesela kopyala yapıştırı yerine iki tane sayfa arasında bağlantılı olarak çalışmak istiyorum. 00:01:59.416 --> 00:02:01.396 Yapabileceğim işlemlerden bir tanesi şu. 00:02:01.456 --> 00:02:02.856 İlk başta şurayı temizleyelim. 00:02:04.717 --> 00:02:05.197 Öğrendik. 00:02:05.237 --> 00:02:11.157 Şimdi mesela A bir ürün, B bir tarih, C bir müşteri tipi. 00:02:11.258 --> 00:02:15.099 İlk başta gelin bunu size göstereyim nasıl yapılacağını. 00:02:15.139 --> 00:02:16.419 Başlıkları taşımak istiyorum. 00:02:16.500 --> 00:02:17.400 Eşittir işareti. 00:02:18.260 --> 00:02:18.720 koydum. 00:02:19.401 --> 00:02:25.223 Eşittir işareti koyduktan sonra A1'i seçtim, Enter'a bastım ve gördüğünüz gibi ürün buraya taşındı. 00:02:26.163 --> 00:02:44.288 Daha sonra alıp sağ tarafına şöyle çektiğim zaman bu alanı bütün gördüğünüz gibi A6 verileri taşıma ve bağlama alıştırma altı ilk başta çalışma kitabının 00:02:44.407 --> 00:02:44.549 sayfasının adı. 00:02:44.589 --> 00:02:48.192 Daha sonra da hangi hücreyi taşıdığım C1 burada gözüküyor. 00:02:48.252 --> 00:02:49.313 Daha sonra ne yapmıştık? 00:02:51.394 --> 00:02:58.831 Sağ tarafına kolonun çift tıklayarak bütün kolon değerlerini oluşturduk. 00:02:58.951 --> 00:03:02.453 Yanlış olan bize gerekli olmayan kolonlardaki bilgileri sildik. 00:03:02.613 --> 00:03:04.434 Sildikten sonra alanı seçtik. 00:03:04.794 --> 00:03:05.355 Nasıldı? 00:03:06.096 --> 00:03:08.017 Arka plan sarıydı, italikti. 00:03:08.517 --> 00:03:09.358 Italik yaptık. 00:03:09.538 --> 00:03:17.203 Daha sonra alıp mesela aynı şekilde aşağı doğru çektiğimizde ne yaptı? 00:03:17.403 --> 00:03:17.983 Kopyaladı. 00:03:18.063 --> 00:03:19.925 Aynı işlemi gerçekleştirmedi değil mi? 00:03:20.044 --> 00:03:21.906 O zaman yapmamız gereken işlem ne yine? 00:03:22.006 --> 00:03:23.167 Yine eşittir diyoruz. 00:03:24.781 --> 00:03:26.743 Eşitli dedikten sonra diğer sayfa gidiyoruz. 00:03:26.883 --> 00:03:28.285 İçecek alanını seçiyoruz. 00:03:29.586 --> 00:03:31.907 Enter tuşuna bastığımız zaman içecek geldi. 00:03:32.089 --> 00:03:39.877 Gördüğünüz gibi hem aşağı doğru taşıdığınızda bir alana oluştu fakat formati yanlıştı, biçimi yanlıştı yani o da sarıydı. 00:03:39.917 --> 00:03:41.198 Biz sarı gelmesini istemiyoruz. 00:03:41.218 --> 00:03:46.018 Daha sonra Alıp bunu aşağı doğru çekiyoruz. 00:03:46.678 --> 00:03:49.300 Çektiğimiz zaman donmuş gıda 45'e kadar geldi. 00:03:49.340 --> 00:03:54.523 Bakalım kaçıncı satıra kadar datamız varmış, verimiz varmış. 00:03:54.823 --> 00:03:55.263 59'a kadar. 00:03:55.544 --> 00:04:02.988 O zaman arkadaşlar 59'uncu satıra kadar bu sürükle işlemine devam ettiriyorum. 00:04:05.612 --> 00:04:09.896 Daha sonra hücrelerin genişliğini ayarlıyorum 59'a kadar. 00:04:10.216 --> 00:04:13.999 Aynı şekilde içecek alanını alıp sağa doğru sürüklüyorum. 00:04:14.960 --> 00:04:17.541 Gördüğünüz gibi bütün detaylar aynı şekilde geldi. 00:04:18.222 --> 00:04:20.104 Tarih burada farklı oluştu. 00:04:20.204 --> 00:04:22.105 Tarih formatını o zaman ne yapıyorduk? 00:04:22.145 --> 00:04:23.687 Hücreleri biçimlendir diyorduk. 00:04:24.127 --> 00:04:24.928 Tarih diyorduk. 00:04:25.308 --> 00:04:26.689 İngilizce ABD değil. 00:04:27.169 --> 00:04:29.031 Bizim alanımız Türkçe olacak. 00:04:29.611 --> 00:04:31.193 Buradan Türkçeyi arıyoruz. 00:04:33.171 --> 00:04:34.472 Türkçe Türkiye'yi seçtik. 00:04:34.592 --> 00:04:35.752 Daha sonra ne demiştik? 00:04:35.872 --> 00:04:38.954 Burada tarih olarak bizim seçtiğimiz format. 00:04:39.053 --> 00:04:40.975 Mesela buradaki herhangi bir dilini yapalım. 00:04:40.995 --> 00:04:44.056 Bu sefer farklı olsun mesela 14 Mart 2012 olarak. 00:04:44.937 --> 00:04:46.537 Mesela burada format böyle gözükmüş. 00:04:46.537 --> 00:04:56.021 26 Şubat 2019 çift tıkladığımız zaman hücrenin köşesine bütün değerler otomatik olarak geldi. 00:04:56.261 --> 00:05:05.564 Aynı işlerini bütün sütunlar için gerçekleştirebilirsiniz veya alternatif olarak üç tane sütünü seçip bunu üçü içinde hatta bütün sütunlar içinde yapabilirsiniz. 00:05:05.604 --> 00:05:07.045 Daha sonra ne yaptık? 00:05:09.365 --> 00:05:13.747 Sağ taraftaki kolon çizgisine çift tıklayarak kolon boyutlarını ayarladık. 00:05:13.927 --> 00:05:24.592 Ayarladıktan sonra gördüğümüz gibi buradaki verilerin hepsi A6 velileri taşıma ve bağlama sayfasından geldi. 00:05:24.632 --> 00:05:25.673 Bunu nereden görüyoruz? 00:05:25.733 --> 00:05:29.436 Bir hücrenin üzerine geldiğimizde A6 çalışma sayfası G2'den geldiğini gördük. 00:05:29.476 --> 00:05:34.461 Peki diyelim ki biz bu işlemi tamamladık fakat bu bağlı kalmasını istemiyoruz. 00:05:35.021 --> 00:05:36.743 Aldık bütün bölgeyi seçtik. 00:05:38.524 --> 00:05:39.645 Control-C yaptık. 00:05:39.725 --> 00:05:44.470 Control-C yaptıktan sonra araya bir tane kolon boşluk bıraktık ki karışmasın. 00:05:46.113 --> 00:05:47.634 I1 hücresini seçiyoruz. 00:05:47.674 --> 00:05:52.199 Sağ far ödümesiye tıkladıktan sonra burada sadece sayıları, değerler. 00:05:54.473 --> 00:06:01.955 komutuyla sadece değerleri getirdiğimizde ve yine gerekli olan ayarları yaptığınızda bu sefer ne fark ediyoruz? 00:06:02.055 --> 00:06:06.516 Bağlanmış olan verileri biz alıp sadece değer olarak buraya kopyalamayı becerdik. 00:06:06.576 --> 00:06:10.617 Fakat değer olarak kopyada aldığınızda fark ettiğiniz şey ne olacak? 00:06:10.677 --> 00:06:13.238 Tarih formatı yine kayık hale geldi. 00:06:13.898 --> 00:06:14.778 O zaman ne yapıyoruz? 00:06:14.818 --> 00:06:17.619 Yüceleri biçimlendir diyoruz, tarihe geliyoruz. 00:06:18.139 --> 00:06:22.520 Burada seçtiğimiz formatın hangisi olduğunu, biçimin hangisi olduğunu bir kez daha bakıyoruz. 00:06:23.339 --> 00:06:28.044 Baktığımızın uygun olduğuna karar verip tamam komutuna bastığımızda işlem tamamlanıyor. 00:06:28.124 --> 00:06:30.065 Burayı alıyoruz tekrar, sarı yapıyoruz. 00:06:30.526 --> 00:06:34.630 Orijinal data'nın nereden geldiğini saklamak için ne yapıyorduk? 00:06:34.730 --> 00:06:36.071 Bütün kolonları seçtik. 00:06:36.212 --> 00:06:43.517 Sağ farö düğmesiyle gizle dediğimizde sadece bizim elimizde değerler kalmış oldu. 00:06:46.243 --> 00:06:48.964 Burada yapacağımız çalışma için ise yine tekrarlayalım. 00:06:49.004 --> 00:06:53.287 Veri alanına gelip filtre ekleyerek gerekli olan işlemleri gerçekleştirmemiz mümkün. 00:06:55.688 --> 00:06:59.150 Ctrl-S tuşuyla yaptığım değişiklikleri kaydettim. 00:06:59.810 --> 00:07:07.234 Tarih ayarları ve takvim kısmına geldiğimde güne göre, aya göre, yıla göre ve gün ayarlarına göre burada çeşitli tarihler var. 00:07:07.394 --> 00:07:12.377 Bu tarihleri mesela nasıl oluşturacağımıza dair bir çalışma yapalım.