{"id":5668,"date":"2017-11-05T09:02:23","date_gmt":"2017-11-05T08:02:23","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=5668"},"modified":"2019-09-30T10:11:30","modified_gmt":"2019-09-30T08:11:30","slug":"7-hasznos-excel-trukk","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/","title":{"rendered":"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz"},"content":{"rendered":"<p>7 hasznos Excel tr\u00fckk, amivel v\u00e9gre id\u0151t nyerhetsz! Ugyanis ha\u00a0megtanulod \u00e9s alkalmazod, akkor <strong>a rutin Excel feladatokat ak\u00e1r harmad-\u00f6t\u00f6d id\u0151 alatt v\u00e9gezheted el,<\/strong> \u00e9s a felszabadult id\u0151t m\u00e1sra ford\u00edthatod.<\/p>\n<p>V\u00e9gre nem kell kapkodnod &#8211; \u00e9s \u00edgy \u00e1lland\u00f3an hib\u00e1zni -, hanem \u00e1t tudod gondolni higgadtan, hogy mit akarsz.<\/p>\n<p>Nem kell \u00e1lland\u00f3an a koll\u00e9g\u00e1khoz rohang\u00e1lni seg\u00edts\u00e9g\u00e9rt, hanem mostant\u00f3l \u0151k fognak irigy tekintettel vizsg\u00e1lgatni &#8211; persze csak titokban&#8230; Tudod, mit? Legy\u00e9l j\u00f3fej, \u00e9s oszd meg vel\u00fck is ezeket a hasznos Excel tr\u00fckk\u00f6ket!<\/p>\n<p><!--more--><br \/><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-hasznos-excel-trukk.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft wp-image-5703 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-hasznos-excel-trukk.png\" alt=\"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz\" width=\"940\" height=\"788\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-hasznos-excel-trukk.png 940w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-hasznos-excel-trukk-300x251.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-hasznos-excel-trukk-768x644.png 768w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-hasznos-excel-trukk-660x553.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-hasznos-excel-trukk-240x201.png 240w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><\/a><\/p>\n<h2>1. Keress \u00fcgyesebben<\/h2>\n<p>Ma az inform\u00e1ci\u00f3 kor\u00e1t \u00e9lj\u00fck, kulcsfontoss\u00e1g\u00fa, hogy milyen hamar tal\u00e1lod meg!<\/p>\n<p><img decoding=\"async\" class=\"alignright wp-image-2181 size-medium\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/05\/nagyit\u00f3-keyboard-300x169.jpg\" alt=\"Excel tr\u00fckk #1: Keress \u00fcgyesebben!\" width=\"300\" height=\"169\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/05\/nagyit\u00f3-keyboard-300x169.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/05\/nagyit\u00f3-keyboard-240x135.jpg 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/05\/nagyit\u00f3-keyboard.jpg 646w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>A sz\u00e1m\u00edt\u00f3g\u00e9pes keres\u00e9shez haszn\u00e1ld a <strong>Ctrl F billenty\u0171kombin\u00e1ci\u00f3t!\u00a0<\/strong><\/p>\n<p>Akkor leszel igaz\u00e1n gyors, ha egy\u00e1ltal\u00e1n nem haszn\u00e1lod az egeret:<\/p>\n<ol>\n<li>Ctrl F a keres\u0151ablakhoz<\/li>\n<li>keresett sz\u00f3 beg\u00e9pel\u00e9se<\/li>\n<li><strong>Enter<\/strong>: \u00e9s m\u00e1r oda is ugrik az els\u0151 tal\u00e1lalatra (m\u00e9g egy Enterrel pedig a k\u00f6vetkez\u0151re).<\/li>\n<\/ol>\n<p><strong>Excel, Word, internet, f\u00e1jlkezel\u0151<\/strong> &#8211; jusson eszedbe a Ctrl F (Enter), mert mindenhol m\u0171k\u00f6dik!<\/p>\n<p>S\u0151t, az Excelben m\u00e9g \u00f6sszetettebben is kereshetsz, olvasd el ezt a cikket, amit a <a href=\"https:\/\/sosexcel.com\/exceltippek\/kereses-excelben-es-mashol\/\" target=\"_blank\" rel=\"noopener\">keres\u00e9s<\/a>r\u0151l \u00edrtam.<\/p>\n<h2>2. Duplakattos Excel tr\u00fckk: m\u00e1sold \u00e1t gyorsan a k\u00e9pleteket<\/h2>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/08\/duplakatt.png\"><img decoding=\"async\" class=\"alignright wp-image-4551 size-medium\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/08\/duplakatt-212x300.png\" alt=\"Excel tr\u00fckk #2: M\u00e1sold \u00e1t duplakattal a k\u00e9pleteket.\" width=\"212\" height=\"300\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/08\/duplakatt-212x300.png 212w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/08\/duplakatt-240x340.png 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/08\/duplakatt.png 241w\" sizes=\"(max-width: 212px) 100vw, 212px\" \/><\/a><\/p>\n<p>Ha ugyanaz a k\u00e9plet t\u00f6bb sorban is ism\u00e9tl\u0151dik, akkor m\u00e1sold le!\u00a0De a \u201cb\u00fcty\u00f6k\u201d k\u00e9zi leh\u00faz\u00e1sa helyett ink\u00e1bb <strong>duplakattal<\/strong>!<\/p>\n<p>Azaz vidd az egeret\u00a0a cella jobb als\u00f3 sark\u00e1n\u00e1l tal\u00e1lhat\u00f3 kis n\u00e9gyzetre, \u00e9s mikor az eg\u00e9r alakja megv\u00e1ltozik pluszjelre, akkor kattints dupl\u00e1n!<\/p>\n<p><strong>Az Excel lem\u00e1solja a k\u00e9pletet az utols\u00f3 sorig,<\/strong> legyen a t\u00e1bl\u00e1zat 3 vagy 1000\u00a0soros. Ez ut\u00f3bbi m\u00e1r igencsak id\u0151ig\u00e9nyes lenne, ha k\u00e9zzel akarn\u00e1d leh\u00fazni.<\/p>\n<p>Persze egyszer\u0171 sz\u00f6veges tartalommal is m\u0171k\u00f6dik a duplakattos tr\u00fckk.<\/p>\n<h2>3. Ker\u00fcld el a felesleges &#8222;pepecsel\u00e9st&#8221;<\/h2>\n<p>Kikevert\u00e9l egy sz\u00ednt, vagy kital\u00e1lt\u00e1l egy bonyolult c\u00edmsor form\u00e1z\u00e1st? De kicsit macer\u00e1s \u00fajra megism\u00e9telni egy m\u00e1sik helyen? A j\u00f3 h\u00edr, hogy nem kell minden t\u00e1bl\u00e1zatn\u00e1l \u00fajra kezdened, mert erre is van egy Excel tr\u00fckk: <strong>a form\u00e1tum-m\u00e1sol\u00f3 ecsettel<\/strong> \u00e1tm\u00e1solhatod a form\u00e1z\u00e1st egyik cell\u00e1r\u00f3l a m\u00e1sikra!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-4240 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/10\/formatum-masolasa.png\" alt=\"Excel tr\u00fckk #3: Haszn\u00e1ld a form\u00e1tumm\u00e1sol\u00f3 ecsetet!\" width=\"257\" height=\"200\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/10\/formatum-masolasa.png 257w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/10\/formatum-masolasa-240x187.png 240w\" sizes=\"(max-width: 257px) 100vw, 257px\" \/><\/p>\n<ol>\n<li>A mint\u00e1ul szolg\u00e1l\u00f3 cell\u00e1n (vagy cell\u00e1kon) \u00e1llva<\/li>\n<li>kattints az ecset ikonra,<\/li>\n<li><strong>majd egy &#8222;ecsetvon\u00e1ssal&#8221; fesd be<\/strong> azokat a cell\u00e1kat, amelyeket ugyanolyanra szeretn\u00e9l form\u00e1zni.<\/li>\n<\/ol>\n<p>Ilyenkor minden be\u00e1ll\u00edt\u00e1s (bet\u0171t\u00edpus, bet\u0171m\u00e9ret, sz\u00ednek, szeg\u00e9lyek, igaz\u00edt\u00e1sok, sz\u00e1mok form\u00e1z\u00e1sa, stb) m\u00e1sol\u00f3dik.<\/p>\n<p>Wordben is m\u0171k\u00f6dik a funkci\u00f3, pr\u00f3b\u00e1ld ki!<\/p>\n<h2>4. Mozgasd tr\u00fckk\u00f6sen az Excel cell\u00e1kat<\/h2>\n<p>Kiv\u00e1g\u00e1s-besz\u00far\u00e1s helyett ugyanazt az eredm\u00e9nyt kapod, ha a <strong>Shift gomb nyomva tart\u00e1sa mellett<\/strong> mozgatod a tartom\u00e1nyt\u00a0a kijel\u00f6l\u00e9s sz\u00e9l\u00e9n\u00e9l.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-4047 size-medium\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel-300x158.png\" alt=\"Excel tr\u00fckk #4: Mozgasd tr\u00fckk\u00f6sen a cell\u00e1kat!\" width=\"300\" height=\"158\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel-300x158.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel-660x347.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel-240x126.png 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel.png 717w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>A Shift \u00e9s Ctrl egy\u00fcttes lenyom\u00e1s\u00e1val pedig a m\u00e1solatot tudod besz\u00farni.<\/p>\n<p>Mindk\u00e9t esetben egy sz\u00fcrke \u201ccs\u00edk\u201d mutatja, hogy hov\u00e1 ker\u00fclnek \u00e1t az adatok. (A sz\u00fcrke kisablakban megjelenik\u00a0a pontos cellatartom\u00e1ny is.)<\/p>\n<p>Ahogy\u00a0elengeded az egeret (a Shiftet k\u00f6zben m\u00e9g tartsd nyomva), egyb\u0151l jobbra cs\u00fasznak a cell\u00e1k, \u00e9s &#8222;helyet cser\u00e9ltek&#8221; a cell\u00e1k.<\/p>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"8254\" class=\"elementor elementor-8254\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3abb8450 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3abb8450\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-20053e6\" data-id=\"20053e6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-458ac75 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"458ac75\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-64debbe3\" data-id=\"64debbe3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-55d278e8 elementor-widget elementor-widget-image\" data-id=\"55d278e8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"270\" height=\"500\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/excel-titok-bemutatas-vip-klub.png\" class=\"attachment-large size-large wp-image-8249\" alt=\"\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/excel-titok-bemutatas-vip-klub.png 270w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/excel-titok-bemutatas-vip-klub-162x300.png 162w\" sizes=\"(max-width: 270px) 100vw, 270px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-e6c31da\" data-id=\"e6c31da\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-66c97cdd elementor-widget elementor-widget-heading\" data-id=\"66c97cdd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">V\u00e9gre itt a megold\u00e1s! Ilyen m\u00e9g nem volt!<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3e7f1fb0 elementor-widget elementor-widget-text-editor\" data-id=\"3e7f1fb0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>L\u00e9trehoztunk egy Titkos VIP Klubot, ahol eg\u00e9sz \u00e9vben fejl\u0151dhetsz.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-64022835 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"64022835\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-lg\" href=\"https:\/\/exceltitok.hu\/vip-excel-klub\/\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">\u00c9rdekel a VIP Excel Klub!<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-237a59fa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"237a59fa\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-4e2b2792\" data-id=\"4e2b2792\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-93f062d elementor-position-top elementor-widget elementor-widget-image-box\" data-id=\"93f062d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-image-box-wrapper\"><figure class=\"elementor-image-box-img\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"401\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-tamogatas-parbeszed.png\" class=\"attachment-full size-full wp-image-8250\" alt=\"\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-tamogatas-parbeszed.png 450w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-tamogatas-parbeszed-300x267.png 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/figure><div class=\"elementor-image-box-content\"><h3 class=\"elementor-image-box-title\">K\u00e9rdez\u00e9s<\/h3><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-7767c4e1\" data-id=\"7767c4e1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-169c2db0 elementor-position-top elementor-widget elementor-widget-image-box\" data-id=\"169c2db0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-image-box-wrapper\"><figure class=\"elementor-image-box-img\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"401\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-kihozzuk-a-maximumot.png\" class=\"attachment-full size-full wp-image-8247\" alt=\"\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-kihozzuk-a-maximumot.png 450w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-kihozzuk-a-maximumot-300x267.png 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/figure><div class=\"elementor-image-box-content\"><h3 class=\"elementor-image-box-title\">Fejl\u0151d\u00e9s<\/h3><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-efe4d1c\" data-id=\"efe4d1c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-76db428e elementor-position-top elementor-widget elementor-widget-image-box\" data-id=\"76db428e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-image-box-wrapper\"><figure class=\"elementor-image-box-img\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"401\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-kapcoslat1.png\" class=\"attachment-full size-full wp-image-8248\" alt=\"\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-kapcoslat1.png 450w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-kapcoslat1-300x267.png 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/figure><div class=\"elementor-image-box-content\"><h3 class=\"elementor-image-box-title\">K\u00f6z\u00f6ss\u00e9g<\/h3><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-763710c1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"763710c1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-652c9520\" data-id=\"652c9520\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5fad12fc elementor-position-top elementor-widget elementor-widget-image-box\" data-id=\"5fad12fc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-image-box-wrapper\"><figure class=\"elementor-image-box-img\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"401\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-elekadas-sajat.png\" class=\"attachment-full size-full wp-image-8246\" alt=\"\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-elekadas-sajat.png 450w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/09\/icon-elekadas-sajat-300x267.png 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/figure><div class=\"elementor-image-box-content\"><h3 class=\"elementor-image-box-title\">N\u00e9ha elakadsz?<\/h3><p class=\"elementor-image-box-description\">N\u00e9ha elakadsz, \u00e9s megnyugtat\u00f3 lenne, ha feltehetn\u00e9d a k\u00e9rd\u00e9seid, \u00e9s seg\u00edtene valaki? Vagy v\u00e1gysz arra, hogy egy-egy feladatot \u00e1tbesz\u00e9lj egy hozz\u00e1\u00e9rt\u0151 szakemberrel, hogy meger\u0151s\u00edt\u00e9st kapj?<\/p><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-552481da\" data-id=\"552481da\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-36ea8798 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"36ea8798\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Munka gyors\u00edt\u00f3 tr\u00fckk\u00f6k<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Napi k\u00e9rdez\u00e9si lehet\u0151s\u00e9g<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Gyors, szinte azonnali v\u00e1lasz<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Pr\u00e9mium oktat\u00f3 anyagok<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">T\u00e1mogat\u00f3 k\u00f6z\u00f6ss\u00e9g<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">25% kedvezm\u00e9ny a kijel\u00f6lt k\u00e9pz\u00e9sekre, anyagokra.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a3702da elementor-align-center elementor-widget elementor-widget-button\" data-id=\"3a3702da\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-lg\" href=\"https:\/\/exceltitok.hu\/vip-excel-klub\/\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Nem vesztegetem az id\u0151m! Bel\u00e9pek a Klubba!<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t\n<h2>5. D\u00e1tumokn\u00e1l b\u00edzd r\u00e1 magad az Excelre<\/h2>\n<p>Az Excel kimagasl\u00f3an j\u00f3l kezeli a d\u00e1tumokat. \u00cdgy p\u00e9ld\u00e1ul azt is tudja, hogy melyik d\u00e1tum milyen napra esett. Ez hasznos lehet, amikor p\u00e9ld\u00e1ul a <a href=\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/\" target=\"_blank\" rel=\"noopener\">munkaid\u0151 beoszt\u00e1s<\/a>n\u00e1l ki akarod hagyni a h\u00e9tv\u00e9g\u00e9ket.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-5741 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/10\/kitoltes-munkanapokkal.png\" alt=\"Excel tr\u00fckk #5: D\u00e1tumok gyors kit\u00f6lt\u00e9se munkanapokkal\" width=\"266\" height=\"156\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/10\/kitoltes-munkanapokkal.png 266w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/10\/kitoltes-munkanapokkal-240x141.png 240w\" sizes=\"(max-width: 266px) 100vw, 266px\" \/><\/p>\n<p>Csak add meg a kezd\u0151 napot vagy d\u00e1tumot, majd m\u00e1sold tov\u00e1bb a t\u00f6bbi cell\u00e1ba a (jobb als\u00f3 sarokban l\u00e9v\u0151 tartalomm\u00e1sol\u00f3) fekete kereszttel.<\/p>\n<p>V\u00e9g\u00fcl a kit\u00f6lt\u00e9si lehet\u0151s\u00e9gekn\u00e9l <strong>v\u00e1laszd a Kit\u00f6lt\u00e9s munkanapokkal opci\u00f3t!<\/strong><\/p>\n<p>Ha szeretn\u00e9l t\u00f6bbet tudni a d\u00e1tumokr\u00f3l, akkor <a href=\"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/\" target=\"_blank\" rel=\"noopener\">olvasd el ezt a cikket is!<\/a><\/p>\n<h2>6. Szabd saj\u00e1t \u00edzl\u00e9sedre az Excel f\u00e1jlokat<\/h2>\n<p>A Be\u00e1ll\u00edt\u00e1sokn\u00e1l megadhatod, hogy <strong>alap\u00e9rtelmezetten h\u00e1ny f\u00fcllel \u00e9s milyen\u00a0bet\u0171t\u00edpussal ny\u00edljon meg az Excel.<\/strong><br \/><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-5742 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/10\/uj-munkalap-alapertelmezett.png\" alt=\"Excel tr\u00fckk #6: Szabd saj\u00e1t \u00edzl\u00e9sedre az Excel f\u00e1jlokat!\" width=\"447\" height=\"132\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/10\/uj-munkalap-alapertelmezett.png 447w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/10\/uj-munkalap-alapertelmezett-300x89.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/10\/uj-munkalap-alapertelmezett-240x71.png 240w\" sizes=\"(max-width: 447px) 100vw, 447px\" \/>\u00cdgy az \u00faj f\u00e1jlok megnyit\u00e1skor (Ctrl N) m\u00e1r nem kell k\u00fcl\u00f6n id\u0151t t\u00f6ltened a be\u00e1ll\u00edt\u00e1sokkal.<\/p>\n<h2>7. K\u00e9sz\u00edts diagramokat gombnyom\u00e1sra<\/h2>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-ennyi.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-3350\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-ennyi-300x183.png\" alt=\"Excel tr\u00fckk #7: Diagramok gombnyom\u00e1sra\" width=\"270\" height=\"165\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-ennyi-300x183.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-ennyi-240x147.png 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-ennyi.png 491w\" sizes=\"(max-width: 270px) 100vw, 270px\" \/><\/a>V\u00e9g\u00fc egy diagramos Excel tr\u00fckk: az <strong>Alt F1 gombokkal <\/strong>tudsz leggyorsabban diagramot besz\u00farni.<\/p>\n<p>M\u00e9ghozz\u00e1 az alap\u00e9rtelmezett diagramot, ami a (csoportos\u00edtott) oszlopdiagram.<\/p>\n<p>Persze az adatokat el\u0151tte ki kell jel\u00f6ln\u00f6d, k\u00fcl\u00f6nben csak egy \u00fcres k\u00e9pet kapsz &#8211; vagy ha a t\u00e1bl\u00e1zaton bel\u00fcl volt\u00e1l, akkor az \u00f6sszes adat beker\u00fcl a diagramba.<\/p>\n<p>Ut\u00e1na ugyan\u00fagy <a href=\"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/\" target=\"_blank\" rel=\"noopener\">m\u00f3dos\u00edthatod a diagramot<\/a>, mintha &#8222;hagyom\u00e1nyosan&#8221; k\u00e9sz\u00fclt volna.<\/p>\n<h2>J\u00f3l j\u00f6nne m\u00e9g t\u00f6bb Excel tr\u00fckk?<\/h2>\n<p>Itt a blogon m\u00e1r <strong>k\u00f6zel 200 \u00edr\u00e1st tal\u00e1lsz azonnal haszn\u00e1lhat\u00f3, ingyenes Excel tr\u00fckk\u00f6kkel<\/strong>, melyet a tan\u00edtv\u00e1nyaim k\u00e9rd\u00e9sei (azaz a val\u00f3 \u00e9let) ihletnek.<\/p>\n<p>Ha jobban szereted a pap\u00edr alap\u00fa anyagokat, akkor rendeld meg a <a href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\" rel=\"noopener\">111 Hasznos Excel tipp<\/a>\u00a0f\u00fczetet.<\/p>\n<p>De leginkbb az egy\u00e9ni\u00a0<a href=\"http:\/\/exceltitok.hu\/\" target=\"_blank\" rel=\"noopener\">Excel oktat\u00e1st aj\u00e1nlom<\/a>, ahol szem\u00e9lyreszabott tr\u00fckk\u00f6kkel \u00e9s tan\u00e1csokkal tudunk ell\u00e1tni. Vagy gyere el egy <a href=\"http:\/\/exceltitok.hu\/workshopok\/\" target=\"_blank\" rel=\"noopener\">\u00fczleti Excel workshopra<\/a>!<\/p>\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-azonnal-hasznalhato-excel-tippek\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"qlI7SmyPcY\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/fejlec-rogzites-maskepp\/\">Fejl\u00e9c r\u00f6gz\u00edt\u00e9s m\u00e1sk\u00e9pp<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Fejl\u00e9c r\u00f6gz\u00edt\u00e9s m\u00e1sk\u00e9pp&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/fejlec-rogzites-maskepp\/embed\/#?secret=kg3883uUmW#?secret=qlI7SmyPcY\" data-secret=\"qlI7SmyPcY\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-azonnal-hasznalhato-excel-tippek\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"pJhVlIhVs6\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/\">\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/embed\/#?secret=CqyLHh4knf#?secret=pJhVlIhVs6\" data-secret=\"pJhVlIhVs6\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>7 hasznos Excel tr\u00fckk, amivel v\u00e9gre id\u0151t nyerhetsz! Ugyanis ha\u00a0megtanulod \u00e9s alkalmazod, akkor a rutin Excel feladatokat ak\u00e1r harmad-\u00f6t\u00f6d id\u0151 alatt v\u00e9gezheted el, \u00e9s a felszabadult id\u0151t m\u00e1sra ford\u00edthatod. V\u00e9gre nem kell kapkodnod &#8211; \u00e9s \u00edgy \u00e1lland\u00f3an hib\u00e1zni -, hanem \u00e1t tudod gondolni higgadtan, hogy mit akarsz. Nem kell \u00e1lland\u00f3an a koll\u00e9g\u00e1khoz rohang\u00e1lni seg\u00edts\u00e9g\u00e9rt, hanem [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5713,"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":[36,9,54,45],"class_list":["post-5668","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-diagram","tag-formatum","tag-gyorsasag","tag-word-tippek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"7 hasznos Excel tr\u00fckk, amivel v\u00e9gre id\u0151t nyerhetsz! \u00cdgy a rutin Excel feladatokat ak\u00e1r harmad-\u00f6t\u00f6d id\u0151 alatt v\u00e9gezheted el, amit m\u00e1sra tudsz ford\u00edtani.\" \/>\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\/7-hasznos-excel-trukk\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"7 hasznos Excel tr\u00fckk, amivel v\u00e9gre id\u0151t nyerhetsz! \u00cdgy a rutin Excel feladatokat ak\u00e1r harmad-\u00f6t\u00f6d id\u0151 alatt v\u00e9gezheted el, amit m\u00e1sra tudsz ford\u00edtani.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/\" \/>\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=\"2017-11-05T08:02:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-30T08:11:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-hasznos-excel-trukk.png\" \/>\n\t<meta property=\"og:image:width\" content=\"940\" \/>\n\t<meta property=\"og:image:height\" content=\"788\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"5 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz\",\"datePublished\":\"2017-11-05T08:02:23+00:00\",\"dateModified\":\"2019-09-30T08:11:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/\"},\"wordCount\":967,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/7-excel-trukk-amivel-idot-nyerhetsz.png\",\"keywords\":[\"diagram\",\"form\u00e1tum\",\"gyorsas\u00e1g\",\"Word tippek\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/\",\"name\":\"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/7-excel-trukk-amivel-idot-nyerhetsz.png\",\"datePublished\":\"2017-11-05T08:02:23+00:00\",\"dateModified\":\"2019-09-30T08:11:30+00:00\",\"description\":\"7 hasznos Excel tr\u00fckk, amivel v\u00e9gre id\u0151t nyerhetsz! \u00cdgy a rutin Excel feladatokat ak\u00e1r harmad-\u00f6t\u00f6d id\u0151 alatt v\u00e9gezheted el, amit m\u00e1sra tudsz ford\u00edtani.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/7-excel-trukk-amivel-idot-nyerhetsz.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/7-excel-trukk-amivel-idot-nyerhetsz.png\",\"width\":1200,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/7-hasznos-excel-trukk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz\"}]},{\"@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":"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"7 hasznos Excel tr\u00fckk, amivel v\u00e9gre id\u0151t nyerhetsz! \u00cdgy a rutin Excel feladatokat ak\u00e1r harmad-\u00f6t\u00f6d id\u0151 alatt v\u00e9gezheted el, amit m\u00e1sra tudsz ford\u00edtani.","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\/7-hasznos-excel-trukk\/","og_locale":"hu_HU","og_type":"article","og_title":"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"7 hasznos Excel tr\u00fckk, amivel v\u00e9gre id\u0151t nyerhetsz! \u00cdgy a rutin Excel feladatokat ak\u00e1r harmad-\u00f6t\u00f6d id\u0151 alatt v\u00e9gezheted el, amit m\u00e1sra tudsz ford\u00edtani.","og_url":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2017-11-05T08:02:23+00:00","article_modified_time":"2019-09-30T08:11:30+00:00","og_image":[{"width":940,"height":788,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-hasznos-excel-trukk.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"5 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz","datePublished":"2017-11-05T08:02:23+00:00","dateModified":"2019-09-30T08:11:30+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/"},"wordCount":967,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz.png","keywords":["diagram","form\u00e1tum","gyorsas\u00e1g","Word tippek"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/","url":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/","name":"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz.png","datePublished":"2017-11-05T08:02:23+00:00","dateModified":"2019-09-30T08:11:30+00:00","description":"7 hasznos Excel tr\u00fckk, amivel v\u00e9gre id\u0151t nyerhetsz! \u00cdgy a rutin Excel feladatokat ak\u00e1r harmad-\u00f6t\u00f6d id\u0151 alatt v\u00e9gezheted el, amit m\u00e1sra tudsz ford\u00edtani.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/09\/7-excel-trukk-amivel-idot-nyerhetsz.png","width":1200,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/7-hasznos-excel-trukk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"7 hasznos Excel tr\u00fckk, amivel id\u0151t nyerhetsz"}]},{"@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\/5668","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=5668"}],"version-history":[{"count":24,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5668\/revisions"}],"predecessor-version":[{"id":8260,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5668\/revisions\/8260"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/5713"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=5668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=5668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=5668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}