{"id":238,"date":"2020-04-30T17:31:35","date_gmt":"2020-04-30T17:31:35","guid":{"rendered":"https:\/\/bethecoach.pl\/?p=238"},"modified":"2026-04-01T11:38:00","modified_gmt":"2026-04-01T11:38:00","slug":"formul-ciag-dalszy","status":"publish","type":"post","link":"https:\/\/bethecoach.pl\/index.php\/2020\/04\/30\/formul-ciag-dalszy\/","title":{"rendered":"Formu\u0142 ci\u0105g dalszy."},"content":{"rendered":"\n<p>Cze\u015b\u0107! Dzi\u015b kolejna cz\u0119\u015b\u0107 o formu\u0142ach \u2013 tym razem bardziej zaawansowane tematy, ale niezwykle potrzebne. Odpowiemy na pytania z ostatniej lekcji. Nauczymy si\u0119 jak za jednym zamachem tworzy\u0107 i przelicza\u0107 setki, a nawet tysi\u0105ce formu\u0142. Zapraszam!<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Kurs Excel #4 Formu\u0142y - Zaawansowane\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/JlHAw3XeUn0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<!--more-->\n\n\n\n<div style=\"height:44px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Bardzo cz\u0119sto zdarza si\u0119, \u017ce chcemy przeliczy\u0107 formu\u0142y dla jaki\u015b wi\u0119kszych zbior\u00f3w danych, na przyk\u0142ad dla ca\u0142ej kolumny. Takim prostym przyk\u0142adem mo\u017ce by\u0107 przemno\u017cenie jednej kolumny przez drug\u0105 kolumn\u0119. Na przyk\u0142ad kiedy chcemy przeliczy\u0107 zysk ze sprzedanych produkt\u00f3w, gdzie w jednej kolumnie mamy koszt jednostkowy, a w drugiej liczb\u0119 sprzedanych sztuk. Wtedy wystarczy napisa\u0107 formu\u0142\u0119, kt\u00f3ra <strong>mno\u017cy warto\u015b\u0107 z jednej kolumny razy warto\u015b\u0107 z drugiej.<\/strong><\/p>\n\n\n\n<div style=\"height:47px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/mnozenie-kolumna.jpg\" alt=\"\" class=\"wp-image-239\" width=\"349\" height=\"334\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/mnozenie-kolumna.jpg 410w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/mnozenie-kolumna-300x287.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/mnozenie-kolumna-24x24.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/mnozenie-kolumna-36x34.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/mnozenie-kolumna-48x46.jpg 48w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><figcaption>Mno\u017cenie warto\u015bci z r\u00f3\u017cnych kolumn<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:69px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Smutnie by by\u0142o, gdyby\u015bmy musieli r\u0119cznie wpisywa\u0107 wszystkie formu\u0142y, a\u017c do ostatniego wiersza w danej kolumnie. A je\u015bli tych warto\u015bci b\u0119dzie kilka tysi\u0119cy? Na szcz\u0119\u015bcie jest spos\u00f3b, aby wszystkie formu\u0142y przeliczy\u0107 wed\u0142ug wzoru w pierwszej napisanej formule. Wystarczy, \u017ce przeci\u0105gniesz w d\u00f3\u0142, <strong>chwytaj\u0105c lewym przyciskiem myszy za kwadracik w prawym dolnym rogu kom\u00f3rki. Kom\u00f3rki poni\u017cej wype\u0142ni\u0105 si\u0119 warto\u015bciami.<\/strong> Do ka\u017cdej kom\u00f3rki w formule od kt\u00f3rej zaczynamy b\u0119dzie dodana taka liczba wierszy, o ile wierszy ni\u017cej ta kom\u00f3rka si\u0119 znajduje (lub odj\u0119ta je\u015bli przeci\u0105gamy formu\u0142\u0119 w g\u00f3r\u0119). Dla przyk\u0142adu, je\u017celi w kom\u00f3rce w drugim wierszu mamy formu\u0142\u0119:<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/drugi-wiersz-1.jpg\" alt=\"\" class=\"wp-image-241\" width=\"384\" height=\"216\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/drugi-wiersz-1.jpg 430w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/drugi-wiersz-1-300x169.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/drugi-wiersz-1-24x14.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/drugi-wiersz-1-36x20.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/drugi-wiersz-1-48x27.jpg 48w\" sizes=\"auto, (max-width: 384px) 100vw, 384px\" \/><figcaption>Formu\u0142a w drugim wierszu<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:39px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>To w trzeciej (jedna poni\u017cej) b\u0119dziemy mie\u0107:<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/trzecia-komorka.jpg\" alt=\"\" class=\"wp-image-242\" width=\"377\" height=\"222\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/trzecia-komorka.jpg 399w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/trzecia-komorka-300x177.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/trzecia-komorka-24x14.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/trzecia-komorka-36x21.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/trzecia-komorka-48x28.jpg 48w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/><figcaption>Formu\u0142a w trzecim wierszu<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:53px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>A w \u00f3smej (dodajemy do pierwszej formu\u0142y 8 (wiersz obecnej kom\u00f3rki) -2 (wiersz pierwszej kom\u00f3rki) = 6):<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/osmy-wiersz.jpg\" alt=\"\" class=\"wp-image-243\" width=\"338\" height=\"212\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/osmy-wiersz.jpg 384w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/osmy-wiersz-300x188.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/osmy-wiersz-24x15.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/osmy-wiersz-36x23.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/osmy-wiersz-48x30.jpg 48w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><figcaption>Formu\u0142a w \u00f3smym wierszu<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:66px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Je\u017celi masz do czynienia z danymi w kolumnie, kt\u00f3ra nie ma pustych warto\u015bci, a zaraz po jej prawej stronie wpisujesz formu\u0142\u0119, kt\u00f3r\u0105 chcesz wype\u0142ni\u0107 ca\u0142\u0105 kolumn\u0119 to mo\u017cesz to zrobi\u0107 jeszcze szybciej. Wystarczy, \u017ce wpiszesz formu\u0142\u0119 w pierwsz\u0105 kom\u00f3rk\u0119, a nast\u0119pnie <strong>dwukrotnie klikniesz ma\u0142y kwadracik w prawym dolnym rogu kom\u00f3rki. Wtedy ca\u0142a kolumna wype\u0142ni si\u0119 formu\u0142ami, a w konsekwencji ich wynikiem. Pami\u0119taj, \u017ce ta metoda zadzia\u0142a tylko, gdy po lewej stronie masz kolumn\u0119 z warto\u015bciami.<\/strong><\/p>\n\n\n\n<div style=\"height:31px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"633\" height=\"291\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/brak-wypelnienia.jpg\" alt=\"\" class=\"wp-image-244\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/brak-wypelnienia.jpg 633w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/brak-wypelnienia-300x138.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/brak-wypelnienia-24x11.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/brak-wypelnienia-36x17.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/brak-wypelnienia-48x22.jpg 48w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><figcaption>Czerwony obszar nie wype\u0142ni si\u0119 formu\u0142ami po dwukrotnym naci\u015bni\u0119ciu kwadracika w prawym dolnym rogu<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Natomiast to co powy\u017cej zak\u0142ada, \u017ce w ka\u017cdych obliczeniach b\u0119dziemy chcieli skorzysta\u0107 z warto\u015bci w kolejnych kom\u00f3rkach. Czyli, \u017ce wszystkie potrzebne do oblicze\u0144 warto\u015bci, b\u0119d\u0105 si\u0119 znajdowa\u0107 w takiej samej relacji odniesienia jak w pierwszej kom\u00f3rce. Nie zawsze tak jest. Na przyk\u0142ad kiedy <strong>mamy jedn\u0105 warto\u015b\u0107 w konkretnej kom\u00f3rce, z kt\u00f3rej chcemy skorzysta\u0107 w ka\u017cdej kolejnej formule<\/strong>. Oczywi\u015bcie mogliby\u015bmy stworzy\u0107 now\u0105 kolumn\u0119 i wype\u0142ni\u0107 j\u0105 takimi samymi warto\u015bciami, ale to zb\u0119dne zajmowanie miejsca i komplikowanie arkusza. <\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Mamy na szcz\u0119\u015bcie mo\u017cliwo\u015b\u0107 <strong>blokowania danej kom\u00f3rki w formule. S\u0142u\u017c\u0105 do tego znaki dolara ($) umieszczane przed liter\u0105 oznaczaj\u0105c\u0105 kolumn\u0119 i liczb\u0105 okre\u015blaj\u0105c\u0105 wiersz. Je\u015bli znak dolara umie\u015bcisz zar\u00f3wno przed liter\u0105 jak i przed liczb\u0105, to ta kom\u00f3rka b\u0119dzie zablokowana zar\u00f3wno przy przeci\u0105ganiu formu\u0142 w orientacji pionowej, jak i w orientacji poziomej. <\/strong><\/p>\n\n\n\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"687\" height=\"281\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/zablokowanie.jpg\" alt=\"\" class=\"wp-image-253\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/zablokowanie.jpg 687w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/zablokowanie-300x123.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/zablokowanie-24x10.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/zablokowanie-36x15.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/zablokowanie-48x20.jpg 48w\" sizes=\"auto, (max-width: 687px) 100vw, 687px\" \/><figcaption>Zablokowanie kom\u00f3rki w obliczeniach<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-pionie.jpg\" alt=\"\" class=\"wp-image-245\" width=\"369\" height=\"277\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-pionie.jpg 437w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-pionie-300x225.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-pionie-24x18.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-pionie-36x27.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-pionie-48x36.jpg 48w\" sizes=\"auto, (max-width: 369px) 100vw, 369px\" \/><figcaption>Przeci\u0105ganie formu\u0142 w pionie<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"266\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-poziomie.jpg\" alt=\"\" class=\"wp-image-246\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-poziomie.jpg 865w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-poziomie-300x92.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-poziomie-768x236.jpg 768w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-poziomie-24x7.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-poziomie-36x11.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/formuly-w-poziomie-48x15.jpg 48w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>Przeci\u0105ganie formu\u0142 w poziomie<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Aby po\u0142\u0105czy\u0107 warto\u015bci z dw\u00f3ch lub wi\u0119cej kom\u00f3rek w ci\u0105g tekstowy nale\u017cy u\u017cy\u0107 w formule znaku konkatenacji czyli \u0142\u0105czenia. Ten znak &amp; &#8211; widnieje na klawiaturze standardowo na klawiszu z numerem 7.<\/strong><\/p>\n\n\n\n<div style=\"height:29px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"334\" height=\"197\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/konkatenacja-formula.jpg\" alt=\"\" class=\"wp-image-247\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/konkatenacja-formula.jpg 334w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/konkatenacja-formula-300x177.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/konkatenacja-formula-24x14.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/konkatenacja-formula-36x21.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/konkatenacja-formula-48x28.jpg 48w\" sizes=\"auto, (max-width: 334px) 100vw, 334px\" \/><figcaption>Formu\u0142a konkatenacji (\u0142\u0105czenia) warto\u015bci w kom\u00f3rkach<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:44px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/efekt-konkatenacji.jpg\" alt=\"\" class=\"wp-image-248\" width=\"330\" height=\"180\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/efekt-konkatenacji.jpg 363w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/efekt-konkatenacji-300x164.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/efekt-konkatenacji-24x13.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/efekt-konkatenacji-36x20.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/efekt-konkatenacji-48x26.jpg 48w\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" \/><figcaption>Rezultat powy\u017cszej formu\u0142y<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:45px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Nie musimy do formu\u0142y z konkatenacj\u0105 wrzuca\u0107 tylko odno\u015bnik\u00f3w do kom\u00f3rek. Mo\u017cemy tak\u017ce dopisa\u0107 jakikolwiek tekst. <strong>Nale\u017cy jednak pami\u0119ta\u0107, \u017ce ka\u017cdy tekst, kt\u00f3ry chcemy doda\u0107, musi by\u0107 po\u0142\u0105czony znakiem \u0142\u0105cznia &amp;, oraz je\u015bli z nim co\u015b chcemy po\u0142\u0105czy\u0107 to te\u017c u\u017cywamy tego znaku. Ponadto tekst wpisany bezpo\u015brednio zawsze otaczamy znakami cudzys\u0142owu.<\/strong><\/p>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"405\" height=\"173\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-formula.jpg\" alt=\"\" class=\"wp-image-249\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-formula.jpg 405w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-formula-300x128.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-formula-24x10.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-formula-36x15.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-formula-48x21.jpg 48w\" sizes=\"auto, (max-width: 405px) 100vw, 405px\" \/><figcaption>Dodanie ci\u0105gu znaj\u00f3w &#8211; konstrukcja<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:41px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"379\" height=\"163\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-efekt.jpg\" alt=\"\" class=\"wp-image-250\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-efekt.jpg 379w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-efekt-300x129.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-efekt-24x10.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-efekt-36x15.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/laczenie-znakow-efekt-48x21.jpg 48w\" sizes=\"auto, (max-width: 379px) 100vw, 379px\" \/><figcaption>Efekt powy\u017cszej formu\u0142y<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:88px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Tak jak wspomnia\u0142em w filmie, <strong>s\u0105 r\u00f3\u017cne metody separacji liczby ca\u0142kowitej od dziesi\u0119tnej. W Polsce przyj\u0119\u0142o si\u0119, \u017ce rozdzielamy takie liczby przecinkiem, natomiast w wielu krajach u\u017cywa si\u0119 kropki.<\/strong> We\u017a to pod uwag\u0119, przy kolejnej analizie jakiego\u015b pliku Excelowego.<\/p>\n\n\n\n<p>Je\u015bli chcesz zmieni\u0107 separator w ustawieniach to wystarczy, \u017ce wejdziesz wed\u0142ug schematu: <strong>File -&gt; Options -&gt;Advanced<\/strong>. Tam znajdziesz opcj\u0119 zmiany separatora dziesi\u0119tnego:<\/p>\n\n\n\n<div style=\"height:34px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"336\" height=\"96\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/separator.jpg\" alt=\"\" class=\"wp-image-251\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/separator.jpg 336w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/separator-300x86.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/separator-24x7.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/separator-36x10.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/04\/separator-48x14.jpg 48w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><figcaption>Zmiana separatora dziesi\u0119tnego<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Je\u015bli natomiast dosta\u0142e\u015b od kogo\u015b plik excelowy, kt\u00f3ry ma inny separator dziesi\u0119tny, mo\u017cesz jednorazowo podmieni\u0107 go na inny jednorazowo dla wszystkich kom\u00f3rek jednocze\u015bnie. O tym jak to zrobi\u0107, b\u0119d\u0119 m\u00f3wi\u0142 w kolejnych materia\u0142ach. Ju\u017c teraz zapraszam!<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Je\u015bli jeszcze nie ogl\u0105da\u0142e\u015b praktycznej cz\u0119\u015bci dotycz\u0105cej tej lekcji to zapraszam:<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Kurs Excel #4 Formu\u0142y - Zaawansowane\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/JlHAw3XeUn0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Cze\u015b\u0107! Dzi\u015b kolejna cz\u0119\u015b\u0107 o formu\u0142ach \u2013 tym razem bardziej zaawansowane tematy, ale niezwykle potrzebne. Odpowiemy na pytania z ostatniej lekcji. Nauczymy si\u0119 jak za jednym zamachem tworzy\u0107 i przelicza\u0107 setki, a nawet tysi\u0105ce formu\u0142. Zapraszam!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-238","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/comments?post=238"}],"version-history":[{"count":5,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/238\/revisions"}],"predecessor-version":[{"id":294,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/238\/revisions\/294"}],"wp:attachment":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/media?parent=238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/categories?post=238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/tags?post=238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}