{"id":112,"date":"2010-01-15T23:31:58","date_gmt":"2010-01-15T22:31:58","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=112"},"modified":"2023-06-09T16:50:48","modified_gmt":"2023-06-09T14:50:48","slug":"skoleni-excel-pro-stredne-pokrocile","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/skoleni-excel-pro-stredne-pokrocile\/","title":{"rendered":"Excel intermediate training"},"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>

This is the most popular training of Excel<\/strong>. Students will learn how to practically use Excel for their work. A list of topics is provided below. 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 a template same\u00a0types of documents<\/li>
  • creating, copying, moving, coloring, renaming sheet<\/li>
  • lock the cell against rewriting formulas or formatting change<\/li>
  • password\u00a0protect<\/strong>\u00a0files from unauthorized access<\/li>
  • use formats numbers as currency, percentage, dates<\/li>
  • set custom number format in the cell<\/li>
  • highlight a cell (whole\u00a0row) by its values using\u00a0conditional formatting<\/strong><\/li>
  • transfer format properties from one cell to another<\/li>
  • automatically generate series of number of days, months, numbers, alphabets etc.<\/li>
  • create and use simple and more dificult\u00a0formulas<\/strong><\/li>
  • to ensure that the formula is automatically recalculated<\/li>
  • retrieve values from other sheets or files<\/li>
  • use in formulas instead of cell addresses their own names (names of fields)<\/li>
  • make it easier to get results using predefined\u00a0functions<\/strong><\/li>
  • use function if,\u00a0sum, average, today and many others<\/li>
  • in the formula set dollars (absolute address<\/strong>) so that the cell address in the formula is\u00a0not changed when copying<\/li>
  • copy the formula to where it is needed in one second<\/li>
  • indicate the range of cells by using keyboard shortcuts<\/li>
  • display data in a chart, such as bar, pie, or line, exactly as you want<\/li>
  • work effectively with large spreadsheets<\/li>
  • filter and sort<\/strong>\u00a0the table, including extended (advanced) filter<\/li>
  • validate\u00a0new values in the table according to the criteria and subsequent warnings on error<\/li>
  • obtain summary data from a table easily by using the sum (subtotal)<\/li>
  • group and hide rows or columns using a group or an auto\u00a0outline<\/li>
  • display summary information in a simple\u00a0PivotTable<\/strong>\u00a0and correctly interpret it<\/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 This is the most popular training of Excel. Students will learn how to practically use Excel for their work. A list of topics is provided below. 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 […]<\/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\/112"}],"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=112"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/112\/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=112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}