{"id":3249,"date":"2024-06-27T08:01:43","date_gmt":"2024-06-27T08:01:43","guid":{"rendered":"https:\/\/pbi.ps\/?post_type=lp_course&p=3249"},"modified":"2024-07-24T10:48:35","modified_gmt":"2024-07-24T10:48:35","slug":"excel-advanced-level","status":"publish","type":"lp_course","link":"https:\/\/pbi.ps\/?lp_course=excel-advanced-level","title":{"rendered":"Excel Advanced Level"},"content":{"rendered":"

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

The participants will become familiar with advanced features of MS Office Excel to facilitate their work with excel<\/p>\n

 <\/p>\n

Quick review and get start with excel<\/strong><\/p>\n

Excel Interface<\/p>\n

Modifying a Worksheet<\/p>\n

Insert, Manipulate, and Delete Cells, Columns, and Rows<\/p>\n

Search For and Replace Data<\/p>\n

Formatting a Worksheet<\/p>\n

Border Options<\/p>\n

Align Cell Contents<\/p>\n

Apply Cell Styles<\/p>\n

 <\/p>\n

Apply Conditional Formatting<\/strong><\/p>\n

Conditional Formatting<\/p>\n

Conditional Formats<\/p>\n

The Conditional Formatting Rules Manager Dialog Box<\/p>\n

The New Formatting Rule Dialog Box<\/p>\n

Clear Rules<\/p>\n

 <\/p>\n

Add Data Validation Criteria<\/strong><\/p>\n

Data Validation<\/p>\n

The Data Validation Dialog Box<\/p>\n

Creating and using lists (dropdown list)<\/p>\n

 <\/p>\n

Performing Calculations<\/strong><\/p>\n

Cell Naming<\/strong><\/p>\n

Apply Range Names<\/p>\n

Range Names<\/p>\n

Adding Range Names Using the Name Box<\/p>\n

Adding Range Names Using the New Name Dialog Box<\/p>\n

Editing a Range Name and Deleting a Range Name<\/p>\n

Using Range Names in Formulas<\/p>\n

 <\/p>\n

Create Formulas in a Worksheet<\/strong><\/p>\n

Excel Formulas<\/p>\n

The Formula Bar<\/p>\n

Elements of an Excel Formula<\/p>\n

Common Mathematical Operators<\/p>\n

The Order of Operations<\/p>\n

Use Logical Functions<\/p>\n

Logical Functions<\/p>\n

Logical Operators<\/p>\n

The AND Function<\/p>\n

The OR Function<\/p>\n

The IF Function<\/p>\n

Lookup Functions<\/p>\n

The LOOKUP Function<\/p>\n

The VLOOKUP Function<\/p>\n

The HLOOKUP Function<\/p>\n

The INDEX Function<\/p>\n

The MATCH Function<\/p>\n

Use Date Functions<\/p>\n

Date<\/p>\n

time<\/p>\n

today<\/p>\n

now<\/p>\n

Serializing Dates and Times with Functions<\/p>\n

Days360<\/p>\n

Network days<\/p>\n

Workdays<\/p>\n

And other date functions<\/p>\n

Financial Functions<\/p>\n

PMT<\/p>\n

PV<\/p>\n

FV<\/p>\n

PPMT<\/p>\n

IPMT<\/p>\n

NPER<\/p>\n

 <\/p>\n

Analyzing Data with PivotTables, Slicers, and Pivot Charts<\/strong><\/p>\n

Create a PivotTable<\/strong><\/p>\n

PivotTables<\/p>\n

Start with Questions, End with Structure<\/p>\n

The Create PivotTable Dialog Box<\/p>\n

The PivotTable Fields Pane<\/p>\n

Summarize Data in a PivotTable<\/p>\n

The \u201cShow Values As\u201d Functionality of a PivotTable<\/p>\n

External Data<\/p>\n

 <\/strong><\/p>\n

Filter Data by Using Slicers<\/strong><\/p>\n

Slicers<\/p>\n

The Insert Slicers Dialog Box<\/p>\n

Create and use dashboard<\/p>\n

 <\/p>\n

Analyze Data with Pivot Charts<\/strong><\/p>\n

Pivot Charts<\/p>\n

Creating Pivot Charts<\/p>\n

Applying a Style to a PivotChart<\/p>\n

 <\/p>\n

Analyze data with data tables<\/strong><\/p>\n

Create and use data tables to analyze data with multiple values at once<\/p>\n

One dimension datable<\/p>\n

Tow dimension data tables<\/p>\n

 <\/p>\n

Advanced charting and graphing:<\/strong><\/p>\n

Advanced Graphing techniques<\/p>\n

Creating custom charts<\/p>\n

Classic combination charts<\/p>\n

Plotting data using a secondary axis<\/p>\n

Custom scatter graphs<\/p>\n

Line and column combination graphs<\/p>\n

 <\/p>\n

Exporting and Importing Excel Data<\/strong><\/p>\n

Import a Delimited Text File<\/strong><\/p>\n

The Import Process<\/p>\n

The Get External Data Group<\/p>\n

Delimited Text Files<\/p>\n

Methods of Importing Text Files<\/p>\n

 <\/strong><\/p>\n

Create a Web Query<\/strong><\/p>\n

Web Queries<\/p>\n

The New Web Query Dialog Box<\/p>\n

 <\/p>\n

Create and Edit a Macro<\/strong><\/p>\n

Macros<\/p>\n

The Record Macro Dialog Box<\/p>\n

Naming Macros<\/p>\n

Visual Basic for Applications<\/p>\n

Copying Macros Between Workbooks<\/p>\n

Macro Security Settings<\/p>\n

 <\/p>\n

Protect and sharing workbook and worksheets<\/strong><\/p>\n

Protecting your data<\/p>\n

Protect a sheet<\/p>\n

Protect a workbook<\/p>\n

Share your work with colleagues<\/p>\n

Protect worksheet ranges<\/p>\n

Encrypt excel file with password<\/p>\n

 <\/p>\n

\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

\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 20+27-07-2024 + 03-08-2024<\/p>\n

\u0648\u0642\u062a \u0627\u0644\u0627\u0646\u0639\u0642\u0627\u062f :<\/strong>  09:00 \u2013 16:00  <\/p>\n

\u0645\u0643\u0627\u0646 \u0627\u0644\u0627\u0646\u0639\u0642\u0627\u062f : <\/strong> \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

\u0627\u0644\u0631\u0633\u0648\u0645:  <\/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>\n

\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u0644\u0645\u062f\u0631\u0628:<\/strong><\/p>\n

\u0623<\/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":"

\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 […]<\/p>\n","protected":false},"author":2,"featured_media":3250,"comment_status":"open","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"course_category":[87,140],"course_tag":[253,265],"class_list":["post-3249","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category---ar","course_category-all-courses-porgrams-ar","course_tag-excel","course_tag-265","course"],"_links":{"self":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/3249","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=3249"}],"version-history":[{"count":3,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/3249\/revisions"}],"predecessor-version":[{"id":3253,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/3249\/revisions\/3253"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/media\/3250"}],"wp:attachment":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3249"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_category&post=3249"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_tag&post=3249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}