Intermediate levelData and IT
Advanced Excel
Pivot tables, cleaning data with Power Query, dynamic arrays, LET and LAMBDA, dashboards.
- Hours
- 40
- Length
- 8–10 weeks
- Group
- up to 20 people
- Format
- In class, Live online
- Taught in
- AZ, RU, EN
Next groups
A group is certain to run once six people enrol. Enrolment closes at 18:00 the day before the first lesson.
| Dates | Days and time | Language | Format | Seats | Enrol in this group |
|---|---|---|---|---|---|
| Mon 2 Nov – Mon 28 Dec16 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats8 seats leftGroup confirmed | Enrol in this group |
| Sat 21 Nov – Sat 30 Jan10 lessons | Days and timeSaturday 10:00–14:00 | LanguageIn Russian | FormatIn class | Seats1 seat leftGroup confirmed | Enrol in this group |
| Tue 24 Nov – Tue 19 Jan16 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn English | FormatLive online | Seats1 seat leftGroup confirmed | Enrol in this group |
| Mon 14 Dec – Wed 3 Feb16 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats14 seats leftGroup confirmed | Enrol in this group |
| Tue 19 Jan – Thu 11 Mar16 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn English | FormatLive online | Seats20 seats left | Enrol in this group |
| Mon 25 Jan – Mon 29 Mar16 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats10 seats leftGroup confirmed | Enrol in this group |
Programme
- Pivot tables, grouping and slicers8 h
- Power Query: connecting, cleaning and merging sources10 h
- Dynamic arrays: FILTER, SORT, UNIQUE, LET, LAMBDA8 h
- Dashboards: charts, conditional formatting, controls8 h
- Checking, protecting and sharing a workbook6 h
- Total40 h
After the course you will be able to
- Refresh a monthly hand-built report with one click
- Combine data from several files and systems
- Build a one-page dashboard for management
What you need first
VLOOKUP, IF and simple charts; if not, “Excel essentials” first.
Tools
- Microsoft Excel
- Power Query
Final project and certificate
A monthly report from your work: gathered with Power Query, shown with pivots and a dashboard.
The certificate goes to those who attend 80% of the lessons and score above 60 on the final project. It is the academy’s own certificate, not a state document; its number can be checked on this site.
Check a certificateCertificate
Awarded to
Elchin Abdullayev
«Advanced Excel» for completing the course
Length: 40 hours · Final project: 95/100
No. PS-2026-0352 · verify at pilleakademiya.az/certificates
Instructors
Nargiz Rzayeva
Excel and reporting
Reporting analyst at a retail chain, 9 years in the trade
Profile and a free consultationTural Ismayilov
Financial modelling in Excel
Investment analyst at a holding company, 11 years in the trade
Profile and a free consultation
Before and after this course
All courses in the field: Data and ITQuestions
Should I move on to Power BI after this?
If the report draws on many sources and many people read it, yes: Power Query is the same in both, so the Power BI course goes faster.
Can I get my money back if I change my mind?
Until the first lesson you get back everything you paid. After the start, the lessons not yet held are refunded, to the card within 10 working days. Cancel on the “Your enrolment” page with the number and your phone.
Can I move to another group?
Yes, once and free, until 3 days before the start: choose another group of the same course on the “Your enrolment” page.
This course for your team
We can run the course at your office or online for your staff only, with examples from your company’s own data.