المدرب : م. مفيد سمارة
.The participants will become familiar with beginner and intermediate features of MS Office Excel to facilitate daily work
Getting Started with Microsoft Excel
Excel Interface
?What are Spreadsheets, Worksheets, and Workbook
?What are Columns, Rows, Cells, and Ranges
The Excel Interface
Navigation Options
Creating a New Blank Workbook
Modifying a Worksheet
Manipulate Data
The Undo and Redo Commands
The AutoFill Feature
AutoFill Options
The Transpose Option
The Clear Button
Work with Comments
Insert, Manipulate, and Delete Cells, Columns, and Rows
The Insert and Delete Options
Column Width and Row Height Alternation Methods
The Hide and Unhide Options
Search For and Replace Data
The Find Command
The Replace Command
The Go To Command
Formatting a Worksheet
Modify Fonts
Fonts
The Font Group
The Format Cells Dialog Box
The Format Painter
Preview and Formatting
Add Borders and Colors to Cells
Number Formats in Excel
Border Options
Fill Options
Sheet Backgrounds
Paste Options
Align Cell Contents
Alignment Options
The Indent Commands
The Wrap Text Command
Orientation Options
The Merge & Center Options
Apply Cell Styles
Cell Styles
The Style Dialog Box
Performing Calculations
Create Formulas in a Worksheet
Excel Formulas
The Formula Bar
Elements of an Excel Formula
Common Mathematical Operators
The Order of Operations
Insert Functions in a Worksheet
Functions
The Function Library
Common Functions in Excel
The Formula AutoComplete Feature
Reuse Formulas
The Cut, Copy, and Paste Commands
Paste Special Options
Relative References
Absolute References
Mixed References
Basic Charts
Create a Basic Chart (Charting is covered in depth in Level 2)
Select Data
Chart Data
Change the Chart Type
Work with chart Labels
Printing Workbook Contents
Define the Basic Page Layout for a Workbook
The Print Options in Backstage View
The Page Setup Dialog Box
The Print Preview Option
Workbook Views
Headers and Footers
Header and Footer Settings
Page Margins
Margins Tab Options
Page Orientation
Refine the Page Layout and Apply Print Options
Zoom Options
Page Breaks
Page Break Options
The Print Area
Print Title
Scaling Options
Refine the Page Layout and Apply Print Options
Format Worksheet Tabs
Format Worksheet Tabs
Changing Tab Color
Manage Worksheets
Grouped Worksheets
Repositioning Worksheets
Inserting or Deleting Worksheets
Hiding and Unhiding Worksheets
Worksheet References in Formulas
Manage the View of Worksheets and Workbooks
The Split Command
The Freeze Panes Options
The Arrange All Command
The Arrange Windows Dialog Box
The View Side by Side Command
The Switch Windows Command
The New Window Command
Use Functions
Function Categories
The Excel Function Reference
Function Syntax
Function Entry Dialog Boxes
Using Nested Functions
Automatic Workbook Calculations
Showing and Hiding Formulas
Enabling Iterative Calculations
Sort and Filter Data
The Difference Between Sorting and Filtering
Sorting Data
Advanced Filtering
Filter Operators
Removing Duplicate Values
عدد الساعات : 21 ساعة تدريبية .
تاريخ الانعقاد : أيام السبت 20 / 04 – 04 / 05 / 2024
وقت الانعقاد : 9:00 صباحا – 4:00 عصراً
مكان الانعقاد : وجاهي – مقر المعهد المصرفي الفلسطيني
الرسوم: (160$) للمشارك الواحد من المؤسسات الأعضاء، و (180$) للمشارك الواحد من المؤسسات غير الأعضاء.
معلومات المدرب:
أ. مفيد سمارة مدرب معتمد للحاسوب، برامج اوراكل، ميكروسوف اوفيس ICDL Trainer.
