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 Development Personal Effectiveness Audit, Accounting Business Development, Sales, Customer Relations CEO, TOP Management Economists, Finance HR, CSR, Internal Communications IT, Engineers Legal affairs, GR Logistics Office Management PR, Marketing, Advertising, Design
  • Status:We are working on the next season
Google Apple Outlook Telegram Bot
  Online-Development Program: Excel for Data Work and Business Analytics. Date: 13 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, 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. 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 6. 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. Speakers. 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.. You can send a question to:. Contact person:. Anna Malikova. E-mail [email protected]. Contact Phone. 067 218 27 41.

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, 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. 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 6. 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.

Trainers

1 / 1
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.
Oleksii Voshchak

You can send a question to:

Contact person:

Anna Malikova

Contact
Register
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
Close - 4
Please mark who will pay for your participation
Your expectations and questions to the trainer
Звідки ви дізнались про програму?
Register
Register
Close
National Minute of Silence
01:00
09:00
National Minute of Silence
Let us honor the memory of all those who lost their lives in russia’s war against Ukraine
00:43
This site is registered on wpml.org as a development site. Switch to a production site key to remove this banner.

Spelling error report

The following text will be sent to our editors: