{"id":697792,"date":"2025-12-09T11:31:23","date_gmt":"2025-12-09T09:31:23","guid":{"rendered":"https:\/\/eba.com.ua\/?post_type=tribe_events&#038;p=697792"},"modified":"2026-04-23T22:10:11","modified_gmt":"2026-04-23T19:10:11","slug":"online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31","status":"publish","type":"tribe_events","link":"https:\/\/eba.com.ua\/en\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/","title":{"rendered":"[:ua]Online-\u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0430 \u0440\u043e\u0437\u0432\u0438\u0442\u043a\u0443: Excel \u0434\u043b\u044f \u0440\u043e\u0431\u043e\u0442\u0438 \u0437 \u0434\u0430\u043d\u0438\u043c\u0438 \u0442\u0430 \u0431\u0456\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0456\u0442\u0438\u043a\u0438[:en]Online-Development Program: Excel for Data Work and Business Analytics[:]"},"content":{"rendered":"<p><\/p>\n<p>Modern businesses need professionals who can work quickly and efficiently with data, analyze large datasets, create clear reports and dashboards, automate calculations, and make data-driven decisions.<\/p>\n<p><span style=\"color: #000000\">EBA Management Development Centre team, together with <strong>Oleksii Voshchak <\/strong>and<strong> Anton Savochka<\/strong>, invites you to join the <strong>Online-Development Program: Excel for Data Work and Business Analytics.<\/strong><\/span><\/p>\n<p>The course covers all key Excel tools needed by a modern specialist: working with data, formulas, functions, pivot tables, as well as elements of reporting automation. The training is structured so that upon completion, you can confidently handle most work tasks \u2014 in marketing, sales, finance, analytics, HR, accounting, and other fields.<\/p>\n<p><strong>Target audience<\/strong>: specialists in marketing, finance, analytics, sales, HR, managers, entrepreneurs, and anyone who works with data and wants to master Excel at a confident user level.<\/p>\n<p data-start=\"999\" data-end=\"1008\"><strong>PROGRAM<\/strong><\/p>\n<p><strong>Module 1. Data normalization and structuring <span class=\"s2\">&#8211; 13 April, 17:30\u201319:30.<\/span><\/strong><\/p>\n<ul>\n<li>Text transformation and cleaning.<\/li>\n<li>Find and replace.<\/li>\n<li>Splitting text into columns.<\/li>\n<li>Identifying and processing duplicates.<\/li>\n<li>Searching using filtering queries.<\/li>\n<li>Sorting for data organization.<\/li>\n<li>Working with smart tables: advantages and specifics.<\/li>\n<\/ul>\n<p><strong>Module 2. Formulas and calculations <span class=\"s2\">&#8211; 15 April, 17:30\u201319:30.<\/span><\/strong><\/p>\n<ul>\n<li>Entering and editing formulas.<\/li>\n<li>Cell referencing.<\/li>\n<li>Common errors.<\/li>\n<li>Circular references.<\/li>\n<li>Formula auditing.<\/li>\n<\/ul>\n<p><strong>Module 3. Working with functions: Part 1 <span class=\"s2\">&#8211; 20 April, 17:30\u201319:30.<\/span><\/strong><\/p>\n<ul>\n<li>Text functions.<\/li>\n<li>Date and time functions.<\/li>\n<li>Logical functions.<\/li>\n<li>Mathematical and statistical functions.<\/li>\n<\/ul>\n<p><strong>Module 4. Working with functions: Part 2 <span class=\"s2\">&#8211; 22 April, 17:30\u201319:30.<\/span><\/strong><\/p>\n<ul>\n<li>Lookup and data matching.<\/li>\n<li>Criteria-based calculations.<\/li>\n<\/ul>\n<p><strong>Module 5. Workshop \u201cExcel 2.0: Automation, Analytics and Visualization with AI\u201d &#8211; 24 April, 17:30\u201319:30.<\/strong><\/p>\n<ul>\n<li>Table design and data generation in Claude AI.<\/li>\n<li>Visualization and &#8220;smart&#8221; analysis in Julius AI.<\/li>\n<li>Advanced tools and optimization of work using AI.<\/li>\n<li>Working with AI agents with Excel.<\/li>\n<\/ul>\n<p><strong>Module 6. Reporting automation <span class=\"s2\">&#8211; 27 April, 17:30\u201319:30.<\/span><\/strong><\/p>\n<ul>\n<li>Drop-down lists.<\/li>\n<li>Conditional formatting.<\/li>\n<li>Creating a report template.<\/li>\n<li>Data pulling and report structuring (grouping tools).<\/li>\n<li>Subtotal and grand totals.<\/li>\n<\/ul>\n<p><strong>Module 7. Pivot tables and data analysis <span class=\"s2\">&#8211; 29 April, 17:30\u201319:30.<\/span><\/strong><\/p>\n<ul>\n<li>Creating and configuring the layout.<\/li>\n<li>Calculated fields.<\/li>\n<li>Grouping.<\/li>\n<li>Slicers.<\/li>\n<li>Visualization based on Pivot Table.<\/li>\n<\/ul>\n<h4><strong>Invitation from the trainer<\/strong><\/h4>\n<p><iframe loading=\"lazy\" title=\"Online-\u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0430 \u0440\u043e\u0437\u0432\u0438\u0442\u043a\u0443: Excel \u0434\u043b\u044f \u0440\u043e\u0431\u043e\u0442\u0438 \u0437 \u0434\u0430\u043d\u0438\u043c\u0438 \u0442\u0430 \u0431\u0456\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0456\u0442\u0438\u043a\u0438\" width=\"422\" height=\"750\" src=\"https:\/\/www.youtube.com\/embed\/mU1SXKX7gJA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Modern businesses need professionals who can work quickly and efficiently with data, analyze large datasets, create clear reports and dashboards, automate calculations, and make data-driven decisions. EBA Management Development Centre team, together with Oleksii Voshchak and Anton Savochka, invites you to join the Online-Development Program: Excel for Data Work and Business Analytics. The course covers [&hellip;]<\/p>\n","protected":false},"author":37119,"featured_media":698036,"comment_status":"open","ping_status":"closed","template":"","meta":{"inline_featured_image":false},"tags":[],"tribe_events_cat":[35,32],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Online-Development Program: Excel for Data Work and Business Analytics - 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-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online-Development Program: Excel for Data Work and Business Analytics - European Business Association\" \/>\n<meta property=\"og:description\" content=\"Modern businesses need professionals who can work quickly and efficiently with data, analyze large datasets, create clear reports and dashboards, automate calculations, and make data-driven decisions. EBA Management Development Centre team, together with Oleksii Voshchak and Anton Savochka, invites you to join the Online-Development Program: Excel for Data Work and Business Analytics. The course covers [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eba.com.ua\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/\" \/>\n<meta property=\"og:site_name\" content=\"European Business Association\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-23T19:10:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eba.com.ua\/wp-content\/uploads\/2025\/12\/Online-programa-rozvytku-Excel-dlya-roboty-z-danymy-ta-biznes-analityky.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-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/\",\"url\":\"https:\/\/eba.com.ua\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/\",\"name\":\"[:ua]Online-\u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0430 \u0440\u043e\u0437\u0432\u0438\u0442\u043a\u0443: Excel \u0434\u043b\u044f \u0440\u043e\u0431\u043e\u0442\u0438 \u0437 \u0434\u0430\u043d\u0438\u043c\u0438 \u0442\u0430 \u0431\u0456\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0456\u0442\u0438\u043a\u0438[:en]Online-Development Program: Excel for Data Work and Business Analytics[:] - European Business Association\",\"isPartOf\":{\"@id\":\"https:\/\/eba.com.ua\/#website\"},\"datePublished\":\"2025-12-09T09:31:23+00:00\",\"dateModified\":\"2026-04-23T19:10:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/eba.com.ua\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eba.com.ua\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eba.com.ua\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/#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-\u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0430 \u0440\u043e\u0437\u0432\u0438\u0442\u043a\u0443: Excel \u0434\u043b\u044f \u0440\u043e\u0431\u043e\u0442\u0438 \u0437 \u0434\u0430\u043d\u0438\u043c\u0438 \u0442\u0430 \u0431\u0456\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0456\u0442\u0438\u043a\u0438\",\"item\":{\"@type\":\"WebPage\",\"name\":\"[:ua]Online-\u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0430 \u0440\u043e\u0437\u0432\u0438\u0442\u043a\u0443: Excel \u0434\u043b\u044f \u0440\u043e\u0431\u043e\u0442\u0438 \u0437 \u0434\u0430\u043d\u0438\u043c\u0438 \u0442\u0430 \u0431\u0456\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0456\u0442\u0438\u043a\u0438[:en]Online-Development Program: Excel for Data Work and Business Analytics[:]\"}}]},{\"@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-\u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0430 \u0440\u043e\u0437\u0432\u0438\u0442\u043a\u0443: Excel \u0434\u043b\u044f \u0440\u043e\u0431\u043e\u0442\u0438 \u0437 \u0434\u0430\u043d\u0438\u043c\u0438 \u0442\u0430 \u0431\u0456\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0456\u0442\u0438\u043a\u0438[:en]Online-Development Program: Excel for Data Work and Business Analytics[:] - 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-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/","og_locale":"en_US","og_type":"article","og_title":"Online-Development Program: Excel for Data Work and Business Analytics - European Business Association","og_description":"Modern businesses need professionals who can work quickly and efficiently with data, analyze large datasets, create clear reports and dashboards, automate calculations, and make data-driven decisions. EBA Management Development Centre team, together with Oleksii Voshchak and Anton Savochka, invites you to join the Online-Development Program: Excel for Data Work and Business Analytics. The course covers [&hellip;]","og_url":"https:\/\/eba.com.ua\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/","og_site_name":"European Business Association","article_modified_time":"2026-04-23T19:10:11+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/eba.com.ua\/wp-content\/uploads\/2025\/12\/Online-programa-rozvytku-Excel-dlya-roboty-z-danymy-ta-biznes-analityky.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-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/","url":"https:\/\/eba.com.ua\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/","name":"[:ua]Online-\u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0430 \u0440\u043e\u0437\u0432\u0438\u0442\u043a\u0443: Excel \u0434\u043b\u044f \u0440\u043e\u0431\u043e\u0442\u0438 \u0437 \u0434\u0430\u043d\u0438\u043c\u0438 \u0442\u0430 \u0431\u0456\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0456\u0442\u0438\u043a\u0438[:en]Online-Development Program: Excel for Data Work and Business Analytics[:] - European Business Association","isPartOf":{"@id":"https:\/\/eba.com.ua\/#website"},"datePublished":"2025-12-09T09:31:23+00:00","dateModified":"2026-04-23T19:10:11+00:00","breadcrumb":{"@id":"https:\/\/eba.com.ua\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eba.com.ua\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/eba.com.ua\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/#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-\u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0430 \u0440\u043e\u0437\u0432\u0438\u0442\u043a\u0443: Excel \u0434\u043b\u044f \u0440\u043e\u0431\u043e\u0442\u0438 \u0437 \u0434\u0430\u043d\u0438\u043c\u0438 \u0442\u0430 \u0431\u0456\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0456\u0442\u0438\u043a\u0438","item":{"@type":"WebPage","name":"[:ua]Online-\u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0430 \u0440\u043e\u0437\u0432\u0438\u0442\u043a\u0443: Excel \u0434\u043b\u044f \u0440\u043e\u0431\u043e\u0442\u0438 \u0437 \u0434\u0430\u043d\u0438\u043c\u0438 \u0442\u0430 \u0431\u0456\u0437\u043d\u0435\u0441-\u0430\u043d\u0430\u043b\u0456\u0442\u0438\u043a\u0438[:en]Online-Development Program: Excel for Data Work and Business Analytics[:]"}}]},{"@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\/697792"}],"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=697792"}],"version-history":[{"count":22,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events\/697792\/revisions"}],"predecessor-version":[{"id":725602,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events\/697792\/revisions\/725602"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/media\/698036"}],"wp:attachment":[{"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/media?parent=697792"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/tags?post=697792"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events_cat?post=697792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}