Microsoft Excel (From Beginner to Advanced)
The Microsoft Excel course is a hands-on training designed to help you work faster and more accurately with data in a professional environment. You will learn table creation and formatting, formulas and functions (IF, VLOOKUP/XLOOKUP, SUMIF/COUNTIF, etc.), sorting and filtering, data validation, conditional formatting, PivotTables, charts, and building dashboards. The training is based on real business scenarios and practical assignments, enabling learners to create common workplace reports confidently by the end of the course.
Üstünlüklərimiz
Professional Mentors
Guidance and support from experienced specialists
Practical Learning
Not just theory — hands-on experience through real projects
Modern Technologies
Python, AI, web development and other trending fields
Career Support
CV preparation, interview simulations and access to job opportunities
Curriculum
Module 1
- 1.Introduction to Microsoft Excel Arithmetic manipulation Logical formulas (IF, AND, OR, IFERROR, etc.) Error types (#DIV/0!, #REF!, #VALUE!, etc.) Text functions (LEFT, RIGHT, MID, LEN, CONCATENATE, etc.) Date and Time functions Math and Trigonometry functions Statistical functions
Module 2
- 1.Data validation Conditional formatting Advanced filtering Sorting and filtering What-if analysis Lookup and Reference functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH)
Module 3
- 1.Pivot Tables Pivot calculations Charts and visualizations Dashboard fundamentals Hyperlinks Hands-on practice with real datasets Final Exam (Project)
Our Top Graduates
Bu kurs üçün hələ məzun məlumatı əlavə olunmayıb.
Our Teachers
Market Salaries
700 AZN
Junior
0-1 year experience
900-1200 AZN
Middle
1–3 years experience
1800 AZN
Senior
3+ years experience
Frequently Asked Questions
idtech is a modern learning ecosystem providing education in technology, programming, and digital skills.
You can register by filling out the form in the 'Apply' section on our website.
Our courses are suitable for both beginners and those looking to deepen their expertise.
Yes, lessons are available both online and in classrooms.