{"id":5413,"date":"2018-04-25T12:01:02","date_gmt":"2018-04-25T10:01:02","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=5413"},"modified":"2018-04-26T02:29:54","modified_gmt":"2018-04-26T00:29:54","slug":"hivatkozas-hasznalj-linkeket","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/","title":{"rendered":"Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket!"},"content":{"rendered":"<p>Hivatkoz\u00e1s (linkek) haszn\u00e1lat\u00e1val egy m\u00e1sik f\u00e1jlt, vagy honlapot kapcsolhatsz a munk\u00e1dhoz, hogy ne kelljen \u00fajra meg \u00fajra keresg\u00e9lned. Vagy ha t\u00fal nagyra n\u0151tt az Excel f\u00e1jl, Word dokumentum, ak\u00e1r f\u00e1jlon bel\u00fcl is megadhatsz egy m\u00e1sik pontot, ahov\u00e1 egy kattint\u00e1ssal \u00e1tugorhatsz.<\/p>\n<p><!--more--><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft wp-image-6471\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/04\/hivatkozas-kattints-ide.png\" alt=\"K\u00f6nny\u00edtsd meg a kattint\u00e1sokat linkekkel, hivatkoz\u00e1sokkal\" width=\"340\" height=\"331\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/04\/hivatkozas-kattints-ide.png 640w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/04\/hivatkozas-kattints-ide-300x292.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/04\/hivatkozas-kattints-ide-240x234.png 240w\" sizes=\"(max-width: 340px) 100vw, 340px\" \/>Egyszer\u0171bb, mint gondoln\u00e1d, r\u00e1ad\u00e1sul<strong> ugyan\u00fagy m\u0171k\u00f6dik<\/strong> az\u00a0Excelben, Wordben, Outlookban, s\u0151t m\u00e9g az interneten is (p\u00e9ld\u00e1ul online levelez\u0151k vagy honlapszerkeszt\u0151k), \u00e9s <strong>m\u00e9g gyorsbillenty\u0171 is van hozz\u00e1!<\/strong><\/p>\n<p>Saj\u00e1t \u00e9s munkat\u00e1rsaid \u00e9let\u00e9t is megk\u00f6nny\u00edtheted, hiszen nem kell \u00f3r\u00e1kat t\u00f6lteni a keresg\u00e9l\u00e9ssel.<\/p>\n<h2>Linkek besz\u00far\u00e1sa<\/h2>\n<p>A &#8222;link&#8221; neve az Office programokban &#8222;hivatkoz\u00e1s&#8221; vagy &#8222;hiperhivatkoz\u00e1s&#8221;. [Fontos, hogy ez nem ugyanaz, mint a <a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-irj-kepleteket-az-excelben\/\" target=\"_blank\" rel=\"noopener\">k\u00e9pletekben haszn\u00e1lt (relat\u00edv \u00e9s abszol\u00fat) hivatkoz\u00e1s<\/a>!]<\/p>\n<p>A pontossa\u00e1g kedv\u00e9\u00e9rt, innent\u0151l link helyett \u00e9n is a hivatkoz\u00e1s sz\u00f3t haszn\u00e1lom.<\/p>\n<h3>\u00cdgy sz\u00farj be hivatkoz\u00e1st:<\/h3>\n<ol>\n<li>El\u0151sz\u00f6r is jel\u00f6ld ki azt a r\u00e9szt, amihez a hivatkoz\u00e1st hozz\u00e1 akarod rendelni. Ez lehet Excelben cella, m\u00e1shol (Word, Outlook, Internet) tetsz\u0151leges hossz\u00fas\u00e1g\u00fa sz\u00f6veg, vagy ak\u00e1r alakzat is (pl. k\u00e9p vagy gomb).<\/li>\n<li><strong>Haszn\u00e1ld a Ctrl K <\/strong>(Apple g\u00e9peken Cmd K)<strong> gyorsbillenty\u0171t a hivatkoz\u00e1s elhelyez\u00e9s\u00e9hez. <\/strong>Ha a men\u00fcn keresed, a Besz\u00far\u00e1s f\u00fcl\u00f6n tal\u00e1lhat\u00f3 a Hivatkoz\u00e1s gomb.<\/li>\n<li>T\u00f6ltsd ki a mez\u0151ket.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/support.content.office.net\/hu-hu\/media\/10aacf03-28aa-4bea-a6f9-5d79a79f6487.png\" alt=\"Hivatkoz\u00e1s, vagyis link besz\u00far\u00e1sa Excelben\" width=\"581\" height=\"270\" \/><\/p>\n<h2>Hivatkoz\u00e1s 4 f\u0151 t\u00edpusa<\/h2>\n<p>Bal oldalt 4 lehet\u0151s\u00e9gb\u0151l v\u00e1laszthatsz:<\/p>\n<ul>\n<li>L\u00e9tez\u0151 f\u00e1jl vagy weblap<\/li>\n<li>Dokumentum adott pontja, azaz az Excel t\u00e1bl\u00e1n bel\u00fcl pl. egy m\u00e1sik f\u00fcl valamely cell\u00e1ja<\/li>\n<li>\u00daj dokumentum<\/li>\n<li>E-mail c\u00edm: Ha erre kattintasz, automatikusan megnyit a levelez\u0151dben egy emailt ezzel a c\u00edmzettel.<\/li>\n<\/ul>\n<h2>Hivatkoz\u00e1s f\u00fcggv\u00e9nnyel<\/h2>\n<p>Az Excelben l\u00e9tezik a HIPERHIVATKOZ\u00c1S nev\u0171 f\u00fcggv\u00e9ny. Ennek seg\u00edts\u00e9g\u00e9vel sz\u00f6vegeket alak\u00edthatsz kattinthat\u00f3 linkekk\u00e9.<\/p>\n<p>A f\u00fcggv\u00e9ny 2 r\u00e9szb\u0151l \u00e1ll:<\/p>\n<ul>\n<li><strong>hivatkoz\u00e1s_hely:<\/strong>\u00a0ez maga a link, pl.\u00a0a megnyitand\u00f3 f\u00e1jl el\u00e9r\u00e9si \u00fatvonala vagy egy weboldal c\u00edme<\/li>\n<li><strong>kedves_n\u00e9v:<\/strong> az a sz\u00f6veg, ami linkk\u00e9nt megjelenik. Ezt nem k\u00f6telez\u0151 megadni, abban az esetben maga a link sz\u00f6vege jelenik meg.<\/li>\n<\/ul>\n<p>P\u00e9ld\u00e1ul:\u00a0=HIPERHIVATKOZ\u00c1S(A2;&#8221;link&#8221;)<\/p>\n<p>Term\u00e9szetes mindk\u00e9t r\u00e9szen megadhatsz sz\u00f6veget, cellahivatkoz\u00e1st, \u00e9s bonyolultabb k\u00e9pleteket is, p\u00e9ld\u00e1ul k\u00fcl\u00f6nb\u00f6z\u0151 cell\u00e1kb\u00f3l is <a href=\"https:\/\/sosexcel.com\/exceltippek\/szovegek-osszefuzese\/\" target=\"_blank\" rel=\"noopener\">\u00f6sszeoll\u00f3zhatod a sz\u00f6veget<\/a>.<\/p>\n<p>P\u00e9ld\u00e1ul:\u00a0=HIPERHIVATKOZ\u00c1S(A2;B2&amp;&#8221; c\u00e9g szerz\u0151d\u00e9se&#8221;)<\/p>\n<p>Ha szeretn\u00e9l szem\u00e9lyes seg\u00edts\u00e9get az Excelhez, <a href=\"http:\/\/exceltitok.hu\/oktatas\/\" target=\"_blank\" rel=\"noopener\">fordulj hozz\u00e1nk bizalommal!<\/a><\/p>\n<h2>N\u00e9zd meg ezt is<\/h2>\n<blockquote class=\"wp-embedded-content\" data-secret=\"ohU1m3pTuR\"><p><a href=\"https:\/\/sosexcel.com\/exceltippek\/fkeres\/\">FKERES &#8211; megtal\u00e1lja helyetted<\/a><\/p><\/blockquote>\n<p><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=9SM8hxBGqv#?secret=ohU1m3pTuR\" data-secret=\"ohU1m3pTuR\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"BJxqcPhk0L\"><p><a href=\"https:\/\/sosexcel.com\/exceltippek\/pdf-tablazatot-excelbe\/\">\u00cdgy tedd \u00e1t a pdf t\u00e1bl\u00e1zatot Excelbe<\/a><\/p><\/blockquote>\n<p><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;\u00cdgy tedd \u00e1t a pdf t\u00e1bl\u00e1zatot Excelbe&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/pdf-tablazatot-excelbe\/embed\/#?secret=bqYJpI2VVu#?secret=BJxqcPhk0L\" data-secret=\"BJxqcPhk0L\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Hivatkoz\u00e1s (linkek) haszn\u00e1lat\u00e1val egy m\u00e1sik f\u00e1jlt, vagy honlapot kapcsolhatsz a munk\u00e1dhoz, hogy ne kelljen \u00fajra meg \u00fajra keresg\u00e9lned. Vagy ha t\u00fal nagyra n\u0151tt az Excel f\u00e1jl, Word dokumentum, ak\u00e1r f\u00e1jlon bel\u00fcl is megadhatsz egy m\u00e1sik pontot, ahov\u00e1 egy kattint\u00e1ssal \u00e1tugorhatsz.<\/p>\n","protected":false},"author":1,"featured_media":5346,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","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":"","adv-header-id-meta":"","stick-header-meta":"","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":[27,28,77],"class_list":["post-5413","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-billentyukombinacio","tag-fuggveny","tag-hatekonysag"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Hivatkoz\u00e1s (linkek) haszn\u00e1lat\u00e1val a f\u00e1jl egy (m\u00e1sik) pontj\u00e1t vagy egy m\u00e1sik f\u00e1jlt, honlapot linkelhetsz a munk\u00e1dhoz, hogy ne kelljen keresg\u00e9lned.\" \/>\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\/hivatkozas-hasznalj-linkeket\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Hivatkoz\u00e1s (linkek) haszn\u00e1lat\u00e1val a f\u00e1jl egy (m\u00e1sik) pontj\u00e1t vagy egy m\u00e1sik f\u00e1jlt, honlapot linkelhetsz a munk\u00e1dhoz, hogy ne kelljen keresg\u00e9lned.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/\" \/>\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=\"2018-04-25T10:01:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-04-26T00:29:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/04\/hivatkozas-kattints-ide.png\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"623\" \/>\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=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket!\",\"datePublished\":\"2018-04-25T10:01:02+00:00\",\"dateModified\":\"2018-04-26T00:29:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/\"},\"wordCount\":495,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/05\/sorok-rogzitese.png\",\"keywords\":[\"billenty\u0171kombin\u00e1ci\u00f3\",\"f\u00fcggv\u00e9ny\",\"hat\u00e9konys\u00e1g\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/\",\"name\":\"Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/05\/sorok-rogzitese.png\",\"datePublished\":\"2018-04-25T10:01:02+00:00\",\"dateModified\":\"2018-04-26T00:29:54+00:00\",\"description\":\"Hivatkoz\u00e1s (linkek) haszn\u00e1lat\u00e1val a f\u00e1jl egy (m\u00e1sik) pontj\u00e1t vagy egy m\u00e1sik f\u00e1jlt, honlapot linkelhetsz a munk\u00e1dhoz, hogy ne kelljen keresg\u00e9lned.\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/05\/sorok-rogzitese.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/05\/sorok-rogzitese.png\",\"width\":1049,\"height\":359},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket!\"}]},{\"@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 az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Hivatkoz\u00e1s (linkek) haszn\u00e1lat\u00e1val a f\u00e1jl egy (m\u00e1sik) pontj\u00e1t vagy egy m\u00e1sik f\u00e1jlt, honlapot linkelhetsz a munk\u00e1dhoz, hogy ne kelljen keresg\u00e9lned.","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\/hivatkozas-hasznalj-linkeket\/","og_locale":"hu_HU","og_type":"article","og_title":"Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Hivatkoz\u00e1s (linkek) haszn\u00e1lat\u00e1val a f\u00e1jl egy (m\u00e1sik) pontj\u00e1t vagy egy m\u00e1sik f\u00e1jlt, honlapot linkelhetsz a munk\u00e1dhoz, hogy ne kelljen keresg\u00e9lned.","og_url":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2018-04-25T10:01:02+00:00","article_modified_time":"2018-04-26T00:29:54+00:00","og_image":[{"width":640,"height":623,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/04\/hivatkozas-kattints-ide.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"2 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket!","datePublished":"2018-04-25T10:01:02+00:00","dateModified":"2018-04-26T00:29:54+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/"},"wordCount":495,"commentCount":6,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/05\/sorok-rogzitese.png","keywords":["billenty\u0171kombin\u00e1ci\u00f3","f\u00fcggv\u00e9ny","hat\u00e9konys\u00e1g"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/","url":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/","name":"Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket! - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/05\/sorok-rogzitese.png","datePublished":"2018-04-25T10:01:02+00:00","dateModified":"2018-04-26T00:29:54+00:00","description":"Hivatkoz\u00e1s (linkek) haszn\u00e1lat\u00e1val a f\u00e1jl egy (m\u00e1sik) pontj\u00e1t vagy egy m\u00e1sik f\u00e1jlt, honlapot linkelhetsz a munk\u00e1dhoz, hogy ne kelljen keresg\u00e9lned.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/05\/sorok-rogzitese.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/05\/sorok-rogzitese.png","width":1049,"height":359},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket!"}]},{"@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\/5413","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=5413"}],"version-history":[{"count":10,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5413\/revisions"}],"predecessor-version":[{"id":9155,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5413\/revisions\/9155"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/5346"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=5413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=5413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=5413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}