{"id":2308,"date":"2013-10-18T15:59:34","date_gmt":"2013-10-18T13:59:34","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=2308"},"modified":"2020-09-04T09:46:35","modified_gmt":"2020-09-04T07:46:35","slug":"videonavod-jednoduche-filtrovani","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/videonavod-jednoduche-filtrovani\/","title":{"rendered":"17. Videotutorial &#8211; simple filtering"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">In large tables it is not easy to navigate and quickly find what you need. This tool will serve <strong>AutoFilter<\/strong>, which is presented inside the video. Learn how to turn it on, how to set one or more conditions, and how to use a\u00a0new feature\u00a0&#8211; filtering by color.\u00a0If this guide has helped you, become a fan on <a href=\"http:\/\/www.facebook.com\/itlektorcz\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n<p style=\"text-align: justify;\"><em>Please note that this tutorial is presented in czech language, with english subtitles.<\/em><\/p>\n<div class=\"potter-video\"><iframe title=\"#17 - Jednoduch\u00e9 filtrov\u00e1n\u00ed v Excelu\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/bofpQXmK_ow?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<p>Source file can be downloaded <a title=\"P\u0159\u00ed\u010dky\" href=\"https:\/\/www.itlektor.cz\/soubory\/17-videonavod-filtr.xlsx\">here<\/a>.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>In large tables it is not easy to navigate and quickly find what you need. This tool will serve AutoFilter, which is presented inside the video. Learn how to turn it on, how to set one or more conditions, and how to use a\u00a0new feature\u00a0&#8211; filtering by color.\u00a0If this guide has helped you, become a [&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":2309,"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,56],"tags":[10,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2308"}],"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=2308"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2308\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/2309"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=2308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=2308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=2308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}