{"id":795670,"date":"2025-12-09T11:31:23","date_gmt":"2025-12-09T09:31:23","guid":{"rendered":""},"modified":"2025-12-12T10:32:30","modified_gmt":"2025-12-12T08:32:30","slug":"online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31","status":"publish","type":"tribe_events","link":"https:\/\/new.eba.com.ua\/en\/event\/online-programa-rozvytku-excel-dlya-roboty-z-danymy-ta-biznes-analityky-2025-12-09-11-31\/","title":{"rendered":"Online-Development Program: Excel for Data Work and Business Analytics"},"content":{"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.<\/p>\n<p><span style=\"color: #000000\">EBA Management Development Centre team, together with <strong>Oleksii Voshchak<\/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. 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 6. 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","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, invites you to join the Online-Development Program: Excel for Data Work and Business Analytics. The course covers all key Excel [&hellip;]<\/p>\n","protected":false},"author":37119,"featured_media":698036,"comment_status":"open","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"tags":[],"tribe_events_cat":[15683],"class_list":["post-795670","tribe_events","type-tribe_events","status-publish","has-post-thumbnail","hentry","tribe_events_cat-regional-events-en","cat_regional-events-en"],"_links":{"self":[{"href":"https:\/\/new.eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events\/795670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/new.eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events"}],"about":[{"href":"https:\/\/new.eba.com.ua\/en\/wp-json\/wp\/v2\/types\/tribe_events"}],"author":[{"embeddable":true,"href":"https:\/\/new.eba.com.ua\/en\/wp-json\/wp\/v2\/users\/37119"}],"replies":[{"embeddable":true,"href":"https:\/\/new.eba.com.ua\/en\/wp-json\/wp\/v2\/comments?post=795670"}],"version-history":[{"count":0,"href":"https:\/\/new.eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events\/795670\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/new.eba.com.ua\/en\/wp-json\/wp\/v2\/media\/698036"}],"wp:attachment":[{"href":"https:\/\/new.eba.com.ua\/en\/wp-json\/wp\/v2\/media?parent=795670"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/new.eba.com.ua\/en\/wp-json\/wp\/v2\/tags?post=795670"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/new.eba.com.ua\/en\/wp-json\/wp\/v2\/tribe_events_cat?post=795670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}