Kira Hesapları 1

WEBVTT 00:00:00.129 --> 00:00:00.969 Hallo Freunde. 00:00:01.410 --> 00:00:10.694 In unserem heutigen Video werden wir gemeinsam sehen, wie wir die erforderlichen Schritte zur Anwendung der Mietkonten in Excel-Übungsdatei korrekt durchführen. 00:00:11.514 --> 00:00:15.536 Dafür müssen wir zuerst unsere Excel-Datei öffnen. 00:00:15.816 --> 00:00:16.276 Ich öffne es. 00:00:16.796 --> 00:00:17.417 Wie geht's? 00:00:18.317 --> 00:00:20.618 Dann habe ich die Mietkonten-Datei geöffnet. 00:00:21.819 --> 00:00:24.120 Wie Sie sehen können, ist meine Datei hier. 00:00:26.620 --> 00:00:28.641 Lass uns gemeinsam unsere Schritte verfolgen. 00:00:29.461 --> 00:00:35.823 Es wurde von uns verlangt, eine Operation einzugeben, die den Bereich B4-B7 zur Zelle B8 addiert. 00:00:36.023 --> 00:00:38.064 Lass uns die Zelle B8 finden. 00:00:38.124 --> 00:00:40.744 Hier ist unsere Zelle B8. 00:00:40.924 --> 00:00:46.586 Es wurde von uns verlangt, eine Berechnung durchzuführen, die den Bereich B4 und B7 addiert. 00:00:48.406 --> 00:00:54.368 Was wir hier tun müssen, ist die einfachste Methode, die wir im ersten und zweiten Video gezeigt haben, die automatische Summe. 00:00:55.128 --> 00:00:58.609 Die Anwendung dieser Operation wählt automatisch den Bereich für uns aus. 00:00:59.750 --> 00:01:02.531 Wir bestätigen dies, indem wir die Eingabetaste drücken. 00:01:02.711 --> 00:01:06.372 Dann gibt es uns das Gesamtergebnis. 00:01:07.152 --> 00:01:08.592 Unser erster Schritt war so. 00:01:08.632 --> 00:01:10.233 Lass uns das rot machen. 00:01:11.098 --> 00:01:15.861 Unsere zweite Operation besteht darin, eine Operation einzugeben, die den Bereich B13-B17 zur Zelle B18 addiert. 00:01:16.722 --> 00:01:17.723 Wieder die gleiche Operation hier. 00:01:17.883 --> 00:01:21.745 Wir wurden gebeten, die Summe dieses Bereichs in Zelle B18 einzugeben. 00:01:21.846 --> 00:01:29.651 Ich summiere diesen Bereich wieder mit der Option für die automatische Summe im Bearbeitungsteil. 00:01:29.791 --> 00:01:30.872 Der Bereich wurde erneut ausgewählt. 00:01:30.952 --> 00:01:31.652 Ich habe die Eingabetaste gedrückt. 00:01:31.873 --> 00:01:34.975 Wie Sie sehen, haben wir die Werte automatisch gefunden. 00:01:35.595 --> 00:01:40.956 Hier mussten wir die Wohnungskosten für den Januar finden. 00:01:41.497 --> 00:01:48.460 Dann ging es darum, diese Kosten auf die hier lebenden Familien pro Quadratmeter aufzuteilen. 00:01:48.500 --> 00:01:51.922 Deshalb haben wir die Quadratmeter aller Summen gefunden. 00:01:52.942 --> 00:01:54.403 Lassen Sie uns den nächsten Schritt betrachten. 00:01:55.183 --> 00:01:56.523 Auch das haben wir erfolgreich abgeschlossen. 00:01:56.863 --> 00:01:57.724 Ich markiere es rot. 00:01:58.264 --> 00:02:03.225 Geben Sie eine Formel in Zelle D5 ein, die die monatlichen Kosten pro Quadratmeter berechnet. 00:02:03.805 --> 00:02:05.585 Lassen Sie uns dafür zu D5 gehen. 00:02:06.666 --> 00:02:11.487 In D5 müssen wir die monatlichen Kosten pro Quadratmeter finden. 00:02:11.526 --> 00:02:14.247 Dafür klicken wir darauf. 00:02:14.507 --> 00:02:17.148 Dann schreiben wir gleich. 00:02:18.368 --> 00:02:28.631 Dann mussten wir die Gesamtkosten durch den Gesamtbereich teilen. 00:02:28.832 --> 00:02:30.512 So habe ich erneut außerhalb der Eingabetaste gedrückt. 00:02:31.353 --> 00:02:36.035 Wie Sie sehen können, haben wir die monatlichen Kosten pro Quadratmeter hier festgestellt. 00:02:37.215 --> 00:02:38.675 Wir haben diese Aufgabe erfolgreich abgeschlossen. 00:02:38.916 --> 00:02:40.016 Lassen Sie uns das nächste anschauen. 00:02:41.717 --> 00:02:46.839 Es wurde nach einer Formel gefragt, um den Anteil der Kosten der Dağlı-Familie in Zelle C13 zu berechnen. 00:02:46.939 --> 00:02:48.200 Lassen Sie uns Zelle C13 finden. 00:02:49.580 --> 00:02:53.522 Hier ist Zelle C13, wo wir versuchen werden, den Kostenanteil der Dağlı-Familie zu finden. 00:02:54.222 --> 00:03:03.067 Was wir hier tun müssen, ist die Anzahl der Quadratmeter, die die Dağlı-Familie besitzt, mit den Kosten pro Quadratmeter zu multiplizieren. 00:03:03.227 --> 00:03:07.229 Um dies zu tun, sage ich wieder gleich. 00:03:08.270 --> 00:03:11.491 Dann habe ich auf die Zelle für die Fläche geklickt. 00:03:11.992 --> 00:03:13.292 Dann mal. 00:03:14.032 --> 00:03:16.474 Wir müssen die Sternentaste auf der Tastatur verwenden. 00:03:17.254 --> 00:03:19.916 Ich habe auch das Einkommen pro Haushaltsmitglied hier geschrieben. 00:03:20.496 --> 00:03:22.056 Dann habe ich Enter gedrückt. 00:03:23.018 --> 00:03:31.444 Wie Sie sehen können, ergab sich ein Kostenanteil von etwa 1186 Lira für die Dağlı-Familie. 00:03:32.906 --> 00:03:34.167 Auch das haben wir erfolgreich berechnet.

WEBVTT 00:00:00.129 --> 00:00:00.969 Hello friends. 00:00:01.410 --> 00:00:10.694 In today's video, we will see together how to correctly apply the necessary steps on the Excel practice document for rent calculations. 00:00:11.514 --> 00:00:15.536 The first thing we need to do is to open our Excel file. 00:00:15.816 --> 00:00:16.276 I'm opening it. 00:00:16.796 --> 00:00:17.417 How is it? 00:00:18.317 --> 00:00:20.618 Then I opened the rent calculations file. 00:00:21.819 --> 00:00:24.120 As you can see, the file is here. 00:00:26.620 --> 00:00:28.641 Let's follow our steps together. 00:00:29.461 --> 00:00:35.823 We are asked to enter a formula in cell B8 that sums the range B4-B7. 00:00:36.023 --> 00:00:38.064 Let's find our cell B8. 00:00:38.124 --> 00:00:40.744 Here is our cell B8. 00:00:40.924 --> 00:00:46.586 We need to calculate the sum of the range B4 and B7. 00:00:48.406 --> 00:00:54.368 The operation we need to perform here is the easiest method, as shown in our second video, which is the auto sum. 00:00:55.128 --> 00:00:58.609 Applying the operation automatically selects the range for us. 00:00:59.750 --> 00:01:02.531 We confirm this by pressing the Enter key. 00:01:02.711 --> 00:01:06.372 Then it gives us the total sum. 00:01:07.152 --> 00:01:08.592 This was our first step. 00:01:08.632 --> 00:01:10.233 Let's make this red. 00:01:11.098 --> 00:01:15.861 Our second operation is to enter a formula in cell B18 that sums the range B13, B17. 00:01:16.722 --> 00:01:17.723 The same process here again. 00:01:17.883 --> 00:01:21.745 We were asked to enter the total of this range into cell B18. 00:01:21.846 --> 00:01:29.651 I am summing this range using the automatic sum option that remains in the editing section when we enter. 00:01:29.791 --> 00:01:30.872 The range is selected again. 00:01:30.952 --> 00:01:31.652 I pressed Enter. 00:01:31.873 --> 00:01:34.975 As you can see, we have automatically found the values. 00:01:35.595 --> 00:01:40.956 Here, we needed to find the total of apartment expenses in January. 00:01:41.497 --> 00:01:48.460 Then it was related to distributing this expense to the families living here on a square meter basis. 00:01:48.500 --> 00:01:51.922 Therefore, we found the square meters of all totals. 00:01:52.942 --> 00:01:54.403 Let's look at our next operation. 00:01:55.183 --> 00:01:56.523 We have successfully completed this as well. 00:01:56.863 --> 00:01:57.724 I am marking it in red. 00:01:58.264 --> 00:02:03.225 Enter a formula in cell D5 to calculate the monthly expense per square meter. 00:02:03.805 --> 00:02:05.585 Let's see D5 for this. 00:02:06.666 --> 00:02:11.487 Here in D5, we need to find the monthly expense per square meter. 00:02:11.526 --> 00:02:14.247 To do this, we click. 00:02:14.507 --> 00:02:17.148 Then we write equals. 00:02:18.368 --> 00:02:28.631 Then we needed to divide the total expense by the Total area. 00:02:28.832 --> 00:02:30.512 So, I pressed Enter again like this. 00:02:31.353 --> 00:02:36.035 As you can see, we have determined the monthly expenses per square meter here. 00:02:37.215 --> 00:02:38.675 We have successfully completed this process. 00:02:38.916 --> 00:02:40.016 Let's look at the next one. 00:02:41.717 --> 00:02:46.839 A formula was requested to calculate the expenses of the Dağlı family in cell C13. 00:02:46.939 --> 00:02:48.200 Let's find cell C13. 00:02:49.580 --> 00:02:53.522 Here is cell C13, where we will try to find the expenses of the Dağlı family. 00:02:54.222 --> 00:03:03.067 What we need to do here is to multiply the number of square meters owned by the Dağlı family by the per square meter household expense. 00:03:03.227 --> 00:03:07.229 To do this, I say equals again. 00:03:08.270 --> 00:03:11.491 Then I clicked on the cell where they own the area. 00:03:11.992 --> 00:03:13.292 Then multiply. 00:03:14.032 --> 00:03:16.474 We need to use the star key on our keyboard for this. 00:03:17.254 --> 00:03:19.916 I also wrote the per capita household income here. 00:03:20.496 --> 00:03:22.056 Then I pressed Enter. 00:03:23.018 --> 00:03:31.444 As you can see, an approximate expense of 1186 lira came out for the Dağlı family. 00:03:32.906 --> 00:03:34.167 We have successfully calculated this as well.

WEBVTT 00:00:00.129 --> 00:00:00.969 Merhaba arkadaşlar. 00:00:01.410 --> 00:00:10.694 Bugünkü videomuzda kiray hesapları Excel alışırma dokümanı üzerinde gerekli adımları nasıl doğru şekilde uygulayacağımızı hep beraber göreceğiz. 00:00:11.514 --> 00:00:15.536 Bunun için ilk yapmamız gereken Excel dosyamızı açmak olacak. 00:00:15.816 --> 00:00:16.276 Açıyorum. 00:00:16.796 --> 00:00:17.417 Nasıl üstü? 00:00:18.317 --> 00:00:20.618 Ardından kiray hesapları dosyasını açtım. 00:00:21.819 --> 00:00:24.120 Gördüğünüz üzere dosyam burada. 00:00:26.620 --> 00:00:28.641 Gelin hep beraber adımlarımızı takip edelim. 00:00:29.461 --> 00:00:35.823 Bizden B8 hücresine B4-B7 hücü aralığını toplayan bir işlem girmemiz istenmiş. 00:00:36.023 --> 00:00:38.064 Gidelim B8 hücremizi bulalım. 00:00:38.124 --> 00:00:40.744 B8 hücremiz burası. 00:00:40.924 --> 00:00:46.586 Bizden B4 ve B7 aralığını toplayan bir hesap yapılması. 00:00:48.406 --> 00:00:54.368 Buraya yapmamız gereken işlem ilk ikinci videomuzda gösterdiğimiz gibi en kolay yöntem olan otomatik toplam. 00:00:55.128 --> 00:00:58.609 İşlemini uygulamak burada bize aralığı seçer otomatik olarak. 00:00:59.750 --> 00:01:02.531 Biz bunu enter tuşuna basarak onaylarız. 00:01:02.711 --> 00:01:06.372 Ardından bize genel toplamı verir. 00:01:07.152 --> 00:01:08.592 İlk adımımız bu şekildeydi. 00:01:08.632 --> 00:01:10.233 Gelin bunu kırmızı yapalım. 00:01:11.098 --> 00:01:15.861 İkinci işlemimiz B18 hücresinde B13, B17 hücü aralığını toplayan bir işlem girmek. 00:01:16.722 --> 00:01:17.723 Yine burada da aynı işlem. 00:01:17.883 --> 00:01:21.745 Bizden bu aralığın toplamını B18 hücresine girmemiz istenmiş. 00:01:21.846 --> 00:01:29.651 Yine aynı şekilde girişmenimizin düzenleme kısmında kalan otomatik toplam seçeneğiyle bu aralığı topluyorum. 00:01:29.791 --> 00:01:30.872 Yine seçili geldi aralık. 00:01:30.952 --> 00:01:31.652 Enter'e bastım. 00:01:31.873 --> 00:01:34.975 Gördüğünüz üzere değerleri otomatik olarak bulmuş olduk. 00:01:35.595 --> 00:01:40.956 Burada yapmamız gereken ocak ayında apartman giderlerini bulmak oldu toplamını. 00:01:41.497 --> 00:01:48.460 Ardından bu gideri burada yaşayan ailelere metekare bazında bölüştürmekle alakalıydı. 00:01:48.500 --> 00:01:51.922 Bu yüzden de tüm toplamaların metekaresini bulduk. 00:01:52.942 --> 00:01:54.403 Gelin bir sonraki işlemimize bakalım. 00:01:55.183 --> 00:01:56.523 Bunu da başarıyla tamamladık. 00:01:56.863 --> 00:01:57.724 Kırmızı ile boyuyorum. 00:01:58.264 --> 00:02:03.225 D5 hücresine metrekare ile metrekare başına düşen aylık gideri hesaplayan bir formül girin. 00:02:03.805 --> 00:02:05.585 Bunun için gelin bakalım D5'e. 00:02:06.666 --> 00:02:11.487 D5 burada bize metrekare başına düşen aylık gideri bulmamız gerekiyor. 00:02:11.526 --> 00:02:14.247 Bunun için yapmamız gereken tıklıyoruz. 00:02:14.507 --> 00:02:17.148 Ardından eşittir yazıyoruz. 00:02:18.368 --> 00:02:28.631 Ardından bizden toplam gideri bölü Toplam alanı bulmamız gerekiyordu. 00:02:28.832 --> 00:02:30.512 Bu şekilde yine enter dışına bastım. 00:02:31.353 --> 00:02:36.035 Gördüğünüz üzere metrekare başına düşen aylık gideri burada tespit etmiş olduk. 00:02:37.215 --> 00:02:38.675 Bu işlemi de başarıyla tamamladık. 00:02:38.916 --> 00:02:40.016 Gelin bir sonrakine bakalım. 00:02:41.717 --> 00:02:46.839 C13 hücresine dağlı ailesinin gider payını hesaplayan bir formül gelin demiş. 00:02:46.939 --> 00:02:48.200 C13 hücresine bulalım. 00:02:49.580 --> 00:02:53.522 Burası C13 hücresi dağlı ailesinin gider payını bulmaya çalışacağız burada. 00:02:54.222 --> 00:03:03.067 Burada yapmamız gereken Dağlı ailesinin sahip olduğu metrekare sayısını metrekare başına düşen haldik giderle çarpmak olacak. 00:03:03.227 --> 00:03:07.229 Bunu yapmak için de yine aynı şekilde eşittir diyorum. 00:03:08.270 --> 00:03:11.491 Ardından sahip oldukları alan hücresine tıkladım. 00:03:11.992 --> 00:03:13.292 Ardından çarpı. 00:03:14.032 --> 00:03:16.474 Klavyemize yıldız tuşunu kullanmamız gerekiyor bunun için. 00:03:17.254 --> 00:03:19.916 Bir de kişi başına düşen haldik geliri buraya yazdım. 00:03:20.496 --> 00:03:22.056 Ardından Enter'a bastım. 00:03:23.018 --> 00:03:31.444 Gördüğünüz üzere 1186 lira gibi küsur atlı bir gider payı çıktı dağlı ailesi için. 00:03:32.906 --> 00:03:34.167 Bunu da başarıyla hesapladık.