{"id":700682,"date":"2025-12-18T17:58:21","date_gmt":"2025-12-18T15:58:21","guid":{"rendered":"https:\/\/eba.com.ua\/?post_type=tribe_events&#038;p=700682"},"modified":"2026-03-10T14:29:26","modified_gmt":"2026-03-10T12:29:26","slug":"online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58","status":"publish","type":"tribe_events","link":"https:\/\/eba.com.ua\/en\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/","title":{"rendered":"[:ua]Online-\u043b\u0435\u043a\u0446\u0456\u044f: \u0414\u0430\u0448\u0431\u043e\u0440\u0434\u0438 \u0432 Excel: \u0432\u0456\u0434 \u0434\u0430\u043d\u0438\u0445 \u0434\u043e \u0440\u0456\u0448\u0435\u043d\u044c[:en]Online-Lecture: Dashboards in Excel: From Data to Decisions[:]"},"content":{"rendered":"<p><\/p>\n<p data-start=\"144\" data-end=\"452\">In modern work with data, it is important not only to calculate metrics, but also to quickly see the overall picture, identify deviations, and make decisions based on visual information. This is exactly why dashboards are used \u2014 a tool that transforms chaotic tables into a clear system for managing metrics.<\/p>\n<p data-start=\"454\" data-end=\"626\">This online-lecture is dedicated to a practical approach to creating interactive dashboards in Excel: from data preparation to building visualizations and control elements.<\/p>\n<p data-start=\"628\" data-end=\"777\">EBA Management Development Centre, together with <strong>Oleksii Voshchak<\/strong>, invite you to the<strong data-start=\"628\" data-end=\"777\"> Online-Lecture: Dashboards in Excel: From Data to Decisions.<\/strong><\/p>\n<p data-start=\"779\" data-end=\"1016\"><strong data-start=\"779\" data-end=\"799\">Target audience:<\/strong> financial analysts, managers, marketers, sales specialists, HR specialists, accountants, entrepreneurs, and everyone who works with data in Excel and wants to learn how to quickly create clear and manageable reports.<\/p>\n<p data-start=\"1018\" data-end=\"1044\"><strong data-start=\"1018\" data-end=\"1044\">Topics for discussion:<\/strong><\/p>\n<p data-start=\"1046\" data-end=\"1069\"><strong data-start=\"1046\" data-end=\"1069\">1. Data preparation.<\/strong><\/p>\n<ul data-start=\"1070\" data-end=\"1197\">\n<li data-start=\"1070\" data-end=\"1098\">\n<p data-start=\"1072\" data-end=\"1098\">Creating a \u201csmart\u201d table.<\/p>\n<\/li>\n<li data-start=\"1099\" data-end=\"1150\">\n<p data-start=\"1101\" data-end=\"1150\">Converting a data range into a structured table.<\/p>\n<\/li>\n<li data-start=\"1151\" data-end=\"1197\">\n<p data-start=\"1153\" data-end=\"1197\">Formatting and preparing data for analysis.<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"1199\" data-end=\"1246\"><strong data-start=\"1199\" data-end=\"1246\">2. Pivot tables as the basis of a dashboard.<\/strong><\/p>\n<ul data-start=\"1247\" data-end=\"1360\">\n<li data-start=\"1247\" data-end=\"1282\">\n<p data-start=\"1249\" data-end=\"1282\">Creating a pivot table template.<\/p>\n<\/li>\n<li data-start=\"1283\" data-end=\"1315\">\n<p data-start=\"1285\" data-end=\"1315\">Filling and configuring data.<\/p>\n<\/li>\n<li data-start=\"1316\" data-end=\"1360\">\n<p data-start=\"1318\" data-end=\"1360\">Preparing pivot tables for visualization.<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"1362\" data-end=\"1387\"><strong data-start=\"1362\" data-end=\"1387\">3. Dashboard creation.<\/strong><\/p>\n<ul data-start=\"1388\" data-end=\"1535\">\n<li data-start=\"1388\" data-end=\"1423\">\n<p data-start=\"1390\" data-end=\"1423\">Creating and configuring charts.<\/p>\n<\/li>\n<li data-start=\"1424\" data-end=\"1461\">\n<p data-start=\"1426\" data-end=\"1461\">Visual structure of the dashboard.<\/p>\n<\/li>\n<li data-start=\"1462\" data-end=\"1501\">\n<p data-start=\"1464\" data-end=\"1501\">Creating control elements (slicers).<\/p>\n<\/li>\n<li data-start=\"1502\" data-end=\"1535\">\n<p data-start=\"1504\" data-end=\"1535\">Interactivity and ease of use.<\/p>\n<\/li>\n<\/ul>\n<p><strong><span style=\"color: #ff0000\">Registration is obligatory. To become a participant, please, click the \u201cRegister\u201d button. Only the users of the EBA site can register at the event. Should you have any questions, please, write at development@eba.com.ua or call (044) 496-06-01. <\/span><\/strong><\/p>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>In modern work with data, it is important not only to calculate metrics, but also to quickly see the overall picture, identify deviations, and make decisions based on visual information. This is exactly why dashboards are used \u2014 a tool that transforms chaotic tables into a clear system for managing metrics. This online-lecture is dedicated [&hellip;]<\/p>\n","protected":false},"author":37119,"featured_media":700694,"comment_status":"open","ping_status":"closed","template":"","meta":{"inline_featured_image":false},"tags":[],"tribe_events_cat":[33,32],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Online-Lecture: Dashboards in Excel: From Data to Decisions - European Business Association<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online-Lecture: Dashboards in Excel: From Data to Decisions - European Business Association\" \/>\n<meta property=\"og:description\" content=\"In modern work with data, it is important not only to calculate metrics, but also to quickly see the overall picture, identify deviations, and make decisions based on visual information. This is exactly why dashboards are used \u2014 a tool that transforms chaotic tables into a clear system for managing metrics. This online-lecture is dedicated [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/\" \/>\n<meta property=\"og:site_name\" content=\"European Business Association\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-10T12:29:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eba.com.ua\/wp-content\/uploads\/2025\/12\/16x9-11.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/\",\"url\":\"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/\",\"name\":\"[:ua]Online-\u043b\u0435\u043a\u0446\u0456\u044f: \u0414\u0430\u0448\u0431\u043e\u0440\u0434\u0438 \u0432 Excel: \u0432\u0456\u0434 \u0434\u0430\u043d\u0438\u0445 \u0434\u043e \u0440\u0456\u0448\u0435\u043d\u044c[:en]Online-Lecture: Dashboards in Excel: From Data to Decisions[:] - European Business Association\",\"isPartOf\":{\"@id\":\"https:\/\/eba.com.ua\/#website\"},\"datePublished\":\"2025-12-18T15:58:21+00:00\",\"dateModified\":\"2026-03-10T12:29:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eba.com.ua\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u041f\u043e\u0434\u0456\u0457\",\"item\":\"https:\/\/eba.com.ua\/events\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Online-\u043b\u0435\u043a\u0446\u0456\u044f: \u0414\u0430\u0448\u0431\u043e\u0440\u0434\u0438 \u0432 Excel: \u0432\u0456\u0434 \u0434\u0430\u043d\u0438\u0445 \u0434\u043e \u0440\u0456\u0448\u0435\u043d\u044c\",\"item\":{\"@type\":\"WebPage\",\"name\":\"[:ua]Online-\u043b\u0435\u043a\u0446\u0456\u044f: \u0414\u0430\u0448\u0431\u043e\u0440\u0434\u0438 \u0432 Excel: \u0432\u0456\u0434 \u0434\u0430\u043d\u0438\u0445 \u0434\u043e \u0440\u0456\u0448\u0435\u043d\u044c[:en]Online-Lecture: Dashboards in Excel: From Data to Decisions[:]\"}}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/eba.com.ua\/#website\",\"url\":\"https:\/\/eba.com.ua\/\",\"name\":\"European Business Association\",\"description\":\"We are looking for proactive business leaders, who shape the investment climate of Ukraine and ready to supervise the work of the largest and the most influential business-community of Ukraine \u2013 European Business Association!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/eba.com.ua\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[:ua]Online-\u043b\u0435\u043a\u0446\u0456\u044f: \u0414\u0430\u0448\u0431\u043e\u0440\u0434\u0438 \u0432 Excel: \u0432\u0456\u0434 \u0434\u0430\u043d\u0438\u0445 \u0434\u043e \u0440\u0456\u0448\u0435\u043d\u044c[:en]Online-Lecture: Dashboards in Excel: From Data to Decisions[:] - European Business Association","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/","og_locale":"en_US","og_type":"article","og_title":"Online-Lecture: Dashboards in Excel: From Data to Decisions - European Business Association","og_description":"In modern work with data, it is important not only to calculate metrics, but also to quickly see the overall picture, identify deviations, and make decisions based on visual information. This is exactly why dashboards are used \u2014 a tool that transforms chaotic tables into a clear system for managing metrics. This online-lecture is dedicated [&hellip;]","og_url":"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/","og_site_name":"European Business Association","article_modified_time":"2026-03-10T12:29:26+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/eba.com.ua\/wp-content\/uploads\/2025\/12\/16x9-11.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/","url":"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/","name":"[:ua]Online-\u043b\u0435\u043a\u0446\u0456\u044f: \u0414\u0430\u0448\u0431\u043e\u0440\u0434\u0438 \u0432 Excel: \u0432\u0456\u0434 \u0434\u0430\u043d\u0438\u0445 \u0434\u043e \u0440\u0456\u0448\u0435\u043d\u044c[:en]Online-Lecture: Dashboards in Excel: From Data to Decisions[:] - European Business Association","isPartOf":{"@id":"https:\/\/eba.com.ua\/#website"},"datePublished":"2025-12-18T15:58:21+00:00","dateModified":"2026-03-10T12:29:26+00:00","breadcrumb":{"@id":"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/eba.com.ua\/event\/online-lektsiya-dashbordy-v-excel-vid-danyh-do-rishen-2025-12-18-17-58\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eba.com.ua\/"},{"@type":"ListItem","position":2,"name":"\u041f\u043e\u0434\u0456\u0457","item":"https:\/\/eba.com.ua\/events\/"},{"@type":"ListItem","position":3,"name":"Online-\u043b\u0435\u043a\u0446\u0456\u044f: \u0414\u0430\u0448\u0431\u043e\u0440\u0434\u0438 \u0432 Excel: \u0432\u0456\u0434 \u0434\u0430\u043d\u0438\u0445 \u0434\u043e \u0440\u0456\u0448\u0435\u043d\u044c","item":{"@type":"WebPage","name":"[:ua]Online-\u043b\u0435\u043a\u0446\u0456\u044f: \u0414\u0430\u0448\u0431\u043e\u0440\u0434\u0438 \u0432 Excel: \u0432\u0456\u0434 \u0434\u0430\u043d\u0438\u0445 \u0434\u043e \u0440\u0456\u0448\u0435\u043d\u044c[:en]Online-Lecture: Dashboards in Excel: From Data to Decisions[:]"}}]},{"@type":"WebSite","@id":"https:\/\/eba.com.ua\/#website","url":"https:\/\/eba.com.ua\/","name":"European Business Association","description":"We are looking for proactive business leaders, who shape the investment climate of Ukraine and ready to supervise the work of the largest and the most influential business-community of Ukraine \u2013 European Business Association!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/eba.com.ua\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events\/700682"}],"collection":[{"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events"}],"about":[{"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/types\/tribe_events"}],"author":[{"embeddable":true,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/users\/37119"}],"replies":[{"embeddable":true,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/comments?post=700682"}],"version-history":[{"count":10,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events\/700682\/revisions"}],"predecessor-version":[{"id":700693,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events\/700682\/revisions\/700693"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/media\/700694"}],"wp:attachment":[{"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/media?parent=700682"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/tags?post=700682"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events_cat?post=700682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}