İstatistik Alıştırmaları 5

WEBVTT 00:00:00.049 --> 00:00:09.234 Hallo Freunde, wir werden mit dem 17. Schritt der statistischen Übungen in unserem 5. und letzten Teil des Videos fortfahren. 00:00:09.294 --> 00:00:11.055 Wenn ihr bereit seid, lasst uns weitermachen. 00:00:11.055 --> 00:00:15.037 Bevor wir mit Schritt 17 beginnen, möchte ich euch etwas zeigen. 00:00:15.597 --> 00:00:25.482 Wie ihr euch vielleicht erinnert, haben wir in eurem vorherigen Schritt gemeinsam die durchschnittlichen maximalen und minimalen Werte unseres Nettoumsatzes in Euro berechnet. 00:00:26.122 --> 00:00:34.251 Wenn wir diese Bewertungen auf andere Zeilen oder andere Spalten übertragen möchten, ziehen wir es erneut von der Ecke aus. 00:00:35.112 --> 00:00:40.698 Wie ihr sehen könnt, haben wir wieder den maximalen und minimalen Wert innerhalb des Bruttoumsatzes in Euro gefunden. 00:00:41.118 --> 00:00:48.742 Wir haben auch den größten, den kleinsten und den durchschnittlichen Wert unseres Gewinns in TL gefunden. 00:00:48.822 --> 00:00:58.106 Das einzige, worauf wir hier achten müssen, ist, dass jegliche Formatierung, Währungsumrechnung usw., die wir in der Zelle gestartet haben, auch auf andere Zeilen übertragen wird. 00:00:58.126 --> 00:01:01.068 Dies kann zu Fehlern führen, da die Werte oben eigentlich in türkischer Lira sind, während unten Euro angezeigt wird. 00:01:01.708 --> 00:01:07.851 Wir müssen das sofort korrigieren. 00:01:08.611 --> 00:01:10.191 Wir müssen dies sofort korrigieren. 00:01:10.912 --> 00:01:21.160 Wir müssen die Zellen identifizieren, die korrigiert werden müssen, und dann die richtige Währungsformatierung anwenden. 00:01:21.800 --> 00:01:25.443 Lassen Sie uns auf diese Weise mit unserem 17. Schritt fortfahren. 00:01:25.443 --> 00:01:29.824 Es wurde gefordert, dass wir den versteckten Call Stun in unserem 17. Schritt sichtbar machen. 00:01:30.324 --> 00:01:38.467 Wie ich hier erwähnt habe, wird der zwischen J und L liegende Call Stun sichtbar, wenn wir mit der rechten Maustaste darauf klicken. 00:01:38.607 --> 00:01:41.788 Hier gab es eine andere Stun-Information. 00:01:42.128 --> 00:01:46.769 Obwohl es ein Teil unserer Tabelle hier ist. 00:01:47.666 --> 00:01:48.907 Wir haben das erfolgreich abgeschlossen. 00:01:48.967 --> 00:02:00.733 In unserem nächsten Schritt wurde uns gesagt, dass wir in die Zelle K4 U4 1500 eingeben sollen, wenn es über 1 Million 500 Tausend liegt, geben Sie eine Formel ein, die in Akstart Nein ergibt. 00:02:01.033 --> 00:02:02.474 Lassen Sie uns wieder zur Zelle K4 gehen. 00:02:04.455 --> 00:02:05.716 Diese K4-Zelle. 00:02:05.816 --> 00:02:09.098 Hier müssen wir eine Operation aus den Formeln hinzufügen. 00:02:09.679 --> 00:02:10.619 Dann EER. 00:02:11.260 --> 00:02:11.940 Wir haben OK gedrückt. 00:02:12.380 --> 00:02:13.401 Logische Prüfung. 00:02:15.542 --> 00:02:18.124 Die uns gegebene Prüfung. 00:02:18.244 --> 00:02:21.226 Muss größer sein als 1.500.000 Lira. 00:02:22.207 --> 00:02:23.488 Fügen wir hinzu, gehen wir so vor. 00:02:25.508 --> 00:02:27.370 Lassen Sie uns so vorgehen, wählen wir sogar I4 aus. 00:02:28.270 --> 00:02:28.531 I4. 00:02:30.151 --> 00:02:30.632 Ist größer. 00:02:31.333 --> 00:02:31.493 Als. 00:02:31.493 --> 00:02:37.931 1 Million 500 Tausend, denke ich. 00:02:39.775 --> 00:02:43.603 Wenn es größer ist, ja, sonst nein. 00:02:45.171 --> 00:02:46.052 muss geschrieben werden. 00:02:46.732 --> 00:02:49.834 Wie Sie sehen, habe ich meinen Test geschrieben und abgeglichen. 00:02:51.514 --> 00:02:59.959 Wie Sie sehen, da der Wert U4 hier mehr als 1,5 Millionen beträgt, hat er hier "Ja" geschrieben. 00:03:00.960 --> 00:03:06.643 Um diesen Vorgang auf unsere anderen Zeilen anzuwenden, ziehe ich wieder an der Ecke wie folgt. 00:03:07.543 --> 00:03:12.586 Wie Sie sehen, ergab der Test manchmal "Ja", manchmal "Nein". 00:03:14.007 --> 00:03:16.331 Wir haben auch diesen Schritt erfolgreich abgeschlossen. 00:03:16.451 --> 00:03:20.393 Wir haben die geforderte Formel auch auf den Bereich K5-K15 angewendet. 00:03:21.514 --> 00:03:27.317 In unserem nächsten Schritt wurde uns gebeten, ein gruppiertes Säulendiagramm zu erstellen. 00:03:27.857 --> 00:03:29.157 Lassen Sie uns diese Bereiche auswählen. 00:03:29.558 --> 00:03:35.762 Diese Bereiche sind B3-15, H3-15, I3-15. 00:03:36.282 --> 00:03:37.163 B, H und I. 00:03:37.903 --> 00:03:49.415 Also dieser Bereich B, B, Ich halte auch die STRG-Taste gedrückt, damit diese Auswahl erfolgreich ist... 00:03:52.911 --> 00:03:59.993 Hier müssen wir ein Säulendiagramm erstellen, um Ausgaben und Einnahmen vergleichen zu können. 00:04:00.353 --> 00:04:04.194 Wie Sie sehen, habe ich diese drei Säulen wie gewünscht ausgewählt. 00:04:04.914 --> 00:04:16.358 Dann können wir durch Klicken auf die empfohlenen Diagramme im Einfügen-Menü das gruppierte Säulendiagramm hier finden. 00:04:16.954 --> 00:04:30.083 Wenn wir es anderswo finden möchten, können wir im Diagramme-Menü auch ein gestapeltes Säulendiagramm oder ein gruppiertes Balkendiagramm auswählen. 00:04:30.123 --> 00:04:30.663 Wir haben die Option. 00:04:31.383 --> 00:04:34.445 Aber was von uns verlangt wurde, war gruppierte Milch. 00:04:34.585 --> 00:04:35.386 Ich habe das wieder angeklickt. 00:04:36.901 --> 00:04:41.964 Und damit haben wir diesen Schritt erfolgreich abgeschlossen. 00:04:43.267 --> 00:04:48.471 Im nächsten Schritt soll die linke obere Ecke dieses Diagramms auf B26 positioniert werden. 00:04:48.951 --> 00:04:54.596 Es wurde gesagt, das Diagramm so zu erweitern, dass es 50 Zellen über B26 reicht. 00:04:55.916 --> 00:05:02.621 Es wurde uns gesagt, dass wir es hier greifen und nach B26 bringen sollen. 00:05:04.082 --> 00:05:09.926 Wir wurden gebeten, von Zelle B26 aus zu greifen und es bis K50 zu ziehen. 00:05:10.586 --> 00:05:15.309 So kann ich K50 von hier aus sehen. 00:05:17.050 --> 00:05:18.170 So habe ich es gemacht. 00:05:19.971 --> 00:05:20.171 Ja. 00:05:23.134 --> 00:05:27.536 So konnten wir auch die Schaltfläche nach unseren Wünschen ändern. 00:05:28.315 --> 00:05:37.761 Aber im nächsten Schritt wurde uns gesagt, den Diagrammtitel zu entfernen und einen Gewinnvergleich durchzuführen. 00:05:37.880 --> 00:05:42.863 Ich werde das hier gleich entfernen. 00:05:53.611 --> 00:06:05.743 Auf diese Weise leitet uns Excel, wenn wir auf ein beliebiges Diagramm klicken, zum Diagrammdesignfeld. 00:06:07.834 --> 00:06:10.096 Wir können die Farben nach Belieben ändern. 00:06:10.616 --> 00:06:11.196 Sie sehen. 00:06:11.857 --> 00:06:15.699 Ein sehr benutzerfreundlicher Bereich. 00:06:16.140 --> 00:06:19.842 Hier können wir die Achsen unseres Diagramms ändern. 00:06:20.282 --> 00:06:22.424 Oder wir können unsere Achsentitel ändern. 00:06:24.125 --> 00:06:27.187 Wir können Grafiktitel hinzufügen, Datenbeschriftungen platzieren. 00:06:27.226 --> 00:06:32.290 Wir können angeben, welche Zahl welchen Wert in unseren Spalten darstellt. 00:06:33.471 --> 00:06:37.512 Oder wir können einige Richtlinien einfügen. 00:06:37.873 --> 00:06:40.855 Vielleicht macht das das Lesen einfacher. 00:06:41.596 --> 00:06:43.638 Oder wir können zusätzliche Indikatoren hinzufügen. 00:06:43.798 --> 00:06:45.019 Wir können Legenden hinzufügen. 00:06:45.420 --> 00:06:47.061 Hier habe ich eine hinzugefügt. 00:06:47.842 --> 00:06:51.286 Das blaue Nettoergebnis bedeutet in TL. 00:06:52.947 --> 00:06:57.349 Die orangefarbenen zeigen an, dass es sich um Gewinn in TL handelt. 00:06:57.409 --> 00:07:11.815 Solche Darstellungen werden häufig verwendet und je verständlicher wir unser Diagramm machen, desto besser können wir zeigen, wie qualitativ hochwertig unsere Arbeit ist. 00:07:12.035 --> 00:07:15.756 Das ist auch für unsere Arbeit sehr gut. 00:07:16.797 --> 00:07:18.357 Lassen Sie uns den nächsten Schritt betrachten. 00:07:19.278 --> 00:07:20.478 Das haben wir erfolgreich abgeschlossen. 00:07:22.233 --> 00:07:35.262 In Ihrem nächsten Schritt wurde angewiesen, die Bereiche B3-15 und J3-J15 auszuwählen und für diesen ausgewählten Bereich ein 3D-Säulendiagramm zu erstellen. 00:07:36.022 --> 00:07:42.867 Lassen Sie uns zu B3 bis B15, J3 bis J15 gehen. 00:07:43.828 --> 00:07:45.069 Ich habe es wieder von hier ausgewählt. 00:07:45.309 --> 00:07:47.130 Mit B3... 00:07:47.750 --> 00:07:50.492 Während die CTL-Taste gedrückt ist, wähle ich hier aus. 00:07:50.993 --> 00:07:51.473 Ausgewählt. 00:07:52.179 --> 00:07:53.619 Wir gehen wieder zum Hinzufügen. 00:07:53.880 --> 00:07:57.721 Dann haben wir hier unsere Tortendiagramme. 00:07:58.441 --> 00:08:08.744 Wenn wir eine 3D-Torte wollen, können wir hier klicken und uns anhand des angezeigten Diagramms für eine Entscheidung zwischen 2D- und 3D-Torten entscheiden. 00:08:09.344 --> 00:08:22.638 Aber ich klicke hier direkt darauf, um das angeforderte 3D-Tortendiagramm hinzuzufügen, und bewege die 3D-Torte auf eine neue Seite. 00:08:22.818 --> 00:08:25.080 Benennen Sie die Seite als Gewinnraten. 00:08:25.720 --> 00:08:41.811 Ich sage hier zuerst "Ausschneiden" oder "Grafik verschieben" auf eine neue Seite, dann gebe ich den geforderten Namen "Gewinnraten" ein und drücke Enter. 00:08:41.851 --> 00:08:43.472 Wie Sie sehen, zeigt uns das neu geöffnete Blatt ein Tortendiagramm der Gewinnraten. 00:08:43.912 --> 00:08:53.275 Wenn wir möchten, können wir hier etwas markieren, einen Wert in unserer Torte halten und ihn so ziehen, um die Segmente hervorzuheben und zu betonen. 00:09:02.997 --> 00:09:07.440 Wenn wir möchten, können wir diese Art von Optionen verwenden, um sie stärker hervorzuheben. 00:09:07.900 --> 00:09:11.062 Hier gibt es auch verschiedene Vorschauen und Grafikstile. 00:09:11.162 --> 00:09:15.245 Wir können sie je nach Bedarf und Ziel verwenden. 00:09:15.945 --> 00:09:19.107 Ebenso können auch einige Änderungen in Bezug auf die Farben vorgenommen werden. 00:09:19.647 --> 00:09:24.530 Diese hängen vollständig von Ihren Wünschen ab. 00:09:25.530 --> 00:09:29.394 Ich habe versucht, die Grafiken auf diese Weise für Sie zu interpretieren. 00:09:29.774 --> 00:09:31.615 Ich hoffe, Sie finden es nützlich. 00:09:32.275 --> 00:09:33.155 Ich wünsche Ihnen viel Erfolg.

WEBVTT 00:00:00.049 --> 00:00:09.234 Hello friends, we will continue from the 17th step of statistical studies, which is the 5th and final part of our video. 00:00:09.294 --> 00:00:11.055 If you are ready, let's continue. 00:00:11.055 --> 00:00:15.037 Before starting step 17, I want to show you something. 00:00:15.597 --> 00:00:25.482 As you know from your previous step, we calculated the average maximum and minimum values of our net revenue in euros together. 00:00:26.122 --> 00:00:34.251 If we want to transfer these evaluations to other rows, we can do it by dragging it from the corner like this. 00:00:35.112 --> 00:00:40.698 As you can see, we found the minimum and maximum values within the euro currency in our gross revenue. 00:00:41.118 --> 00:00:48.742 Or we have also found the largest, smallest, and average values of our profit in TL. 00:00:48.822 --> 00:00:58.106 The only thing we need to pay attention to here is that if there is any formatting, currency formatting, etc. in the cell where we started the filling process, it is also transferred to other rows. 00:00:58.126 --> 00:01:01.068 This formatting can cause some errors because the values we mentioned above are actually in Turkish lira while they appear as Euro below. 00:01:01.708 --> 00:01:07.851 This needs to be corrected immediately. 00:01:08.611 --> 00:01:10.191 We need to correct this right away. 00:01:10.912 --> 00:01:21.160 Again, we need to identify the cells that need to be corrected, and then apply the necessary currency formatting correctly. 00:01:21.800 --> 00:01:25.443 Let's continue from our 17th step in this way. 00:01:25.443 --> 00:01:29.824 We were asked to make the hidden Call Stun in our 17th step visible. 00:01:30.324 --> 00:01:38.467 As I mentioned, by right-clicking on the Call Stun between J and L, it will become visible as I show. 00:01:38.607 --> 00:01:41.788 There was a different Stun here. 00:01:42.128 --> 00:01:46.769 However, it is a part of our table here. 00:01:47.666 --> 00:01:48.907 We have successfully completed this. 00:01:48.967 --> 00:02:00.733 In our next step, it was instructed to enter a formula that gives a "yes" answer in Akstart if U4 in cell K4 is greater than 1,500,000. 00:02:01.033 --> 00:02:02.474 Let's go to cell K4 again. 00:02:04.455 --> 00:02:05.716 This is cell K4. 00:02:05.816 --> 00:02:09.098 Here, we need to add a formula from the formulas. 00:02:09.679 --> 00:02:10.619 Then EER. 00:02:11.260 --> 00:02:11.940 We clicked OK. 00:02:12.380 --> 00:02:13.401 Logical test. 00:02:15.542 --> 00:02:18.124 The test given to us here. 00:02:18.244 --> 00:02:21.226 Must be greater than 1,500,000 liras in I4. 00:02:22.207 --> 00:02:23.488 Let's add it like this, let's go like this. 00:02:25.508 --> 00:02:27.370 Let's go like this, let's even select I4. 00:02:28.270 --> 00:02:28.531 I4. 00:02:30.151 --> 00:02:30.632 Is greater than. 00:02:31.333 --> 00:02:31.493 One. 00:02:31.493 --> 00:02:37.931 I think it's 1,500,000. 00:02:39.775 --> 00:02:43.603 If it's greater, yes, otherwise no. 00:02:45.171 --> 00:02:46.052 it needs to be written. 00:02:46.732 --> 00:02:49.834 As you can see, I wrote and matched my test. 00:02:51.514 --> 00:02:59.959 As you can see, the value U4 here is more than 1 million 500 thousand, so it wrote yes here. 00:03:00.960 --> 00:03:06.643 To apply this process to our other rows, I grab it from the corner like this. 00:03:07.543 --> 00:03:12.586 As you can see, some months resulted in yes and some months resulted in no according to this test. 00:03:14.007 --> 00:03:16.331 We have successfully completed this task. 00:03:16.451 --> 00:03:20.393 Again, we applied the formula requested to the range K5-K15. 00:03:21.514 --> 00:03:27.317 In our next step, we were asked to create a clustered column chart. 00:03:27.857 --> 00:03:29.157 Let's select these ranges. 00:03:29.558 --> 00:03:35.762 These ranges are B3-15, H3-15, I3-15 ranges. 00:03:36.282 --> 00:03:37.163 B, H, and I. 00:03:37.903 --> 00:03:49.415 So the range is B, B, By the way, I'm holding down CTRL to make these selection operations successful... 00:03:52.911 --> 00:03:59.993 Here, we need to create a column chart to compare expenses and profits. 00:04:00.353 --> 00:04:04.194 As you can see, I selected these three columns as I wanted. 00:04:04.914 --> 00:04:16.358 Then, by clicking on the recommended charts in the insert menu, we can find the clustered column here. 00:04:16.954 --> 00:04:30.083 If we want to find it elsewhere, we can again find the clustered column, stacked column in the charts menu. 00:04:30.123 --> 00:04:30.663 we have the option. 00:04:31.383 --> 00:04:34.445 But what was requested from us was the clustered milk. 00:04:34.585 --> 00:04:35.386 I clicked on it again. 00:04:36.901 --> 00:04:41.964 and we successfully completed this step. 00:04:43.267 --> 00:04:48.471 In the next step, place the top left corner of this graph at B26. 00:04:48.951 --> 00:04:54.596 It was said to develop the graph with 50 high intervals with B26. 00:04:55.916 --> 00:05:02.621 It was said to bring it to B26 from here, I think. 00:05:04.082 --> 00:05:09.926 We were asked to take it from the B26 cell and bring it up to K50. 00:05:10.586 --> 00:05:15.309 I can see K50 like this. 00:05:17.050 --> 00:05:18.170 I applied it like this. 00:05:19.971 --> 00:05:20.171 Yes. 00:05:23.134 --> 00:05:27.536 We were also able to change the button as we wanted. 00:05:28.315 --> 00:05:37.761 But in our next step, we were instructed to remove the chart title and make a profit comparison. 00:05:37.880 --> 00:05:42.863 I will write it down here immediately. 00:05:53.611 --> 00:06:05.743 In this way, when we click on any chart, Excel sends us to the chart design box to change the colors of our chart. 00:06:07.834 --> 00:06:10.096 we can change the colors in the direction we want. 00:06:10.616 --> 00:06:11.196 You see. 00:06:11.857 --> 00:06:15.699 A very user-friendly area. 00:06:16.140 --> 00:06:19.842 From here, we can change our axes by adding chart members. 00:06:20.282 --> 00:06:22.424 Or we can change the axis titles. 00:06:24.125 --> 00:06:27.187 We can add graphic titles, put data labels. 00:06:27.226 --> 00:06:32.290 We can write on which value represents which number on our columns. 00:06:33.471 --> 00:06:37.512 Or we can add some guide lines. 00:06:37.873 --> 00:06:40.855 Maybe this can make reading easier. 00:06:41.596 --> 00:06:43.638 Or besides that, we can add indicators. 00:06:43.798 --> 00:06:45.019 We can add legends. 00:06:45.420 --> 00:06:47.061 As you can see, I added one here. 00:06:47.842 --> 00:06:51.286 This blue line represents net expenses in Turkish Lira. 00:06:52.947 --> 00:06:57.349 The orange line indicates profit in Turkish Lira. 00:06:57.409 --> 00:07:11.815 These kinds of indications are frequently used and the more understandable we make our graph, the more it shows how high the quality of our output is. 00:07:12.035 --> 00:07:15.756 This is quite good for our work. 00:07:16.797 --> 00:07:18.357 Let's look at our next step. 00:07:19.278 --> 00:07:20.478 We have successfully completed this. 00:07:22.233 --> 00:07:35.262 In your next step, you are instructed to select the ranges B3-15 and J3-J15 and create a 3D pie chart for this selected area. 00:07:36.022 --> 00:07:42.867 Let's go to B3 to B15, J3 to J15 right away. 00:07:43.828 --> 00:07:45.069 I selected it from here again. 00:07:45.309 --> 00:07:47.130 With B3... 00:07:47.750 --> 00:07:50.492 While the CTL shot is pressed, I'm selecting from here. 00:07:50.993 --> 00:07:51.473 I've selected. 00:07:52.179 --> 00:07:53.619 We are going to add it again. 00:07:53.880 --> 00:07:57.721 Then, as you can see here, we have our pie charts. 00:07:58.441 --> 00:08:08.744 If we want a 3D pie chart, we can click on the suggested graphics from the menu above to decide by looking at the image. 00:08:09.344 --> 00:08:22.638 But here, I'm clicking here to add the requested 3D pie chart and move it to a new page. 00:08:22.818 --> 00:08:25.080 Name the page as profit margins. 00:08:25.720 --> 00:08:41.811 Here, I'm saying cut to move this table as a priority or select move the chart option, say new page, then the requested name profit margins 00:08:41.851 --> 00:08:43.472 I've written the name, pressed okay. 00:08:43.912 --> 00:08:53.275 As you can see, on the newly opened page, a chart showing profit margins, a pie chart is presented to us. 00:08:53.755 --> 00:09:02.977 If we want, we can highlight any value in our pie chart here, and if we pull it like this to emphasize the layers more, 00:09:02.997 --> 00:09:07.440 if we want to bring them more to the forefront, we can use such options. 00:09:07.900 --> 00:09:11.062 There are also some preview graph styles here. 00:09:11.162 --> 00:09:15.245 We can use these in the way we want according to our purpose. 00:09:15.945 --> 00:09:19.107 Similarly, some changes can be made regarding colors. 00:09:19.647 --> 00:09:24.530 These are entirely dependent on what you want for your work. 00:09:25.530 --> 00:09:29.394 I tried to express the graphics in this way for you. 00:09:29.774 --> 00:09:31.615 I hope you find it helpful. 00:09:32.275 --> 00:09:33.155 I wish you success.

WEBVTT 00:00:00.049 --> 00:00:09.234 Merhaba arkadaşlar, videomuzun 5. ve son kısmı olan istatistik alışmalarının 17. adımından devam edeceğiz bu videomuzda. 00:00:09.294 --> 00:00:11.055 Hazırsanız gelin, devam edelim. 00:00:11.055 --> 00:00:15.037 17. adımı başlamadan önce size bir şey göstermek istiyorum. 00:00:15.597 --> 00:00:25.482 Bir önceki adımınızda bildiğiniz üzere net Ciro'muzun avru cinsindeki değerlerinden ortalama maksimum ve minimum değerlerini hesaplamıştık hep beraber. 00:00:26.122 --> 00:00:34.251 Bu değerlendirmeleri diğer satırları da aktarmak, diğer süsunları da aktarmak istersek yine bunu köşesinden tutarak şöyle çekiyoruz. 00:00:35.112 --> 00:00:40.698 Gördüğünüz üzere yine brute gider avrucun üstündeki bedel içerisinde de minibu maksimum değeri. 00:00:41.118 --> 00:00:48.742 ya da TL cinsindeki karımızın yine en büyük, en küçük ve ortalama değerini bulmuş olduk. 00:00:48.822 --> 00:00:58.106 Burada dikkat etmemiz gereken tek şey doldurma işlemini başlattığımız hücrede herhangi bir biçimlendirme, para verimi biçimlendirmesi vesaire varsa yine 00:00:58.126 --> 00:01:01.068 bu biçimlendirme diğer satırlara da aktarılıyor. 00:01:01.708 --> 00:01:07.851 Bu birtakım hatalara sebep olabilir çünkü yukarıda belirttiğimiz değerler aslında Türk lirası iken aşağıda Euro gözüküyor. 00:01:08.611 --> 00:01:10.191 Bunu hemen düzeltmemiz gerekir. 00:01:10.912 --> 00:01:21.160 Yine buradan girip seçtiğimiz düzeltilmesi gereken hücreleri belirleyip, ardından gerekli para bilimini doğru şekilde uygulamamız gerekiyor. 00:01:21.800 --> 00:01:25.443 Bu şekilde gelin 17. adımızdan devam edelim. 00:01:25.443 --> 00:01:29.824 17. adımımıza gizlenmiş Call Stun'u görünür kılmamız istenmiş. 00:01:30.324 --> 00:01:38.467 Burada bahsettiğim gibi J ile L arasında kalan Call Stun'u hemen sağ tıklayıp gösterdiğimizi görünecektir. 00:01:38.607 --> 00:01:41.788 Burada farklı bir Stun bilirdi. 00:01:42.128 --> 00:01:46.769 Oysa buradaki tablomuzun bir parçası kendisi. 00:01:47.666 --> 00:01:48.907 Bunu başarıyla tamamladık. 00:01:48.967 --> 00:02:00.733 Bir sonraki halimizde K4 hücresine U4 1500, buradaki 1 milyon 500 liradan yüksekse evet, Akstart'ta hayır cevabı veren bir formül girin denmiş. 00:02:01.033 --> 00:02:02.474 Yine K4 hücresine gidelim. 00:02:04.455 --> 00:02:05.716 Bu k4 hüresi. 00:02:05.816 --> 00:02:09.098 Burda bizim yapmamız gereken formüllerden işlem ekle. 00:02:09.679 --> 00:02:10.619 Ardından EER. 00:02:11.260 --> 00:02:11.940 Tamam dedik. 00:02:12.380 --> 00:02:13.401 Mantıksal sınama. 00:02:15.542 --> 00:02:18.124 Burda bize verilen sınama. 00:02:18.244 --> 00:02:21.226 I4 1.500.000 liradan büyük olmak zorunda. 00:02:22.207 --> 00:02:23.488 Şöyle ekleyelim, şöyle gidelim. 00:02:25.508 --> 00:02:27.370 Şöyle gidelim hatta I4'u seçelim. 00:02:28.270 --> 00:02:28.531 I4. 00:02:30.151 --> 00:02:30.632 Büyüktür. 00:02:31.333 --> 00:02:31.493 Bir. 00:02:31.493 --> 00:02:37.931 1 milyon 500 bin sanıyorum. 00:02:39.775 --> 00:02:43.603 Eğer büyükse, evet aksi takirde hayır. 00:02:45.171 --> 00:02:46.052 yazması gerekiyor. 00:02:46.732 --> 00:02:49.834 Gördüğünüz üzere sınamamı yazdım, eşleştirdim. 00:02:51.514 --> 00:02:59.959 Gördüğünüz üzere buradaki U4 değeri 1 milyon 500 binden fazla olduğu için burada evet yazdı. 00:03:00.960 --> 00:03:06.643 Bu işlemi diğer satırlarımıza da uygulamak için yine köşesinden tutup şu şekilde çekiyorum. 00:03:07.543 --> 00:03:12.586 Gördüğünüz üzere bazı aylar evet bazı aylar hayır çıktı bu sınamaya göre. 00:03:14.007 --> 00:03:16.331 Bu adamımızı da Başarıyla tamamladık. 00:03:16.451 --> 00:03:20.393 Yine bizden istenen formülü K5-K15 aralığına da uyguladık. 00:03:21.514 --> 00:03:27.317 Bir sonraki adımımızda ise bir kümelenmiş stüm grafiği oluşturmamız istenmiş. 00:03:27.857 --> 00:03:29.157 Gelin bu aralıkları seçelim. 00:03:29.558 --> 00:03:35.762 Bu aralıklar B3-15, H3-15, I3-15 aralıkları. 00:03:36.282 --> 00:03:37.163 B, H ve I. 00:03:37.903 --> 00:03:49.415 Yani şu aralık B, B, Bu arada CTRL'ye basılı tutuyorum ki bu seçme işlemleri başarılı bir şekilde... 00:03:52.911 --> 00:03:59.993 Burada gider ve kar karşılaştırması yapabilmek için bir sütün grafiği oluşmamız gerekiyor. 00:04:00.353 --> 00:04:04.194 Gördüğünüz üzere bu üç sütünü istediğim şekilde seçtim. 00:04:04.914 --> 00:04:16.358 Ardından ekle menüsü içerisinden önerilen grafiklere tıklayarak kümelenmiş sütünü burada bulabiliriz. 00:04:16.954 --> 00:04:30.083 Eğer bunun haricinde başka bir yerden bulmak istersek yine grafikler menüsü içerisinde 2B sütün, kümelenmiş sütün, yığılmış sütün olacak şekilde bir sürü 00:04:30.123 --> 00:04:30.663 seçeneğe sahibiz. 00:04:31.383 --> 00:04:34.445 Fakat bizden istenen kümelenmiş sütündü. 00:04:34.585 --> 00:04:35.386 Yine bunu tıkladım. 00:04:36.901 --> 00:04:41.964 ve bu adımızı başarı ile tamamlamış olduk. 00:04:43.267 --> 00:04:48.471 Bir sonraki adımızda bu grafiğin sol üst köşesi B26 yücesine gelecek şekilde yerleştirin. 00:04:48.951 --> 00:04:54.596 Grafiği B26 ile 50 yüce aralıklarını kaptıracak şekilde geliştirin denmiş. 00:04:55.916 --> 00:05:02.621 Şuradan tutarak Sanırım B26'ye getirin denmişti bize. 00:05:04.082 --> 00:05:09.926 Buradan B26 hücresinden tutup bunu K50'ye kadar getirmemiz istenmiş. 00:05:10.586 --> 00:05:15.309 Şu şekilde K50'yi buradan görebiliyorum. 00:05:17.050 --> 00:05:18.170 Şu şekilde uyguladım. 00:05:19.971 --> 00:05:20.171 Evet. 00:05:23.134 --> 00:05:27.536 Bunu da button'ı istediğim bir şekilde değiştirebilmiş olduk. 00:05:28.315 --> 00:05:37.761 Fakat bir sonraki adımımızda ise bize grafik başlığını gider ve kâr karşılaştırması yapın talimatı verilmiş. 00:05:37.880 --> 00:05:42.863 Ben buradan hemen yazmamı gider. 00:05:53.611 --> 00:06:05.743 Bu şekilde grafiğimizin renklerini yine herhangi bir grafiğin üzerine tıkladığımızda bizi grafik tasarımı kutucuğuna gönderir Excel. 00:06:07.834 --> 00:06:10.096 renkleri değiştirebiliriz istediğimiz doğrultuda. 00:06:10.616 --> 00:06:11.196 Görüyorsunuz. 00:06:11.857 --> 00:06:15.699 Oldukça kolay kullanımlı bir bölge. 00:06:16.140 --> 00:06:19.842 Buradan grafik üyesi ekleden eksenlerimizi değiştirebiliriz. 00:06:20.282 --> 00:06:22.424 Ya da eksen başlıklarımızı değiştirebiliriz. 00:06:24.125 --> 00:06:27.187 Grafik başlıklarını ekleyebiliriz, veri etiketleri koyabiliriz. 00:06:27.226 --> 00:06:32.290 Burada hangi değerin hangi rakamı ifade ettiğini üzerine yazabiliriz bu stünlerimizin. 00:06:33.471 --> 00:06:37.512 Ya da Bir takım kılavuz çizgiler koyabiliriz. 00:06:37.873 --> 00:06:40.855 Belki bu okumayı daha kolay hale getirebilir. 00:06:41.596 --> 00:06:43.638 Ya da bunun haricinde göstergeler ekleyebiliriz. 00:06:43.798 --> 00:06:45.019 Lejantlar ekleyebiliriz. 00:06:45.420 --> 00:06:47.061 Burada gördüğünüz üzere bir tane ekledim. 00:06:47.842 --> 00:06:51.286 Bu mavi net gider TL cinsinde anlamına geliyor. 00:06:52.947 --> 00:06:57.349 Turuncularla kar TL dizisinde olduğunu ifare ediyor. 00:06:57.409 --> 00:07:11.815 Bu tarz ifareler sıkça kullanılır ve grafimizi ne kadar anlaşılır hale getirirsek bu bizim iş çıktığımızın ne kadar kaliteli olduğunu kendine ifare edebildiğini gösterir. 00:07:12.035 --> 00:07:15.756 Bu da oldukça iyidir bizim çalışmalarımız açısından. 00:07:16.797 --> 00:07:18.357 Gelin bir sonraki adımımıza bakalım. 00:07:19.278 --> 00:07:20.478 Bunu da başarıyla tamamladık. 00:07:22.233 --> 00:07:35.262 Bir sonraki adımınızda B3-15 ve J3-J15 aralıklarını seçip bu seçili alan için bir 3B pastagrafiyi oluşturun şeklinde bir talimat verilmiş. 00:07:36.022 --> 00:07:42.867 B3 ile B15, J3 ile J15 hemen gidelim. 00:07:43.828 --> 00:07:45.069 Yine şuradan seçtim. 00:07:45.309 --> 00:07:47.130 B3 ile J... 00:07:47.750 --> 00:07:50.492 Yine CTL atışı basılı iken buradan seçiyorum. 00:07:50.993 --> 00:07:51.473 Seçtim. 00:07:52.179 --> 00:07:53.619 yine eklemenizine gidiyoruz. 00:07:53.880 --> 00:07:57.721 Ardından burada gördüğünüz üzere pasta grafiklerimiz var. 00:07:58.441 --> 00:08:08.744 Bir 3B pasta istiyorsak buradan 2B pasta istiyorsak yine üstteki menüden önerilen grafikleri tıklayıp buradan görüntüsüne bakarak karar verebiliriz. 00:08:09.344 --> 00:08:22.638 Fakat ben burada direkt bizden talep edilen 3B pasta grafin eklemek için buradan tıklıyorum ve 3B pasta'yı buradan Bu grafiği yeni bir sayfaya taşıyın. 00:08:22.818 --> 00:08:25.080 Sayfanın adını kâr oranları olarak tanımlayın. 00:08:25.720 --> 00:08:41.811 Ben burada bu tabloyu taşımak için öncelikli bir kest diyorum ya da grafiği taşı seçeneğine yeni sayfa deyip ardından bizden istenen isim olan kâr oranları 00:08:41.851 --> 00:08:43.472 adını yazdım, tamamı bastım. 00:08:43.912 --> 00:08:53.275 Gördüğünüz üzere yeni açılan sayfada bize kâr oranlarını sunan bir grafik, bir pasta grafiği sunuyor. 00:08:53.755 --> 00:09:02.977 Eğer istersek, burada herhangi bir şey görünüp versek yine pastamızda herhangi bir değeri tutup şu şekilde çektiğimizde ve layarları daha çok vurgulamak, 00:09:02.997 --> 00:09:07.440 daha çok öne çıkarmak istiyorsak Bu tarz seçenekleri kullanabiliriz. 00:09:07.900 --> 00:09:11.062 Burada bir takım ön izlemeler grafik stilleri de var. 00:09:11.162 --> 00:09:15.245 Bunları da istediğimiz şekilde istediğimiz amaç doğrultusunda kullanabiliriz. 00:09:15.945 --> 00:09:19.107 Yine aynı şekilde renkler konusunda da bir takım değişiklikler yapılabilir. 00:09:19.647 --> 00:09:24.530 Bunlar tamamen sizin çalışmanıza ne istediğinizi bağlı. 00:09:25.530 --> 00:09:29.394 Bu şekilde grafikleri de ifade etmeye çalıştım sizin için. 00:09:29.774 --> 00:09:31.615 Umarım faydasını görürsünüz. 00:09:32.275 --> 00:09:33.155 Başarılar diliyorum.