{"id":546,"date":"2013-12-23T11:36:58","date_gmt":"2013-12-23T10:36:58","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=546"},"modified":"2020-04-14T13:13:13","modified_gmt":"2020-04-14T11:13:13","slug":"mi-is-az-a-makro","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/","title":{"rendered":"Mi is az a makr\u00f3?"},"content":{"rendered":"

Kell nekem tudnom a makr\u00f3kat? M\u00e1r t\u00f6bbsz\u00f6r hallottam r\u00f3la.<\/p>\n

V\u00e1lasz<\/strong>: Alapvet\u0151en a makr\u00f3 m\u00e1r egy halad\u00f3bb, programoz\u00f3i szeml\u00e9letet is ig\u00e9nyl\u0151 funkci\u00f3, egy mini program, ami rengeteget tud gyors\u00edtani a munkav\u00e9gz\u00e9sen.<\/p>\n

Sokszor azonban t\u00falmisztifik\u00e1lj\u00e1k. \u00c9n \u00e1ltal\u00e1ban lebesz\u00e9lem r\u00f3la az \u00e1tlagos felhaszn\u00e1l\u00f3kat.<\/p>\n

Egyr\u00e9szt az\u00e9rt, mert m\u00e1r egy magabiztos Excel tud\u00e1ssal is sokat gyors\u00edthatsz a munk\u00e1don. M\u00e1sr\u00e9szt, ha val\u00f3ban sz\u00fcks\u00e9ges, akkor lesz a munkahelyeden r\u00e1 egy dedik\u00e1lt szem\u00e9ly, aki a programoz\u00e1ssal foglalkozik. Neked igaz\u00e1b\u00f3l csak a makr\u00f3k felhaszn\u00e1l\u00e1s\u00e1t \u00e9rdemes ismerned<\/strong>.<\/p>\n

Mire j\u00f3 a makr\u00f3?<\/h3>\n

Akkor van \u00e9rtelme, ha van olyan feladatod, amit egy\u00e9bk\u00e9nt rendszeresen kell v\u00e9gezned<\/strong>. Ilyenkor – ugyan\u00fagy mint egy vide\u00f3-felv\u00e9telt – lehet r\u00f6gz\u00edteni a m\u0171veleteket. Ut\u00e1na b\u00e1rmikor vissza tudod j\u00e1tszani, megism\u00e9telheted. Annyi a k\u00fcl\u00f6nbs\u00e9g, hogy az Excel sokkal gyorsabban v\u00e9gzi el ugyanazt a m\u0171veletsort. Pl. ami neked 10 perc, az \u00edgy 3 m\u00e1sodperc lesz.<\/p>\n

Sok id\u0151t lehet sp\u00f3rolni a makr\u00f3val akkor is, ha rendszeresen sok adatot kell sz\u00e9tv\u00e1lasztani k\u00fcl\u00f6n f\u00e1jlokba (p\u00e9ld\u00e1ul partnerek szerint), vagy a visszakapott adatokat \u00f6sszeilleszteni egy t\u00e1bl\u00e1zatba.<\/p>\n

Makr\u00f3t \u00edrni, azaz automatiz\u00e1lni a Wordben is lehets\u00e9ges! P\u00e9ld\u00e1ul kiv\u00e1l\u00f3an haszn\u00e1lhat\u00f3 helyes\u00edr\u00e1si hib\u00e1k jav\u00edt\u00e1s\u00e1ra.<\/p>\n

Mit\u0151l neh\u00e9z a makr\u00f3 \u00edr\u00e1s?<\/h3>\n

Nem ism\u00e9telhet\u0151 meg minden m\u0171veletsor, pontosabban nem biztos, hogy „megism\u00e9telve” is ugyanazt az eredm\u00e9nyt adja! Miel\u0151tt makr\u00f3z\u00e1sba kezdesz, j\u00f3l \u00e1t kell gondolnod, hogy milyen k\u00f6r\u00fclm\u00e9nyek k\u00f6z\u00f6tt lesz legk\u00f6zelebb sz\u00fcks\u00e9ged erre a feladatra.<\/p>\n

Ez egy komplexebb szeml\u00e9letet ig\u00e9nyel<\/strong>: Biztos, hogy a k\u00f6vetkez\u0151 alkalommal is megism\u00e9telhet\u0151 a m\u0171veletsor? Biztosan ugyanannyi adatod lesz? Ugyanott lesznek? Nem t\u00f6r\u00f6lsz v\u00e9letlen\u00fcl egy megl\u00e9v\u0151 adatot? M\u00e1sik munkalapon is m\u0171k\u00f6dni fog?<\/p>\n

Hasonl\u00f3an \u00e1t kell gondolni az \u00f6sszes mi-van-ha el\u00e1gaz\u00e1st, \u00e9s megadni r\u00e1 a megold\u00e1st, k\u00fcl\u00f6nben „kiakad” a makr\u00f3, \u00e9s nem m\u0171k\u00f6dik.<\/p>\n

V\u00e9gezet\u00fcl az\u00e9rt is kell k\u00f6r\u00fcltekint\u0151nek lenni, mert amit a makr\u00f3 csin\u00e1l, azt nem tudod visszavonni<\/strong>. Teh\u00e1t \u00e9rdemes el\u0151tte (ak\u00e1r t\u00f6bb) m\u00e1solatot k\u00e9sz\u00edtened a t\u00e1bl\u00e1zatodr\u00f3l.<\/p>\n

\u00c1prilis 22-\u00e9n 14:00-15:00<\/strong> Perj\u00e9si Zolt\u00e1n oktat\u00f3nk kedvcsin\u00e1l\u00f3 el\u0151ad\u00e1s\u00e1n besz\u00e9lni fog arr\u00f3l, hogy mi mindenre haszn\u00e1lhatod a makr\u00f3kat, \u00e9s arr\u00f3l is, hogy mikor \u00e9rdemes megtanulni, \u00e9s mikor kell ink\u00e1bb kiadni a makr\u00f3\u00edr\u00e1s feladat\u00e1t. Sz\u00e1mos gyakorlati p\u00e9ld\u00e1t is fog mutatni a makr\u00f3k alkalmaz\u00e1s\u00e1ra. Konkr\u00e9t k\u00f3dol\u00e1s nem lesz, \u00edgy mindenki sz\u00e1m\u00e1ra \u00e9rthet\u0151 lesz. Az el\u0151ad\u00e1s VIP Klubtagoknak ingyenes, jelenkez\u00e9s itt: Excel VIP Klub<\/a><\/span>  \u2705 R\u00e1ad\u00e1sul, ha szeretn\u00e9d megtanulni a makr\u00f3kat, akkor VIP Klubtagk\u00e9nt -25% kedvezm\u00e9nyt, azaz nett\u00f3 9.750 Ft kedvezm\u00e9nyt kapsz a workshopra. Vagyis r\u00f6gt\u00f6n \"visszanyered\" az els\u0151 havid\u00edjat.<\/pre>\n
Hogyan \u00e9rdemes elsaj\u00e1t\u00edtani a makr\u00f3 \u00edr\u00e1st?<\/h3>\n
\"A<\/a><\/p>\n
Ha m\u00e9gis sz\u00fcks\u00e9ged van a makr\u00f3kra, akkor kezd j\u00e1t\u00e9kosan, \u00e9s ismerd meg a Makr\u00f3 r\u00f6gz\u00edt\u00e9s folyamat\u00e1t.<\/strong><\/p>\n
A N\u00e9zet men\u00fcben tal\u00e1lod a Makr\u00f3 parancsot.<\/p>\n
Ind\u00edtsd el a felv\u00e9telt, ugyan\u00fagy, ahogy a videokamer\u00e1n is megnyomod a rec gombot. Ezut\u00e1n v\u00e9gezz el p\u00e1r alap m\u0171veletet: adatok be\u00edr\u00e1sa, form\u00e1z\u00e1s, sorba rendez\u00e9s, esetleg k\u00e9pletek.<\/p>\n
Miut\u00e1n v\u00e9gezt\u00e9l, nyomd meg a stop gombhoz hasonl\u00f3an a le\u00e1ll\u00edt\u00e1s parancsot. L\u00e9pj be a Makr\u00f3 megjelen\u00edt\u00e9se ablakba, j\u00e1tszd vissza a felv\u00e9telt, \u00e9s n\u00e9zd meg, mi t\u00f6rt\u00e9nik!<\/p>\n
R\u00f6gz\u00edt\u00e9s sor\u00e1n a h\u00e1tt\u00e9rben az Excel minden l\u00e9p\u00e9sedet r\u00f6gz\u00edti egy k\u00fcl\u00f6n helyen. Visual Basicnek h\u00edvj\u00e1k mag\u00e1t a programoz\u00e1si nyelvet<\/strong>, amin ezt megteszi. Ha futtat\u00e1skor kiakad a makr\u00f3, vagy a Szerkeszt\u00e9s parancsot v\u00e1lasztod, akkor egy k\u00fcl\u00f6n ablakban megny\u00edlik a program, ahol t\u00e9telesen l\u00e1tni fogod a parancsokat.<\/p>\n
N\u00e9mi angol tud\u00e1ssal k\u00f6nnyen \u00e9rtelmezhet\u0151 a sz\u00f6veg. Mint l\u00e1thatod, \u00e9n\u00a0egy 2-es elrendez\u00e9s\u0171 (azaz c\u00edmet is tartalmaz\u00f3) 3 dimenzi\u00f3s csoportos\u00edtott oszlop diagramot (3DColumnClustered)\u00a0k\u00e9sz\u00edtettem az F9 – J16 cell\u00e1kb\u00f3l, \u00e9s ezt r\u00f6gz\u00edtettem:<\/p>\n
Sub Makr\u00f31()\n'\n' Makr\u00f31 Makr\u00f3\n'\n'\n Range(\"F9:J16\").Select\n ActiveSheet.Shapes.AddChart.Select\n ActiveChart.ChartType = xl3DColumnClustered\n ActiveChart.SetSourceData Source:=Range(\"Munka1!$F$9:$J$16\")\n ActiveChart.ApplyLayout (2)\n ActiveChart.ChartTitle.Select\n Selection.Caption = \"\u00c9rt\u00e9kes\u00edt\u00e9s\"\n Range(\"P10\").Select\nEnd Sub<\/pre>\n
A makr\u00f3kon magad is elv\u00e9gezhetsz kisebb v\u00e1ltoztat\u00e1sokat, ehhez nem kell felt\u00e9tlen\u00fcl ismerned a Visual Basic programoz\u00e1si nyelvet. P\u00e9ld\u00e1ul ebben a r\u00f6vid r\u00e9szletben is k\u00f6nnyen \u00e1t\u00edrhatod a kijel\u00f6lt cell\u00e1kat, vagy a diagram c\u00edm\u00e9t. Vagy ha t\u00f6bb kisebb programot r\u00f6gz\u00edtesz, akkor szabadon m\u00e1solhatod a k\u00f3dokat, vagy \u00f6sszevonhatod a makr\u00f3kat.<\/p>\n
B\u00e1tran j\u00e1tssz \u00e9s k\u00eds\u00e9rletezz vele, mert sokat lehet tanulni bel\u0151le!<\/p>\n
Ha \u00e9rdekel, hasonl\u00f3 feladatot megoldhatunk egy\u00fctt\u00a0is.\u00a0Makr\u00f3 (VBA) programoz\u00e1st azonban nem tan\u00edtunk. Az ExcelTitok tanfolyamokon<\/a>\u00a0a gyakorlatias, id\u0151sp\u00f3rol\u00f3 technik\u00e1kra helyezz\u00fck a hangs\u00falyt<\/strong>.<\/p>\n
Ha szeretn\u00e9d alaposan megismerni a Visual Basic nyelvet<\/strong>, \u00e9s rutint szerezni a hibajav\u00edt\u00e1sban, akkor \u00e9rdemes r\u00e9szt venned egy c\u00e9lzott tanfolyamon<\/a>.<\/p>\n
A hozz\u00e1\u00e9rt\u0151k \u00f6sszetett m\u0171veleteket is biztons\u00e1ggal levez\u00e9nyelhetnek, ami t\u00e9nyleg rengeteg id\u0151t, energi\u00e1t sp\u00f3rolhat.<\/p>\n
Maradt m\u00e9g k\u00e9rd\u00e9sed a makr\u00f3val kapcsolatban?\nPr\u00f3b\u00e1ltad m\u00e1r?\nOszd meg a tapasztalataidat a hozz\u00e1sz\u00f3l\u00e1sok k\u00f6z\u00f6tt!<\/pre>\n","protected":false},"excerpt":{"rendered":"
Kell nekem tudnom a makr\u00f3kat? M\u00e1r t\u00f6bbsz\u00f6r hallottam r\u00f3la. V\u00e1lasz: Alapvet\u0151en a makr\u00f3 m\u00e1r egy halad\u00f3bb, programoz\u00f3i szeml\u00e9letet is ig\u00e9nyl\u0151 funkci\u00f3, egy mini program, ami rengeteget tud gyors\u00edtani a munkav\u00e9gz\u00e9sen. Sokszor azonban t\u00falmisztifik\u00e1lj\u00e1k. \u00c9n \u00e1ltal\u00e1ban lebesz\u00e9lem r\u00f3la az \u00e1tlagos felhaszn\u00e1l\u00f3kat.<\/p>\n","protected":false},"author":1,"featured_media":6188,"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,73],"class_list":["post-546","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-egyszerusites","tag-makro"],"yoast_head":"\nMi is az a makr\u00f3? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Mennyire fontos a makr\u00f3 ismerete? Milyen helyzetekre j\u00f3?\" \/>\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\/mi-is-az-a-makro\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mi is az a makr\u00f3? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Mennyire fontos a makr\u00f3 ismerete? Milyen helyzetekre j\u00f3?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/\" \/>\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=\"2013-12-23T10:36:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-14T11:13:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/12\/makro-rogzitese-visszajatszasa.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\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\\\/mi-is-az-a-makro\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Mi is az a makr\u00f3?\",\"datePublished\":\"2013-12-23T10:36:58+00:00\",\"dateModified\":\"2020-04-14T11:13:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/\"},\"wordCount\":837,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/12\\\/makro-rogzitese-visszajatszasa.png\",\"keywords\":[\"egyszer\u0171s\u00edt\u00e9s\",\"makr\u00f3\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/\",\"name\":\"Mi is az a makr\u00f3? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/12\\\/makro-rogzitese-visszajatszasa.png\",\"datePublished\":\"2013-12-23T10:36:58+00:00\",\"dateModified\":\"2020-04-14T11:13:13+00:00\",\"description\":\"Mennyire fontos a makr\u00f3 ismerete? Milyen helyzetekre j\u00f3?\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/12\\\/makro-rogzitese-visszajatszasa.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/12\\\/makro-rogzitese-visszajatszasa.png\",\"width\":1200,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/mi-is-az-a-makro\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mi is az a makr\u00f3?\"}]},{\"@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":"Mi is az a makr\u00f3? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Mennyire fontos a makr\u00f3 ismerete? Milyen helyzetekre j\u00f3?","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\/mi-is-az-a-makro\/","og_locale":"hu_HU","og_type":"article","og_title":"Mi is az a makr\u00f3? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Mennyire fontos a makr\u00f3 ismerete? Milyen helyzetekre j\u00f3?","og_url":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2013-12-23T10:36:58+00:00","article_modified_time":"2020-04-14T11:13:13+00:00","og_image":[{"width":1200,"height":300,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/12\/makro-rogzitese-visszajatszasa.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\/mi-is-az-a-makro\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Mi is az a makr\u00f3?","datePublished":"2013-12-23T10:36:58+00:00","dateModified":"2020-04-14T11:13:13+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/"},"wordCount":837,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/12\/makro-rogzitese-visszajatszasa.png","keywords":["egyszer\u0171s\u00edt\u00e9s","makr\u00f3"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/","url":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/","name":"Mi is az a makr\u00f3? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/12\/makro-rogzitese-visszajatszasa.png","datePublished":"2013-12-23T10:36:58+00:00","dateModified":"2020-04-14T11:13:13+00:00","description":"Mennyire fontos a makr\u00f3 ismerete? Milyen helyzetekre j\u00f3?","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/12\/makro-rogzitese-visszajatszasa.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/12\/makro-rogzitese-visszajatszasa.png","width":1200,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/mi-is-az-a-makro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Mi is az a makr\u00f3?"}]},{"@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\/546","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=546"}],"version-history":[{"count":28,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/546\/revisions"}],"predecessor-version":[{"id":8675,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/546\/revisions\/8675"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/6188"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=546"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}