{"id":471,"date":"2018-12-05T23:45:05","date_gmt":"2018-12-05T23:45:05","guid":{"rendered":"http:\/\/www.schulmann.hu\/istvan\/?page_id=471"},"modified":"2019-07-08T15:09:06","modified_gmt":"2019-07-08T15:09:06","slug":"excel-guru","status":"publish","type":"page","link":"https:\/\/www.schulmann.hu\/istvan\/soma-vagyok\/excel-guru\/","title":{"rendered":"Excel guru"},"content":{"rendered":"<p><span class=\"wpsdc-drop-cap\">A<\/span>z Excel t&aacute;bl&aacute;zatkezel&#337;vel 1995-ben ismerkedtem meg. &#336; akkor 10 &eacute;ves volt, &eacute;n pedig 19. M&aacute;r akkor elvar&aacute;zsolt&hellip;<\/p>\n<p>J&oacute; ismerets&eacute;g&uuml;nk az&oacute;ta is tart. Munk&aacute;im sor&aacute;n 1998 &oacute;ta haszn&aacute;lom. Szinte a &bdquo;norm&aacute;l munkamenettel&rdquo; egy id&#337;ben kezdtem el a <strong>programoz&aacute;s&aacute;t<\/strong> tanulni, zseni&aacute;lis dolognak tartom, hogy Visual Basic nyelven szabadon programozhat&oacute; a rendszer.<\/p>\n<p>A sok &eacute;vnyi haszn&aacute;lat k&ouml;zben kih&iacute;v&aacute;sk&eacute;nt kezeltem minden olyan megoldand&oacute; feladatot, amivel addig m&eacute;g nem tal&aacute;lkoztam. Sok ilyen akadt&hellip;<\/p>\n<p><strong>Szinte a kezdetekt&#337;l fogva az Excellel megval&oacute;s&iacute;that&oacute; komplexebb feladatok megold&aacute;sa k&iacute;s&eacute;ri a munk&aacute;mat<\/strong>. Az egyszer&#369;, sokszor t&uacute;ls&aacute;gosan is bombabiztos haszn&aacute;lat, az &uuml;gyviteli feladatok automatiz&aacute;l&aacute;sa, a rutin jelleg&#369; feladatok leggyorsabb megold&aacute;s&aacute;nak m&oacute;dja a vez&eacute;relvem.<\/p>\n<p>J&oacute; p&aacute;r &uuml;zleti alkalmaz&aacute;st k&eacute;sz&iacute;tettem el az &eacute;vek alatt. <strong>SAP k&ouml;lts&eacute;g kontrollerk&eacute;nt<\/strong>, <strong>projektvezet&#337;k&eacute;nt<\/strong>, de ak&aacute;r <strong>gazdas&aacute;gi informatikusk&eacute;n<\/strong>t is mindig <strong>nagy haszn&aacute;t vettem<\/strong> a megszerzett tud&aacute;snak. Volt r&aacute; p&eacute;lda, hogy egy fut&oacute;verseny eg&eacute;sz napj&aacute;t t&aacute;mogattam az azonnali eredm&eacute;nyek szolg&aacute;ltat&aacute;s&aacute;val, a versenyz&#337;k az Excel alapj&aacute;n &aacute;lltak fel a dobog&oacute;ra&hellip;<\/p>\n<p>2003 &oacute;ta <strong>oktatom is az Excel haszn&aacute;lat&aacute;t,<\/strong> az alapokt&oacute;l a k&ouml;z&eacute;phalad&oacute; szintig. &Ouml;r&ouml;m, mikor a velem tanul&oacute;k megtanulj&aacute;k a f&uuml;ggv&eacute;ny haszn&aacute;lat alapjait, mikor a legfontosabb f&uuml;ggv&eacute;nyeket m&aacute;r ismerik, magabiztosan k&eacute;sz&iacute;tenek kimutat&aacute;sokat, s hab a tort&aacute;n, ha egy Excel munkalapot sz&eacute;pen tudnak megform&aacute;zni. J&oacute; &eacute;lm&eacute;nyk&eacute;nt &eacute;lem meg, ha olyan probl&eacute;ma megold&aacute;s&aacute;ban k&eacute;rik a seg&iacute;ts&eacute;gemet, amivel kapcsolatban megvan az ismeret at eszk&ouml;z l&eacute;t&eacute;re, csak az apr&oacute;s&aacute;gokat kell megmutatni.<\/p>\n<p>Ha az Excellel kapcsolatban&nbsp;sz&uuml;ks&eacute;ged van:<\/p>\n<ul>\n<li>egy profi m&oacute;don &ouml;sszerakott Excel t&aacute;bl&aacute;ra,<\/li>\n<li>egy programk&oacute;dokkal t&aacute;mogatott &uuml;zleti megold&aacute;sra,<\/li>\n<li>egy alapoz&oacute; oktat&aacute;sra,<\/li>\n<li>egy speci&aacute;lis ter&uuml;let m&eacute;lyebb ismeret&eacute;re, akkor<\/li>\n<\/ul>\n<h3>keress b&aacute;tran!<\/h3>\n<div role=\"form\" class=\"wpcf7\" id=\"wpcf7-f5-o1\" lang=\"hu-HU\" dir=\"ltr\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/istvan\/wp-json\/wp\/v2\/pages\/471#wpcf7-f5-o1\" method=\"post\" class=\"wpcf7-form init\" novalidate=\"novalidate\" data-status=\"init\">\n<div style=\"display: none;\">\n<input type=\"hidden\" name=\"_wpcf7\" value=\"5\">\n<input type=\"hidden\" name=\"_wpcf7_version\" value=\"5.6.4\">\n<input type=\"hidden\" name=\"_wpcf7_locale\" value=\"hu_HU\">\n<input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f5-o1\">\n<input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\">\n<input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\">\n<input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\">\n<input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\">\n<input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\">\n<input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\">\n<input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\">\n<input type=\"hidden\" name=\"_wpcf7cf_options\" value='{\"form_id\":5,\"conditions\":[],\"settings\":{\"animation\":\"yes\",\"animation_intime\":200,\"animation_outtime\":200,\"conditions_ui\":\"normal\",\"notice_dismissed\":false,\"notice_dismissed_rollback-cf7-5.3.2\":true,\"notice_dismissed_update-cf7-5.7.6\":true,\"notice_dismissed_update-cf7-5.9.3\":true}}'>\n<input type=\"hidden\" name=\"_wpcf7_recaptcha_response\" value=\"\">\n<\/div>\n<p><label> <b>N&eacute;v<\/b> - k&ouml;telez&#337;<br>\n    <span class=\"wpcf7-form-control-wrap\" data-name=\"your-name\"><input type=\"text\" name=\"your-name\" value=\"\" size=\"40\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\"><\/span> <\/label><\/p>\n<p><label> <b>Email c&iacute;m<\/b> - k&ouml;telez&#337; - <small>mindenk&eacute;ppen szeretn&eacute;k neked v&aacute;laszolni!<\/small><br>\n    <span class=\"wpcf7-form-control-wrap\" data-name=\"your-email\"><input type=\"email\" name=\"your-email\" value=\"\" size=\"40\" class=\"wpcf7-form-control wpcf7-text wpcf7-email wpcf7-validates-as-required wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\"><\/span> <\/label><\/p>\n<p><label> <b>Telefon<\/b> - <small>ha szeretn&eacute;d, hogy visszah&iacute;vjalak, k&eacute;rlek, add meg!<\/small><br>\n    <span class=\"wpcf7-form-control-wrap\" data-name=\"tel-657\"><input type=\"tel\" name=\"tel-657\" value=\"\" size=\"40\" class=\"wpcf7-form-control wpcf7-text wpcf7-tel wpcf7-validates-as-tel\" aria-invalid=\"false\"><\/span> <\/label><\/p>\n<p><label> <b>Miben seg&iacute;thetek?<\/b> - <small>K&eacute;rlek, &iacute;rd ide, vagy jel&ouml;ld be!<\/small><br>\n    <span class=\"wpcf7-form-control-wrap\" data-name=\"your-subject\"><input type=\"text\" name=\"your-subject\" value=\"\" size=\"40\" class=\"wpcf7-form-control wpcf7-text\" aria-invalid=\"false\"><\/span> <\/label><\/p>\n<p><span class=\"wpcf7-form-control-wrap\" data-name=\"checkbox-487\"><span class=\"wpcf7-form-control wpcf7-checkbox\"><span class=\"wpcf7-list-item first\"><input type=\"checkbox\" name=\"checkbox-487[]\" value=\"Weblapot szeretn&eacute;k\"><span class=\"wpcf7-list-item-label\">Weblapot szeretn&eacute;k<\/span><\/span><span class=\"wpcf7-list-item\"><input type=\"checkbox\" name=\"checkbox-487[]\" value=\"Egy programra van sz&uuml;ks&eacute;gem\"><span class=\"wpcf7-list-item-label\">Egy programra van sz&uuml;ks&eacute;gem<\/span><\/span><span class=\"wpcf7-list-item\"><input type=\"checkbox\" name=\"checkbox-487[]\" value=\"Fundamenta &uuml;gyem van\"><span class=\"wpcf7-list-item-label\">Fundamenta &uuml;gyem van<\/span><\/span><span class=\"wpcf7-list-item\"><input type=\"checkbox\" name=\"checkbox-487[]\" value=\"Szeretn&eacute;m az &uuml;zletemet fejleszteni\"><span class=\"wpcf7-list-item-label\">Szeretn&eacute;m az &uuml;zletemet fejleszteni<\/span><\/span><span class=\"wpcf7-list-item last\"><input type=\"checkbox\" name=\"checkbox-487[]\" value=\"Szeretn&eacute;m az &eacute;letemet fejleszteni\"><span class=\"wpcf7-list-item-label\">Szeretn&eacute;m az &eacute;letemet fejleszteni<\/span><\/span><\/span><\/span><\/p>\n<p><label> <b>&Uuml;zeneted<\/b> - <small>P&aacute;r sz&oacute;ban, mondatban, hogy tudjam, mivel k&eacute;sz&uuml;ljek, ha b&#337;vebben egyeztet&uuml;nk.<\/small><br>\n    <span class=\"wpcf7-form-control-wrap\" data-name=\"your-message\"><textarea name=\"your-message\" cols=\"40\" rows=\"10\" class=\"wpcf7-form-control wpcf7-textarea\" aria-invalid=\"false\"><\/textarea><\/span> <\/label><\/p>\n<p><input type=\"submit\" value=\"K&uuml;ld&eacute;s\" class=\"wpcf7-form-control has-spinner wpcf7-submit\"><\/p>\n<div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div><\/form><\/div>\n<blockquote><p>=HA(KEREK.FEL((A18-D&Aacute;TUM&Eacute;RT&Eacute;K(&Ouml;SSZEF&#368;Z(&Eacute;V(A18);&rdquo;.01.01&Prime;)))\/7+HA(&Eacute;V(A18)&gt;&Eacute;V(MA());0,1;0);0)+HA(H&Eacute;T.NAPJA(A18;2)=1;1;0)&gt;52;1;KEREK.FEL((A18-D&Aacute;TUM&Eacute;RT&Eacute;K(&Ouml;SSZEF&#368;Z(&Eacute;V(A18);&rdquo;.01.01&Prime;)))\/7+HA(&Eacute;V(A18)&gt;&Eacute;V(MA());0,1;0);0)+HA(H&Eacute;T.NAPJA(A18;2)=1;1;0))+HA(OSZLOP()&gt;26; &Ouml;SSZEF&#368;Z(KARAKTER(INT((OSZLOP()-1)\/26)+64);KARAKTER(HA(MARAD&Eacute;K(OSZLOP();26)=0;1;MARAD&Eacute;K(OSZLOP();26))+64)); KARAKTER(OSZLOP()+64))<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Az Excel t&aacute;bl&aacute;zatkezel&#337;vel 1995-ben ismerkedtem meg. &#336; akkor 10 &eacute;ves volt, &eacute;n pedig 19. M&aacute;r akkor elvar&aacute;zsolt&hellip; J&oacute; ismerets&eacute;g&uuml;nk az&oacute;ta is tart. Munk&aacute;im sor&aacute;n 1998 &oacute;ta haszn&aacute;lom. Szinte a &bdquo;norm&aacute;l munkamenettel&rdquo; egy id&#337;ben kezdtem el a programoz&aacute;s&aacute;t tanulni, zseni&aacute;lis dolognak tartom, hogy Visual Basic nyelven szabadon programozhat&oacute; a rendszer. A sok &eacute;vnyi haszn&aacute;lat k&ouml;zben kih&iacute;v&aacute;sk&eacute;nt <a href=\"https:\/\/www.schulmann.hu\/istvan\/soma-vagyok\/excel-guru\/\" rel=\"nofollow\"><span class=\"sr-only\">Read more about Excel guru<\/span>[&hellip;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":481,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"ngg_post_thumbnail":0},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.schulmann.hu\/istvan\/wp-json\/wp\/v2\/pages\/471"}],"collection":[{"href":"https:\/\/www.schulmann.hu\/istvan\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.schulmann.hu\/istvan\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.schulmann.hu\/istvan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.schulmann.hu\/istvan\/wp-json\/wp\/v2\/comments?post=471"}],"version-history":[{"count":0,"href":"https:\/\/www.schulmann.hu\/istvan\/wp-json\/wp\/v2\/pages\/471\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.schulmann.hu\/istvan\/wp-json\/wp\/v2\/pages\/481"}],"wp:attachment":[{"href":"https:\/\/www.schulmann.hu\/istvan\/wp-json\/wp\/v2\/media?parent=471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}