• الطلاب.
• الخريجون.
• الموظفين.
• المديرون و أصحاب العمل.

.Starting Excel
.Understanding the Display Screen
.Working with the Ribbon
.Working with the Quick Access Toolbar
.Exploring Backstage View
.Opening a Workbook
.Managing Open Workbooks
.Using Excel Help

.Saving a Workbook
.Editing Cell Contents
.Clearing Cell Contents
.Working with Undo and Redo
.Closing a Workbook
.Creating a New Workbook
.Entering Constant Values

.Entering Formulas
.Using the SUM Function
.Summing Columns or Rows Automatically
.Using General Statistical Functions
.Working with the Range Finder
.Using Formula Error Checking

.Copying and Pasting Constant Values and Formulas
.Moving and Pasting Constant Values and Formulas
.Using Collect and Paste
.Using AutoFill

.Formatting Numbers
.Changing the Font Format
.Aligning Cell Contents
.Merging Cells
.Adding Borders
.Applying Cell Styles

.Changing Column Width and Row Height
.Using AutoFit
.Inserting and Deleting Columns or Rows
.Hiding Columns or Rows
.Using Custom Worksheet Views

.Polymorphism

.Viewing, Renaming, and Color-coding Worksheets
.Editing a Group
.Manipulating Worksheets
.Creating Linked Formulas

.Applying Conditional Formatting
.Using Data Validation
.Creating and Using Custom Formats

.Using Absolute Cell References
.Creating and Using Named Ranges
.Creating a Relative Named Range
.Using Custom Zoom
.Using Functions
.Working with Insert Function
.Using Financial Functions
.Using Date Functions

.Creating a Table
.Sorting a Table
.Filtering a Table
.Working with the Total Row
.Creating a Calculated Column
.Formatting a Table

.Working with Cell Styles
.Merging Styles
.Using Templates
.Creating Templates

.Protecting Workbooks and Worksheets
.Protecting a Workbook
.Protecting a Worksheet
.Allowing Users to Edit Ranges
.Working with Shared Workbooks
.Configuring a Workbook for Shared Use
.Highlighting Tracked Changes
.Reviewing Shared Workbook Changes

.Creating Charts
.Changing the Chart Location and Size
.Changing the Chart Type
.Modifying Chart Elements
.Formatting Chart Elements
.Adding and Removing Data Series
.Printing Charts
.Creating a Sparkline

أون لاين.

PM 10:30-8:30   بتوقيت مكة المكرمة.

السبت، الإثنين،.

  ساعة تدريبية 12 – 14

May Course Start 02-05 2020

June Course Start 06-06-202

 July Course Start 04-07-2020