Microsoft Excel – Intermediate Level

تاريخ البداية تاريخ التهاية المكان التصنيف
2020-10-18 2020-10-29 تدريب الكتروني تكنولوجيا المعلومات

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

 

Description:

 

                Excel Intermediate level covers the basic and intermediate concepts of Microsoft excel with performing with basics of excel, working with cells, working with worksheets, Using and creating the templates, formatting the worksheets, calculating data, working with graphs. The manual is a great reference for after the class.

 

Objectives:

                At the end of the program, the trainees should be apple to:

  • Start and using Microsoft excel
  • Entering, editing and formatting data
  • Managing the worksheets
  • Entering formulas and functions to perform calculation on the data
  • Using the most recently used functions
  • Inserting shapes and pictures
  • Creating charts
  • Preparing the data for print
  • Creating & Using templates

 

Targeted Group:

                All staff

 

Prerequisite: Basic knowledge of windows operating systems

               

Contents:

  1. Basics of excel:
    • Introduction to Microsoft excel
    • Getting started with excel
    • Use help function
  2. Working with cells:
    • Cell Basics
    • Select, copy, and move cells
    • Use the office clip board
    • What is a cell reference?
    • Find and replace data
  3. Entering and editing data
    • Entering data & Labels
    • Use auto fill
    • Create and use lists
    • Sorting
    • Use number formatting
  4. Formatting:
    • Formatting cells
    • Use styles
    • Use auto format
    • Use conditional formatting
  5. Managing a worksheet:
    • View a worksheet
    • Insert, delete rows and columns
    • Resize rows and columns
    • Hide rows and columns
    • Freeze rows and columns
    • Comparing worksheets
    • Use auto filter and advanced filter
    • Modify page setup
    • Use header and footer
    • Set print aria
  1. Working with Workbook:
    • Insert, delete worksheets
    • Rename worksheets
    • Copy worksheets
    • Format worksheet taps
    • Hide/show a worksheet
  1. Calculating data:
    • What is a formula
    • Create a formula
    • Edit a formula
    • Cell reference types
    • What is a function
    • Insert and use functions
    • Enter a function manually

 

  1. Using & creating templates
  2. creating charts

 

 

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

تاريخ الانعقاد : الاحد والاثنين والاربعاء من كل اسبوع 18-29/10/2020

وقت الانعقاد :  17:30 – 20:30

مكان الانعقاد :  عبر تقنية زووم

 

الرسوم: (120$) للمشارك الواحد

 

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

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