Advanced Excel Course

كورسنا القادم يوم 13 - 9
الاكسل للمحترفين
5 محاضرات - يواقع ساعة ونصف
بسعر 75 الف عراقي (55$) لخارج العراق
المحاضرات بين يوم ويوم
تكون المحاضرات اونلاين وتسجل لكم ايضا
تحياتي
مواضيع الكورس ادناه :
Advanced Excel Course
Duration: (5 sessions × 1.5 hours)
🔹 Topics to Cover:

1. PivotTables and PivotCharts (Intro)
   • Creating PivotTables
   • Grouping and filtering
   • Basic PivotCharts

2. Tables and Structured References
   • Converting data into tables
   • Table formulas

3. Basic Dashboard Elements
   • Combining visuals
   • Using form controls (sliders)

4. Advanced Functions
   • SUMIFS, COUNTIFS, IFS
   • OFFSET, INDIRECT, CHOOSE
   • Become Faster With Excel Shortcuts

5. Advanced PivotTable Techniques
   • Calculated fields
   • Slicers and timelines
   • Grouping by date or custom fields

6. Power Query (Get & Transform)
   • Importing from different sources
   • Cleaning and transforming data

7. Advanced Charting Techniques
   • Combo charts, sparklines
   • Dynamic charts with named ranges

8. Dashboard Design
   • KPI indicators

9. Macros & VBA (Intro)
   • Recording macros
   • Basic VBA editor usage