{"id":2327,"date":"2017-02-15T14:17:20","date_gmt":"2017-02-15T13:17:20","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=2327"},"modified":"2022-05-18T17:39:13","modified_gmt":"2022-05-18T15:39:13","slug":"arajanlat-kalkulator-excelben","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/","title":{"rendered":"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el!"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Mit tenn\u00e9l, ha ma beh\u00edvna a f\u0151n\u00f6k\u00f6d, \u00e9s <strong>R\u00e1d b\u00edzn\u00e1 az \u00faj \u00e1raj\u00e1nlat kalkul\u00e1tor elk\u00e9sz\u00edt\u00e9s\u00e9t?<\/strong> Term\u00e9szetesen Excelben kellene egy olyan sablont \u00f6ssze\u00e1ll\u00edtanod, amely&nbsp;p\u00e1r v\u00e1ltoz\u00f3 adat megad\u00e1sa ut\u00e1n kiadn\u00e1 a v\u00e9g\u00f6sszeget.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mit tenn\u00e9l, hogy \u00e9rezn\u00e9d magad?&nbsp;Bep\u00e1nikoln\u00e1l, vagy izgatottan le\u00fcln\u00e9l a sz\u00e1m\u00edt\u00f3g\u00e9p el\u00e9 \u00e9s m\u00e1r \u00edrn\u00e1d is a k\u00e9pleteket?&nbsp;<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\"><strong>A reakci\u00f3d val\u00f3sz\u00edn\u0171leg 2 dologt\u00f3l f\u00fcgg<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>mennyire vagy&nbsp;rutinos az Excelben,<\/li><li>\u00e9s, hogy az \u00e9letben&nbsp;(pap\u00edr alapon, sz\u00e1mol\u00f3g\u00e9ppel) mennyire bonyolult&nbsp;a c\u00e9ged \u00e1raz\u00e1sa.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">N\u00e9zz\u00fck meg, hogyan \u00e9rdemes hozz\u00e1fognod a kalkul\u00e1tor k\u00e9sz\u00edt\u00e9shez, \u00e9s milyen szempontokat kell v\u00e9giggondolnod! De el\u0151sz\u00f6r is: mi\u00e9rt b\u00edzd az Excelre ezt a feladatot a koll\u00e9g\u00e1k helyett?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3 \u00e9rv, hogy az Excelt haszn\u00e1ld az \u00e1raj\u00e1nlat k\u00e9sz\u00edt\u00e9shez<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u2714 Id\u0151t sp\u00f3rol:<\/strong><br>Nagyon sokan panaszkodnak, hogy az aj\u00e1nlat\u00edr\u00e1s rengeteg id\u0151t vesz ig\u00e9nybe, van, ahol egy teljes ember munk\u00e1j\u00e1t kiteszi, m\u00e9gis gyakran kidobott munka (k\u00f6lts\u00e9g), hiszen csak minden sokadikb\u00f3l lesz \u00fczlet. Ha viszont az Excelt haszn\u00e1lod, el\u00e9g egyszer \u00f6ssze\u00e1ll\u00edtani &#8211; igaz, ez t\u00f6bb id\u0151 -, ut\u00e1na m\u00e1r mindig gyorsan kisz\u00e1molja a v\u00e1ltoz\u00f3 ig\u00e9nyekre, mennyis\u00e9gekre a v\u00e9geredm\u00e9nyt. Aj\u00e1nlatt\u00f3l \u00e9s sz\u00e1m\u00edt\u00e1st\u00f3l f\u00fcgg\u0151en ak\u00e1r 15-60 percet meg tud sp\u00f3rolni.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u2714 Mindig j\u00f3l sz\u00e1mol:<\/strong><br>Ha alaposan v\u00e9giggondoltad a folyamatod, akkor a kalkul\u00e1tor nem fog semmit elfelejteni vagy f\u00e9lre\u00fctni, hanem garant\u00e1ltan pontos lesz az aj\u00e1nlat.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u2714 Lev\u00e9dhet\u0151 \u00e9s automatiz\u00e1lhat\u00f3:<\/strong><br>vannak olyan Excel funkci\u00f3k, amelyekkel \u201ch\u00fclye-biztoss\u00e1\u201d teheted az Excelt, \u00edgy biztosan nem fogj\u00e1k kit\u00f6r\u00f6lni a koll\u00e9g\u00e1k a be\u00edrt k\u00e9pleteket. S\u0151t, ak\u00e1r az Excelb\u0151l is k\u00e9sz\u00edthetsz pdf form\u00e1tumot vagy k\u00fcldhetsz e-mailt.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"810\" height=\"450\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts.png\" alt=\"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben - \u00e9s m\u00e1ris megsp\u00f3rolhatsz egy \u00faj munkat\u00e1rsat.\" class=\"wp-image-9521\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts.png 810w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts-300x167.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts-768x427.png 768w\" sizes=\"(max-width: 810px) 100vw, 810px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Egyszer\u0171 kalkul\u00e1torok<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Tegy\u00fck fel, hogy viszonylag egyszer\u0171 folyamatr\u00f3l van sz\u00f3.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Van egy 6.000 Ft-os term\u00e9ked, amib\u0151l a vev\u0151 rendel N&nbsp;darabot. Tiszta sor, N x 6000 lesz a v\u00e9g\u00f6sszeg. Ezt ak\u00e1r fejben, vagy sz\u00e1mol\u00f3g\u00e9ppel is ki tudod sz\u00e1molni.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Az Excelben sem bonyolultabb, csup\u00e1n a megfelel\u0151 adatokat \u00e9s&nbsp;<a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-irj-kepleteket-az-excelben\/\" target=\"_blank\" rel=\"noopener\">k\u00e9pletet kell elhelyezned<\/a>&nbsp;egy t\u00e1bl\u00e1zatban.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ha t\u00f6bb term\u00e9ked van<\/strong>, akkor azokat egym\u00e1s al\u00e1 rendezheted. A v\u00e9g\u00e9re tehetsz egy sz\u00e1ll\u00edt\u00e1si k\u00f6lts\u00e9get, esetleg egy kuponkedvezm\u00e9nyt.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/money-256312_1280.jpg\"><img decoding=\"async\" width=\"300\" height=\"200\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/money-256312_1280-300x200.jpg\" alt=\"\u00c1raj\u00e1nlat kalkul\u00e1tor: pap\u00edron vagy Excelben?\" class=\"wp-image-4442\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/money-256312_1280-300x200.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/money-256312_1280-768x512.jpg 768w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/money-256312_1280-1024x682.jpg 1024w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/money-256312_1280-660x440.jpg 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/money-256312_1280-240x160.jpg 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/money-256312_1280.jpg 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u00d6sszess\u00e9g\u00e9ben&nbsp;a 4 alapm\u0171velettel elboldogulhatsz<\/strong>. (M\u00e1s t\u00e9ma, de hasonl\u00f3 fel\u00e9p\u00edt\u00e9s a <a href=\"https:\/\/sosexcel.com\/exceltippek\/keszits-brutto-netto-berkalkulatort\/\" target=\"_blank\" rel=\"noopener\">brutt\u00f3-nett\u00f3 b\u00e9r kalkul\u00e1tor<\/a>.)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ha rendszeresen haszn\u00e1lod, \u00e9s ezzel megk\u00f6nny\u00edted magad \u00e9s m\u00e1sok munk\u00e1j\u00e1t, ezt a t\u00e1bl\u00e1zatot m\u00e1r nevezhet\u00fcnk &#8222;Excel \u00e1raj\u00e1nlat kalkul\u00e1tor&#8221;-nak.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Amikor j\u00f6nnek a komplik\u00e1ci\u00f3k<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A bonyodalmak akkor j\u00f6nnek, amikor t\u00f6bb term\u00e9ked \u00e9s t\u00f6bb \u00e1rlist\u00e1d van. Vagy ha bej\u00f6nnek k\u00fcl\u00f6nb\u00f6z\u0151 felt\u00e9telek, mint p\u00e9ld\u00e1ul a v\u00e9g\u00f6sszegt\u0151l f\u00fcgg a sz\u00e1ll\u00edt\u00e1si k\u00f6lts\u00e9g, vagy a kedvezm\u00e9ny m\u00e9rt\u00e9ke.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ezekhez az esetekhez ugyanis m\u00e1r sz\u00fcks\u00e9ged lesz f\u00fcggv\u00e9nyekre. HA, \u00c9S, VAGY, <a rel=\"noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/fkeres\/\" target=\"_blank\">FKERES<\/a>, hogy csak az &#8222;egyszer\u0171bbeket&#8221; eml\u00edtsem.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A logikai f\u00fcggv\u00e9nyekkel (HA, \u00c9S, VAGY, &#8230;) megadhatod azokat a felt\u00e9teleket, amelyek kedvezm\u00e9nyre vagy extra d\u00edjra szolg\u00e1lnak. A keres\u0151f\u00fcggv\u00e9nyekkel (FKERES, INDEX, HOL.VAN, &#8230;) pedig egyszer\u0171s\u00edtheted az \u00e1rak kikeres\u00e9s\u00e9t az \u00e1rlist\u00e1kb\u00f3l.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Hi\u00e1ba bonyolult a folyamat,&nbsp;<strong>ha a munkat\u00e1rsaidat be tudod r\u00e1 tan\u00edtan\u00ed, akkor az Excelt is!<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">De<strong> a neh\u00e9zs\u00e9g<\/strong> nem is felt\u00e9tlen maga a k\u00e9plet &#8211; <strong>sokkal ink\u00e1bb a folyamat \u00e1tgondol\u00e1sa:&nbsp;<\/strong>h\u00e1ny \u00e1rlist\u00e1b\u00f3l dolgozol,&nbsp;honnan (melyik list\u00e1b\u00f3l, ott is \u00e9ppen melyik sor, melyik oszlop) veszed az adatokat.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Ha szeretn\u00e9l <strong>seg\u00edts\u00e9get az \u00e1raj\u00e1nlat kelkul\u00e1tor \nelk\u00e9sz\u00edt\u00e9s\u00e9hez<\/strong>, akkor gyere el a k\u00f6vetkez\u0151&nbsp;\n<a href=\"http:\/\/exceltitok.hu\/arajanlat-keszites\/\" target=\"_blank\" rel=\"noopener\">\u00e1raj\u00e1nlat-k\u00e9sz\u00edt\u0151 workshopra<\/a>&nbsp;vagy&nbsp;\negy <a href=\"http:\/\/exceltitok.hu\/oktatas\" target=\"_blank\" rel=\"noopener\">Excel mini tanfolyamra<\/a>!<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Tervezd meg&nbsp;az&nbsp;\u00e1raj\u00e1nlat&nbsp;kalkul\u00e1tor k\u00e9sz\u00edt\u00e9s\u00e9t<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Mint mindig, itt is jobban j\u00e1rsz, ha tervez\u00e9ssel kezded. (Erre a pap\u00edrt javaslom.)<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img decoding=\"async\" width=\"300\" height=\"214\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/site-1696713_1280-300x214.jpg\" alt=\"A j\u00f3 \u00e1raj\u00e1nlat kalkul\u00e1tor titka a folyamatok \u00e1tgondol\u00e1sa\" class=\"wp-image-4458\"\/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Pr\u00f3b\u00e1lj meg <strong>egy egyszer\u0171&nbsp;folyamat\u00e1br\u00e1t<\/strong> <strong>k\u00e9sz\u00edteni<\/strong>, hogy l\u00e1sd az \u00f6sszef\u00fcgg\u00e9seket!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Gondold v\u00e9gig, ha most \u00e1t kellene adnod az \u00e1raj\u00e1nlat k\u00e9sz\u00edt\u00e9st <strong>egy koll\u00e9g\u00e1nak<\/strong>, akkor <strong>hogyan magyar\u00e1zn\u00e1d el<\/strong> neki <strong>a l\u00e9p\u00e9seket<\/strong>.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Milyen szempontokat, bej\u00f6v\u0151 adatokat kell gy\u0171jtened<\/li><li>h\u00e1ny \u00f6sszetev\u0151je van a v\u00e9gs\u0151 \u00e1rnak<\/li><li>milyen kedvezm\u00e9nyek j\u00e1rnak<\/li><li>h\u00e1ny \u00e1rlist\u00e1b\u00f3l dolgozol<\/li><li>h\u00e1ny k\u00fcl\u00f6nb\u00f6z\u0151 folyamatod van, amire k\u00fcl\u00f6n sz\u00e1m\u00edt\u00e1s&nbsp;sz\u00fcks\u00e9ges.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">P\u00e9ld\u00e1ul csak az\u00e9rt, mert t\u00f6bb partner term\u00e9k\u00e9t forgalmazod, \u00e9s t\u00f6bb \u00e1rlist\u00e1val dolgozol, nem kell k\u00fcl\u00f6n sablon mindegyikre, ha egy\u00e9bk\u00e9nt maga a folyamat megegyezik.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">De ha teljesen m\u00e1s a folyamat, \u00e9s teljesen m\u00e1s elemekb\u0151l \u00e9p\u00fcl fel, akkor \u00e9rdemes lehet k\u00fcl\u00f6n kalkul\u00e1tort k\u00e9sz\u00edteni.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c1raj\u00e1nlat&nbsp;kalkul\u00e1tor a gyakorlatban<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kor\u00e1bban&nbsp;egy szoftverfejleszt\u0151 c\u00e9gn\u00e9l dolgoztam. 2007. j\u00fanius\u00e1ban&nbsp;modul\u00e1riss\u00e1 v\u00e1lt a sz\u00e1ml\u00e1z\u00f3-program, azaz a felhaszn\u00e1l\u00f3k maguk v\u00e1logathatt\u00e1k \u00f6ssze a sz\u00e1mukra fontos funkci\u00f3kat.&nbsp;Viszont sz\u00e1mos bels\u0151 \u00f6sszef\u00fcgg\u00e9st kellett figyelembe venni.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Az \u00e9rt\u00e9kes\u00edt\u0151&nbsp;koll\u00e9g\u00e1k h\u00e1l\u00e1sak voltak, mikor elk\u00e9sz\u00fclt egy bels\u0151 Excel sablon, mert onnant\u00f3l gyorsabb \u00e9s pontosabb lett a sz\u00e1m\u00edt\u00e1s.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">De k\u00e9s\u0151bb a fejleszt\u0151 is \u00f6r\u00fclt az Excel mint\u00e1nak, mikor megrendeltem a weboldaladra az <a href=\"https:\/\/sosexcel.com\/exceltippek\/offline-es-online-kalkulatorok\/\" target=\"_blank\" rel=\"noopener\">online kalkul\u00e1tor<\/a>t, mert <strong>j\u00f3l \u00e1tgondolt volt \u00e9s egyb\u0151l minden egy\u00e9rtem\u0171 volt a sz\u00e1m\u00e1ra<\/strong>. Csup\u00e1n 1-1,5 \u00f3ra fejleszt\u00e9si k\u00f6lts\u00e9g lett, szemben azzal, ahogy egy\u00e9bk\u00e9nt el tud folyni az id\u0151, ha menet k\u00f6zben kell a felmer\u00fcl\u0151 k\u00e9rd\u00e9seket&nbsp;egyeztetni, net\u00e1n akkor jut eszedbe, hogy &#8222;Hopp\u00e1, olyan is szokott lenni, hogy&#8230;&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sajnos az Excel f\u00e1jl m\u00e1r nincs meg, de az ebb\u0151l k\u00e9sz\u00fclt&nbsp;webes \u00e1raj\u00e1nlat kalkul\u00e1tor 10&nbsp;\u00e9v ut\u00e1n is &#8211; a sz\u00fcks\u00e9ges&nbsp;v\u00e1ltoztat\u00e1sokkal &#8211; remek\u00fcl \u00fczemel. <a href=\"https:\/\/www.revolexpress.hu\/megrendeles\" target=\"_blank\" rel=\"noopener\">Itt megn\u00e9zheted<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Egy j\u00f3 kalkul\u00e1tor id\u0151t sp\u00f3rol<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Excel tan\u00e1rk\u00e9nt is&nbsp;t\u00f6bb c\u00e9gnek seg\u00edtettem m\u00e1r rendbe szedni az \u00e1raj\u00e1nlatok kisz\u00e1mol\u00e1s\u00e1t &#8211; \u00e9s l\u00e1tom, hogy rengeteg id\u0151t nyertek vele.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><span style=\"color: #4b4b4b; font-family: Arial, sans-serif;\">Id\u0151t sp\u00f3rolhatsz, ha programoz\u00e1s el\u0151tt \u00e1llsz. <\/span><\/li><li><span style=\"color: #4b4b4b; font-family: Arial, sans-serif;\">Egyszer\u0171bb lesz a koll\u00e9g\u00e1k betan\u00edt\u00e1sa. <\/span><\/li><li>A legt\u00f6bbet pedig a haszn\u00e1lattal sp\u00f3rolhatod meg.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img loading=\"lazy\" decoding=\"async\" width=\"257\" height=\"300\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/66630-Woman-laptop.jpg\" alt=\"Az Excel kalkul\u00e1tor id\u0151t sp\u00f3rol \u00e9s rengeteg el\u0151nnyel j\u00e1r\" class=\"wp-image-873\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/66630-Woman-laptop.jpg 257w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/66630-Woman-laptop-240x280.jpg 240w\" sizes=\"(max-width: 257px) 100vw, 257px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"color: #4b4b4b; font-family: Arial, sans-serif;\"><strong>Egy &#8222;rutin&#8221; sz\u00e1m\u00edt\u00e1snak nem szabadna&nbsp;<span class=\"il\">5<\/span>&nbsp;percn\u00e9l t\u00f6bbe telnie.&nbsp;<\/strong>Ha Te egy aj\u00e1nlattal f\u00e9l \u00f3r\u00e1t foglalkozol, akkor az minden alkalommal 25&nbsp;<span class=\"il\">perc<\/span>&nbsp;vesztes\u00e9g. <\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Napi <strong>4 aj\u00e1nlatn\u00e1l m\u00e1r 100&nbsp;<span class=\"il\">perc<\/span><\/strong>. Ami <span style=\"color: #ff0000;\"><strong>hetente t\u00f6bb mint egy munkanap&#8230;<\/strong><\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Egy j\u00f3 Excel kalkul\u00e1torral ak\u00e1r&nbsp;<strong>t\u00f6bb adminisztrat\u00edv ember munk\u00e1j\u00e1t megsp\u00f3rolhatod.&nbsp;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vagy ha az aj\u00e1nlatad\u00e1s az \u00e9rt\u00e9kest\u0151id feladata, akkor a pap\u00edrmunka helyett v\u00e9gre val\u00f3ban az \u00fcgyfelekre f\u00f3kusz\u00e1lhatnak.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Amit folyamat\u00e1ban \u00e1tl\u00e1tsz, \u00e9s egy koll\u00e9g\u00e1nak el tudsz magyar\u00e1zni (be tudod tan\u00edtani), azt az Excel m\u00e9g k\u00f6nnyebben &#8222;meg\u00e9rti&#8221;, \u00e9s bombabiztosan elv\u00e9gzi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ha szeretn\u00e9l <strong>seg\u00edts\u00e9get az \u00e1raj\u00e1nlat sablon elk\u00e9sz\u00edt\u00e9s\u00e9hez<\/strong>, akkor gyere el a k\u00f6vetkez\u0151&nbsp;<a href=\"http:\/\/exceltitok.hu\/arajanlat-keszites\/\" target=\"_blank\" rel=\"noopener\">\u00e1raj\u00e1nlat-k\u00e9sz\u00edt\u0151 workshopra<\/a>&nbsp;vagy&nbsp;egy <a href=\"http:\/\/exceltitok.hu\/oktatas\" target=\"_blank\" rel=\"noopener\">Excel mini tanfolyamra<\/a>!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><blockquote class=\"wp-embedded-content\" data-secret=\"UFfYNocImV\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/640000ft-excel-hiba\/\">A 640.000 forintos Excel hiba, ami ak\u00e1r 4x annyiba is ker\u00fclhetett volna<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;A 640.000 forintos Excel hiba, ami ak\u00e1r 4x annyiba is ker\u00fclhetett volna&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/640000ft-excel-hiba\/embed\/#?secret=92GUciuuVU#?secret=UFfYNocImV\" data-secret=\"UFfYNocImV\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><blockquote class=\"wp-embedded-content\" data-secret=\"4u8fJf5v6z\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/fkeres\/\">FKERES &#8211; megtal\u00e1lja helyetted<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;FKERES &#8211; megtal\u00e1lja helyetted&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/fkeres\/embed\/#?secret=ZSur2W6U2V#?secret=4u8fJf5v6z\" data-secret=\"4u8fJf5v6z\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>Mit tenn\u00e9l, ha ma beh\u00edvna a f\u0151n\u00f6k\u00f6d, \u00e9s R\u00e1d b\u00edzn\u00e1 az \u00faj \u00e1raj\u00e1nlat kalkul\u00e1tor elk\u00e9sz\u00edt\u00e9s\u00e9t? Term\u00e9szetesen Excelben kellene egy olyan sablont \u00f6ssze\u00e1ll\u00edtanod, amely&nbsp;p\u00e1r v\u00e1ltoz\u00f3 adat megad\u00e1sa ut\u00e1n kiadn\u00e1 a v\u00e9g\u00f6sszeget. Mit tenn\u00e9l, hogy \u00e9rezn\u00e9d magad?&nbsp;Bep\u00e1nikoln\u00e1l, vagy izgatottan le\u00fcln\u00e9l a sz\u00e1m\u00edt\u00f3g\u00e9p el\u00e9 \u00e9s m\u00e1r \u00edrn\u00e1d is a k\u00e9pleteket?&nbsp;<\/p>\n","protected":false},"author":1,"featured_media":9521,"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":[43,83],"class_list":["post-2327","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-egyszerusites","tag-kalkulator"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Egy Excel \u00e1raj\u00e1nlat kalkul\u00e1tor k\u00f6nnyen elk\u00e9sz\u00edthet\u0151, \u00e9s rengeteg el\u0151nnyel j\u00e1r. Min\u00e9l \u00f6sszetettebb a folyamatod, ann\u00e1l ink\u00e1bb meg\u00e9ri Excellel automatiz\u00e1lni.\" \/>\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\/arajanlat-kalkulator-excelben\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el!\" \/>\n<meta property=\"og:description\" content=\"Egy Excel \u00e1raj\u00e1nlat kalkul\u00e1tor k\u00f6nnyen elk\u00e9sz\u00edthet\u0151, \u00e9s rengeteg el\u0151nnyel j\u00e1r. Min\u00e9l \u00f6sszetettebb a folyamatod, ann\u00e1l ink\u00e1bb meg\u00e9ri Excellel automatiz\u00e1lni.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/\" \/>\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-02-15T13:17:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-18T15:39:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts.png\" \/>\n\t<meta property=\"og:image:width\" content=\"810\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\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=\"7 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el!\",\"datePublished\":\"2017-02-15T13:17:20+00:00\",\"dateModified\":\"2022-05-18T15:39:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/\"},\"wordCount\":1362,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/arajanlat-kalkulator-excel-uj-munkatarts.png\",\"keywords\":[\"egyszer\u0171s\u00edt\u00e9s\",\"kalkul\u00e1tor\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/\",\"name\":\"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/arajanlat-kalkulator-excel-uj-munkatarts.png\",\"datePublished\":\"2017-02-15T13:17:20+00:00\",\"dateModified\":\"2022-05-18T15:39:13+00:00\",\"description\":\"Egy Excel \u00e1raj\u00e1nlat kalkul\u00e1tor k\u00f6nnyen elk\u00e9sz\u00edthet\u0151, \u00e9s rengeteg el\u0151nnyel j\u00e1r. Min\u00e9l \u00f6sszetettebb a folyamatod, ann\u00e1l ink\u00e1bb meg\u00e9ri Excellel automatiz\u00e1lni.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/arajanlat-kalkulator-excel-uj-munkatarts.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/arajanlat-kalkulator-excel-uj-munkatarts.png\",\"width\":810,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/arajanlat-kalkulator-excelben\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el!\"}]},{\"@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":"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Egy Excel \u00e1raj\u00e1nlat kalkul\u00e1tor k\u00f6nnyen elk\u00e9sz\u00edthet\u0151, \u00e9s rengeteg el\u0151nnyel j\u00e1r. Min\u00e9l \u00f6sszetettebb a folyamatod, ann\u00e1l ink\u00e1bb meg\u00e9ri Excellel automatiz\u00e1lni.","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\/arajanlat-kalkulator-excelben\/","og_locale":"hu_HU","og_type":"article","og_title":"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el!","og_description":"Egy Excel \u00e1raj\u00e1nlat kalkul\u00e1tor k\u00f6nnyen elk\u00e9sz\u00edthet\u0151, \u00e9s rengeteg el\u0151nnyel j\u00e1r. Min\u00e9l \u00f6sszetettebb a folyamatod, ann\u00e1l ink\u00e1bb meg\u00e9ri Excellel automatiz\u00e1lni.","og_url":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2017-02-15T13:17:20+00:00","article_modified_time":"2022-05-18T15:39:13+00:00","og_image":[{"width":810,"height":450,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts.png","type":"image\/png"}],"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\/arajanlat-kalkulator-excelben\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el!","datePublished":"2017-02-15T13:17:20+00:00","dateModified":"2022-05-18T15:39:13+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/"},"wordCount":1362,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts.png","keywords":["egyszer\u0171s\u00edt\u00e9s","kalkul\u00e1tor"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/","url":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/","name":"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts.png","datePublished":"2017-02-15T13:17:20+00:00","dateModified":"2022-05-18T15:39:13+00:00","description":"Egy Excel \u00e1raj\u00e1nlat kalkul\u00e1tor k\u00f6nnyen elk\u00e9sz\u00edthet\u0151, \u00e9s rengeteg el\u0151nnyel j\u00e1r. Min\u00e9l \u00f6sszetettebb a folyamatod, ann\u00e1l ink\u00e1bb meg\u00e9ri Excellel automatiz\u00e1lni.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/02\/arajanlat-kalkulator-excel-uj-munkatarts.png","width":810,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/arajanlat-kalkulator-excelben\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"\u00c1raj\u00e1nlat kalkul\u00e1tor Excelben: \u00edgy k\u00e9sz\u00edtsd el!"}]},{"@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\/2327","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=2327"}],"version-history":[{"count":22,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/2327\/revisions"}],"predecessor-version":[{"id":9524,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/2327\/revisions\/9524"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/9521"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=2327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=2327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=2327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}