{"id":2182,"date":"2013-09-26T22:42:59","date_gmt":"2013-09-26T20:42:59","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=2182"},"modified":"2024-05-02T21:48:26","modified_gmt":"2024-05-02T19:48:26","slug":"skoleni-excel","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/skoleni-excel\/","title":{"rendered":"Excel training"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2182\" class=\"elementor elementor-2182\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3b22c001 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3b22c001\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-71099510\" data-id=\"71099510\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e47d940 elementor-widget elementor-widget-text-editor\" data-id=\"e47d940\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><img decoding=\"async\" class=\"alignleft size-full wp-image-413\" style=\"border: 0px none currentColor;\" title=\"ex\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2010\/01\/ex.jpg\" alt=\"\" width=\"85\" height=\"94\">Excel is an effective tool for managing data in tables. The easiest way to learn to work in it, is to attend Excel training. Learn how to create, edit, combine tables, use the tools of filtering functions over to the summaries and pivot tables. You may be surprised what you can do in Excel and how it can help you save time and money. Because this program is so extensive, the training requires gradual absorption of knowledge at various levels, the subsequent us in practice and the search for new solutions and challenges.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6722331 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"6722331\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a href=\"https:\/\/www.itlektor.cz\/kontakt\/\" rel=\"nofollow\" class=\"elementor-button-link elementor-button elementor-size-md\" role=\"button\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t<span class=\"elementor-button-icon elementor-align-icon-left\">\n\t\t\t\t\t\t\t\t\t<i class=\"fa fa-info-circle\" aria-hidden=\"true\"><\/i>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Make and order<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ffd7f2b elementor-tabs-view-horizontal elementor-widget elementor-widget-tabs\" data-id=\"ffd7f2b\" data-element_type=\"widget\" data-widget_type=\"tabs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-tabs\">\n\t\t\t<div class=\"elementor-tabs-wrapper\" role=\"tablist\" >\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-2681\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-2681\" aria-expanded=\"false\">For beginners<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-2682\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-2682\" aria-expanded=\"false\">For intermediate<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-2683\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-2683\" aria-expanded=\"false\">For advanced<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-2684\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"4\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-2684\" aria-expanded=\"false\">For experts<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"elementor-tabs-content-wrapper\" role=\"tablist\" aria-orientation=\"vertical\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-2681\" aria-expanded=\"false\">For beginners<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-2681\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2681\" tabindex=\"0\" hidden=\"false\"><p>Training contains eg.:<\/p><ul><li>file\u00a0management<\/li><li>manipulation with\u00a0cells<\/li><li>formatting tables<\/li><li>basic formulas and functions<\/li><li>simple charts<\/li><li>settings for printing<\/li><li>more information &gt;\u00a0<a title=\"Kurz Excel pro za\u010d\u00e1te\u010dn\u00edky\" href=\"https:\/\/www.itlektor.cz\/microsoft-excel\/skoleni-excel-pro-zacatecniky\/\">Excel for beginners<\/a><\/li><\/ul><p><\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-2682\" aria-expanded=\"false\">For intermediate<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-2682\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2682\" tabindex=\"0\" hidden=\"hidden\"><p>Training contains eg.:<\/p><ul><li>custom\u00a0and conditional formatting<\/li><li>formulas and functions in practice<\/li><li>working with database tables<\/li><li>sorting and filtering<\/li><li>summaries and pivot tables<\/li><li>creation of different types of charts<\/li><li>more information &gt;\u00a0<a title=\"Kurz Excel pro st\u0159edn\u011b pokro\u010dil\u00e9\" href=\"https:\/\/www.itlektor.cz\/microsoft-excel\/skoleni-excel-pro-stredne-pokrocile\/\">Excel for intermediate<\/a><\/li><\/ul><p><\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-2683\" aria-expanded=\"false\">For advanced<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-2683\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2683\" tabindex=\"0\" hidden=\"hidden\"><p>Training contains eg.:<\/p><ul><li>conditional functions<\/li><li>array formulas<\/li><li>lookup function<\/li><li>creation of forms<\/li><li>PivotTable from A to Z<\/li><li>user-recorded macros<\/li><li>more information&gt;\u00a0<a title=\"Kurz Excel pro pokro\u010dil\u00e9\" href=\"https:\/\/www.itlektor.cz\/microsoft-excel\/skoleni-excel-pro-pokrocile\/\">Excel for advanced<\/a><\/li><\/ul><p><\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"4\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-2684\" aria-expanded=\"false\">For experts<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-2684\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"4\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2684\" tabindex=\"0\" hidden=\"hidden\"><p>Training contains eg.:<\/p><ul><li>importing external data<\/li><li>forecast\u00a0functions<\/li><li>Solver add-in<\/li><li>Goal Seek<\/li><li>comparing scenarios<\/li><li>financial functions<\/li><li>more information &gt;\u00a0<a title=\"Kurz Excel pro specialisty\" href=\"https:\/\/www.itlektor.cz\/microsoft-excel\/kurz-excel-pro-specialisty\/\">Excel for experts<\/a><\/li><\/ul><p><\/p><\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2be6048 elementor-view-stacked elementor-shape-circle elementor-mobile-position-top elementor-vertical-align-top elementor-widget elementor-widget-icon-box\" data-id=\"2be6048\" data-element_type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\t\t\t\t\t\t<div class=\"elementor-icon-box-icon\">\n\t\t\t\t<a class=\"elementor-icon elementor-animation-\" href=\"\/prospekt.pdf\">\n\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-download\"><\/i>\t\t\t\t<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t<a href=\"\/prospekt.pdf\" >\n\t\t\t\t\t\tSt\u00e1hn\u011bte si katalog\t\t\t\t\t<\/a>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tKompletn\u00ed katalog s nab\u00eddkou v\u0161ech kurz\u016f si st\u00e1hn\u011bte <a href=\"\/prospekt.pdf\"><u>zde<\/u><\/a>.\t\t\t\t\t<\/p>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-657f7d1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"657f7d1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-9fab582\" data-id=\"9fab582\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f76de5d elementor-align-left elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"f76de5d\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-heart\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">v\u00fdhodn\u00e1 cena<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-graduation-cap\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">certifikovan\u00fd lektor<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-smile\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">pohodov\u00e1 atmosf\u00e9ra<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">elektronick\u00e9 materi\u00e1ly v cen\u011b<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-dot-circle\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">m\u00edsto kon\u00e1n\u00ed u klienta<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-831a2cf\" data-id=\"831a2cf\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2b77083 elementor-widget elementor-widget-image\" data-id=\"2b77083\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"600\" height=\"365\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/09\/balicek_kancelar_fb.jpg\" class=\"attachment-large size-large wp-image-5592\" alt=\"\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/09\/balicek_kancelar_fb.jpg 600w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/09\/balicek_kancelar_fb-300x183.jpg 300w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/09\/balicek_kancelar_fb-24x15.jpg 24w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/09\/balicek_kancelar_fb-36x22.jpg 36w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/09\/balicek_kancelar_fb-48x29.jpg 48w\" sizes=\"(max-width: 600px) 100vw, 600px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Excel is an effective tool for managing data in tables. The easiest way to learn to work in it, is to attend Excel training. Learn how to create, edit, combine tables, use the tools of filtering functions over to the summaries and pivot tables. You may be surprised what you can do in Excel and [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":413,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3],"tags":[10,50,71],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2182"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=2182"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2182\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/413"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=2182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=2182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=2182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}