{"id":116,"date":"2010-01-15T23:38:45","date_gmt":"2010-01-15T22:38:45","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=116"},"modified":"2023-06-09T17:07:14","modified_gmt":"2023-06-09T15:07:14","slug":"skoleni-excel-pro-pokrocile","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/skoleni-excel-pro-pokrocile\/","title":{"rendered":"Training Excel advanced"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t
\"\"<\/figure>
Training description<\/div>

Are you interested in advanced tools<\/strong> of Excel? We offer the possibility of learning advanced methods and tools in Excel with the following suggested outline. Topics are presented by the trainer, then he answers any questions from the audience about the topic and then students do exercises on their computer to use their new knowledge. Throughout the trainer assists them and advises individually.<\/p><\/div><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\"Online\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t
<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

<\/p>

  • use\u00a0conditional functions<\/strong>\u00a0(IF, COUNTIF, SUMIF, COUNTIFS, SUMIFS etc…)<\/li>
  • use database functions to calculate summaries from\u00a0large tables<\/li>
  • create an array formula and use it for special functions<\/li>
  • link the two tables by using the\u00a0lookup\u00a0functions<\/strong>\u00a0such as VLOOKUP, HLOOKUP, INDEX, MATCH\u00a0etc.<\/li>
  • prepare a form for users through\u00a0form controls<\/strong>\u00a0like a combo box, option button, check box, scroll bar etc.<\/li>
  • fully use all options of the\u00a0Pivot table<\/strong><\/li>
  • merge data from multiple tables into a single one<\/li>
  • create groups and automatic outline\u00a0for easy hide and show parts of the table<\/li>
  • work with the\u00a0names of cells<\/strong>, named ranges\u00a0and constants instead of cell addresses<\/li>
  • create and record simple\u00a0macros<\/strong>\u00a0for repetitive\u00a0operations<\/li>
  • display data in a chart, such as bar, pie, or line, exactly as you want<\/li><\/ul>

    <\/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\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","protected":false},"excerpt":{"rendered":"

    Training description Are you interested in advanced tools of Excel? We offer the possibility of learning advanced methods and tools in Excel with the following suggested outline. Topics are presented by the trainer, then he answers any questions from the audience about the topic and then students do exercises on their computer to use their […]<\/p>\n","protected":false},"author":1,"featured_media":413,"comment_status":"open","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,9],"tags":[10,49,70,71],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/116"}],"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=116"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/116\/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=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}