{"id":277,"date":"2020-05-07T17:49:19","date_gmt":"2020-05-07T17:49:19","guid":{"rendered":"https:\/\/bethecoach.pl\/?p=277"},"modified":"2026-04-01T11:37:59","modified_gmt":"2026-04-01T11:37:59","slug":"typy-danych-w-excelu","status":"publish","type":"post","link":"https:\/\/bethecoach.pl\/index.php\/2020\/05\/07\/typy-danych-w-excelu\/","title":{"rendered":"Typy danych w Excelu."},"content":{"rendered":"\n<p>Zapraszam Ci\u0119 na lekcj\u0119, w kt\u00f3rej om\u00f3wi\u0119 typy danych, a tak\u017ce ich prezentowanie w programie MS Excel. Zach\u0119cam do obejrzenia video z praktycznymi przyk\u0142adami oraz przeczytania artyku\u0142u, kt\u00f3ry uzupe\u0142nia ten temat.<\/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 #5 Typy Danych\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/8QA6sE5xKxI?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:58px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Najbardziej og\u00f3lnie rzecz ujmuj\u0105c, <strong>typy danych w programie MS Excel mo\u017cemy podzieli\u0107 na tekstowe i liczbowe<\/strong>. Wi\u0119cej typ\u00f3w danych mo\u017ce by\u0107 okre\u015blone szczeg\u00f3\u0142owo w <strong>VBA<\/strong> \u2013 czyli j\u0119zyku programowania, w kt\u00f3rym piszemy programy dzia\u0142aj\u0105ce w programie MS Excel (tak zwane \u201emakra\u201d).<\/p>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Domy\u015blnie, jak wspomina\u0142em w poprzednich materia\u0142ach, Excel pr\u00f3buje przypisa\u0107 typ danych do wprowadzonych przez Ciebie warto\u015bci. Jest w tym ca\u0142kiem dobry, dlatego bardzo cz\u0119sto zostawiamy domy\u015blny typ danych czyli <em><strong>General<\/strong><\/em>. Je\u015bli jednak b\u0119dziesz chcia\u0142\/a pokaza\u0107 dane w formacie mniej standardowym to trzeba b\u0119dzie wybra\u0107 z dost\u0119pnych opcji lub stworzy\u0107 sw\u00f3j w\u0142asny.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Typ <strong>danych tekstowych jest standardowo wyr\u00f3wnany do lewej kraw\u0119dzi kom\u00f3rki<\/strong> i po tym najszybciej mo\u017cesz go rozpozna\u0107.<\/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=\"317\" height=\"90\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/tekstowe-typy-danych.jpg\" alt=\"\" class=\"wp-image-278\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/tekstowe-typy-danych.jpg 317w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/tekstowe-typy-danych-300x85.jpg 300w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/tekstowe-typy-danych-24x7.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/tekstowe-typy-danych-36x10.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/tekstowe-typy-danych-48x14.jpg 48w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><figcaption>Tekstowe typy danych<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:54px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Istnieje <strong>mo\u017cliwo\u015b\u0107 przedstawiania danych liczbowych w postaci tekstu \u2013 wystarczy, \u017ce przed ich warto\u015bci\u0105 wstawisz znak cudzys\u0142owu \u2018.<\/strong><\/p>\n\n\n\n<div style=\"height:36px\" 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=\"123\" height=\"77\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/data-jako-tekst.jpg\" alt=\"\" class=\"wp-image-279\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/data-jako-tekst.jpg 123w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/data-jako-tekst-24x15.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/data-jako-tekst-36x23.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/data-jako-tekst-48x30.jpg 48w\" sizes=\"auto, (max-width: 123px) 100vw, 123px\" \/><figcaption>Warto\u015b\u0107 liczbowa jako tekst<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:39px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Ale zaraz, zaraz. M\u00f3wi\u0119 o typie liczbowym, a pokazuj\u0119 Ci dat\u0119. I tutaj przechodzimy do <strong>typ\u00f3w liczbowych<\/strong>. Ot\u00f3\u017c <strong>warto\u015bci wyr\u00f3wnane do prawej kraw\u0119dzi \u2013 s\u0105 warto\u015bciami typu liczbowego<\/strong>. To znaczy, \u017ce Excel przechowuje je w postaci liczb. To, \u017ce widzimy dat\u0119 czy czas jest tylko prezentacj\u0105 warto\u015bci liczbowej uprzednio konwertowanej.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>To, \u017ce <strong>data jest warto\u015bci\u0105 liczbow\u0105<\/strong> mo\u017cesz sprawdzi\u0107 zmieniaj\u0105c typ kom\u00f3rki z dat\u0105 na typ numeryczny.<\/p>\n\n\n\n<div style=\"height:37px\" 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=\"190\" height=\"106\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/data-na-numer.jpg\" alt=\"\" class=\"wp-image-280\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/data-na-numer.jpg 190w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/data-na-numer-24x13.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/data-na-numer-36x20.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/data-na-numer-48x27.jpg 48w\" sizes=\"auto, (max-width: 190px) 100vw, 190px\" \/><figcaption>Data jako warto\u015b\u0107 numeryczna<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:39px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Liczba, kt\u00f3r\u0105 w tym przypadku prezentuje Excel jest liczb\u0105 dni jaka up\u0142yn\u0119\u0142a od pocz\u0105tkowej daty, umownie ustalon\u0105 przez MS Excel jako 1 stycznia 1900 roku.<\/strong> Fakt ten sprawia, \u017ce daty mo\u017cesz u\u017cywa\u0107 w kalkulacjach. Mo\u017cesz na przyk\u0142ad od jednej daty odj\u0105\u0107 drug\u0105, licz\u0105c w ten spos\u00f3b r\u00f3\u017cnic\u0119 w dniach pomi\u0119dzy nimi.<\/p>\n\n\n\n<div style=\"height:40px\" 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=\"123\" height=\"102\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/daty-formu\u0142a.jpg\" alt=\"\" class=\"wp-image-281\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/daty-formu\u0142a.jpg 123w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/daty-formu\u0142a-24x20.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/daty-formu\u0142a-36x30.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/daty-formu\u0142a-48x40.jpg 48w\" sizes=\"auto, (max-width: 123px) 100vw, 123px\" \/><figcaption>Dzia\u0142anie na datach<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:45px\" 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=\"121\" height=\"115\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/daty-formu\u0142a-efekt-1.jpg\" alt=\"\" class=\"wp-image-283\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/daty-formu\u0142a-efekt-1.jpg 121w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/daty-formu\u0142a-efekt-1-24x24.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/daty-formu\u0142a-efekt-1-36x34.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/daty-formu\u0142a-efekt-1-48x46.jpg 48w\" sizes=\"auto, (max-width: 121px) 100vw, 121px\" \/><figcaption>Dzia\u0142anie na datach &#8211; efekt<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:51px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Kolejnym ciekawym przyk\u0142adem wbudowanego w Excelu typu danych jest<strong> typ czasu \u2013 Time<\/strong>. Domy\u015blnie wygl\u0105da on nast\u0119puj\u0105co.<\/p>\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=\"93\" height=\"62\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/czas.jpg\" alt=\"\" class=\"wp-image-284\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/czas.jpg 93w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/czas-24x16.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/czas-36x24.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/czas-48x32.jpg 48w\" sizes=\"auto, (max-width: 93px) 100vw, 93px\" \/><figcaption>Typ Time<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:29px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Po <strong>zamianie typu czasu na numeryczny<\/strong> dostajemy:<\/p>\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\"><img loading=\"lazy\" decoding=\"async\" width=\"90\" height=\"71\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/czas-jako-liczba.jpg\" alt=\"\" class=\"wp-image-285\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/czas-jako-liczba.jpg 90w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/czas-jako-liczba-24x19.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/czas-jako-liczba-36x28.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/czas-jako-liczba-48x38.jpg 48w\" sizes=\"auto, (max-width: 90px) 100vw, 90px\" \/><figcaption>Zmiana na typ numeryczny<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Jeste\u015b zaskoczony? Czas to r\u00f3wnie\u017c typ liczbowy. Rezultat, kt\u00f3ry widzisz to <strong>u\u0142amek doby jaki up\u0142yn\u0105\u0142 do danej godziny<\/strong>. Ten fakt tak\u017ce skutkuje tym, \u017ce mo\u017cemy wykonywa\u0107 kalkulacje na godzinach \u2013 na przyk\u0142ad odejmowa\u0107 jedn\u0105 od drugiej.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Przydatnym typem danych s\u0105 <strong>procenty<\/strong>. <strong>Je\u017celi chcemy po wprowadzeniu danych zamieni\u0107 warto\u015bci na typ procentowy to pami\u0119tajmy, \u017ce musimy wpisywa\u0107 procent jako liczb\u0119 dziesi\u0119tn\u0105 (na przyk\u0142ad 30% = 0,3).<\/strong><\/p>\n\n\n\n<p>Je\u015bli jednak najpierw zaznaczymy puste kom\u00f3rki i przypiszemy do nich format procentowy, to mo\u017cemy wpisywa\u0107 procenty jako liczby ca\u0142kowite (1 jednostka odpowie 1 %).<\/p>\n\n\n\n<div style=\"height:43px\" 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=\"98\" height=\"82\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/procenty-przyklad.jpg\" alt=\"\" class=\"wp-image-286\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/procenty-przyklad.jpg 98w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/procenty-przyklad-24x20.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/procenty-przyklad-36x30.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/procenty-przyklad-48x40.jpg 48w\" sizes=\"auto, (max-width: 98px) 100vw, 98px\" \/><figcaption>Typ procentowy<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:42px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>W przypadku <strong>analizowania bud\u017cet\u00f3w czy operowania na danych zawieraj\u0105cych zestawienia finansowe<\/strong> mo\u017ce przyda\u0107 nam si\u0119 <strong>typ <em>Accounting<\/em><\/strong> (ksi\u0119gowy). Typ ten dodaje walut\u0119 do kom\u00f3rki i oddziela liczby spacjami dla lepszej ich czytelno\u015bci. Co ciekawe dolar w tych kom\u00f3rkach nie oznacza, \u017ce warto\u015b\u0107 zmieni\u0142a si\u0119 na tekstow\u0105. Wr\u0119cz przeciwnie, warto\u015b\u0107 dalej jest liczbowa i mo\u017cesz wykonywa\u0107 na niej obliczenia.<\/p>\n\n\n\n<div style=\"height:38px\" 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=\"153\" height=\"221\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/ksiegowe-przyklad.jpg\" alt=\"\" class=\"wp-image-287\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/ksiegowe-przyklad.jpg 153w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/ksiegowe-przyklad-17x24.jpg 17w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/ksiegowe-przyklad-25x36.jpg 25w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/ksiegowe-przyklad-33x48.jpg 33w\" sizes=\"auto, (max-width: 153px) 100vw, 153px\" \/><figcaption>Typ Accounting<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Ostatnim typem danych, kt\u00f3ry om\u00f3wi\u0119 b\u0119dzie <strong>typ logiczny<\/strong>. Typ ten <strong>przyjmuj\u0119 warto\u015b\u0107 <em>TRUE<\/em> (prawda) lub <em>FALSE<\/em> (fa\u0142sz).<\/strong> Cz\u0119sto typ ten \u201eujawni\u201d Ci si\u0119 przy por\u00f3wnywaniu r\u00f3\u017cnych warto\u015bci. Na przyk\u0142ad por\u00f3wnuj\u0105c dwie liczby (sprawdzaj\u0105c czy jedna jest wi\u0119ksza od drugiej):<\/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=\"198\" height=\"124\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/porownanie-liczb.jpg\" alt=\"\" class=\"wp-image-288\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/porownanie-liczb.jpg 198w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/porownanie-liczb-24x15.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/porownanie-liczb-36x23.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/porownanie-liczb-48x30.jpg 48w\" sizes=\"auto, (max-width: 198px) 100vw, 198px\" \/><figcaption>Por\u00f3wnanie liczb<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Otrzymujemy warto\u015b\u0107 logiczn\u0105.<\/p>\n\n\n\n<div style=\"height:38px\" 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=\"224\" height=\"139\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/porownanie-liczb-efekt.jpg\" alt=\"\" class=\"wp-image-289\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/porownanie-liczb-efekt.jpg 224w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/porownanie-liczb-efekt-24x15.jpg 24w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/porownanie-liczb-efekt-36x22.jpg 36w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/porownanie-liczb-efekt-48x30.jpg 48w\" sizes=\"auto, (max-width: 224px) 100vw, 224px\" \/><figcaption>Wynik w postaci typu logicznego<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:37px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Powy\u017csze typy danych <strong>nie s\u0105 jednak wszystkimi typami, jakie mo\u017cesz przedstawi\u0107 w Excelu<\/strong>. Istnieje ich tak naprawd\u0119 niesko\u0144czona ilo\u015b\u0107. <strong>Aby stworzy\u0107 sw\u00f3j typ danych, albo zmodyfikowa\u0107 ju\u017c istniej\u0105cy format \u2013 wystarczy, \u017ce na danym zakresie kom\u00f3rek wybierzesz opcj\u0119 <em>Format Cells<\/em><\/strong> po klikni\u0119ciu prawym przyciskiem myszy. Nast\u0119pnie ostatnia opcja w zak\u0142adce <em>Number<\/em> to <em>Custom<\/em>. W niej <strong>mo\u017cesz tworzy\u0107 i modyfikowa\u0107 prezentowane formaty<\/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=\"292\" height=\"588\" src=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Format-Cells.jpg\" alt=\"\" class=\"wp-image-290\" srcset=\"https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Format-Cells.jpg 292w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Format-Cells-149x300.jpg 149w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Format-Cells-12x24.jpg 12w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Format-Cells-18x36.jpg 18w, https:\/\/bethecoach.pl\/wp-content\/uploads\/2020\/05\/Format-Cells-24x48.jpg 24w\" sizes=\"auto, (max-width: 292px) 100vw, 292px\" \/><figcaption>Opcja Format Cells<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:33px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Wi\u0119cej o tej opcji znajdziesz w filmie do\u0142\u0105czonym do tej lekcji. W jednej z kolejnych lekcji wr\u00f3cimy do tematu tworzenia autorskich format\u00f3w. <\/strong><\/p>\n\n\n\n<div style=\"height:25px\" 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 #5 Typy Danych\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/8QA6sE5xKxI?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>Zapraszam Ci\u0119 na lekcj\u0119, w kt\u00f3rej om\u00f3wi\u0119 typy danych, a tak\u017ce ich prezentowanie w programie MS Excel. Zach\u0119cam do obejrzenia video z praktycznymi przyk\u0142adami oraz przeczytania artyku\u0142u, kt\u00f3ry uzupe\u0142nia ten temat.<\/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-277","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/277","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=277"}],"version-history":[{"count":3,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/277\/revisions"}],"predecessor-version":[{"id":293,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/posts\/277\/revisions\/293"}],"wp:attachment":[{"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/media?parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/categories?post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bethecoach.pl\/index.php\/wp-json\/wp\/v2\/tags?post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}