إكسل الخبير تعني ان لديك  المهارات اللازمة لتحقيق أقصى استفادة من برنامج Excel من خلال الكفاءة في إنشاء جداول بيانات احترافية وإدارتها وتوزيعها لمجموعة متنوعة من الأغراض في مختلف المجالات - هذه الدورة هي تجهيز لإختبار Microsoft Excel Expert (Office 2016)- و هي احد الدورات المستردة من صندوق الموارد البشرية (هدف)

 

محاور الدورة 

​

Manage workbook options and settings

Manage workbooks

Copy macros between workbooks

Reference data in other workbooks

Enable macros in a workbook

Manage workbook versions

Prepare workbooks for collaboration

Restrict editing

Protect worksheets and cell ranges

Protect workbook structure

Configure formula calculation options

Manage comments

Use and configure language options

Configure editing and display languages

Use language-specific features

Manage and format data

Fill cells based on existing data

Fill cells by using Flash Fill

Fill cells by using advanced Fill Series options

Format and validate data 

Create custom number formats

Configure data validation

Group and ungroup data

Calculate data by inserting subtotals and totals

Remove duplicate records

Apply advanced conditional formatting and filtering

Create custom conditional formatting rules

Create conditional formatting rules that use formulas

Manage conditional formatting rules

Create advanced formulas and macros

Perform logical operations in formulas

Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(),

SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(),

MINIFS(), AND(), OR(), and NOT() functions

Look up data by using functions

look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions

Use advanced date and time functions

Reference date and time by using the NOW() and TODAY() functions

Calculate dates by using the WEEKDAY() and WORKDAY() functions

Perform data analysis

Summarize data from multiple ranges by using the Consolidate feature

Perform what-if analysis by using Goal Seek and Scenario Manager

Forecast data by using the AND(), IF(), and NPER() functions

Calculate financial data by using the PMT() function

Troubleshoot formulas

Trace precedence and dependence

Monitor cells and formulas by using the Watch Window

Validate formulas by using error checking rules

Evaluate formulas

Create and modify simple macros

Record simple macros

Name simple macros

Edit simple macros

Manage advanced charts and tables

Create and modify advanced charts

Create and modify dual axis charts

Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map,

Sunburst, and Waterfall charts

Create and modify PivotTables

Create PivotTables

Modify field selections and options

Create slicers

Group PivotTable data

Add calculated fields

Format data

Create and modify PivotCharts

Create PivotCharts

Manipulate options in existing PivotCharts

Apply styles to PivotCharts

Drill down into PivotChart details

:بيانات الدورة

مدة البرنامج: 10 أيام

وقت البرنامج من 6:00 م الى م 9:00

تاريخ البرنامج:10 أكتوبر 

ساعات التدريب: 30 ساعة

مستوى الدورة: متقدم

المادة العلمية: إنجليزي مبسط

الشرح بالعربي

سعر التسجيل للدورة لوحدها 650 ريال  

جميع شهاداتنا معتمدة من المؤسسة العامة للتدريب التقني والمهني