{"id":4270,"date":"2015-10-10T19:45:16","date_gmt":"2015-10-10T17:45:16","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=4270"},"modified":"2020-09-04T09:39:14","modified_gmt":"2020-09-04T07:39:14","slug":"41-videonavod-jak-na-kontingencky-zakladni-model","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/41-videonavod-jak-na-kontingencky-zakladni-model\/","title":{"rendered":"41. Videotutorial &#8211; Deal with Pivot Tables 1 &#8211; Basic model"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">The video series\u00a0<a href=\"https:\/\/www.itlektor.cz\/en\/pivot-tables\/\">Deal with Pivot Tables<\/a>\u00a0starts with a tutorial\u00a0<strong>Basic model<\/strong>. You will learn how to create a simple Pivot table in Excel. If 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 width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/tWLo-3kDpzE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<p>Source file can be downloaded\u00a0<a href=\"https:\/\/www.itlektor.cz\/soubory\/kontingencky\/cesty.xlsx\">here<\/a>.<\/p>\n<p>Creation of a basic Pivot table is not a big deal. Before we go into it together, see what kind of data we work with. Source file to download can be found below the video.<\/p>\n<p>We see a table of business trips. This is a column table with all column headings. Such table is suitable for creating a summary table, which is called Pivot and this videotutorial series is all about this tool.<\/p>\n<p>Click anywhere to the table, and select Insert tab, click PivotTable. In the activated dialog, check address that corresponds to the selected area of our table, or reselect it. We usually put Pivot on a new sheet, therefore nothing else is changed in this window and confirm by OK button.<\/p>\n<p>On a new sheet, there is a left space displayed for our Pivot table and on the right we can see so called the Field list, and also Pivot table sections.<\/p>\n<p>To see the summary data, eg. how much does total cost for each country, move country field (Zem\u011b) to ROWS and total (\u010c\u00e1stka) to VALUES. Generally, the data that you want to group &#8211; individual values without duplicates, are placed in ROWS or COLUMNS, depending on the direction in which the values will be displayed. Calculations are always in VALUES section.\u00a0 Filters (report filter) section we learn in more detail in a forthcoming parts.<\/p>\n<p>To move the country field (Zem\u011b) from ROWS to COLUMNS just drag and drop it. To remove pull it to the top Field list, to be displayed again drag back.<\/p>\n<p>So, this is Pivot table that for the country summarizes the total cost of trips. Next time we will look at what basic summary functions in the VALUES Pivot table offers. Do not forget to watch!<\/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>The video series\u00a0Deal with Pivot Tables\u00a0starts with a tutorial\u00a0Basic model. You will learn how to create a simple Pivot table in Excel. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it\u00a0can be useful for them too. Please note that this tutorial is presented in czech [&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":4271,"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,70,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/4270"}],"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=4270"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/4270\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/4271"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=4270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=4270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=4270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}