Excel Intermediate Training (in Azerbaijani) | Ilgar Zarbaliyev
Details
๐ Excel Intermediate Training Series (4 Sessions)
This live Excel training series is designed for Mingachevir Technical University students who already know Excel basics and want to improve their analytical, logical, and reporting skills.
๐บ All sessions will be live-streamed on YouTube and include practical examples and hands-on exercises.
### ๐น Program Outline
- Lesson 1: SUMIF/S, COUNTIF/S, AVERAGEIF/S, MINIFS, MAXIFS, VLOOKUP, HLOOKUP
- Lesson 2: IF logic, text functions, date functions, conditional formatting
- Lesson 3: Data validation, protection, filtering, duplicates, subtotals
- Lesson 4: Tables, consolidation, pivot tables & charts
๐ Final practical exam included
๐ฏ Ideal for students aiming to build strong Excel skills for business, analytics, and future Power BI learning.
Related topics
Microsoft Azure
Power BI
Microsoft Dynamics
Microsoft Power Platform
PaaS (Platform as a Service)
