المدرب:أ.مفيد سمارة
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 ساعة تدريبية .
تاريخ الانعقاد : أيام السبت الموافقة 20+27-07-2024 + 03-08-2024
وقت الانعقاد : 09:00 – 16:00
مكان الانعقاد : مقر المعهد المصرفي الفلسطيني – رام الله.
الرسوم: ( 160$) للمشارك الواحد من المؤسسات الأعضاء، و ( 180$) للمشارك الواحد من المؤسسات غير الأعضاء
معلومات المدرب:
أ. مفيد سمارة مدرب معتمد للحاسوب، برامج اوراكل، ميكروسوف اوفيس ICDL Trainer.
