FM01Financial Modelling Master 1Advanced Excel Modeling and Enhancements
Arabic
Intermediate
FACE 2 FACE
ON SITE TRAINING
LIVE VIRTUAL
TRAINING
COACHING
& MENTORING
SELF-PACED
TRAINING
Select Date
Course Overview
In this course, participants will learn how to create dynamic dashboards and charts, develop advanced Excel models, and explore optimization models using the Solver tool. The course focuses on the fundamentals of building effective models and applying advanced Excel techniques to analyze data and solve business optimization problems.
Key Takeaways
1
بعد إنتهائكم من هذة الرحلة التدريبية و حضوركم لهذة الثلاث دورات ، ستتمكنوا من الاجابة على الأسئلة التالية و الكثير الكثير من الاسئلة الأخرى ذات الصلة :
2
كيف يمكن انشاء نماذج ديناميكية من البداية للنهاية في الاكسل باستخدام دوال متعددة؟
3
ما هي المشاكل الحقيقية لاستخدام ال اي ار ار في تقييم المشاريع و كيفية معالجتها؟
4
كيف يمكن انشاء ماكرو ديناميكي لتسريع جميع العمليات المتكررة كل شهر لتفادي اهدار الوقت و المجهود و الاخطاء؟
5
كيف يمكن الوصول لاي في بي ايه متطور لحل مشاكل عديدة بشكل دوري؟
6
كيف يمكن ادخال المحاكاة باستخدام المونت كارلو لاتخاذ قرارات صائبة خاصة بالمستقبل ؟
7
كيف يمكنك ان تستخدم الباور بيفوت في تحليل بيانات غزيرة و متشابكة للمساعدة في اتخاذ القرارات؟
edX
Every individual has the potential to create change, whether in their life, their community, or the world. The transformative power of education is what unlocks that potential. Yet, access to high-quality education has been a privilege of the few. Back in 2012, we realized it was a time for a seismic shift in learning. From the tried and true to the leading edge. From “for some” to “for all.” By opening the classroom through online learning, edX empowers millions of learners to unlock their potential and become changemakers.
Course Outline
نمذجة إكسل المتقدمة وتحسيناتها
خلال هذه الدورة، سيتعلم المشاركون كيفية إنشاء لوحات معلومات ومخططات ديناميكية، وتطوير نماذج إكسل باستخدام مهارات متقدمة، واكتشاف نماذج التحسين باستخدام أداة Solver. تركز الدورة على أساسيات بناء النماذج الفعالة وتطبيق تقنيات إكسل المتقدمة لتحليل البيانات وحل مشكلات تحسين الأعمال.
تقييم المشاريع والتحليل المالي القائم على إكسل
تغطي هذه الدورة التدريبية تقنيات نمذجة البيانات والتحليل والتصور باستخدام “ باور بيفوت “ عبر برنامج إكسل.
كما سيتعلم المتدربين كيفية استيراد مجموعات البيانات الكبيرة وتنظيفها وتحليلها وإنشاء العلاقات بين الجداول واستخدام تعبيرات تحليل البيانات "دي ايه اكس" وتصميم تصورات بيانات فعالة.
البرمجة باستخدام "في بي ايه" عبر مايكروسوفت إكسل
هذه الدورة تقدم برمجة "VBA" في إكسل، بدءاً من الأساسيات وصولاً إلى مستوى متقدم لأتمتة المهام. يتعلم المشاركون كيفية إنشاء وحدات ماكرو، استخدام الحلقات والوظائف، وإنشاء نماذج لتحسين الكفاءة. تشمل الدورة أمثلة واقعية وتطبيقات عملية في مجالات مثل التمويل وتحليل البيانات، مما يعزز القدرة على حل المشكلات المعقدة. الدورة مصممة للمبتدئين، وتساعدهم على إتقان "VBA" واستخدامه لأتمتة المهام اليومية وزيادة الإنتاجية في العمل.
Who Should Attend?
تم تصميم هذه الدورة العملية والتفاعلية للغاية خصيصًا لـ
الجميع
FAQ
What language will the course be taught in and what level of English do I need to take part in an LEORON training program?
Most of our public courses are delivered in English language. You need to be proficient in English to be able to fully participate in the workshop and network with other delegates. For in-house courses we have the capability to train in Arabic, Dutch, German and Portuguese.
Are LEORON Public courses certified by an official body/organization?
LEORON Institute partners with 20+ international bodies and associations.We also award continuing professional development credits (CPE/PDUs) for:1. NASBA (National Association of State Boards of Accountancy) 2. Project Management Institute PDUs 3. CISI credits 4. GARP credits 5. HRCI recertification credits 6. SHRM recertification credits
What is the deadline for registering to a public course?
The deadline to register for a public course is 14 days before the course starts. Kindly note that occasionally we do accept late registrations as well, but this needs to be confirmed with the project manager of the training program or with our registration desk that can be reached at +1071 4 1075 5711 or [email protected].
What does the course fee cover?
The course fee covers a premium training experience in a 5-star hotel, learning materials, lunches & refreshments, and for some courses, the certification fee and membership with the accrediting bodies.
Does LEORON give discounts?
Yes, we can provide discounts for group bookings. If you would like to discuss a discount on a corporate level, we will be happy to talk to you.
Reviews
- Review:Certified Professional in Quality and Patient SafetyWe have been working with LEORON for the past two years and will be working with them again this upcoming year. The programs they delivered were fruitful and exciting and our organization has received positive feedback from the participants. What our organization aims to do is to provide at no cost training for all the private sector employees so that they may benefit from our offered programs in Innovation and Professional development. Leoron has helped us achieve this goal. We look forward to continuing this service and wish them the best of luck. Regards,Nasser M. Al-Subaie
- Review:Certified Professional in Quality and Patient SafetySince the partnership was signed between BAE Systems Saudi Development & Training and LEORON in 2017, we have been working together to offer the Saudi market a complete portfolio of training solutions benefiting from the wide and extensive experience of both parties. Recognizing the great success of this partnership, we are looking for further collaborations in the future that will position both companies as one of the leading training providers in Saudi Arabia. We thank the LEORON team for their full cooperation and continuing support, and look forward to further success together in the years to come.Emad Alrajih
- Review:Certified Professional in Quality and Patient SafetyDating back to 2014, Mobily’s “LEORON” experience has grown from a single collaboration to a long-term partnership. We consider “LEORON” Institute as a strategic partner, whose contribution has been nothing but premium in equipping our staff with field-based knowledge and information. Past three years have resulted with an expanded collaboration with superior customer service and support. Best Regards,Turki S. Alsahaan
- Review:IAMM Internal Audit Maturity ModelIn recognition of their dedication and contribution supporting IKEA Saudi Arabia in arranging training programs during 2017 & 2018, looking forward for more development and exciting effort this year. On behalf of IKEA Saudi Arabia, THANK YOU!Dalal Kutbi
