fbpx
Size of letters 1x
Site color
Image
Additionally
Line height
Letter spacing
Font
Embedded items (videos, maps, etc.)
 

Online-Development Program: Excel for Data Work and Business Analytics

IT Personal Effectiveness Personal Development CEO, TOP Management HR, CSR, Internal Communications IT, Engineers PR, Marketing, Advertising, Design Audit, Accounting Economists, Finance Logistics Office Management Business Development, Sales, Customer Relations Legal affairs, GR
  • Status:We are working on the next season
Google Apple Outlook Telegram Bot
  Online-Development Program: Excel for Data Work and Business Analytics. Date: 14 April2026. Time: 17:30 19:30. Language: Ukrainian. Place: Will be online. 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 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 — in marketing, sales, finance, analytics, HR, accounting, and other fields. Target audience: 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. PROGRAM Module 1. Data normalization and structuring - 13 April, 17:30–19:30. Text transformation and cleaning. Find and replace. Splitting text into columns. Identifying and processing duplicates. Searching using filtering queries. Sorting for data organization. Working with smart tables: advantages and specifics. Module 2. Formulas and calculations - 15 April, 17:30–19:30. Entering and editing formulas. Cell referencing. Common errors. Circular references. Formula auditing. Module 3. Working with functions: Part 1 - 20 April, 17:30–19:30. Text functions. Date and time functions. Logical functions. Mathematical and statistical functions. Module 4. Working with functions: Part 2 - 22 April, 17:30–19:30. Lookup and data matching. Criteria-based calculations. Module 5. Workshop “Excel 2.0: Automation, Analytics and Visualization with AI” - 24 April, 17:30–19:30. Table design and data generation in Claude AI. Visualization and smart analysis in Julius AI. Advanced tools and optimization of work using AI. Working with AI agents with Excel. Module 6. Reporting automation - 27 April, 17:30–19:30. Drop-down lists. Conditional formatting. Creating a report template. Data pulling and report structuring (grouping tools). Subtotal and grand totals. Module 7. Pivot tables and data analysis - 29 April, 17:30–19:30. Creating and configuring the layout. Calculated fields. Grouping. Slicers. Visualization based on Pivot Table. Invitation from the trainer. https://youtube.com/shorts/mU1SXKX7gJASpeakers. Oleksii Voshchak. Excel and Google Sheets expert, financial analyst, and consultant with over 15 years of experience in the banking sector, IT, and consulting. Assistant Finance Manager at Forsego.. Anton Savochka. Business trainer, management consultant, game developer, artificial intelligence specialist, and facilitator.. You can send a question to:. Contact person:. Olena Musiienko. E-mail [email protected]. Contact Phone. 067 218 67 63.

About the Programme

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 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 — in marketing, sales, finance, analytics, HR, accounting, and other fields.

Target audience: 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.

PROGRAM

Module 1. Data normalization and structuring – 13 April, 17:30–19:30.

  • Text transformation and cleaning.
  • Find and replace.
  • Splitting text into columns.
  • Identifying and processing duplicates.
  • Searching using filtering queries.
  • Sorting for data organization.
  • Working with smart tables: advantages and specifics.

Module 2. Formulas and calculations – 15 April, 17:30–19:30.

  • Entering and editing formulas.
  • Cell referencing.
  • Common errors.
  • Circular references.
  • Formula auditing.

Module 3. Working with functions: Part 1 – 20 April, 17:30–19:30.

  • Text functions.
  • Date and time functions.
  • Logical functions.
  • Mathematical and statistical functions.

Module 4. Working with functions: Part 2 – 22 April, 17:30–19:30.

  • Lookup and data matching.
  • Criteria-based calculations.

Module 5. Workshop “Excel 2.0: Automation, Analytics and Visualization with AI” – 24 April, 17:30–19:30.

  • Table design and data generation in Claude AI.
  • Visualization and “smart” analysis in Julius AI.
  • Advanced tools and optimization of work using AI.
  • Working with AI agents with Excel.

Module 6. Reporting automation – 27 April, 17:30–19:30.

  • Drop-down lists.
  • Conditional formatting.
  • Creating a report template.
  • Data pulling and report structuring (grouping tools).
  • Subtotal and grand totals.

Module 7. Pivot tables and data analysis – 29 April, 17:30–19:30.

  • Creating and configuring the layout.
  • Calculated fields.
  • Grouping.
  • Slicers.
  • Visualization based on Pivot Table.

Invitation from the trainer

Trainers

1 / 2
Oleksii Voshchak
Excel and Google Sheets expert, financial analyst, and consultant with over 15 years of experience in the banking sector, IT, and consulting. Assistant Finance Manager at Forsego.
Anton Savochka
Business trainer, management consultant, game developer, artificial intelligence specialist, and facilitator.
Oleksii Voshchak
Anton Savochka

You can send a question to:

Contact person:

Olena Musiienko

Contact
Registration
First Name (ua)
Last Name (ua)
Job Title (ua)
First Name (en)
Last Name (en)
Job Title (en)
Contact Phone
Your mobile number
Please mark who will pay for your participation
Your expectations and questions to the trainer
Звідки ви дізнались про програму?
Register If your company is already a member of the EBA and you have a personal cabinet / or want to create it, please follow the link.
Close - 4
Please mark who will pay for your participation
Your expectations and questions to the trainer
Звідки ви дізнались про програму?
Register
Register
Close
Nationwide Minute of Silence
01:00
09:00
Nationwide Minute of Silence
Let us honor the memory of all those who lost their lives in russia’s war against Ukraine
00:43

Spelling error report

The following text will be sent to our editors: