A program focused on large datasets, arrays, data models and automation in Excel. Includes Power Query, Power Pivot, VBA and basic visualization tools.
Language of course:
Ukrainian
Format of the event:
Online
Add to collection
you haven't created a collection yet
Add Collection
Course overview
Description generated based on course syllabus and open data.
Advanced Excel: who it suits and who it does not
Suitable (advanced Excel)
- Analysts, finance and operations specialists with practical Excel experience.
- Those working with large tables, data merges, models and pivot reports.
- Users aiming to apply Power Query, Power Pivot, DAX measures and basic dashboards.
Not suitable
- Beginners without basic knowledge of formulas, references and pivot tables.
- Those expecting to work only in Google Sheets without Microsoft Excel tools.
- Users who need full-scale programming with Python or R instead of Excel.
Advanced Excel: problem → effect in data work
Large datasets → processing via array formulas and Power Query
Use dynamic arrays, filtering, transformations and merges without manual operations.
Heterogeneous sources → consolidation in a Power Pivot model
Build table relationships, DAX measures for calculations, manage links and cube formulas.
Repetitive actions → macros and VBA
Record routine steps, standard VBA procedures, integrate with external sources.
Need quick overviews → visualization in Excel and Power BI
Create charts, maps and clear reports with minimal manual refresh.
Advanced Excel vs alternatives: a brief comparison
- Advanced Excel: local data prep, models, automation without separate coding.
- Google Sheets: collaborative online work, limited data volume and add-ins.
- SQL: reliable database queries; requires access rights and query language skills.
- Python/R: flexible analytics and ML; higher entry threshold and environment support.
- BI platforms: governed dashboards; separate source and publication setup from Excel.
Advanced Excel: scope and planned competencies
- Array and dynamic array formulas: FILTER, UNIQUE, SORT, SEQUENCE.
- Lookup and combinations: XLOOKUP, INDEX, MATCH, XMATCH, function chaining.
- Power Query: import, cleaning, transformation and merging from multiple sources.
- Power Pivot: data model, relationships, DAX measures, link management, cube formulas.
- Visualization: pivots and charts, maps, integration with Power BI.
- VBA and macros: macro recording, procedure structure, common automation scenarios.
- Connections to external sources: files, databases, web services and data refresh.
- AI tools in Excel: assistive prompts and faster data preparation.
Advanced Excel instructor
Mykyta Svidlo — Head of Operations | Delivery Unit at Uklon. Experience: SAP implementation at Coca-Cola Hellenic Ukraine; pricing and market analysis at Shell Retail Ukraine; financial analysis, P&L, management accounting; pricing system implementation.
Course Description
"Lecturer
Mykyta Svydlo
Head of Operations | Delivery Unit at Uklon
- implemented and adapted SAP in the operational activities of Coca-Cola Hellenic Ukraine- at Shell Retail Ukraine, he formed prices for petroleum products, analyzed the competitive environment and markets for each gas station- introduced a new fuel pricing system, which increased the margin to 140 thousand dollars per year- has 10 years of experience in sales analytics, management accounting and financial analysis- worked as a financial analyst at Coca-Cola Hellenic Ukraine: kept management accounting, prepared P&L, analyzed deviations in revenue and discounts"
Evaluation
Only authorized users can leave reviews and rate
Log in »
.png)
