{"id":335,"date":"2019-01-17T00:00:00","date_gmt":"2019-01-16T23:00:00","guid":{"rendered":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/"},"modified":"2021-08-24T22:58:43","modified_gmt":"2021-08-24T20:58:43","slug":"zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach","status":"publish","type":"post","link":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/","title":{"rendered":"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v&nbsp;organizac\u00edch a firm\u00e1ch"},"content":{"rendered":"\n<p>Po\u017eadavky na obsahy \u0161kolen\u00ed <strong>MS Excel, <\/strong>kter\u00e9 jsme<strong> <\/strong>realizovali v&nbsp;roce 2018 ve \u0161kolsk\u00fdch organizac\u00edch a ve firm\u00e1ch, byly velmi r\u016fznorod\u00e9 a odv\u00edjely se od schopnost\u00ed \u00fa\u010dastn\u00edk\u016f. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Dv\u011b nej\u010dast\u011bj\u0161\u00ed \u00farovn\u011b \u0161kolen\u00ed<\/h2>\n\n\n\n<p>Pominu-li procentu\u00e1ln\u011b malou \u010d\u00e1st skute\u010dn\u011b <strong>pokro\u010dil\u00fdch <\/strong>u\u017eivatel\u016f, majorita se d\u00e1 rozd\u011blit do dvou skupin: <strong>za\u010d\u00e1te\u010dn\u00edk <\/strong>nebo <strong>pokro\u010dilej\u0161\u00ed <\/strong>u\u017eivatel. Do prvn\u00ed, za\u010d\u00e1te\u010dnick\u00e9, skupiny spad\u00e1 v\u011bt\u0161ina pedagog\u016f na \u0161kol\u00e1ch a&nbsp;tak\u00e9 v\u011bt\u0161ina t\u011bch firemn\u00edch pracovn\u00edk\u016f, kte\u0159\u00ed excelovsk\u00e9 se\u0161ity pou\u017e\u00edvaj\u00ed, ale netvo\u0159\u00ed. Tv\u016frci jsou zpravidla na pokro\u010dilej\u0161\u00ed \u00farovni a&nbsp;pat\u0159\u00ed do skupiny druh\u00e9.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Za\u010d\u00e1te\u010dnick\u00e1 \u00farove\u0148<\/h3>\n\n\n\n<p>\u0160kolen\u00ed za\u010d\u00e1te\u010dnick\u00fdch \u00fa\u010dastn\u00edk\u016f vy\u017eaduje jejich zna\u010dn\u00e9 \u00fasil\u00ed u\u017e p\u0159i zvl\u00e1d\u00e1n\u00ed z\u00e1kladn\u00edch form\u00e1tovac\u00edch n\u00e1stroj\u016f a postup\u016f, jako nap\u0159. vkl\u00e1d\u00e1n\u00ed nebo odstra\u0148ov\u00e1n\u00ed \u0159\u00e1dk\u016f \u010di sloupc\u016f, volba form\u00e1tu bu\u0148ky, zalamov\u00e1n\u00ed obsahu bu\u0148ky do v\u00edce \u0159\u00e1dk\u016f atd. Tvorba vzorc\u016f s&nbsp;p\u011bti z\u00e1kladn\u00edmi funkcemi nebo \u010dty\u0159mi z\u00e1kladn\u00edm matematick\u00fdmi operacemi za\u010d\u00edn\u00e1 b\u00fdt pro mnoh\u00e9 stropem toho, co jsou v&nbsp;jednom dni schopni si osvojit. N\u011bkdy se jim poda\u0159\u00ed zvl\u00e1dnout je\u0161t\u011b pou\u017eit\u00ed absolutn\u00edch odkaz\u016f ve vzorc\u00edch a&nbsp;z\u00e1kladn\u00ed p\u0159edtiskov\u00e9 p\u0159\u00edpravy. <\/p>\n\n\n\n<p>Nem\u00e1 smyl sna\u017eit se zde probrat co nejv\u011bt\u0161\u00ed kvantum l\u00e1tky, \u00fa\u010dastn\u00edci by t\u00edm byli zahlceni. Je naopak t\u0159eba co nejv\u00edce probran\u00e9 kapitoly <strong>procvi\u010dit<\/strong>. T\u00e9m\u011b\u0159 v\u017edy maj\u00ed \u00fa\u010dastn\u00edci z\u00e1jem m\u00edt cvi\u010den\u00ed prov\u00e1d\u011bn\u00e1 na \u0161kolen\u00ed k&nbsp;dispozici i pro <strong>pozd\u011bj\u0161\u00ed opakov\u00e1n\u00ed<\/strong>. Um\u00eds\u0165uji je proto do webov\u00e9 \u00falo\u017eny. Odtud si \u00fa\u010dastn\u00edci jednotliv\u00e1 cvi\u010den\u00ed stahuj\u00ed u\u017e b\u011bhem \u0161kolen\u00ed a stejn\u00fdm zp\u016fsobem pak mohou i pozd\u011bji. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">M\u00edrn\u011b pokro\u010dil\u00e1 \u00farove\u0148<\/h3>\n\n\n\n<p>Pokud se jedn\u00e1 o pokro\u010dilej\u0161\u00ed u\u017eivatele spadaj\u00edc\u00ed do ji\u017e zm\u00edn\u011bn\u00e9 druh\u00e9 skupiny, je mo\u017en\u00e9 se zam\u011b\u0159it na kapitoly, o kter\u00e9 maj\u00ed sami z\u00e1jem. Podle m\u00fdch zku\u0161enost\u00ed se mezi nej\u010dast\u011bji po\u017eadovan\u00e9 a pro n\u011b nejp\u0159\u00ednosn\u011bj\u0161\u00ed, podle jejich ohlasu, \u0159adily tyto n\u00e1sleduj\u00edc\u00ed.<\/p>\n\n\n\n<ul><li>Tvorba vzorc\u016f z&nbsp;dat na <strong>v\u00edce listech<\/strong>.<\/li><li>Pou\u017eit\u00ed <strong>agrega\u010dn\u00edch <\/strong>funkc\u00ed <em>SUMIF<\/em>, <em>AVERAGEIF<\/em>, <em>COUNTIF<\/em>, <em>PO\u010cET2<\/em>.<\/li><li>Pou\u017eit\u00ed <strong>vyhled\u00e1vac\u00edch <\/strong>funkc\u00ed <em>SVYHLEDAT<\/em>, <em>VVYHLEDAT<\/em>, <em>INDEX<\/em>.<\/li><li>Pou\u017eit\u00ed <strong>styl\u016f<\/strong> tabulky (n\u00e1stroj <em>Form\u00e1tovat jako tabulku<\/em>) pro rychl\u00e9 statistick\u00e9 v\u00fdpo\u010dty.<\/li><li>N\u00e1stroje pro <strong>pr\u00e1ci s&nbsp;rozs\u00e1hlou tabulkou<\/strong>. <ul><li><em>Filtry<\/em><\/li><\/ul><ul><li>Kl\u00e1vesov\u00e9 zkratky <em>Ctrl+End<\/em>, <em>Ctrl+Home<\/em>, <em>Ctrl+Shift+\u0161ipka<\/em> <\/li><\/ul><ul><li><em>Souhrny<\/em> <\/li><\/ul><\/li><li>Principy tvorby <strong>kontingen\u010dn\u00edch tabulek <\/strong>a jejich praktick\u00e9 pou\u017eit\u00ed.<\/li><\/ul>\n\n\n\n<p>Jedn\u00e1 se o oblasti, kter\u00e9 nab\u00edz\u00edme ve \u0161kolen\u00edch <a href=\"https:\/\/centrum-vzdelavani.cz\/firemni-vzdelavani\/pocitacove-a-it-kurzy\/efektivni-digitalni-kancelar\/\">Efektivn\u00ed digit\u00e1ln\u00ed kancel\u00e1\u0159<\/a> a&nbsp;<a href=\"https:\/\/centrum-vzdelavani.cz\/firemni-vzdelavani\/pocitacove-a-it-kurzy\/kancelarsky-balik-ms-officelibreoffice\/#ms-excel-zpracovani-rozsahlych-tabulek\">MS Excel \u2013 Zpracov\u00e1n\u00ed rozs\u00e1hl\u00fdch tabulek<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-3 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img decoding=\"async\" src=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/POCET2-1.jpg\" alt=\"PO\u010cET, PO\u010cET2\" data-id=\"7240\" data-link=\"https:\/\/centrum-vzdelavani.cz\/?attachment_id=7240\" class=\"wp-image-7240\" \/><figcaption class=\"blocks-gallery-item__caption\">Cvi\u010den\u00ed s&nbsp;funkcemi PO\u010cET a PO\u010cET2<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><img decoding=\"async\" src=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/SVYHLEDAT-2.jpg\" alt=\"SVYHLELDAT\" data-id=\"7245\" data-link=\"https:\/\/centrum-vzdelavani.cz\/?attachment_id=7245\" class=\"wp-image-7245\" \/><figcaption class=\"blocks-gallery-item__caption\">Cvi\u010den\u00ed s&nbsp;funkc\u00ed SVYHLELDAT<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><img decoding=\"async\" src=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Kontingentni_tabulka.jpg\" alt=\"Kontingen\u010dn\u00ed tabulka\" data-id=\"7247\" data-link=\"https:\/\/centrum-vzdelavani.cz\/?attachment_id=7247\" class=\"wp-image-7247\" \/><figcaption class=\"blocks-gallery-item__caption\">Cvi\u010den\u00ed s&nbsp;kontingen\u010dn\u00ed tabulkou<\/figcaption><\/figure><\/li><\/ul><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Pokro\u010dil\u00e1 \u00farove\u0148<\/h3>\n\n\n\n<p>Na z\u00e1v\u011br se chci zm\u00ednit o opakuj\u00edc\u00edm se dotazu od pokro\u010dil\u00fdch u\u017eivatel\u016f, kte\u0159\u00ed \u010dasto zpracov\u00e1vaj\u00ed se\u0161ity pln\u00e9 dat. Tyto se\u0161ity m\u00edvaj\u00ed <strong>propojen\u00e9 <\/strong>mezi sebou a cht\u011bj\u00ed v\u011bd\u011bt, jak to prov\u00e9st, aby nemuseli data po \u00faprav\u00e1ch v\u017edy aktualizovat. Kdy\u017e jim sd\u011bl\u00edm, \u017ee v&nbsp;propojen\u00fdch se\u0161itech to s&nbsp;daty tak je, doch\u00e1z\u00ed u&nbsp;nich k&nbsp;ur\u010dit\u00e9mu zklam\u00e1n\u00ed. <\/p>\n\n\n\n<p>Vysv\u011btluji potom, \u017ee v\u011bt\u0161\u00ed komfort pro propojov\u00e1n\u00ed a kombinov\u00e1n\u00ed dat z&nbsp;r\u016fzn\u00fdch zdroj\u016f nab\u00edz\u00ed n\u00e1stroj <em>Nov\u00fd dotaz<\/em> (ve star\u0161\u00edch verz\u00edch ne\u017e <strong>MS Excel 2016<\/strong> bylo nutn\u00e9 dopln\u011bk pod n\u00e1zvem <em>Power Query <\/em>do aplikace instalovat), a \u017ee jejich p\u0159edstavu by nejv\u00edce naplnilo datab\u00e1zov\u00e9 zpracov\u00e1n\u00ed dat, nap\u0159\u00edklad v&nbsp;aplikaci <strong>MS&nbsp;Access<\/strong>. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a ref=\"magnificPopup\" href=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Novy_dotaz.jpg\"><img decoding=\"async\" src=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Novy_dotaz-300x173.jpg\" alt=\"Nov\u00fd dotaz (Power Query)\" class=\"wp-image-7251\" \/><\/a><figcaption>N\u00e1stroje pro tvorbu dotaz\u016f (propojov\u00e1n\u00ed a kombinov\u00e1n\u00ed dat z&nbsp;r\u016fzn\u00fdch zdroj\u016f)<\/figcaption><\/figure><\/div>\n\n\n\n<p>Pr\u00e1ci s&nbsp;dotazy by bylo mo\u017en\u00e9 zvl\u00e1dnout spole\u010dn\u011b je\u0161t\u011b s&nbsp;jin\u00fdmi pokro\u010dil\u00fdmi n\u00e1stroji podle po\u017eadavk\u016f b\u011bhem jednodenn\u00edho \u0161kolen\u00ed. Osvojen\u00ed pr\u00e1ce v&nbsp;<em>MS Access<\/em> je u\u017e \u010dasov\u011b n\u00e1ro\u010dn\u011bj\u0161\u00ed. Jednodenn\u00ed \u0161kolen\u00ed by v\u0161ak posta\u010dovalo na pochopen\u00ed pojm\u016f a princip\u016f pr\u00e1ce. \u00da\u010dastn\u00edci se t\u00edm zorientuj\u00ed a mohou se pak rozhodnout, zda se budou cht\u00edt v&nbsp;<em>MS Access<\/em> rozv\u00edjet d\u00e1l.<\/p>\n\n\n\n<p>M\u00e1-li va\u0161e firma \u010di \u0161kola z\u00e1jem o uzav\u0159en\u00e9 \u0161kolen\u00ed v&nbsp;<strong>MS Excel<\/strong> v&nbsp;roce 2019, tak nev\u00e1hejte a napi\u0161te na email <a href=\"mailto:info@poc-sluzba.cz\">info@poc-sluzba.cz<\/a>. Brzy se V\u00e1m ozve z&nbsp;n\u011bkter\u00fdch koleg\u016f, kter\u00fd s&nbsp;v\u00e1mi provede \u00favodn\u00ed anal\u00fdzu, co p\u0159esn\u011b pot\u0159ebujete a na co se zam\u011b\u0159it na \u0161kolen\u00ed \u010di semin\u00e1\u0159i. Pokud m\u00e1te z\u00e1jem jako jednotlivci se z\u00fa\u010dastnit \u0161kolen\u00ed na <strong>MS Excel<\/strong>, tak sledujte <a href=\"https:\/\/centrum-vzdelavani.cz\/aktualni-terminy-skoleni-zkousek\/\">na\u0161e term\u00edny<\/a>, kter\u00e9 se \u010dasto aktualizuj\u00ed dle popt\u00e1vky.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Po\u017eadavky na obsahy \u0161kolen\u00ed MS Excel, kter\u00e9 jsme realizovali v&nbsp;roce 2018 ve \u0161kolsk\u00fdch organizac\u00edch a ve firm\u00e1ch, byly velmi r\u016fznorod\u00e9 a odv\u00edjely se od schopnost\u00ed \u00fa\u010dastn\u00edk\u016f. Dv\u011b nej\u010dast\u011bj\u0161\u00ed \u00farovn\u011b \u0161kolen\u00ed Pominu-li procentu\u00e1ln\u011b malou \u010d\u00e1st skute\u010dn\u011b pokro\u010dil\u00fdch u\u017eivatel\u016f, majorita se d\u00e1 rozd\u011blit do dvou skupin: za\u010d\u00e1te\u010dn\u00edk nebo pokro\u010dilej\u0161\u00ed u\u017eivatel. Do prvn\u00ed, za\u010d\u00e1te\u010dnick\u00e9, skupiny spad\u00e1 v\u011bt\u0161ina pedagog\u016f&#8230;<\/p>\n","protected":false},"author":6,"featured_media":1030,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10,4],"tags":[138,139,21,140,141,142,143],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Zku\u0161enosti se \u0161kolen\u00edm MS Excel v organizac\u00edch a firm\u00e1ch &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ<\/title>\n<meta name=\"description\" content=\"\u010cl\u00e1nek popisuje zku\u0161enosti se \u0161kolen\u00edmi MS Excel v roce 2018 ve \u0161kol\u00e1ch a firm\u00e1ch. Nej\u010dast\u011bj\u0161\u00ed po\u017eadavky \u00fa\u010dastn\u00edk\u016f \u0161kolen\u00ed.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v organizac\u00edch a firm\u00e1ch &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\" \/>\n<meta property=\"og:description\" content=\"\u010cl\u00e1nek popisuje zku\u0161enosti se \u0161kolen\u00edmi MS Excel v roce 2018 ve \u0161kol\u00e1ch a firm\u00e1ch. Nej\u010dast\u011bj\u0161\u00ed po\u017eadavky \u00fa\u010dastn\u00edk\u016f \u0161kolen\u00ed.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/\" \/>\n<meta property=\"og:site_name\" content=\"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-16T23:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-24T20:58:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Zden\u011bk Kom\u00ednek\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zden\u011bk Kom\u00ednek\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/\"},\"author\":{\"name\":\"Zden\u011bk Kom\u00ednek\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/24215dcb593ae1be7a8dd745b82ab372\"},\"headline\":\"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v&nbsp;organizac\u00edch a firm\u00e1ch\",\"datePublished\":\"2019-01-16T23:00:00+00:00\",\"dateModified\":\"2021-08-24T20:58:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/\"},\"wordCount\":867,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#organization\"},\"image\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg\",\"keywords\":[\"Kontingen\u010dn\u00ed tabulka\",\"MS Access\",\"MS Excel\",\"MS Office\",\"PO\u010cET2\",\"Power Query\",\"SVYHLEDAT\"],\"articleSection\":[\"DVPP\",\"Firemn\u00ed \u0161kolen\u00ed\"],\"inLanguage\":\"cs\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/\",\"name\":\"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v organizac\u00edch a firm\u00e1ch &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\",\"isPartOf\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg\",\"datePublished\":\"2019-01-16T23:00:00+00:00\",\"dateModified\":\"2021-08-24T20:58:43+00:00\",\"description\":\"\u010cl\u00e1nek popisuje zku\u0161enosti se \u0161kolen\u00edmi MS Excel v roce 2018 ve \u0161kol\u00e1ch a firm\u00e1ch. Nej\u010dast\u011bj\u0161\u00ed po\u017eadavky \u00fa\u010dastn\u00edk\u016f \u0161kolen\u00ed.\",\"breadcrumb\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#primaryimage\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg\",\"contentUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg\",\"width\":1200,\"height\":630,\"caption\":\"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v organizac\u00edch a firm\u00e1ch\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Dom\u016f\",\"item\":\"https:\/\/centrum-vzdelavani.cz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v&nbsp;organizac\u00edch a firm\u00e1ch\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#website\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/\",\"name\":\"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\",\"description\":\"Va\u0161e m\u00edsto pro kurzy, \u0161kolen\u00ed a zkou\u0161ky\",\"publisher\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/centrum-vzdelavani.cz\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"cs\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#organization\",\"name\":\"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o.\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg\",\"contentUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg\",\"width\":\"1024\",\"height\":\"1024\",\"caption\":\"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o.\"},\"image\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/24215dcb593ae1be7a8dd745b82ab372\",\"name\":\"Zden\u011bk Kom\u00ednek\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/28ee5a8fc57665deeb1aaf3efef28433?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/28ee5a8fc57665deeb1aaf3efef28433?s=96&d=mm&r=g\",\"caption\":\"Zden\u011bk Kom\u00ednek\"},\"description\":\"Lektor IT, ECDL Expert a tester a Microsoft Office Specialist\",\"sameAs\":[\"https:\/\/centrum-vzdelavani.cz\"],\"url\":\"https:\/\/centrum-vzdelavani.cz\/author\/zkominek\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v organizac\u00edch a firm\u00e1ch &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","description":"\u010cl\u00e1nek popisuje zku\u0161enosti se \u0161kolen\u00edmi MS Excel v roce 2018 ve \u0161kol\u00e1ch a firm\u00e1ch. Nej\u010dast\u011bj\u0161\u00ed po\u017eadavky \u00fa\u010dastn\u00edk\u016f \u0161kolen\u00ed.","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:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/","og_locale":"cs_CZ","og_type":"article","og_title":"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v organizac\u00edch a firm\u00e1ch &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","og_description":"\u010cl\u00e1nek popisuje zku\u0161enosti se \u0161kolen\u00edmi MS Excel v roce 2018 ve \u0161kol\u00e1ch a firm\u00e1ch. Nej\u010dast\u011bj\u0161\u00ed po\u017eadavky \u00fa\u010dastn\u00edk\u016f \u0161kolen\u00ed.","og_url":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/","og_site_name":"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","article_published_time":"2019-01-16T23:00:00+00:00","article_modified_time":"2021-08-24T20:58:43+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg","type":"image\/jpeg"}],"author":"Zden\u011bk Kom\u00ednek","twitter_card":"summary_large_image","twitter_misc":{"Napsal(a)":"Zden\u011bk Kom\u00ednek","Odhadovan\u00e1 doba \u010dten\u00ed":"4 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#article","isPartOf":{"@id":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/"},"author":{"name":"Zden\u011bk Kom\u00ednek","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/24215dcb593ae1be7a8dd745b82ab372"},"headline":"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v&nbsp;organizac\u00edch a firm\u00e1ch","datePublished":"2019-01-16T23:00:00+00:00","dateModified":"2021-08-24T20:58:43+00:00","mainEntityOfPage":{"@id":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/"},"wordCount":867,"commentCount":0,"publisher":{"@id":"https:\/\/centrum-vzdelavani.cz\/#organization"},"image":{"@id":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#primaryimage"},"thumbnailUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg","keywords":["Kontingen\u010dn\u00ed tabulka","MS Access","MS Excel","MS Office","PO\u010cET2","Power Query","SVYHLEDAT"],"articleSection":["DVPP","Firemn\u00ed \u0161kolen\u00ed"],"inLanguage":"cs"},{"@type":"WebPage","@id":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/","url":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/","name":"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v organizac\u00edch a firm\u00e1ch &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","isPartOf":{"@id":"https:\/\/centrum-vzdelavani.cz\/#website"},"primaryImageOfPage":{"@id":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#primaryimage"},"image":{"@id":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#primaryimage"},"thumbnailUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg","datePublished":"2019-01-16T23:00:00+00:00","dateModified":"2021-08-24T20:58:43+00:00","description":"\u010cl\u00e1nek popisuje zku\u0161enosti se \u0161kolen\u00edmi MS Excel v roce 2018 ve \u0161kol\u00e1ch a firm\u00e1ch. Nej\u010dast\u011bj\u0161\u00ed po\u017eadavky \u00fa\u010dastn\u00edk\u016f \u0161kolen\u00ed.","breadcrumb":{"@id":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#primaryimage","url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg","contentUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg","width":1200,"height":630,"caption":"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v organizac\u00edch a firm\u00e1ch"},{"@type":"BreadcrumbList","@id":"https:\/\/centrum-vzdelavani.cz\/zkusenosti-se-skolenim-ms-excel-v-organizacich-a-firmach\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Dom\u016f","item":"https:\/\/centrum-vzdelavani.cz\/"},{"@type":"ListItem","position":2,"name":"Zku\u0161enosti se \u0161kolen\u00edm MS Excel v&nbsp;organizac\u00edch a firm\u00e1ch"}]},{"@type":"WebSite","@id":"https:\/\/centrum-vzdelavani.cz\/#website","url":"https:\/\/centrum-vzdelavani.cz\/","name":"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","description":"Va\u0161e m\u00edsto pro kurzy, \u0161kolen\u00ed a zkou\u0161ky","publisher":{"@id":"https:\/\/centrum-vzdelavani.cz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/centrum-vzdelavani.cz\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"cs"},{"@type":"Organization","@id":"https:\/\/centrum-vzdelavani.cz\/#organization","name":"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o.","url":"https:\/\/centrum-vzdelavani.cz\/","logo":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/","url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg","contentUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg","width":"1024","height":"1024","caption":"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o."},"image":{"@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/24215dcb593ae1be7a8dd745b82ab372","name":"Zden\u011bk Kom\u00ednek","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/28ee5a8fc57665deeb1aaf3efef28433?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/28ee5a8fc57665deeb1aaf3efef28433?s=96&d=mm&r=g","caption":"Zden\u011bk Kom\u00ednek"},"description":"Lektor IT, ECDL Expert a tester a Microsoft Office Specialist","sameAs":["https:\/\/centrum-vzdelavani.cz"],"url":"https:\/\/centrum-vzdelavani.cz\/author\/zkominek\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Zkus\u030cenosti-se-s\u030ckoleni\u0301m-MS-Excel-v-organizaci\u0301ch-a-firma\u0301ch-1.jpg","_links":{"self":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/posts\/335"}],"collection":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/comments?post=335"}],"version-history":[{"count":0,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/media\/1030"}],"wp:attachment":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}