{"id":3191,"date":"2024-05-22T08:38:04","date_gmt":"2024-05-22T08:38:04","guid":{"rendered":"https:\/\/pbi.ps\/?post_type=lp_course&#038;p=3191"},"modified":"2024-07-24T10:49:45","modified_gmt":"2024-07-24T10:49:45","slug":"%d8%a7%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%A7%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":"\u0627\u0643\u0633\u0644 \u0627\u0644\u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u0645\u062a\u0642\u062f\u0645"},"content":{"rendered":"<p dir=\"RTL\" style=\"text-align: right;\"><strong>\u0627\u0644\u0645\u062f\u0631\u0628:\u0623.\u0645\u0641\u064a\u062f \u0633\u0645\u0627\u0631\u0629<\/strong><\/p>\n<p>The participants will become familiar with advanced features of MS Office Excel to facilitate their work with excel.<\/p>\n<p><strong>Quick review and get start with excel<\/strong><\/p>\n<ul>\n<li>Excel Interface<\/li>\n<li>Modifying a Worksheet<\/li>\n<li>Insert, Manipulate, and Delete Cells, Columns, and Rows<\/li>\n<li>Search For and Replace Data<\/li>\n<li>Formatting a Worksheet<\/li>\n<li>Border Options<\/li>\n<li>Align Cell Contents<\/li>\n<li>Apply Cell Styles<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Apply Conditional Formatting<\/strong><\/p>\n<ul>\n<li>Conditional Formatting<\/li>\n<li>Conditional Formats<\/li>\n<li>The Conditional Formatting Rules Manager Dialog Box<\/li>\n<li>The New Formatting Rule Dialog Box<\/li>\n<li>Clear Rules<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Add Data Validation Criteria<\/strong><\/p>\n<ul>\n<li>Data Validation<\/li>\n<li>The Data Validation Dialog Box<\/li>\n<li>Creating and using lists (dropdown list)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Performing Calculations<\/strong><\/p>\n<p><strong>Cell Naming<\/strong><\/p>\n<ul>\n<li>Apply Range Names<\/li>\n<li>Range Names<\/li>\n<li>Adding Range Names Using the Name Box<\/li>\n<li>Adding Range Names Using the New Name Dialog Box<\/li>\n<li>Editing a Range Name and Deleting a Range Name<\/li>\n<li>Using Range Names in Formulas<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Create Formulas in a Worksheet<\/strong><\/p>\n<ul>\n<li>Excel Formulas<\/li>\n<li>The Formula Bar<\/li>\n<li>Elements of an Excel Formula<\/li>\n<li>Common Mathematical Operators<\/li>\n<li>The Order of Operations<\/li>\n<li>Use Logical Functions<\/li>\n<li>Logical Functions<\/li>\n<li>Logical Operators<\/li>\n<li>The AND Function<\/li>\n<li>The OR Function<\/li>\n<li>The IF Function<\/li>\n<li>Lookup Functions<\/li>\n<\/ul>\n<ul>\n<li>The LOOKUP Function<\/li>\n<li>The VLOOKUP Function<\/li>\n<li>The HLOOKUP Function<\/li>\n<li>The INDEX Function<\/li>\n<li>The MATCH Function<\/li>\n<\/ul>\n<ul>\n<li>Use Date Functions<\/li>\n<\/ul>\n<ul>\n<li>Date<\/li>\n<li>time<\/li>\n<li>today<\/li>\n<li>now<\/li>\n<li>Serializing Dates and Times with Functions<\/li>\n<li>Days360<\/li>\n<li>Network days<\/li>\n<li>Workdays<\/li>\n<li>And other date functions<\/li>\n<\/ul>\n<ul>\n<li>Financial Functions<\/li>\n<\/ul>\n<ul>\n<li>PMT<\/li>\n<li>PV<\/li>\n<li>FV<\/li>\n<li>PPMT<\/li>\n<li>IPMT<\/li>\n<li>NPER<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Analyzing Data with PivotTables, Slicers, and Pivot Charts<\/strong><\/p>\n<p><strong>Create a PivotTable<\/strong><\/p>\n<ul>\n<li>PivotTables<\/li>\n<li>Start with Questions, End with Structure<\/li>\n<li>The Create PivotTable Dialog Box<\/li>\n<li>The PivotTable Fields Pane<\/li>\n<li>Summarize Data in a PivotTable<\/li>\n<li>The \u201cShow Values As\u201d Functionality of a PivotTable<\/li>\n<li>External Data<\/li>\n<\/ul>\n<p><strong>&nbsp;<\/strong><\/p>\n<p><strong>Filter Data by Using Slicers<\/strong><\/p>\n<ul>\n<li>Slicers<\/li>\n<li>The Insert Slicers Dialog Box<\/li>\n<li>Create and use dashboard<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Analyze Data with Pivot Charts<\/strong><\/p>\n<ul>\n<li>Pivot Charts<\/li>\n<li>Creating Pivot Charts<\/li>\n<li>Applying a Style to a PivotChart<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Analyze data with data tables<\/strong><\/p>\n<p>Create and use data tables to analyze data with multiple values at once<\/p>\n<ul>\n<li>One dimension datable<\/li>\n<li>Tow dimension data tables<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Advanced charting and graphing:<\/strong><\/p>\n<ul>\n<li>Advanced Graphing techniques<\/li>\n<li>Creating custom charts<\/li>\n<li>Classic combination charts<\/li>\n<li>Plotting data using a secondary axis<\/li>\n<li>Custom scatter graphs<\/li>\n<li>Line and column combination graphs<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Exporting and Importing Excel Data<\/strong><\/p>\n<p><strong>Import a Delimited Text File<\/strong><\/p>\n<ul>\n<li>The Import Process<\/li>\n<li>The Get External Data Group<\/li>\n<li>Delimited Text Files<\/li>\n<li>Methods of Importing Text Files<\/li>\n<\/ul>\n<p><strong>&nbsp;<\/strong><\/p>\n<p><strong>Create a Web Query<\/strong><\/p>\n<ul>\n<li>Web Queries<\/li>\n<li>The New Web Query Dialog Box<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Create and Edit a Macro<\/strong><\/p>\n<ul>\n<li>Macros<\/li>\n<li>The Record Macro Dialog Box<\/li>\n<li>Naming Macros<\/li>\n<li>Visual Basic for Applications<\/li>\n<li>Copying Macros Between Workbooks<\/li>\n<li>Macro Security Settings<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Protect and sharing workbook and worksheets<\/strong><\/p>\n<ul>\n<li>Protecting your data<\/li>\n<li>Protect a sheet<\/li>\n<li>Protect a workbook<\/li>\n<li>Share your work with colleagues<\/li>\n<li>Protect worksheet ranges<\/li>\n<li>Encrypt excel file with password<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>\u0639\u062f\u062f \u0627\u0644\u0633\u0627\u0639\u0627\u062a : 21<\/strong> \u0633\u0627\u0639\u0629 \u062a\u062f\u0631\u064a\u0628\u064a\u0629 .<\/p>\n<p><strong>\u062a\u0627\u0631\u064a\u062e \u0627\u0644\u0627\u0646\u0639\u0642\u0627\u062f :<\/strong> \u0623\u064a\u0627\u0645 \u0627\u0644\u0633\u0628\u062a \u0627\u0644\u0645\u0648\u0627\u0641\u0642\u0629 29\/6&nbsp; &#8211;&nbsp; 6+13\/07\/2024<\/p>\n<p><strong>\u0648\u0642\u062a \u0627\u0644\u0627\u0646\u0639\u0642\u0627\u062f :<\/strong>&nbsp; 09:00 \u2013 16:00 &nbsp;<\/p>\n<p><strong>\u0645\u0643\u0627\u0646 \u0627\u0644\u0627\u0646\u0639\u0642\u0627\u062f : <\/strong>&nbsp;\u0645\u0642\u0631 \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.<\/p>\n<p><strong>\u0627\u0644\u0631\u0633\u0648\u0645:&nbsp; <\/strong>( 160$) \u0644\u0644\u0645\u0634\u0627\u0631\u0643 \u0627\u0644\u0648\u0627\u062d\u062f \u0645\u0646 \u0627\u0644\u0645\u0624\u0633\u0633\u0627\u062a \u0627\u0644\u0623\u0639\u0636\u0627\u0621\u060c \u0648 ( 180$) \u0644\u0644\u0645\u0634\u0627\u0631\u0643 \u0627\u0644\u0648\u0627\u062d\u062f \u0645\u0646 \u0627\u0644\u0645\u0624\u0633\u0633\u0627\u062a \u063a\u064a\u0631 \u0627\u0644\u0623\u0639\u0636\u0627\u0621<\/p>\n<p>&nbsp;<\/p>\n<p><strong><u>\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u0644\u0645\u062f\u0631\u0628:<\/u><\/strong><\/p>\n<p><strong>\u0623<\/strong><strong>. \u0645\u0641\u064a\u062f \u0633\u0645\u0627\u0631\u0629<\/strong> \u0645\u062f\u0631\u0628 \u0645\u0639\u062a\u0645\u062f \u0644\u0644\u062d\u0627\u0633\u0648\u0628\u060c \u0628\u0631\u0627\u0645\u062c \u0627\u0648\u0631\u0627\u0643\u0644\u060c \u0645\u064a\u0643\u0631\u0648\u0633\u0648\u0641 \u0627\u0648\u0641\u064a\u0633 ICDL Trainer.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0627\u0644\u0645\u062f\u0631\u0628:\u0623.\u0645\u0641\u064a\u062f \u0633\u0645\u0627\u0631\u0629 The participants will become familiar with advanced features of MS Office Excel to facilitate their work with excel. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":3192,"comment_status":"open","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"course_category":[87,140],"course_tag":[265],"class_list":["post-3191","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category---ar","course_category-all-courses-porgrams-ar","course_tag-265","course"],"_links":{"self":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/3191","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=3191"}],"version-history":[{"count":1,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/3191\/revisions"}],"predecessor-version":[{"id":3193,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/3191\/revisions\/3193"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/media\/3192"}],"wp:attachment":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3191"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_category&post=3191"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_tag&post=3191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}