اكسل المستوى المتقدم

المدرب:أ.مفيد سمارة

The participants will become familiar with advanced features of MS Office Excel to facilitate their work with excel.

Quick review and get start with excel

• Excel Interface
• Modifying a Worksheet
• Insert, Manipulate, and Delete Cells, Columns, and Rows
• Search For and Replace Data
• Formatting a Worksheet
• Border Options
• Align Cell Contents
• Apply Cell Styles

 

Apply Conditional Formatting

• Conditional Formatting
• Conditional Formats
• The Conditional Formatting Rules Manager Dialog Box
• The New Formatting Rule Dialog Box
• Clear Rules

 

Add Data Validation Criteria

• Data Validation
• The Data Validation Dialog Box
• Creating and using lists (dropdown list)

 

Performing Calculations

Cell Naming

• Apply Range Names
• Range Names
• Adding Range Names Using the Name Box
• Adding Range Names Using the New Name Dialog Box
• Editing a Range Name and Deleting a Range Name
• Using Range Names in Formulas

 

Create Formulas in a Worksheet

• Excel Formulas
• The Formula Bar
• Elements of an Excel Formula
• Common Mathematical Operators
• The Order of Operations
• Use Logical Functions
• Logical Functions
• Logical Operators
• The AND Function
• The OR Function
• The IF Function
• Lookup Functions

• The LOOKUP Function
• The VLOOKUP Function
• The HLOOKUP Function
• The INDEX Function
• The MATCH Function

• Use Date Functions

• Date
• time
• today
• now
• Serializing Dates and Times with Functions
• Days360
• Network days
• Workdays
• And other date functions

• Financial Functions

• PMT
• PV
• FV
• PPMT
• IPMT
• NPER

 

Analyzing Data with PivotTables, Slicers, and Pivot Charts

Create a PivotTable

• PivotTables
• Start with Questions, End with Structure
• The Create PivotTable Dialog Box
• The PivotTable Fields Pane
• Summarize Data in a PivotTable
• The “Show Values As” Functionality of a PivotTable
• External Data

 

Filter Data by Using Slicers

• Slicers
• The Insert Slicers Dialog Box
• Create and use dashboard

 

Analyze Data with Pivot Charts

• Pivot Charts
• Creating Pivot Charts
• Applying a Style to a PivotChart

 

Analyze data with data tables

Create and use data tables to analyze data with multiple values at once

• One dimension datable
• Tow dimension data tables

 

Advanced charting and graphing:

• Advanced Graphing techniques
• Creating custom charts
• Classic combination charts
• Plotting data using a secondary axis
• Custom scatter graphs
• Line and column combination graphs

 

Exporting and Importing Excel Data

Import a Delimited Text File

• The Import Process
• The Get External Data Group
• Delimited Text Files
• Methods of Importing Text Files

 

Create a Web Query

• Web Queries
• The New Web Query Dialog Box

 

Create and Edit a Macro

• Macros
• The Record Macro Dialog Box
• Naming Macros
• Visual Basic for Applications
• Copying Macros Between Workbooks
• Macro Security Settings

 

Protect and sharing workbook and worksheets

• Protecting your data
• Protect a sheet
• Protect a workbook
• Share your work with colleagues
• Protect worksheet ranges
• Encrypt excel file with password

 

عدد الساعات : 21 ساعة تدريبية .

تاريخ الانعقاد : أيام السبت الموافقة 29/6  –  6+13/07/2024

وقت الانعقاد :  09:00 – 16:00  

مكان الانعقاد :  مقر المعهد المصرفي الفلسطيني – رام الله.

الرسوم:  ( 160$) للمشارك الواحد من المؤسسات الأعضاء، و ( 180$) للمشارك الواحد من المؤسسات غير الأعضاء

 

معلومات المدرب:

أ. مفيد سمارة مدرب معتمد للحاسوب، برامج اوراكل، ميكروسوف اوفيس ICDL Trainer.