{"id":4063,"date":"2025-03-09T10:56:37","date_gmt":"2025-03-09T10:56:37","guid":{"rendered":"https:\/\/pbi.ps\/?post_type=lp_course&#038;p=4063"},"modified":"2025-04-28T07:54:47","modified_gmt":"2025-04-28T07:54:47","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%a8%d8%aa%d8%af%d8%a6-%d9%88%d8%a7%d9%84%d9%85%d8%aa%d9%88%d8%b3%d8%b7","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%A8%D8%AA%D8%AF%D8%A6-%D9%88%D8%A7%D9%84%D9%85%D8%AA%D9%88%D8%B3%D8%B7","title":{"rendered":"\u0628\u0631\u0646\u0627\u0645\u062c \u0625\u0643\u0633\u0644 &#8211; \u0627\u0644\u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u0645\u0628\u062a\u062f\u0626 \u0648\u0627\u0644\u0645\u062a\u0648\u0633\u0637"},"content":{"rendered":"<p style=\"text-align: right;\"><strong>\u0627\u0644\u0645\u062f\u0631\u0628 : \u0645\u0641\u064a\u062f \u0633\u0645\u0627\u0631\u0629<\/strong><\/p>\n<p style=\"font-weight: 400; text-align: left;\"><b><strong>Introduction<\/strong><\/b><\/p>\n<p style=\"font-weight: 400; text-align: left;\">This training program aims to equip participants with the knowledge and skills necessary to use intermediate features of Microsoft Excel, enhancing their efficiency and productivity in daily tasks.<\/p>\n<p style=\"font-weight: 400; text-align: left;\"><b><strong>General Objective<\/strong><\/b><\/p>\n<p style=\"font-weight: 400; text-align: left;\">Enable participants to understand and utilize essential and advanced tools and functions in Microsoft Excel to complete tasks efficiently and accurately.<\/p>\n<p style=\"font-weight: 400; text-align: left;\"><b><strong>Detailed Objectives<\/strong><\/b><\/p>\n<ul style=\"font-weight: 400;\">\n<li style=\"direction: ltr; text-align: left;\">Understand the Excel interface and navigate its elements.<\/li>\n<li style=\"direction: ltr; text-align: left;\">Input, format, and manipulate data effectively.<\/li>\n<li style=\"direction: ltr; text-align: left;\">Use basic and advanced formulas and functions.<\/li>\n<li style=\"direction: ltr; text-align: left;\">Create charts and graphs for data analysis.<\/li>\n<li style=\"direction: ltr; text-align: left;\">Format worksheets and prepare them for printing.<\/li>\n<li style=\"direction: ltr; text-align: left;\">Use sorting and filtering tools to manage data efficiently.<\/li>\n<\/ul>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Training Plan<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Day 1: Introduction to Excel and Data Handling<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Getting Started with Microsoft Excel<\/strong><\/b><\/p>\n<ul style=\"font-weight: 400; text-align: left;\">\n<li style=\"direction: ltr;\">What are Spreadsheets, Worksheets, and Workbooks?<\/li>\n<li style=\"direction: ltr;\">Understanding the Excel Interface.<\/li>\n<li style=\"direction: ltr;\">Navigation Options.<\/li>\n<li style=\"direction: ltr;\">Creating a New Workbook.<\/li>\n<\/ul>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Modifying a Worksheet<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Entering and editing data.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">The Undo and Redo commands.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">The AutoFill feature and its options.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">The Clear button and working with comments.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Insert, Manipulate, and Delete Cells, Columns, and Rows<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Insert and delete options.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Adjusting column width and row height.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Hide and unhide options.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Search for and Replace Data<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">The Find and Replace commands.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">The Go To command.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Day 2: Data Formatting and Calculations<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Formatting a Worksheet<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Modifying fonts and colors.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">The Format Cells dialog box.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Using the Format Painter.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Adding borders and backgrounds.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Aligning Cell Contents<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Alignment options.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Indent commands and wrap text.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Orientation and merge &amp; center options.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Applying Cell Styles<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Using pre-defined styles.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">The Style dialog box.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Performing Calculations<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Creating formulas.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">The Formula Bar and elements of an Excel formula.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Common mathematical operators and the order of operations.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Inserting and Using Functions<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Introduction to Excel functions.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Function Library and common functions.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">The Formula AutoComplete feature.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Reusing Formulas<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Cut, copy, and paste commands.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Paste special options.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Relative, absolute, and mixed references.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Day 3: Charts and Printing Options<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Creating Basic Charts<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Selecting data for charts.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Changing chart types.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Working with chart labels.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Printing Workbook Contents<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Page layout settings.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Print options in Backstage view.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Advanced printing settings.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Refining Page Layout and Print Options<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Zoom options.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Page breaks and print areas.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Print titles and scaling options.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Managing Worksheets and Workbooks<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Formatting worksheet tabs.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Changing tab colors.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Managing, repositioning, inserting, and deleting worksheets.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Hiding and unhiding worksheets.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Using worksheet references in formulas.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Managing the View of Worksheets and Workbooks<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Split and freeze panes.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Arrange all and arrange windows commands.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">View side by side and switch windows options.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Creating a new window for the same workbook.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Using Advanced Functions<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Function categories.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Excel function reference and syntax.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Using nested functions.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Automatic workbook calculations.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Showing and hiding formulas.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\"><b><strong>Sorting and Filtering Data<\/strong><\/b><\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Difference between sorting and filtering.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Advanced sorting and filtering techniques.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Filter operators.<\/p>\n<p style=\"direction: ltr; font-weight: 400; text-align: left;\">Removing duplicate values.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<table style=\"height: 89px;\" width=\"804\">\n<tbody>\n<tr>\n<td width=\"92\">\u0639\u062f\u062f \u0627\u0644\u0633\u0627\u0639\u0627\u062a<\/td>\n<td width=\"156\">\u0627\u0644\u0645\u062f\u0631\u0628 \u0627\u0644\u0645\u0642\u062a\u0631\u062d<\/td>\n<td width=\"156\">\u062a\u0627\u0631\u064a\u062e \u0627\u0644\u0627\u0646\u0639\u0642\u0627\u062f<\/td>\n<td width=\"93\">\u0627\u0644\u0631\u0633\u0648\u0645 \u0644\u0644\u0627\u0639\u0636\u0627\u0621<\/td>\n<td width=\"109\">\u0627\u0644\u0631\u0633\u0648\u0645 \u0644\u063a\u064a\u0631 \u0627\u0644\u0627\u0639\u0636\u0627\u0621<\/td>\n<\/tr>\n<tr>\n<td>21<\/td>\n<td>\u0645\u0641\u064a\u062f \u0633\u0645\u0627\u0631\u0629<\/td>\n<td width=\"156\">19\/4 &#8211; 3\/5\/2025<\/td>\n<td width=\"93\">160<\/td>\n<td width=\"109\">180<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>\u0627\u0644\u0645\u062f\u0631\u0628 : \u0645\u0641\u064a\u062f \u0633\u0645\u0627\u0631\u0629 Introduction This training program aims to equip participants with the knowledge and skills necessary to use [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":4050,"comment_status":"open","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"course_category":[87,140],"course_tag":[205],"class_list":["post-4063","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\/4063","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=4063"}],"version-history":[{"count":8,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/4063\/revisions"}],"predecessor-version":[{"id":4097,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/4063\/revisions\/4097"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/media\/4050"}],"wp:attachment":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4063"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_category&post=4063"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_tag&post=4063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}