{"id":1681,"date":"2012-03-28T15:53:00","date_gmt":"2012-03-28T13:53:00","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=1681"},"modified":"2023-06-09T16:57:57","modified_gmt":"2023-06-09T14:57:57","slug":"kurz-excel-pro-specialisty","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/kurz-excel-pro-specialisty\/","title":{"rendered":"Training Excel for experts"},"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 only interested in a specific part of Excel? We offer the opportunity for consultation of specialized methods and tools in Excel in any combination. A list of possible topics is given below. Choose topics that you want to learn during the training. 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>

Modul EXCEL7<\/h2>
  • import\u00a0data from other files or database sources<\/li>
  • use the special tool\u00a0to import data – MS Query<\/li>
  • retrieve up to date\u00a0information from a table located on the Internet (eg. exchange rates)<\/li>
  • compare variants of solving the problem through scenarios<\/li>
  • solve the economic and optimization problems using Solver and find solutions – Goal Seek<\/li>
  • forecast the future using statistical functions FORECAST and TREND<\/li>
  • calculate financial\u00a0variables using the functions working with payments\u00a0and interest<\/li>
  • obtain statistical data on measured values using\u00a0Descriptive statistics add-in<\/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 only interested in a specific part of Excel? We offer the opportunity for consultation of specialized methods and tools in Excel in any combination. A list of possible topics is given below. Choose topics that you want to learn during the training. Topics are presented by the trainer, then he answers […]<\/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,71],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/1681"}],"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=1681"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/1681\/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=1681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=1681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=1681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}