Fatura 1

WEBVTT 00:00:00.049 --> 00:00:07.952 Hallo Leute, in unserem heutigen Video werden wir gemeinsam die Übungen zur Rechnungsstellung, das vierte Übungsvideo von Microsoft Excel, durchgehen. 00:00:08.612 --> 00:00:10.573 Seid ihr bereit? Lasst uns mit den Übungen beginnen. 00:00:11.674 --> 00:00:15.175 Zuerst müssen wir die Rechnungsdatei in Excel öffnen. 00:00:15.215 --> 00:00:17.596 Für diejenigen, die es nicht geöffnet haben, über das Dateimenü. 00:00:17.916 --> 00:00:20.857 Öffnen Sie die Datei, indem Sie sie auswählen und die Quelle angeben. 00:00:21.736 --> 00:00:27.019 Diese Dateien sollten bereits über unser Online-Portal verfügbar sein. 00:00:28.380 --> 00:00:30.180 Lasst uns gemeinsam mit den Übungen beginnen. 00:00:30.801 --> 00:00:37.063 In unserem ersten Schritt wurde die Anweisung gegeben, den Bereich A3-B3 zu verbinden und ordnungsgemäß zu formatieren. 00:00:38.264 --> 00:00:41.687 Wir sollen also die Bereiche A3 und B3 verbinden. 00:00:41.747 --> 00:00:47.853 Dann müssen wir eine Stelle auswählen, X markieren, die Befehle "Verbinden und zentrieren" und "Rechtsbündig" ausführen. 00:00:47.893 --> 00:00:53.098 Anschließend müssen wir gemäß der Anweisung den Befehl "Rechtsbündig" ausführen. 00:00:53.938 --> 00:00:55.500 Das haben wir erfolgreich erledigt. 00:00:56.735 --> 00:00:57.996 Ich habe hier Rot ausgewählt. 00:00:58.437 --> 00:01:00.319 Um zu zeigen, dass ich fertig bin. 00:01:01.320 --> 00:01:01.901 Lassen Sie uns fortfahren. 00:01:02.081 --> 00:01:08.528 Den Bereich A3-B3 in die Form der Zellen A4-A5-A7-A9 verschieben, lautet die Anweisung... 00:01:09.659 --> 00:01:10.420 hier. 00:01:12.441 --> 00:01:18.605 Um dies zu tun, müssen wir wiederum das Format hier kopieren. 00:01:18.705 --> 00:01:21.486 Um dies zu tun, müssen wir erneut die Formatpinsel verwenden. 00:01:22.307 --> 00:01:26.289 Um dies zu erreichen, müssen wir zweimal auf den Formatpinsel klicken. 00:01:27.250 --> 00:01:33.488 Wenn wir zweimal klicken, erhalten wir das Recht, dieses Format in verschiedene Zellen zu kopieren. 00:01:34.869 --> 00:01:43.634 Nachdem wir diesen Vorgang abgeschlossen haben, müssen wir die SLC-Taste drücken, um diesen Vorgang abzubrechen. 00:01:44.295 --> 00:01:49.998 A4, A5, A7 und A9 sind die geforderten Zellen. 00:01:50.038 --> 00:01:53.460 Wie Sie sehen können, habe ich das Format kopiert. 00:01:54.101 --> 00:01:58.163 Wenn unser Vorgang abgeschlossen ist, können wir den Formatpinsel erneut mit der ESC-Taste schließen. 00:01:59.344 --> 00:02:10.550 Der Punkt hier ist, dass wenn wir einmal auf den Formatpinsel klicken, können wir das Format einmal kopieren, aber wenn wir zweimal klicken, wird diese Option aktiviert und wir 00:02:10.591 --> 00:02:19.257 werden die Funktion selbst, also den Formatpinsel, weiterhin verwenden, bis wir die ESC-Taste drücken oder erneut auf den Formatpinsel klicken. 00:02:19.597 --> 00:02:22.619 In diesem Sinne habe ich das auch gezeigt. 00:02:23.500 --> 00:02:24.540 Ich male das rot. 00:02:25.241 --> 00:02:26.942 Wir haben das erfolgreich gemeistert. 00:02:28.931 --> 00:02:35.098 Unser nächster Schritt ist es, den Bereich A6, A8 und C5, C9 mit Grau zu formatieren. 00:02:35.738 --> 00:02:39.842 Wie Sie sehen, sind A6 und A8 hier kein Bereich. 00:02:39.882 --> 00:02:41.904 Diese müssen einzeln ausgewählt werden. 00:02:42.845 --> 00:02:49.831 In diesem Zusammenhang müssen wir mit unserer CTL-Reichweite mehrere Zellen auswählen. 00:02:50.486 --> 00:02:53.347 Hier wurden A6 und A8 angefordert. 00:02:53.407 --> 00:02:56.306 Ich halte die STRG-Taste auf meiner Tastatur gedrückt. 00:02:56.907 --> 00:03:01.549 Dann sollen wir A8 und den Bereich von C5 bis C9 auswählen. 00:03:01.989 --> 00:03:06.250 Und dann wurde gefragt, diesen Bereich grau zu formatieren. 00:03:07.410 --> 00:03:10.871 Wir haben das erfolgreich abgeschlossen. 00:03:12.772 --> 00:03:13.792 Unser nächster Schritt ist A4. 00:03:15.145 --> 00:03:20.069 Es soll ein einzelner Unterstrich für die Zellbereiche A4-C4 und A6-C6 angewendet werden. 00:03:20.689 --> 00:03:23.071 Dafür wähle ich erneut A4-C4 aus. 00:03:25.212 --> 00:03:27.574 Ich habe A4-C4 ausgewählt. 00:03:28.514 --> 00:03:31.436 Hier habe ich einen einzelnen Unterstrich angewendet. 00:03:34.755 --> 00:03:36.657 Als Nächstes kommt der Bereich A6, C6. 00:03:36.857 --> 00:03:39.719 Auch hier wurde gefragt, einen einzelnen Unterstrich anzuwenden. 00:03:39.819 --> 00:03:45.004 Wie Sie sehen können, gibt es bereits einen einzelnen Unterstrich in den geschriebenen Texten. 00:03:45.224 --> 00:03:46.205 Ich habe das angewendet. 00:03:48.542 --> 00:03:53.264 Auch diesen Schritt mit dem einzelnen Unterstrich haben wir erfolgreich abgeschlossen. 00:03:53.304 --> 00:03:59.867 Unser nächster Schritt ist es, den Zellbereich A8-C8 mit einem doppelten Unterstrich zu formatieren. 00:04:00.427 --> 00:04:03.488 Hier finden wir A8-C8. 00:04:03.888 --> 00:04:05.049 Wie Sie sehen können, hier. 00:04:05.989 --> 00:04:10.091 Wir kommen hierher und wenden die Schriftart mit zwei Unterstrichen an. 00:04:10.271 --> 00:04:11.051 Wie Sie sehen können. 00:04:12.032 --> 00:04:13.635 Wir haben auch diese Phase erfolgreich abgeschlossen. 00:04:14.357 --> 00:04:18.785 Die Schritte nach dem fünften Schritt werden im nächsten Video erklärt. 00:04:19.387 --> 00:04:20.188 Viel Erfolg.

WEBVTT 00:00:00.049 --> 00:00:07.952 Hello friends, in today's video, we will work on invoice exercises, which is the fourth practice video of Microsoft Excel together. 00:00:08.612 --> 00:00:10.573 Are you ready? Let's look at our exercises. 00:00:11.674 --> 00:00:15.175 First of all, we need to have opened the invoice Excel file. 00:00:15.215 --> 00:00:17.596 For those who haven't opened it, again from the file menu. 00:00:17.916 --> 00:00:20.857 You can open the file by selecting open and specifying the source. 00:00:21.736 --> 00:00:27.019 These files will already be provided to you from our online portal. 00:00:28.380 --> 00:00:30.180 Let's look at our exercises together. 00:00:30.801 --> 00:00:37.063 In our first step, we are instructed to merge and format the A3-B3 range. 00:00:38.264 --> 00:00:41.687 We are asked to merge the ranges between A3 and B3. 00:00:41.747 --> 00:00:47.853 So, we need to select X somewhere, give the command to merge and center. 00:00:47.893 --> 00:00:53.098 Then, we need to give the command to align right according to the instructions. 00:00:53.938 --> 00:00:55.500 We have successfully completed this. 00:00:56.735 --> 00:00:57.996 I chose red here. 00:00:58.437 --> 00:01:00.319 To indicate that I have completed it. 00:01:01.320 --> 00:01:01.901 Let's continue. 00:01:02.081 --> 00:01:08.528 Move the A3-B3 cell range to the format of A4-A5-A7-A9 cells... 00:01:09.659 --> 00:01:10.420 There is an instruction. 00:01:12.441 --> 00:01:18.605 To do this, what we need to do is to copy the format here. 00:01:18.705 --> 00:01:21.486 We need to use the format painter again to do this. 00:01:22.307 --> 00:01:26.289 To be able to do this, we should double-click on the format painter. 00:01:27.250 --> 00:01:33.488 When we double-click, we gain the ability to move this format to different cells multiple times. 00:01:34.869 --> 00:01:43.634 After completing this process, our next step will be to press the SLC key to cancel this operation. 00:01:44.295 --> 00:01:49.998 A4, A5, A7, and A9 are the cells requested from us. 00:01:50.038 --> 00:01:53.460 As you can see, I have copied the format. 00:01:54.101 --> 00:01:58.163 When our operation is finished, we can close the format painter again with the ESC key. 00:01:59.344 --> 00:02:10.550 The detail here is that when we single-click on the format painter, we can copy the format once, but when we double-click, this option becomes active and we 00:02:10.591 --> 00:02:19.257 continue to use the format painter itself until we press the ESC key or click on the format painter again. 00:02:19.597 --> 00:02:22.619 In this sense, I have also demonstrated this. 00:02:23.500 --> 00:02:24.540 I am painting this in red as well. 00:02:25.241 --> 00:02:26.942 We have successfully completed it together. 00:02:28.931 --> 00:02:35.098 Our next step is to format the range of A6, A8, C5, and C9 with a gray color. 00:02:35.738 --> 00:02:39.842 As you can see, A6 and A8 are not a range here. 00:02:39.882 --> 00:02:41.904 These are cells that need to be selected individually. 00:02:42.845 --> 00:02:49.831 In this context, what we need to do is to select these multiple cells using our CTRL selection. 00:02:50.486 --> 00:02:53.347 A6 and A8 have been requested here. 00:02:53.407 --> 00:02:56.306 I am currently holding down the CTRL key on my keyboard. 00:02:56.907 --> 00:03:01.549 Then we are asked to select A8 and the part from C5 to C9. 00:03:01.989 --> 00:03:06.250 And then we are asked to apply a gray formatting to this section. 00:03:07.410 --> 00:03:10.871 We have successfully completed this part as well. 00:03:12.772 --> 00:03:13.792 Our next step is A4. 00:03:15.145 --> 00:03:20.069 It will be to apply a single bottom border style to the cell ranges A4-C4 and A6-C6. 00:03:20.689 --> 00:03:23.071 For this, I am selecting A4-C4 again. 00:03:25.212 --> 00:03:27.574 I have selected A4-C4. 00:03:28.514 --> 00:03:31.436 I have applied a single bottom border here. 00:03:34.755 --> 00:03:36.657 Next is the range A6, C6. 00:03:36.857 --> 00:03:39.719 Again, we are asked to apply a single bottom border here. 00:03:39.819 --> 00:03:45.004 As you can see, there is already a single bottom border within the text I quickly wrote. 00:03:45.224 --> 00:03:46.205 I have applied this. 00:03:48.542 --> 00:03:53.264 We have successfully completed this single bottom border step as well. 00:03:53.304 --> 00:03:59.867 Our next step is to apply a double bottom border style to the cell range A8-C8. 00:04:00.427 --> 00:04:03.488 Here we find A8-C8. 00:04:03.888 --> 00:04:05.049 As you can see, right here. 00:04:05.989 --> 00:04:10.091 We come here and apply the double underline font style. 00:04:10.271 --> 00:04:11.051 As you can see. 00:04:12.032 --> 00:04:13.635 We have successfully completed this stage as well. 00:04:14.357 --> 00:04:18.785 I will be explaining our steps after the fifth one in the next video. 00:04:19.387 --> 00:04:20.188 Good luck.

WEBVTT 00:00:00.049 --> 00:00:07.952 Merhaba arkadaşlar, bugünkü videomuzda Microsoft Excel'in dördüncü alışma videosu olan fatura alıştırmalarını beraber işleyeceğiz. 00:00:08.612 --> 00:00:10.573 Hazırsınız, gelin alışmalarımıza bakalım. 00:00:11.674 --> 00:00:15.175 İlk olarak fatura Excel dosyasını açmış olmamız gerekiyor. 00:00:15.215 --> 00:00:17.596 Açmayanlar için yine dosya menüsünden. 00:00:17.916 --> 00:00:20.857 Aç ve kaynağı belirterek dosyayı açabilirsiniz. 00:00:21.736 --> 00:00:27.019 Bu dosyalar size zaten online portalımızdan sağlamış olacaktır. 00:00:28.380 --> 00:00:30.180 Gelin alışmalarımıza hep beraber bakalım. 00:00:30.801 --> 00:00:37.063 Birinci aşamamızda A3-B3 fücrü aralığını birleştirin ve sağlıklı biçimlendirin şeklinde bir talimat verilmiş. 00:00:38.264 --> 00:00:41.687 Bizden A3 ve B33 aralarını birleştirmemiz talebeleriymiş. 00:00:41.747 --> 00:00:47.853 Burada o zaman X'ini bir yerde seçip birleştir ve ortala komutunu vermemiz gerekiyor. 00:00:47.893 --> 00:00:53.098 Bunun ardında da sağ hizala komutunu vermemiz gerekiyor talimata göre. 00:00:53.938 --> 00:00:55.500 Bunu başarıyla halletmiş olduk. 00:00:56.735 --> 00:00:57.996 Buradan kırmızı seçtim. 00:00:58.437 --> 00:01:00.319 Tamamladığımı ifade etmek için. 00:01:01.320 --> 00:01:01.901 Devam edelim. 00:01:02.081 --> 00:01:08.528 A3-B3 hücre aralığı biçimine A4-A5-A7-A9 hücrelerine taşıyın şeklinde bir... 00:01:09.659 --> 00:01:10.420 Talimat var. 00:01:12.441 --> 00:01:18.605 Bunu da yapabilmek için yine yapmamız gereken şey buradaki biçimi kopyalamak olacak. 00:01:18.705 --> 00:01:21.486 Bunu yapmak için yine biçim boyutusunu kullanmamız gerekiyor. 00:01:22.307 --> 00:01:26.289 Bunu yapabilmek için biçim boyutusuna iki kez tıklamalıyız. 00:01:27.250 --> 00:01:33.488 İki kez tıkladığımızda bu biçimi farklı hücrelere Birden fazla kez taşıma hakkı kazanırız. 00:01:34.869 --> 00:01:43.634 Bu işlemi tamamladıktan sonra da yapacağımız işlem SLC tuşuna basarak bu işlemi iptal etmek olacak. 00:01:44.295 --> 00:01:49.998 Şöyle A4, A5, A7 ve A9 bizden istenilen şüpheler. 00:01:50.038 --> 00:01:53.460 Bunlar da gördüğünüz üzere biçimi kopyalamış oldum. 00:01:54.101 --> 00:01:58.163 İşlemimiz bittiği zaman da ESC tuşu ile yine biçim boyasını kapatabiliriz. 00:01:59.344 --> 00:02:10.550 Buradaki detay şu, biçim boyasını bir kez tıkladığımızda bir kez biçim kopyalayabiliriz fakat iki kez tıkladığımızda bu seçenek aktif hale dönüşür ve biz 00:02:10.591 --> 00:02:19.257 ESC tuşuna ya da biçim boyasını tekrar tıklayana kadar bu fonksiyonun kendisinin yani biçim boyasını kullanmaya devam eder. 00:02:19.597 --> 00:02:22.619 Bu anlamda bunu da göstermiş var etmiş oldum. 00:02:23.500 --> 00:02:24.540 Bunu da kırmızıya boyuyorum. 00:02:25.241 --> 00:02:26.942 Seninle başarılı bir şekilde hallettik. 00:02:28.931 --> 00:02:35.098 Bir sonraki adımız ise A6, A8 ve C5, C9 aralığına gri renkle biçimlendirin demiş. 00:02:35.738 --> 00:02:39.842 Gördüğünüz üzere burada A6 ve A8 bir aralık değil. 00:02:39.882 --> 00:02:41.904 Bunlar tek tek seçilmesi gereken hücreler. 00:02:42.845 --> 00:02:49.831 Bu bağlamda yapmamız gereken şey, CTL yetişimimizi kullanarak birden fazla olan bu hücreleri seçmek. 00:02:50.486 --> 00:02:53.347 Şuradan A6 ve A8 istenmiş. 00:02:53.407 --> 00:02:56.306 CTRL tuşu şu an klavyemle basılı tutuyorum. 00:02:56.907 --> 00:03:01.549 Ardından A8 ve bir de bizden C5'den C9'a kadar olan kısım seçmemizi. 00:03:01.989 --> 00:03:06.250 Ve ardından da bu kısımdan bir gri biçimlendirimi uygulamamızı istemiş. 00:03:07.410 --> 00:03:10.871 Burayı da başarıyla tamamladık. 00:03:12.772 --> 00:03:13.792 Bir sonraki adımımız A4. 00:03:15.145 --> 00:03:20.069 A4-C4 ve A6-C6 hücre aralıklarını tek alt çizgi biçimi uygulamak olacak. 00:03:20.689 --> 00:03:23.071 Bunun için yine A4-C4 seçiyorum. 00:03:25.212 --> 00:03:27.574 A4-C4 seçtim. 00:03:28.514 --> 00:03:31.436 Buraya bir tek alt çizgi uyguladım. 00:03:34.755 --> 00:03:36.657 Bir sonraki ise A6, C6 aralığı. 00:03:36.857 --> 00:03:39.719 Yine buraya da bir tek alt çizgi uygulamamı istemiş. 00:03:39.819 --> 00:03:45.004 Gördüğünüz üzere hemen yazıp bir düzenlemelerin içerisinde tek alt çizgi bulunmakta. 00:03:45.224 --> 00:03:46.205 Bunu uygulamış oldum. 00:03:48.542 --> 00:03:53.264 Bunu da tek alt çizgi aşamasını da başarıyla tamamladık. 00:03:53.304 --> 00:03:59.867 Bir sonraki aşamamız A8-C8 hücrü aralığına çift alt çizgi biçimi uygulamak. 00:04:00.427 --> 00:04:03.488 Burada A8-C8'i buluyoruz. 00:04:03.888 --> 00:04:05.049 Gördüğünüz üzere şurası. 00:04:05.989 --> 00:04:10.091 Buraya gelip altı çift çizgili yazı tipini uyguluyoruz. 00:04:10.271 --> 00:04:11.051 Gördüğünüz üzere. 00:04:12.032 --> 00:04:13.635 Bu aşamayı da başarıyla tamamladık. 00:04:14.357 --> 00:04:18.785 Beşinci adımdan sonraki adımlarımızı bir sonraki videoda anlatıyor olacağım. 00:04:19.387 --> 00:04:20.188 Kolay dilerim.