{"id":7684,"date":"2019-06-04T10:27:53","date_gmt":"2019-06-04T08:27:53","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=7684"},"modified":"2025-06-29T00:25:56","modified_gmt":"2025-06-28T22:25:56","slug":"uj-funkciok-a-google-tablazatban","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/","title":{"rendered":"\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban &#8211; ami seg\u00edt az adattiszt\u00edt\u00e1sban"},"content":{"rendered":"\n<p>A Google T\u00e1bl\u00e1zatban szerepl\u0151 adatokn\u00e1l is el\u0151fordulhat, hogy elg\u00e9pel\u00e9s vagy duplik\u00e1ci\u00f3k nehez\u00edtik a munk\u00e1t. Szerencs\u00e9re k\u00e9sz\u00fcltek \u00faj funkci\u00f3k, hogy k\u00f6nnyebb legyen az adatok karbantart\u00e1sa.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\">Felesleges sz\u00f3k\u00f6z\u00f6k a Google T\u00e1bl\u00e1zatban<\/h2>\n\n\n\n<p>Gyakran el\u0151fordul, hogy g\u00e9pel\u00e9s k\u00f6zben felesleges sz\u00f3k\u00f6z\u00f6k ker\u00fclnek a sz\u00f6vegbe. Vagy export\u00e1l\u00e1s k\u00f6zben ker\u00fcl a sz\u00f6veg v\u00e9g\u00e9re t\u00f6bb \u00fcres karakter.<\/p>\n\n\n\n<p>A Google T\u00e1bl\u00e1zatban \u00faj funkci\u00f3 seg\u00edti ezeknek a sz\u00f3k\u00f6z\u00f6knek az elt\u00e1vol\u00edt\u00e1s\u00e1t:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Jel\u00f6ld ki a probl\u00e9m\u00e1s cell\u00e1kat vagy oszlop(ok)at.<\/li>\n\n\n\n<li>V\u00e1laszd a Data \/ Trim Whitespace (magyarul Adatok f\u00fcl \/ T\u00e9rk\u00f6z lev\u00e1g\u00e1sa)<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-image alignright is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"583\" height=\"614\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/felesleges-sz\u00f3k\u00f6z\u00f6k-Google-tablazatban.png\" alt=\"Most m\u00e1r k\u00f6nnyen t\u00f6r\u00f6lheted a felesleges sz\u00f3k\u00f6z\u00f6ket a Google T\u00e1bl\u00e1zatban\" class=\"wp-image-7687\" style=\"width:528px;height:556px\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/felesleges-sz\u00f3k\u00f6z\u00f6k-Google-tablazatban.png 583w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/felesleges-sz\u00f3k\u00f6z\u00f6k-Google-tablazatban-285x300.png 285w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/felesleges-sz\u00f3k\u00f6z\u00f6k-Google-tablazatban-240x253.png 240w\" sizes=\"(max-width: 583px) 100vw, 583px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p>A funkci\u00f3 m\u00e1r ki is t\u00f6r\u00f6lte a felesleges sz\u00f3k\u00f6z\u00f6ket, \u00e9s csup\u00e1n annyit \u00e1rul el, hogy h\u00e1ny hib\u00e1s cell\u00e1t tal\u00e1lt.<\/p>\n\n\n\n<figure class=\"wp-block-image alignright is-resized\"><img decoding=\"async\" width=\"589\" height=\"191\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/eltavolitott-szokozok.png\" alt=\"Az ablak mutatja, hogyh\u00e1ny cell\u00e1ban tal\u00e1lt felesleges sz\u00f3k\u00f6zt.\" class=\"wp-image-7686\" style=\"width:460px;height:149px\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/eltavolitott-szokozok.png 589w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/eltavolitott-szokozok-300x97.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/eltavolitott-szokozok-240x78.png 240w\" sizes=\"(max-width: 589px) 100vw, 589px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-left\"><strong>Felesleges sz\u00f3k\u00f6znek sz\u00e1m\u00edt:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>a sz\u00f6veg elej\u00e9n minden sz\u00f3k\u00f6z<\/li>\n\n\n\n<li>a szavak k\u00f6z\u00f6tt az egyn\u00e9l t\u00f6bb sz\u00f3k\u00f6z (azaz egy sz\u00f3k\u00f6zt meghagy a funkci\u00f3)<\/li>\n\n\n\n<li>az utols\u00f3 sz\u00f3 ut\u00e1n minden sz\u00f3k\u00f6z<\/li>\n<\/ul>\n\n\n\n<p class=\"has-very-light-gray-background-color has-background\">F\u00fcggv\u00e9nyk\u00e9nt (Excelben csak \u00edgy lehet a sz\u00f3k\u00f6z\u00f6ket t\u00f6r\u00f6lni) a KIMETSZ (TRIM) a megold\u00e1s.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Duplik\u00e1ci\u00f3k a Google T\u00e1bl\u00e1zatban<\/h2>\n\n\n\n<p>A m\u00e1sik neh\u00e9zs\u00e9g, amikor bizonyos sorok, vagy csak adatok dupl\u00e1n szerepelnek. Erre k\u00edn\u00e1l megold\u00e1st az Adatok \/ Adatkarbantart\u00e1s \/ Ism\u00e9tl\u0151d\u00e9sek elt\u00e1vol\u00edt\u00e1sa (angolul Remove Duplicates). Hasonl\u00edt az <a rel=\"noreferrer noopener\" aria-label=\"Excel Ism\u00e9tl\u0151d\u00e9sek elt\u00e1vol\u00edt\u00e1sa funkci\u00f3ra (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"http:\/\/exceltitok.hu\/ismetlodo-adatok\/\" target=\"_blank\">Excel Ism\u00e9tl\u0151d\u00e9sek elt\u00e1vol\u00edt\u00e1sa funkci\u00f3ra.<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/12\/google-ismetlodesek.png\"><img decoding=\"async\" width=\"670\" height=\"562\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/12\/google-ismetlodesek.png\" alt=\"Google T\u00e1bl\u00e1zatban is van lehet\u0151s\u00e9g a duplik\u00e1ci\u00f3k\/is\u00e9tl\u0151d\u00e9sek t\u00f6rl\u00e9s\u00e9re.\" class=\"wp-image-9830\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/12\/google-ismetlodesek.png 670w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/12\/google-ismetlodesek-300x252.png 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-text-align-center has-very-light-gray-background-color has-background\"><a rel=\"noreferrer noopener\" aria-label=\"iGoogle T\u00e1bl\u00e1zat vagy Excel: melyiket \u00e9rdemes haszn\u00e1lni? (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"https:\/\/sosexcel.com\/exceltippek\/google-tablazat-vagy-excel-melyiket-erdemes-hasznalni\/https:\/\/sosexcel.com\/exceltippek\/google-tablazat-vagy-excel-melyiket-erdemes-hasznalni\/\" target=\"_blank\">Google T\u00e1bl\u00e1zat vagy Excel: melyiket \u00e9rdemes haszn\u00e1lni?<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image alignright is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"369\" height=\"511\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/mi-a-duplikacio.png\" alt=\"Duplik\u00e1ci\u00f3k a Google T\u00e1bl\u00e1zatban\" class=\"wp-image-7693\" style=\"width:388px;height:536px\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/mi-a-duplikacio.png 369w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/mi-a-duplikacio-217x300.png 217w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/mi-a-duplikacio-240x332.png 240w\" sizes=\"(max-width: 369px) 100vw, 369px\" \/><\/figure>\n\n\n\n<p>Els\u0151 l\u00e9p\u00e9sk\u00e9nt mondd meg, hogy mi sz\u00e1m\u00edt dupl\u00e1nak: alap\u00e9rtelmezetten az, ha minden oszlopban egyeznek az adatok. <\/p>\n\n\n\n<p>Ha ezen enyh\u00edteni szeretn\u00e9l, csak vedd ki a pip\u00e1t az el\u0151l a mez\u0151n\u00e9v el\u0151l, ahol lehet elt\u00e9r\u00e9s. Pl. ha a vev\u0151ket n\u00e9zed, akkor el\u00e9g a c\u00e9gnevet, esetleg c\u00edmet bebpip\u00e1lva hagyni. Ha viszont szeretn\u00e9d megk\u00fcl\u00f6nb\u00f6ztetni term\u00e9kenk\u00e9nt, akkor azt is (E oszlop) hagyd bepip\u00e1lva.<\/p>\n\n\n\n<p><strong>A Google funkci\u00f3 is az adatb\u00e1zisban szerepl\u0151 els\u0151 adatot hagyja meg, \u00e9s a tov\u00e1bbiakat t\u00f6rli<\/strong> &#8211; de azt nem fogod l\u00e1tni, hogy mely sorok lettek kit\u00f6r\u00f6lve.<\/p>\n\n\n\n<p>A kattint\u00e1s ut\u00e1n a k\u00f6vetkez\u0151 \u00fczenetet fogod l\u00e1tni:<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:66% auto\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"207\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/duplikacio-eltavolitva-google-tablazatban.png\" alt=\"\" class=\"wp-image-7692 size-full\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/duplikacio-eltavolitva-google-tablazatban.png 558w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/duplikacio-eltavolitva-google-tablazatban-300x111.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/duplikacio-eltavolitva-google-tablazatban-240x89.png 240w\" sizes=\"(max-width: 558px) 100vw, 558px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>X adatot ker\u00fclt t\u00f6rl\u00e9sre, Y egyedi sor maradt meg.<\/p>\n<\/div><\/div>\n\n\n\n<p class=\"has-very-light-gray-background-color has-background\">Ha v\u00e1ltoztatni szeretn\u00e9d a Google kezel\u0151fel\u00fclet nyelv\u00e9t (angol, magyar, stb), <a href=\"https:\/\/support.google.com\/accounts\/answer\/32047?co=GENIE.Platform%3DDesktop&amp;hl=hu\">olvasd&nbsp;el&nbsp;ezt&nbsp;a&nbsp;le\u00edr\u00e1st.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9g t\u00f6bb tud\u00e1s a Google T\u00e1bl\u00e1zatokr\u00f3l \u00e9s az Excelt\u0151l<\/h2>\n\n\n\n<p>B\u00e1r j\u00f3magam (\u00e9s a csapatom) az Excel mellett tettem le a voksom, b\u00e1rmikor sz\u00edvesen seg\u00edt\u00fcnk, ha megakadt\u00e1l egy Google T\u00e1bl\u00e1zattal. Olvasd tov\u00e1bb az \u00edr\u00e1sainkat, vagy <a aria-label=\"gyere hozz\u00e1nk tanulni (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"http:\/\/exceltitok.hu\/oktatas\" target=\"_blank\" rel=\"noreferrer noopener\">gyere hozz\u00e1nk egy\u00e9nileg tanulni<\/a>.<\/p>\n\n\n\n<p>N\u00e9zd meg \u00e1tfog\u00f3,\u00a0<strong>9 alkalmas kezd\u0151t\u0151l halad\u00f3ig<\/strong>\u00a0<a href=\"https:\/\/exceltitok.hu\/google-tablazatok\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google T\u00e1bl\u00e1zatok tanfolyam<\/a>ot.<\/p>\n\n\n\n<p> <a rel=\"noreferrer noopener\" href=\"http:\/\/exceltitok.hu\/kereses-es-csere-az-excelben\/#google\" target=\"_blank\">Keres\u00e9s \u00e9s csere<\/a> a Google T\u00e1bl\u00e1zatban. <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-azonnal-haszn-lhat-excel-tippek wp-block-embed-azonnal-haszn-lhat-excel-tippek\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"FSdeOSDIOk\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/google-tablazat-sor-rogzitese\/\">Hogyan m\u0171k\u00f6dik a Google T\u00e1bl\u00e1zat sor r\u00f6gz\u00edt\u00e9se?<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Hogyan m\u0171k\u00f6dik a Google T\u00e1bl\u00e1zat sor r\u00f6gz\u00edt\u00e9se?&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/google-tablazat-sor-rogzitese\/embed\/#?secret=Q5JSc7mIOb#?secret=FSdeOSDIOk\" data-secret=\"FSdeOSDIOk\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-azonnal-haszn-lhat-excel-tippek wp-block-embed-azonnal-haszn-lhat-excel-tippek\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"Wp0RLBAlGJ\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/7-konnyen-megjegyezheto-billentyukombinacio\/\">7 k\u00f6nnyen megjegyezhet\u0151 billenty\u0171kombin\u00e1ci\u00f3, amivel \u00f3r\u00e1kat sp\u00f3rolhatsz<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;7 k\u00f6nnyen megjegyezhet\u0151 billenty\u0171kombin\u00e1ci\u00f3, amivel \u00f3r\u00e1kat sp\u00f3rolhatsz&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/7-konnyen-megjegyezheto-billentyukombinacio\/embed\/#?secret=jeJlsGOfsL#?secret=Wp0RLBAlGJ\" data-secret=\"Wp0RLBAlGJ\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n","protected":false},"excerpt":{"rendered":"<p>A Google T\u00e1bl\u00e1zatban szerepl\u0151 adatokn\u00e1l is el\u0151fordulhat, hogy elg\u00e9pel\u00e9s vagy duplik\u00e1ci\u00f3k nehez\u00edtik a munk\u00e1t. Szerencs\u00e9re k\u00e9sz\u00fcltek \u00faj funkci\u00f3k, hogy k\u00f6nnyebb legyen az adatok karbantart\u00e1sa.<\/p>\n","protected":false},"author":1,"featured_media":7130,"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":"set","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":[30,69,49],"class_list":["post-7684","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-adatbazis","tag-adatkezeles","tag-google-tablazatok"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban - ami seg\u00edt az adattiszt\u00edt\u00e1sban<\/title>\n<meta name=\"description\" content=\"A Google T\u00e1bl\u00e1zatban szerepl\u0151 adatokn\u00e1l is el\u0151fordulhat, hogy elg\u00e9pel\u00e9s vagy duplik\u00e1ci\u00f3k nehez\u00edtik a munk\u00e1t. Szerencs\u00e9re k\u00e9sz\u00fcltek erre \u00faj funkci\u00f3k.\" \/>\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\/uj-funkciok-a-google-tablazatban\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban - ami seg\u00edt az adattiszt\u00edt\u00e1sban\" \/>\n<meta property=\"og:description\" content=\"A Google T\u00e1bl\u00e1zatban szerepl\u0151 adatokn\u00e1l is el\u0151fordulhat, hogy elg\u00e9pel\u00e9s vagy duplik\u00e1ci\u00f3k nehez\u00edtik a munk\u00e1t. Szerencs\u00e9re k\u00e9sz\u00fcltek erre \u00faj funkci\u00f3k.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/\" \/>\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=\"2019-06-04T08:27:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-28T22:25:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/felesleges-sz\u00f3k\u00f6z\u00f6k-Google-tablazatban.png\" \/>\n\t<meta property=\"og:image:width\" content=\"583\" \/>\n\t<meta property=\"og:image:height\" content=\"614\" \/>\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\\\/uj-funkciok-a-google-tablazatban\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban &#8211; ami seg\u00edt az adattiszt\u00edt\u00e1sban\",\"datePublished\":\"2019-06-04T08:27:53+00:00\",\"dateModified\":\"2025-06-28T22:25:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/\"},\"wordCount\":580,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/meres-informacio-adat.png\",\"keywords\":[\"adatb\u00e1zis\",\"adatkezel\u00e9s\",\"Google T\u00e1bl\u00e1zatok\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/\",\"name\":\"\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban - ami seg\u00edt az adattiszt\u00edt\u00e1sban\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/meres-informacio-adat.png\",\"datePublished\":\"2019-06-04T08:27:53+00:00\",\"dateModified\":\"2025-06-28T22:25:56+00:00\",\"description\":\"A Google T\u00e1bl\u00e1zatban szerepl\u0151 adatokn\u00e1l is el\u0151fordulhat, hogy elg\u00e9pel\u00e9s vagy duplik\u00e1ci\u00f3k nehez\u00edtik a munk\u00e1t. Szerencs\u00e9re k\u00e9sz\u00fcltek erre \u00faj funkci\u00f3k.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/meres-informacio-adat.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/meres-informacio-adat.png\",\"width\":1344,\"height\":373},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/uj-funkciok-a-google-tablazatban\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban &#8211; ami seg\u00edt az adattiszt\u00edt\u00e1sban\"}]},{\"@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":"\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban - ami seg\u00edt az adattiszt\u00edt\u00e1sban","description":"A Google T\u00e1bl\u00e1zatban szerepl\u0151 adatokn\u00e1l is el\u0151fordulhat, hogy elg\u00e9pel\u00e9s vagy duplik\u00e1ci\u00f3k nehez\u00edtik a munk\u00e1t. Szerencs\u00e9re k\u00e9sz\u00fcltek erre \u00faj funkci\u00f3k.","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\/uj-funkciok-a-google-tablazatban\/","og_locale":"hu_HU","og_type":"article","og_title":"\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban - ami seg\u00edt az adattiszt\u00edt\u00e1sban","og_description":"A Google T\u00e1bl\u00e1zatban szerepl\u0151 adatokn\u00e1l is el\u0151fordulhat, hogy elg\u00e9pel\u00e9s vagy duplik\u00e1ci\u00f3k nehez\u00edtik a munk\u00e1t. Szerencs\u00e9re k\u00e9sz\u00fcltek erre \u00faj funkci\u00f3k.","og_url":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2019-06-04T08:27:53+00:00","article_modified_time":"2025-06-28T22:25:56+00:00","og_image":[{"width":583,"height":614,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/06\/felesleges-sz\u00f3k\u00f6z\u00f6k-Google-tablazatban.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\/uj-funkciok-a-google-tablazatban\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban &#8211; ami seg\u00edt az adattiszt\u00edt\u00e1sban","datePublished":"2019-06-04T08:27:53+00:00","dateModified":"2025-06-28T22:25:56+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/"},"wordCount":580,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/06\/meres-informacio-adat.png","keywords":["adatb\u00e1zis","adatkezel\u00e9s","Google T\u00e1bl\u00e1zatok"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/","url":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/","name":"\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban - ami seg\u00edt az adattiszt\u00edt\u00e1sban","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/06\/meres-informacio-adat.png","datePublished":"2019-06-04T08:27:53+00:00","dateModified":"2025-06-28T22:25:56+00:00","description":"A Google T\u00e1bl\u00e1zatban szerepl\u0151 adatokn\u00e1l is el\u0151fordulhat, hogy elg\u00e9pel\u00e9s vagy duplik\u00e1ci\u00f3k nehez\u00edtik a munk\u00e1t. Szerencs\u00e9re k\u00e9sz\u00fcltek erre \u00faj funkci\u00f3k.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/06\/meres-informacio-adat.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/06\/meres-informacio-adat.png","width":1344,"height":373},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/uj-funkciok-a-google-tablazatban\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"\u00daj funkci\u00f3k a Google T\u00e1bl\u00e1zatban &#8211; ami seg\u00edt az adattiszt\u00edt\u00e1sban"}]},{"@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\/7684","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=7684"}],"version-history":[{"count":20,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/7684\/revisions"}],"predecessor-version":[{"id":9967,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/7684\/revisions\/9967"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/7130"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=7684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=7684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=7684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}