{"id":3028,"date":"2024-03-25T09:51:13","date_gmt":"2024-03-25T09:51:13","guid":{"rendered":"https:\/\/pbi.ps\/?post_type=lp_course&p=3028"},"modified":"2024-05-07T06:02:52","modified_gmt":"2024-05-07T06:02:52","slug":"excel-intermediate-level","status":"publish","type":"lp_course","link":"https:\/\/pbi.ps\/?lp_course=excel-intermediate-level","title":{"rendered":"Excel Intermediate Level"},"content":{"rendered":"

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

 <\/p>\n

.The participants will become familiar with beginner and intermediate features of MS Office Excel to facilitate daily work<\/p>\n

Getting Started with Microsoft Excel<\/strong><\/p>\n

Excel Interface<\/strong><\/p>\n

?What are Spreadsheets, Worksheets, and Workbook<\/p>\n

?What are Columns, Rows, Cells, and Ranges<\/p>\n

The Excel Interface<\/p>\n

Navigation Options<\/p>\n

Creating a New Blank Workbook<\/p>\n

 <\/p>\n

Modifying a Worksheet<\/strong><\/p>\n

Manipulate Data<\/p>\n

The Undo and Redo Commands<\/p>\n

The AutoFill Feature<\/p>\n

AutoFill Options<\/p>\n

The Transpose Option<\/p>\n

The Clear Button<\/p>\n

Work with Comments<\/p>\n

 <\/p>\n

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

The Insert and Delete Options<\/p>\n

Column Width and Row Height Alternation Methods<\/p>\n

The Hide and Unhide Options<\/p>\n

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

The Find Command<\/p>\n

The Replace Command<\/p>\n

The Go To Command<\/p>\n

 <\/p>\n

Formatting a Worksheet<\/strong><\/p>\n

Modify Fonts<\/p>\n

Fonts<\/p>\n

The Font Group<\/p>\n

The Format Cells Dialog Box<\/p>\n

The Format Painter<\/p>\n

Preview and Formatting<\/p>\n

Add Borders and Colors to Cells<\/p>\n

Number Formats in Excel<\/p>\n

 <\/p>\n

Border Options<\/strong><\/p>\n

Fill Options<\/p>\n

Sheet Backgrounds<\/p>\n

Paste Options<\/p>\n

Align Cell Contents<\/strong><\/p>\n

Alignment Options<\/p>\n

The Indent Commands<\/p>\n

The Wrap Text Command<\/p>\n

Orientation Options<\/p>\n

The Merge & Center Options<\/p>\n

Apply Cell Styles<\/strong><\/p>\n

Cell Styles<\/p>\n

The Style Dialog Box<\/p>\n

 <\/p>\n

Performing Calculations<\/strong><\/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

Insert Functions in a Worksheet<\/strong><\/p>\n

Functions<\/p>\n

The Function Library<\/p>\n

Common Functions in Excel<\/p>\n

The Formula AutoComplete Feature<\/p>\n

Reuse Formulas<\/strong><\/p>\n

The Cut, Copy, and Paste Commands<\/p>\n

Paste Special Options<\/p>\n

Relative References<\/p>\n

Absolute References<\/p>\n

Mixed References<\/p>\n

 <\/p>\n

Basic Charts<\/strong><\/p>\n

Create a Basic Chart (Charting is covered in depth in Level 2)<\/p>\n

Select Data<\/p>\n

Chart Data<\/p>\n

Change the Chart Type<\/p>\n

Work with chart Labels<\/p>\n

 <\/p>\n

Printing Workbook Contents<\/strong><\/p>\n

Define the Basic Page Layout for a Workbook<\/p>\n

The Print Options in Backstage View<\/p>\n

The Page Setup Dialog Box<\/p>\n

The Print Preview Option<\/p>\n

Workbook Views<\/p>\n

Headers and Footers<\/p>\n

Header and Footer Settings<\/p>\n

Page Margins<\/p>\n

Margins Tab Options<\/p>\n

Page Orientation<\/p>\n

Refine the Page Layout and Apply Print Options<\/strong><\/p>\n

Zoom Options<\/p>\n

Page Breaks<\/p>\n

Page Break Options<\/p>\n

The Print Area<\/p>\n

Print Title<\/p>\n

Scaling Options<\/p>\n

 <\/p>\n

Refine the Page Layout and Apply Print Options<\/strong><\/p>\n

Format Worksheet Tabs<\/p>\n

Format Worksheet Tabs<\/p>\n

Changing Tab Color<\/p>\n

Manage Worksheets<\/p>\n

Grouped Worksheets<\/p>\n

Repositioning Worksheets<\/p>\n

Inserting or Deleting Worksheets<\/p>\n

Hiding and Unhiding Worksheets<\/p>\n

Worksheet References in Formulas<\/p>\n

 <\/p>\n

Manage the View of Worksheets and Workbooks<\/strong><\/p>\n

The Split Command<\/p>\n

The Freeze Panes Options<\/p>\n

The Arrange All Command<\/p>\n

The Arrange Windows Dialog Box<\/p>\n

The View Side by Side Command<\/p>\n

The Switch Windows Command<\/p>\n

The New Window Command<\/p>\n

 <\/p>\n

Use Functions<\/strong><\/p>\n

Function Categories<\/p>\n

The Excel Function Reference<\/p>\n

Function Syntax<\/p>\n

Function Entry Dialog Boxes<\/p>\n

Using Nested Functions<\/p>\n

Automatic Workbook Calculations<\/p>\n

Showing and Hiding Formulas<\/p>\n

Enabling Iterative Calculations<\/p>\n

Sort and Filter Data<\/strong><\/p>\n

The Difference Between Sorting and Filtering<\/p>\n

Sorting Data<\/p>\n

Advanced Filtering<\/p>\n

Filter Operators<\/p>\n

Removing Duplicate Values<\/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   20 \/ 04 \u2013 04 \/ 05 \/ 2024<\/p>\n

\u0648\u0642\u062a \u0627\u0644\u0627\u0646\u0639\u0642\u0627\u062f : <\/strong>  9:00 \u0635\u0628\u0627\u062d\u0627 \u2013 4:00 \u0639\u0635\u0631\u0627\u064b<\/p>\n

\u0645\u0643\u0627\u0646 \u0627\u0644\u0627\u0646\u0639\u0642\u0627\u062f : <\/strong> \u0648\u062c\u0627\u0647\u064a \u2013 \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 <\/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:<\/u><\/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 : \u0645. \u0645\u0641\u064a\u062f \u0633\u0645\u0627\u0631\u0629   .The participants will become familiar with beginner and intermediate features of MS Office Excel […]<\/p>\n","protected":false},"author":2,"featured_media":3029,"comment_status":"open","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"course_category":[87,140],"course_tag":[253,205],"class_list":["post-3028","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-205","course"],"_links":{"self":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/3028","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=3028"}],"version-history":[{"count":4,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/3028\/revisions"}],"predecessor-version":[{"id":3051,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/3028\/revisions\/3051"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/media\/3029"}],"wp:attachment":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3028"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_category&post=3028"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_tag&post=3028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}