Excel Part 3 - Advanced Excel

Excel المتقدّم خلال يوم واحد. تدير أوراق العمل والمصنّفات المتعددة، وتتعاون وتحمي الملفات، وتؤتمت بوحدات الماكرو، وتتقن دوال البحث، وتستخدم أدوات التنبّؤ.

يوم واحدمتقدّم7 وحدات

سجّل أو استفسر ←اسأل عبر واتساب

نظرة عامة

ما ستتعلّمه

المحتوى التقني أدناه معروضٌ باللغة الإنجليزية كما ورد في منهاج الدورة، حفاظاً على دقّة المصطلحات.

Work with multiple worksheets and workbooks.
Share and protect workbooks to ensure secure collaboration.
Automate workbook functionality with macros and advanced tools.
Use Lookup functions and perform formula auditing to troubleshoot and enhance spreadsheets.
Forecast and analyze data trends.
Create Sparklines and map data for dynamic, visual reporting.

المنهاج

7 وحدات

Create links between workbooks and use external references
Work with 3-D references across worksheets
Combine and consolidate data from multiple sources

Co-author workbooks and manage collaboration features
Protect worksheet content and control access permissions

Set up data validation rules to control user input
Find and fix invalid data and formula errors
Automate repetitive actions with recorded macros

Use advanced Lookup functions to retrieve data
Trace cell relationships and troubleshoot formulas
Monitor calculations with the Watch Window and Evaluate Formulas

Explore scenarios for strategic decision-making
Apply the Goal Seek tool to backtrack solutions
Build simple forecasts based on historical data

Summarize trends with Sparklines inside cells

What Is Microsoft Copilot Chat?
The Magic Prompt Formula
Work Smarter with AI

لمن هذه الدورة

مستخدمو Excel المتمرّسون الذين يريدون الأتمتة وتدقيق الصيغ والتنبّؤ.

قبل أن تبدأ

Students should have completed Microsoft Excel - Part 1 (Introduction) and Microsoft Excel - Part 2 (Intermediate) , or have equivalent knowledge and experience. You should be comfortable entering and formatting data, creating basic formulas, using functions like SUM and IF, and working with simple PivotTables and charts.