{"id":4238,"date":"2025-05-21T10:11:04","date_gmt":"2025-05-21T10:11:04","guid":{"rendered":"https:\/\/pbi.ps\/?post_type=lp_course&p=4238"},"modified":"2025-06-25T08:04:22","modified_gmt":"2025-06-25T08:04:22","slug":"%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d8%ac-%d8%a5%d9%83%d8%b3%d9%84-%d8%a7%d9%84%d9%85%d8%b3%d8%aa%d9%88%d9%89-%d8%a7%d9%84%d9%85%d8%aa%d9%82%d8%af%d9%85","status":"publish","type":"lp_course","link":"https:\/\/pbi.ps\/?lp_course=%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D8%AC-%D8%A5%D9%83%D8%B3%D9%84-%D8%A7%D9%84%D9%85%D8%B3%D8%AA%D9%88%D9%89-%D8%A7%D9%84%D9%85%D8%AA%D9%82%D8%AF%D9%85","title":{"rendered":"\u0628\u0631\u0646\u0627\u0645\u062c \u0625\u0643\u0633\u0644 – \u0627\u0644\u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u0645\u062a\u0642\u062f\u0645"},"content":{"rendered":"

\u0627\u0644\u0645\u062f\u0631\u0628: \u0645\u0641\u064a\u062f \u0633\u0645\u0627\u0631\u0629<\/strong><\/p>\n

Program Introduction<\/strong><\/p>\n

Microsoft Excel is one of the most essential tools used across industries for data analysis, reporting, and decision-making. This advanced-level training program is designed to empower participants with comprehensive skills in using Excel’s advanced features, enabling them to create dynamic reports, analyze complex data sets, and automate tasks efficiently and professionally.<\/p>\n

Target Audience<\/strong><\/p>\n

This program is intended for:<\/p>\n

Employees  who use Excel in their daily tasks.<\/p>\n

Data analysts, finance, and administrative staff.<\/p>\n

Individuals with a basic knowledge of Excel looking to advance to expert-level capabilities.<\/p>\n

 <\/p>\n

Program Goal<\/strong><\/p>\n

To enhance participants’ proficiency in utilizing advanced Excel features for professional data management, analysis, and reporting.<\/p>\n

General Objectives<\/strong><\/p>\n

By the end of this program, participants will be able to:<\/p>\n

Apply conditional formatting and data validation rules.<\/p>\n

Use advanced logical, financial, and date functions.<\/p>\n

Create and manipulate PivotTables, PivotCharts, and interactive dashboards with Slicers.<\/p>\n

Analyze data using data tables and advanced charting techniques.<\/p>\n

Import and export data from external sources.<\/p>\n

Record and edit macros to automate repetitive tasks.<\/p>\n

Secure workbooks and manage user permissions effectively.<\/p>\n

 <\/p>\n

Program Content :<\/strong><\/p>\n

Day 1: Advanced Data Management and Functions<\/p>\n

Quick Review: Excel interface and essentials<\/p>\n

Data formatting and cell styles<\/p>\n

Conditional formatting and rules manager<\/p>\n

Data validation and dropdown lists<\/p>\n

Named ranges and referencing<\/p>\n

Logical functions: IF, AND, OR<\/p>\n

Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH<\/p>\n

Date and time functions: TODAY, NOW, NETWORKDAYS, WORKDAYS, etc.<\/p>\n

Financial functions: PMT, PV, FV, NPER, IPMT, PPMT<\/p>\n

 <\/p>\n

Day 2: Data Analysis and Advanced Reporting<\/p>\n

Creating PivotTables and using the PivotTable Fields pane<\/p>\n

Summarizing data and using \u201cShow Values As\u201d<\/p>\n

Interactive dashboards with Slicers<\/p>\n

Creating and customizing PivotCharts<\/p>\n

Data tables for scenario analysis (one- and two-variable data tables)<\/p>\n

Advanced charting:<\/p>\n

Custom chart creation<\/p>\n

Combination charts (line + column)<\/p>\n

Secondary axis usage<\/p>\n

Scatter and mixed graphs<\/p>\n

 <\/p>\n

Day 3: Integration, Automation, and Data Protection<\/p>\n

Importing and exporting data:<\/p>\n

Delimited text files<\/p>\n

External data sources<\/p>\n

Creating web queries to pull data from the internet<\/p>\n

Macros and VBA:<\/p>\n

Recording macros<\/p>\n

Macro security settings<\/p>\n

Copying between workbooks<\/p>\n

Workbook and worksheet protection:<\/p>\n

Protecting sheets and workbooks<\/p>\n

Encrypting files with passwords<\/p>\n

Sharing workbooks and defining editable ranges<\/p>\n

 <\/p>\n

Training Methodology<\/strong><\/p>\n

Hands-on exercises using Excel<\/p>\n

Live demonstrations and walkthroughs<\/p>\n

Real-world examples and case-based discussions<\/p>\n

Training files and advanced practice scenarios<\/p>\n

 <\/p>\n

\u0639\u062f\u062f \u0633\u0627\u0639\u0627\u062a : 21\u0633\u0627\u0639\u0629<\/strong><\/p>\n

\u0645\u0643\u0627\u0646 \u0627\u0644\u0627\u0646\u0639\u0642\u0627\u062f : \u0627\u0644\u0645\u0639\u0647\u062f \u0627\u0644\u0645\u0635\u0631\u0641\u064a \u0627\u0644\u0641\u0644\u0633\u0637\u064a\u0646\u064a \u2013 \u0631\u0627\u0645 \u0627\u0644\u0644\u0647<\/strong><\/p>\n

\n
\n
\u0645\u0648\u0627\u0639\u064a\u062f \u0627\u0644\u062f\u0648\u0631\u0629 :<\/strong><\/div>\n
\n
 <\/div>\n
 <\/div>\n
\n\n\n\n\n\n\n
\u0627\u0644\u064a\u0648\u0645<\/span><\/p>\n
 <\/div>\n<\/th>\n
\u0627\u0644\u062a\u0627\u0631\u064a\u062e<\/span><\/p>\n
 <\/div>\n<\/th>\n
\u0648\u0642\u062a \u0627\u0644\u0628\u062f\u0627\u064a\u0629<\/span><\/p>\n
 <\/div>\n<\/th>\n
\u0648\u0642\u062a \u0627\u0644\u0646\u0647\u0627\u064a\u0629<\/span><\/p>\n
 <\/div>\n<\/th>\n
\u0627\u0644\u0645\u062f\u0629<\/span><\/p>\n
 <\/div>\n<\/th>\n<\/tr>\n
\u0627\u0644\u0633\u0628\u062a<\/td>\n21\/06\/2025<\/td>\n09:00<\/td>\n16:00<\/td>\n07:00<\/td>\n<\/tr>\n
\u0627\u0644\u0633\u0628\u062a<\/td>\n28\/06\/2025<\/td>\n09:00<\/td>\n16:00<\/td>\n07:00<\/td>\n<\/tr>\n
\u0627\u0644\u0633\u0628\u062a<\/td>\n05\/07\/2025<\/td>\n09:00<\/td>\n16:00<\/td>\n07:00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u0627\u0644\u0645\u062f\u0631\u0628: \u0645\u0641\u064a\u062f \u0633\u0645\u0627\u0631\u0629 Program Introduction Microsoft Excel is one of the most essential tools used across industries for data analysis, […]<\/p>\n","protected":false},"author":2,"featured_media":4239,"comment_status":"open","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"course_category":[87,140],"course_tag":[205],"class_list":["post-4238","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category---ar","course_category-all-courses-porgrams-ar","course_tag-205","course"],"_links":{"self":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/4238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4238"}],"version-history":[{"count":1,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/4238\/revisions"}],"predecessor-version":[{"id":4240,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/4238\/revisions\/4240"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/media\/4239"}],"wp:attachment":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4238"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_category&post=4238"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_tag&post=4238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}