{"id":1619,"date":"2014-11-15T22:40:19","date_gmt":"2014-11-15T21:40:19","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=1619"},"modified":"2022-04-24T22:30:34","modified_gmt":"2022-04-24T20:30:34","slug":"az-excel-hasznalata-egyszeruen","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/","title":{"rendered":"Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Az Excel haszn\u00e1lata k\u00f6nnyen megtanulhat\u00f3. Persze lehet, hogy els\u0151re Te is \u00f3vatosan, net\u00e1n&nbsp;<a title=\"Nem kell, hogy az Excel stresszes legyen!\" href=\"https:\/\/sosexcel.com\/exceltippek\/nem-kell-hogy-az-excel-stresszes-legyen\/\" target=\"_blank\" rel=\"noopener\"><span style=\"text-decoration: underline;\">f\u00e9lelemmel k\u00f6zel\u00edtesz a program fel\u00e9<\/span><\/a>, ami biztos, hogy nem a Te hib\u00e1d, mert b\u00e1rki megtanulhatja. Ebben az esetben \u00e9rdemes elj\u00f6nn\u00f6d egy <span style=\"text-decoration: underline;\"><a title=\"Garant\u00e1ltan megbar\u00e1tkozol az Excellel\" href=\"http:\/\/exceltitok.hu\/\" target=\"_blank\" rel=\"noopener\">szem\u00e9lyre szabott Excel mini-tanfolyamra<\/a><\/span>, ahol garant\u00e1ltan siker\u00e9lm\u00e9nyben lesz r\u00e9szed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A Microsoft Excel egy <a title=\"Mi a t\u00e1bl\u00e1zatkezel\u0151 \u00e9s honnan lehet let\u00f6lteni?\" href=\"https:\/\/sosexcel.com\/exceltippek\/mi-a-tablazatkezelo-es-honnan-lehet-letolteni\/\" target=\"_blank\" rel=\"noopener\"><span style=\"text-decoration: underline;\">t\u00e1bl\u00e1zatkezel\u0151 program<\/span><\/a>, melyet jellemz\u0151en <strong>adatok t\u00e1rol\u00e1s\u00e1<\/strong>ra, elemz\u00e9sre \u00e9s <strong>sz\u00e1mol\u00e1sra<\/strong> haszn\u00e1lhatsz.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\">Ebben a 2 dologban k\u00fcl\u00f6n\u00f6sen profi. <strong>Meg fogsz&nbsp;lep\u0151dni, hogy mennyivel okosabb<\/strong>, mint Te, \u00e9s mennyi mindent&nbsp;megcsin\u00e1l helyetted.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00cdgy kezdd az Excel tanul\u00e1st<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line.jpg\"><img fetchpriority=\"high\" decoding=\"async\" width=\"300\" height=\"201\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line-300x201.jpg\" alt=\"Az Excel haszn\u00e1lata egyszer\u0171, csak el kell kezdeni valahol.\" class=\"wp-image-1875\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line-300x201.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line-660x442.jpg 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line-240x161.jpg 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line.jpg 845w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"font-size: 16px; line-height: 1.714285714;\">Ha megnyitsz egy Excel f\u00e1jlt, n\u00e9h\u00e1ny f\u00fcllel (munkalap) \u00e9s j\u00f3 sok&nbsp;cell\u00e1val tal\u00e1lod magad szemben. <\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"font-size: 16px; line-height: 1.714285714;\">Fel\u00fcl bet\u0171ket tal\u00e1lsz, ezek&nbsp;hat\u00e1rozz\u00e1k meg az oszlopokat, oldalt pedig sz\u00e1mokat, amik a&nbsp;sorokat azonos\u00edtj\u00e1k. <\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"font-size: 16px; line-height: 1.714285714;\">A kett\u0151 kombin\u00e1ci\u00f3ja fogja meghat\u00e1rozni a&nbsp;cell\u00e1t. P\u00e9ld\u00e1ul a B oszlop 4. sorban l\u00e9v\u0151 cell\u00e1ja lesz a B4.<\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A cell\u00e1k kijel\u00f6l\u00e9s\u00e9re&nbsp;<span style=\"text-decoration: underline;\"><a title=\"A kijel\u00f6l\u00e9s fort\u00e9lyai \u2013 avagy hogyan haszn\u00e1ld az egeret a t\u00e1bl\u00e1zatokban?\" href=\"https:\/\/sosexcel.com\/exceltippek\/a-kijeloles-fortelyai-avagy-hogyan-hasznald-az-egeret-tablazatokban\/\" target=\"_blank\" rel=\"noopener\">eleinte az egeret \u00e9rdemes haszn\u00e1lnod<\/a><\/span>.&nbsp;A cell\u00e1kat ugyan\u00fagy form\u00e1zhatod, mint a sz\u00f6vegeket a Wordben. De itt is&nbsp;<a title=\"Haszn\u00e1ld a st\u00edlusokat az egyszer\u0171bb form\u00e1z\u00e1shoz\" href=\"https:\/\/sosexcel.com\/exceltippek\/hasznald-a-stilusokat-az-egyszerubb-formazashoz\/\" target=\"_blank\" rel=\"noopener\"><span style=\"text-decoration: underline;\">egyszer\u0171s\u00edthetsz a st\u00edlusok haszn\u00e1lat\u00e1val<\/span><\/a>. Valamint \u00e9rdemes n\u00e9h\u00e1ny elvet betartanod, hogy a v\u00e9g\u00e9n&nbsp;<a title=\"A sz\u00e9p t\u00e1bl\u00e1zat 7 tulajdons\u00e1ga\" href=\"https:\/\/sosexcel.com\/exceltippek\/a-szep-tablazat-7-jellemzoje\/\" target=\"_blank\" rel=\"noopener\"><span style=\"text-decoration: underline;\">sz\u00e9p legyen a t\u00e1bl\u00e1zatod<\/span>.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00cdgy \u00edrd be az adatokat<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">El\u00e9g csak r\u00e1kattintanod egy cell\u00e1ra (csak egyszer(!), \u00e9s ne ijedj meg, ha nem l\u00e1tod a kurzort), \u00e9s m\u00e1r \u00edrhatod is az \u00e9rt\u00e9ket,&nbsp;amit ott szeretn\u00e9l l\u00e1tni. A tartalom r\u00f6gz\u00edt\u00e9s\u00e9re az Enter \u00e9s a Tab&nbsp;gombokat haszn\u00e1lhatod. Mindkett\u0151 a k\u00f6vetkez\u0151 cell\u00e1ba ugrik, az&nbsp;egyik lefel\u00e9, a m\u00e1sik jobbra. <a title=\"Adatbevitel gyorsan\" rel=\"noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/adatbevitel-gyorsan\/\" target=\"_blank\"><span style=\"text-decoration: underline;\">Gyors\u00edthatsz, ha a kett\u0151t egy\u00fctt haszn\u00e1lod<\/span><\/a>, ebben a vide\u00f3ban mutatom is:&nbsp;<\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/_QjoDnescos\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Igyekezz egy cell\u00e1ba csak sz\u00e1mot vagy csak sz\u00f6veget \u00edrni<\/strong>, s\u0151t tagold k\u00fcl\u00f6n oszlopokra, amennyire csak tudod.&nbsp;P\u00e9ld\u00e1ul az id\u0151intervallumok kezdet\u00e9t \u00e9s v\u00e9g\u00e9t k\u00fcl\u00f6n oszlopban add&nbsp;meg. Nevek \u00e9s c\u00edmek eset\u00e9ben is \u00e9rdemes elgondolkodnod azon,&nbsp;hogy milyen tagol\u00e1sban lesz sz\u00fcks\u00e9ged k\u00e9s\u0151bb az inform\u00e1ci\u00f3ra: mehet egy mez\u0151be, vagy k\u00fcl\u00f6n szeretn\u00e9d kezelni p\u00e9ld\u00e1ul a vezet\u00e9knevet \u00e9s a keresztnevet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sz\u00e1mok mell\u00e9 sose \u00edrd be k\u00e9zzel a m\u00e9rt\u00e9kegys\u00e9get.<\/strong> Erre haszn\u00e1lj&nbsp;k\u00fcl\u00f6n oszlopot vagy cellaform\u00e1z\u00e1st. P\u00e9ld\u00e1ul a Ft ki\u00edr\u00e1sra 3 megold\u00e1st is haszn\u00e1lhatsz:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Kattints a jobbklikk Cellaform\u00e1z\u00e1s men\u00fcre, majd a felugr\u00f3 ablakban (Cell\u00e1k form\u00e1z\u00e1sa) a Sz\u00e1m f\u00fcl\u00f6n a P\u00e9nznem csoportot haszn\u00e1ld.<\/li><li>Ugyanezt a Kezd\u0151lapon is megtal\u00e1lod: a Sz\u00e1m&nbsp;csoporton az \u00c1ltal\u00e1nos kateg\u00f3ria helyett v\u00e1laszd a leny\u00edl\u00f3 list\u00e1ban a P\u00e9nznem kateg\u00f3ri\u00e1t.<\/li><li>Vagy kicsit lejjebb&nbsp;a p\u00e9nz ikonra kattintva is Ft form\u00e1z\u00e1st kapsz.&nbsp;A p\u00e9nz melletti ny\u00edlra kattintva a $ \u00e9s \u20ac form\u00e1z\u00e1s is el\u00e9rhet\u0151.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-3 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/cellaform\u00e1z\u00e1s-p\u00e9nznem.jpg\"><img decoding=\"async\" width=\"556\" height=\"471\" data-id=\"2446\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/cellaform\u00e1z\u00e1s-p\u00e9nznem.jpg\" alt=\"\" class=\"wp-image-2446\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/cellaform\u00e1z\u00e1s-p\u00e9nznem.jpg 556w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/cellaform\u00e1z\u00e1s-p\u00e9nznem-300x254.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/cellaform\u00e1z\u00e1s-p\u00e9nznem-240x203.jpg 240w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/sz\u00e1mform\u00e1tum-p\u00e9nznem-e1434451384353.jpg\"><img decoding=\"async\" width=\"372\" height=\"298\" data-id=\"2445\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/sz\u00e1mform\u00e1tum-p\u00e9nznem-e1434451384353.jpg\" alt=\"\" class=\"wp-image-2445\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/sz\u00e1mform\u00e1tum-p\u00e9nz-ikon.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"372\" height=\"250\" data-id=\"2444\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/sz\u00e1mform\u00e1tum-p\u00e9nz-ikon.jpg\" alt=\"\" class=\"wp-image-2444\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/sz\u00e1mform\u00e1tum-p\u00e9nz-ikon.jpg 372w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/sz\u00e1mform\u00e1tum-p\u00e9nz-ikon-300x202.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/sz\u00e1mform\u00e1tum-p\u00e9nz-ikon-240x161.jpg 240w\" sizes=\"(max-width: 372px) 100vw, 372px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">A p\u00e9nznemek&nbsp;alap\u00e9rtelmezetten 2 tizedesjeggyel jelennek meg, ez\u00e9rt akkor se&nbsp;ijedj meg, ha <a rel=\"noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/mi-ez-a-sok\/\" target=\"_blank\"><span style=\"text-decoration: underline;\">hirtelen ### -kel lesz tele a cella<\/span><\/a>. Ilyenkor&nbsp;cs\u00f6kkentsd a tizedes jegyek hely\u00e9t, vagy&nbsp;sz\u00e9les\u00edtsd ki kell\u0151en az oszlopot.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img loading=\"lazy\" decoding=\"async\" width=\"147\" height=\"87\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/tizedesjegy.jpg\" alt=\"tizedesjegy\" class=\"wp-image-2450\"\/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">A 00-s ikonokkal cs\u00f6kkentheted, illetve n\u00f6velheted a tizedes jegyek sz\u00e1m\u00e1t.&nbsp;Nem baj,&nbsp;ha nem tal\u00e1lod el els\u0151re, korrig\u00e1lj a m\u00e1sik&nbsp;ir\u00e1nyba.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ezek a l\u00e1tsz\u00f3lagos m\u00f3dos\u00edt\u00e1sok nem fogj\u00e1k&nbsp;mag\u00e1t a sz\u00e1mot megv\u00e1ltoztatni. A sz\u00e1m\u00edt\u00e1sokhoz <strong>a program&nbsp;mindig a t\u00e9nyleges \u00e9rt\u00e9ket haszn\u00e1lja<\/strong>, melyet a szerkeszt\u0151l\u00e9cr\u0151l&nbsp;olvashatsz le.&nbsp;P\u00e9ld\u00e1ul ha egy cell\u00e1ban 17,51-t \u00edrsz, de egy tizedes jegyre&nbsp;form\u00e1zod, akkor 17,5 lesz. Viszont&nbsp;a 8,37-b\u0151l 8,4 lesz a kerek\u00edt\u00e9s szab\u00e1lyai szerint.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Az Excel haszn\u00e1lata sz\u00e1mol\u00e1sra<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A munkalapokon egyszer\u0171 k\u00e9pletek be\u00edr\u00e1s\u00e1val \u00f6sszead\u00e1st,&nbsp;oszt\u00e1st, szorz\u00e1st \u00e9s kivon\u00e1s\u00e1t v\u00e9gezhetsz, <strong>hasonl\u00f3an, mint egy&nbsp;sz\u00e1mol\u00f3g\u00e9pen<\/strong>.&nbsp;K\u00f6nnyebbs\u00e9g, hogy a m\u00e1r r\u00f6gz\u00edtett sz\u00e1mokat tov\u00e1bbi&nbsp;sz\u00e1m\u00edt\u00e1sokkor nem kell \u00fajra bep\u00f6ty\u00f6gni, hanem hivatkozhatsz&nbsp;arra a cell\u00e1ra, amelyben szerepel.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/szamolas-excelben.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"227\" height=\"150\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/szamolas-excelben.jpg\" alt=\"Az Excel haszn\u00e1lata sz\u00e1mol\u00e1sra\" class=\"wp-image-1623\"\/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Ennek el\u0151nye, hogy ha \u00e1t\u00edrod a hivatkozott cell\u00e1ban szerepl\u0151&nbsp;sz\u00e1mot, akkor automatikusan friss\u00fcl a k\u00e9plet eredm\u00e9nye is.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ha be\u00edrt\u00e1l <strong>egy k\u00e9pletet, azt r\u00e1ad\u00e1sul \u00e1tm\u00e1solhatod a szomsz\u00e9dos&nbsp;cell\u00e1kba is<\/strong>, \u00edgy nem kell \u00fajra meg \u00fajra kisz\u00e1molnod a sorokat.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">P\u00e9ld\u00e1ul egy lelt\u00e1rnyilv\u00e1ntart\u00e1sban el\u00e9g egyszer megadni a darab x \u00e1r k\u00e9pletet, \u00e9s a m\u00e1sol\u00e1s ut\u00e1n ak\u00e1r t\u00f6bb sz\u00e1z sorra is megkapod az eredm\u00e9nyt. Ezt h\u00edvj\u00e1k relat\u00edv hivatkoz\u00e1snak az Excelben.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Minden k\u00e9plet egyenl\u0151s\u00e9gjellel (=) kezd\u0151dik<\/strong>. Ha&nbsp;szeretn\u00e9l sp\u00f3rolni, haszn\u00e1ld a pluszjelet (+) a numerikus&nbsp;billenty\u0171zetr\u0151l. Ezt is felismeri az Excel, \u00e9s kiteszi el\u00e9 az = jelet.&nbsp;Majd a sz\u00e1mokat \u00e9s a haszn\u00e1lni k\u00edv\u00e1nt&nbsp;matematikai m\u0171veleteket \u00edrd be (ehhez a numerikus billenty\u0171zet + &#8211; \/ * jeleit haszn\u00e1ld),&nbsp;ugyan\u00fagy, mint a sz\u00e1mol\u00f3g\u00e9pbe. Sz\u00fcks\u00e9g eset\u00e9n <a title=\"Mi a m\u0171veletek sorrendje, \u00e9s mikor kell z\u00e1r\u00f3jelet haszn\u00e1lni?\" href=\"https:\/\/sosexcel.com\/exceltippek\/mi-a-muveletek-sorrendje-es-mikor-kell-zarojelet-hasznalni\/\" target=\"_blank\" rel=\"noopener\"><span style=\"text-decoration: underline;\">ne feledkezz meg a z\u00e1r\u00f3jelekr\u0151l se!<\/span><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ha v\u00e9gezt\u00e9l, a&nbsp;k\u00e9plet v\u00e9gleges\u00edt\u00e9s\u00e9hez&nbsp;nyomd meg az Enter billenty\u0171t. Ekkor az&nbsp;Excel kisz\u00e1m\u00edtja \u00e9s megjelen\u00edti a k\u00e9plet eredm\u00e9ny\u00e9t.&nbsp;Ha ki van jel\u00f6lve a cella, a k\u00e9pletet a szerkeszt\u0151l\u00e9cen l\u00e1tod, itt tudod ut\u00f3lag ellen\u0151rizni.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A sz\u00e1m\u00edt\u00e1sokat <a title=\"A f\u00fcggv\u00e9nyek olyanok, mint az automat\u00e1k\" href=\"https:\/\/sosexcel.com\/exceltippek\/fuggvenyek-olyanok-mint-az-automatak\/\" target=\"_blank\" rel=\"noopener\"><span style=\"text-decoration: underline;\">egyszer\u0171s\u00edtheted a f\u00fcggv\u00e9nyek seg\u00edts\u00e9g\u00e9vel<\/span><\/a>. A legismertebb f\u00fcggv\u00e9nyek a <span style=\"text-decoration: underline;\"><a title=\"Rossz helyre teszed a Szumm\u00e1t\" href=\"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/\" target=\"_blank\" rel=\"noopener\">Szumma<\/a>&nbsp;<\/span>(vagy AutoSzum), \u00c1tlag, Darab, Minimum, Maximum. Ez ut\u00f3bbi n\u00e9gyet a Szumma melletti ny\u00edln\u00e1l tal\u00e1lod.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Az Excel haszn\u00e1lata adatok t\u00e1rol\u00e1s\u00e1ra<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Az adatokat elkezdheted egy Excel t\u00e1bl\u00e1ban is gy\u0171jteni, de gyakori eset, hogy valamilyen programb\u00f3l k\u00e9red le az adatokat, \u00e9s az Excelben.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Figyelj arra, hogy az Excel adatb\u00e1zisodnak mindig csak egy fejl\u00e9ce (elnevez\u00e9se) legyen, \u00e9s a k\u00fcl\u00f6nb\u00f6z\u0151 adatokat k\u00fcl\u00f6n oszlopba gy\u0171jtsd, p\u00e9ld\u00e1ul vev\u0151 neve (ak\u00e1r k\u00fcl\u00f6n vezet\u00e9kn\u00e9v, keresztn\u00e9v), c\u00edme, v\u00e1s\u00e1rl\u00e1s d\u00e1tuma, megv\u00e1s\u00e1rolt term\u00e9k neve \u00e9s \u00e1ra.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ha ezt betartod, k\u00f6nnyebben kezelhet\u0151 lesz a t\u00e1bl\u00e1zatod. P\u00e9ld\u00e1ul megsp\u00f3rolhatod&nbsp;&nbsp;a kijel\u00f6l\u00e9seket a <a title=\"Fejl\u00e9cek r\u00f6gz\u00edt\u00e9se\" href=\"https:\/\/sosexcel.com\/exceltippek\/felso-sor-rogzitese\/\" rel=\"noopener noreferrer\"><span style=\"text-decoration: underline;\">fejl\u00e9c r\u00f6gz\u00edt\u00e9sn\u00e9l<\/span><\/a>, sorba rendez\u00e9sn\u00e9l, sz\u0171r\u00e9sn\u00e9l, kimutat\u00e1s k\u00e9sz\u00edt\u00e9sn\u00e9l.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sokat seg\u00edt, ha haszn\u00e1lod a &#8222;<a href=\"https:\/\/sosexcel.com\/exceltippek\/formazas-tablazatkent\/\" rel=\"noopener\"><span style=\"text-decoration: underline;\">Form\u00e1z\u00e1s t\u00e1bl\u00e1zatk\u00e9nt<\/span><\/a>&#8221; funkci\u00f3t.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/01\/K%C3%A9perny%C5%91fot%C3%B3-2017-01-07-1.17.40.png\" rel=\"lightbox[5456]\"><img loading=\"lazy\" decoding=\"async\" width=\"238\" height=\"224\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/01\/K\u00e9perny\u0151fot\u00f3-2017-01-07-1.17.40.png\" alt=\"Az Excel haszn\u00e1lata adatok t\u00e1rol\u00e1s\u00e1ra\" class=\"wp-image-4709\"\/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">A men\u00fc jobb sz\u00e9l\u00e9n az (AutoSzum mellett) keresd a Rendez\u00e9s \u00e9s sz\u0171r\u00e9s gombot, itt tal\u00e1lod a list\u00e1kkal, adatb\u00e1zisokkal kapcsolatos leghasznosabb funkci\u00f3kat:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/hiba-sorba-rendezesnel-oszlopot-jelolsz-ki\/\"><span style=\"text-decoration: underline;\">Hogyan kell az adatokat sorba rendezni?<\/span><br><\/a><span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/tobb-szempont-szerint-rendezni-az-adatokat\/\">Lehet-e egyszerre t\u00f6bb szempont szerint rendezni az adatokat?<\/a><\/span><br><span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/\">Hogyan tudsz napok szerint rendezni?<\/a><\/span><br><span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-hasznald-szurest-az-informacio-kinyeresere\/\">Hogyan haszn\u00e1ld a sz\u0171r\u00e9st az inform\u00e1ci\u00f3 kinyer\u00e9s\u00e9re?<\/a><\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Az Excel haszn\u00e1lata m\u00e9g jobban<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ha szeretn\u00e9d m\u00e9g jobban ismerni&nbsp;az Excelt<\/strong>, akkor \u00e9rdemes elj\u00f6nn\u00f6d egy Excel tanfolyamra, ahol gyakorlatias p\u00e9ld\u00e1kon kereszt\u00fcl, j\u00e1t\u00e9kosan tan\u00edtunk meg az Excel haszn\u00e1lat\u00e1ra.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"text-decoration: underline;\"><a rel=\"noopener\" href=\"https:\/\/exceltitok.hu\/oktatas\/\" target=\"_blank\">Egy\u00e9nileg, teljesen\u00a0 szem\u00e9lyre szabotton<\/a><\/span> is tanulhatsz, vagy csatlakozhatsz a 9 alkalmas <span style=\"text-decoration: underline;\"><a rel=\"noopener\" href=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/\" target=\"_blank\">csoportos Kezd\u0151 Excel tanfolyam<\/a><\/span>hoz is:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>egy\u00e9ni: <span style=\"text-decoration: underline;\"><a href=\"https:\/\/exceltitok.hu\/oktatas\/\" target=\"_blank\" rel=\"noopener\">https:\/\/exceltitok.hu\/oktatas\/<\/a><\/span><\/li><li>csoportos: <span style=\"text-decoration: underline;\"><a href=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/\" target=\"_blank\" rel=\"noopener\">https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/<\/a><\/span><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Minden tan\u00e1runk profi Excel felhaszn\u00e1l\u00f3 \u00e9s oktat\u00f3,<\/strong> mellette komoly gazdas\u00e1gi tapasztalattal rendelkezik. Vagyis olyan mentort kapsz, aki pontosan \u00e9rti, hogy a munk\u00e1dban mire van sz\u00fcks\u00e9ged.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Kezdj el gyakorolni ezekkel a feladatokkal<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Ak\u00e1rhogy is tanulsz, a sikered a gyakorl\u00e1s mennyis\u00e9g\u00e9t\u0151l f\u00fcgg. N\u00e9zd meg ezt a 2 p\u00e9ld\u00e1t \u00e9s sz\u00e1nj id\u0151t a gyakorl\u00e1sra:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kezd\u0151 Excel feladat: <span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-feladat-megoldas-formazas-6\/\">https:\/\/sosexcel.com\/exceltippek\/excel-feladat-megoldas-formazas-6\/<\/a><\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cdgy v\u00e1laszd sz\u00e9t a vezet\u00e9k- \u00e9s keresztnevet: <span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/\">https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/<\/a><\/span><\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/Zj23CGqs7dE\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n","protected":false},"excerpt":{"rendered":"<p>Az Excel haszn\u00e1lata k\u00f6nnyen megtanulhat\u00f3. Persze lehet, hogy els\u0151re Te is \u00f3vatosan, net\u00e1n&nbsp;f\u00e9lelemmel k\u00f6zel\u00edtesz a program fel\u00e9, ami biztos, hogy nem a Te hib\u00e1d, mert b\u00e1rki megtanulhatja. Ebben az esetben \u00e9rdemes elj\u00f6nn\u00f6d egy szem\u00e9lyre szabott Excel mini-tanfolyamra, ahol garant\u00e1ltan siker\u00e9lm\u00e9nyben lesz r\u00e9szed. A Microsoft Excel egy t\u00e1bl\u00e1zatkezel\u0151 program, melyet jellemz\u0151en adatok t\u00e1rol\u00e1s\u00e1ra, elemz\u00e9sre \u00e9s sz\u00e1mol\u00e1sra [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","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":"default","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":"var(--ast-global-color-4)","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":[58],"class_list":["post-1619","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek","tag-kezdoknek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en - ExcelTitok<\/title>\n<meta name=\"description\" content=\"Az Excel haszn\u00e1lata k\u00f6nnyen megtanulhat\u00f3. Persze lehet, hogy els\u0151re Te is \u00f3vatosan, net\u00e1n f\u00e9lelemmel k\u00f6zel\u00edtesz a program fel\u00e9. Seg\u00edtek, olvass tov\u00e1bb.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en - ExcelTitok\" \/>\n<meta property=\"og:description\" content=\"Az Excel haszn\u00e1lata k\u00f6nnyen megtanulhat\u00f3. Persze lehet, hogy els\u0151re Te is \u00f3vatosan, net\u00e1n f\u00e9lelemmel k\u00f6zel\u00edtesz a program fel\u00e9. Seg\u00edtek, olvass tov\u00e1bb.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-15T21:40:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-24T20:30:34+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line-300x201.jpg\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en\",\"datePublished\":\"2014-11-15T21:40:19+00:00\",\"dateModified\":\"2022-04-24T20:30:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/\"},\"wordCount\":1456,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/11\\\/start-line-300x201.jpg\",\"keywords\":[\"kezd\u0151knek\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/\",\"name\":\"Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en - ExcelTitok\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/11\\\/start-line-300x201.jpg\",\"datePublished\":\"2014-11-15T21:40:19+00:00\",\"dateModified\":\"2022-04-24T20:30:34+00:00\",\"description\":\"Az Excel haszn\u00e1lata k\u00f6nnyen megtanulhat\u00f3. Persze lehet, hogy els\u0151re Te is \u00f3vatosan, net\u00e1n f\u00e9lelemmel k\u00f6zel\u00edtesz a program fel\u00e9. Seg\u00edtek, olvass tov\u00e1bb.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/11\\\/start-line-300x201.jpg\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/11\\\/start-line-300x201.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/az-excel-hasznalata-egyszeruen\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\\\/\\\/exceltitok.hu\\\/\",\"https:\\\/\\\/www.facebook.com\\\/bernadett.koros\"],\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/author\\\/sos-excel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en - ExcelTitok","description":"Az Excel haszn\u00e1lata k\u00f6nnyen megtanulhat\u00f3. Persze lehet, hogy els\u0151re Te is \u00f3vatosan, net\u00e1n f\u00e9lelemmel k\u00f6zel\u00edtesz a program fel\u00e9. Seg\u00edtek, olvass tov\u00e1bb.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/","og_locale":"hu_HU","og_type":"article","og_title":"Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en - ExcelTitok","og_description":"Az Excel haszn\u00e1lata k\u00f6nnyen megtanulhat\u00f3. Persze lehet, hogy els\u0151re Te is \u00f3vatosan, net\u00e1n f\u00e9lelemmel k\u00f6zel\u00edtesz a program fel\u00e9. Seg\u00edtek, olvass tov\u00e1bb.","og_url":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2014-11-15T21:40:19+00:00","article_modified_time":"2022-04-24T20:30:34+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line-300x201.jpg","type":"","width":"","height":""}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"7 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en","datePublished":"2014-11-15T21:40:19+00:00","dateModified":"2022-04-24T20:30:34+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/"},"wordCount":1456,"commentCount":6,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line-300x201.jpg","keywords":["kezd\u0151knek"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/","url":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/","name":"Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en - ExcelTitok","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line-300x201.jpg","datePublished":"2014-11-15T21:40:19+00:00","dateModified":"2022-04-24T20:30:34+00:00","description":"Az Excel haszn\u00e1lata k\u00f6nnyen megtanulhat\u00f3. Persze lehet, hogy els\u0151re Te is \u00f3vatosan, net\u00e1n f\u00e9lelemmel k\u00f6zel\u00edtesz a program fel\u00e9. Seg\u00edtek, olvass tov\u00e1bb.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line-300x201.jpg","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/11\/start-line-300x201.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/az-excel-hasznalata-egyszeruen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Itt kezdd: Az Excel haszn\u00e1lata egyszer\u0171en"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/1619","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=1619"}],"version-history":[{"count":42,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/1619\/revisions"}],"predecessor-version":[{"id":9507,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/1619\/revisions\/9507"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=1619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=1619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=1619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}