Beginner levelData and IT
Excel essentials
Tables, formulas, VLOOKUP and XLOOKUP, sorting, filters and simple charts: the Excel of everyday office work.
- Hours
- 20
- Length
- 4–5 weeks
- Group
- up to 20 people
- Format
- In class, Live online
- Taught in
- AZ, RU
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 26 Oct – Mon 23 Nov8 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatLive online | SeatsFullGroup confirmed | Full |
| Sun 1 Nov – Sun 6 Dec5 lessons | Days and timeSunday 10:00–14:00 | LanguageIn Russian | FormatIn class | Seats7 seats leftGroup confirmed | Enrol in this group |
| Tue 10 Nov – Thu 3 Dec8 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats5 seats leftGroup confirmed | Enrol in this group |
| Mon 23 Nov – Wed 16 Dec8 lessons | Days and timeMon, Wed 19:00–21:30 | LanguageIn Azerbaijani | FormatLive online | Seats17 seats left | Enrol in this group |
| Sun 29 Nov – Sun 27 Dec5 lessons | Days and timeSunday 10:00–14:00 | LanguageIn Russian | FormatIn class | Seats6 seats leftGroup confirmed | Enrol in this group |
| Tue 8 Dec – Tue 5 Jan8 lessons | Days and timeTue, Thu 19:00–21:30 | LanguageIn Azerbaijani | FormatIn class | Seats20 seats left | Enrol in this group |
Programme
- Sheets, cells, formats and printing4 h
- Formulas: SUM, AVERAGE, IF, absolute and relative references6 h
- Joining two tables with VLOOKUP and XLOOKUP4 h
- Sorting, filters, conditional formatting4 h
- Simple charts and laying out a report2 h
- Total20 h
After the course you will be able to
- Build a daily report with formulas instead of by hand
- Compare two lists and find the differences
- Send your manager a readable table and chart
What you need first
Being able to open and save files on a computer.
Tools
- Microsoft Excel
Final project and certificate
A sheet from your own work: clean it, calculate it with formulas and make a one-page report.
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
Name Surname
«Excel essentials» for completing the course
Length: 20 hours · Final project: 91/100
No. PS-2026-···· · 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 consultation
Before and after this course
All courses in the field: Data and ITQuestions
In which language is Excel set up?
The lab runs the English interface; we also give the formula names in Russian and Azerbaijani so any version at work feels familiar.
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.