Online-Training: Microsoft Excel

• Duration:14 May - 04 June
• Language: Ukrainian
• Time: 10:00 - 13:00
• Format:4 days (14, 21, 28 May and 4 June on Wednesdays), from 10 till 13.00 each of these days
• Fee for EBA members:7000 UAH
• Early Registration for EBA members:6000 UAH till April 14th
• Place: Will be online
Cancel registration Register Register a colleague

This training is designed for users who already have basic knowledge of Excel and wish to expand their skills to an advanced level. It covers more complex functions, tools, and data analysis methods, enabling participants to use Excel more effectively in their work. 

EBA Management Development Centre team together with Bogdan Duda invite you to join the Online-Training: Microsoft Excel. 

Target audience: is intended for professionals working with large datasets, financial models, reporting, and analytics, as well as those aiming to enhance their efficiency in Excel. It is suitable for analysts, financial managers, marketers, and other specialists who want to master advanced spreadsheet skills. 

What participants will learn after the training 

By the end of this course, participants will be able to: 

• Use advanced Excel formulas and functions. 
• Create and customize PivotTables and PivotCharts for data analysis. 
• Utilize new Excel functions such as IFS, XLOOKUP, and others. 
• Apply conditional summation and calculations based on multiple criteria. 
• Employ modern Excel formulas for efficient data processing. 
• Manipulate data using PivotTables and DAX formulas in Power Pivot. 

What knowledge participants should have before the start of the training

Participants should have: 

• Basic knowledge of Excel, including simple formulas and functions. 
• Experience working with spreadsheets, creating, and formatting tables. 
• An understanding of basic data operations such as filtering and sorting. 

Syllabus

Module 1. Basic Formulas – May 14th 

• Features of using formulas with table functions. 
• Table names and column pointers. Performing more complex calculations. 
• New Excel functions: IFS, XLOOKUP. 
• Replacing multiple IF functions and IFS with lookup functions (VLOOKUP, HLOOKUP). 
• Searching and replacing data using a combination of INDEX and MATCH functions. 

Module 2. Advanced Features of Basic Formulas – May 21st 

• Conditional summation and calculations based on multiple criteria. 
• Secrets of the SUMPRODUCT function. 
• Error handling in formulas. 
• Instant fill capabilities. 

Module 3. Modern Excel Formulas –  May 28th

• Formulas: FILTER, LET, UNIQUE, SEQUENCE, TAKE, DROP. 
• Formula LAMBDA. 
• Formulas WRAPCOLS, WRAPROWS. 
• Formulas CHOOSECOLS, CHOOSEROWS. 
• Formulas TEXTSPLIT, TEXTBEFORE, TEXTAFTER. 

Module 4. Data Manipulation Using PivotTables – June 04th 

• Creating a PivotTable report from worksheet data. 
• Layout, formatting, and modification of PivotTables. 
• Working with the PivotTable field list; interim and grand totals in reports. 
• Grouping items in a PivotTable report (manual and automatic). 
• Additional calculations in PivotTables for quick analysis (percentages, cumulative totals, parent-child ratios). 
• Creating, editing, and deleting PivotTable formulas; using slicers to filter PivotTable data. 
• Connecting slicers to multiple PivotTables. 
• Referencing PivotTable cells with GETPIVOTDATA; customized PivotTable formats. 
• Generating multiple PivotTables from a single data source. 
• Creating a PivotChart report based on a PivotTable. 
• Connecting slicers. 
• Introduction to Power Pivot and DAX formulas. 

You can send a question to: