Diplomas
Certificates
Courses

MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Call our Sales
   Clients Testimonials
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   ICDL Module 4 Spreadsheets

Admission

This course is designed for trainees who would like to be familiar with spreadsheet applications.


ICDL Module 4 Spreadsheets
Exam # Duration Language Level Type Classroom Code Fees
-- 12 Arabic/English Advanced Course Classroom Cs117 200 LE
Description :
This course requires the candidate to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she shall understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. The candidate shall be able to accomplish standard mathematical and logical operations using basic formulas and functions. The candidate shall demonstrate competence in using some of the more advanced features of a spreadsheet application such as importing objects, and creating graphs and charts.
 

 



Objectives :
  • Using Microsoft Excel as a Spreadsheet Application
  • Performing Editing and Formatting Operations
  • Handling Worksheets
  • Using Formulas and Functions
  • Using Charts and Graphs
  • Printing Spreadsheets


Topics :

Working with Spreadsheets

  • Open, close a spreadsheet application
  • Create a new spreadsheet
  • Save and Save as
  • Use available Help functions
  • Use magnification/zoom tools

Cells

  • Insert Data
  • Select Cells
  • Rows and Columns
  • Edit Data
  • Duplicate, Move and Delete
  • Search and Replace
  • Sort Data
  • Use the undo, redo command
  • Use the Auto fill tool

Managing Worksheets

  • Insert, delete rows and columns
  • Modify column widths & row heights
  • Freeze, unfreeze row and column
  • Insert & Delete Worksheets
  • Rename Worksheet
  • Move & Duplicate Worksheet

Formulas and Functions

  • Arithmetic Formulas
  • Create formulas using cell references
  • Understand standard error values associated with using formulas
  • Functions
  • Use the logical function

Formatting

  • Numbers/Dates
  • Text Formatting
  • Alignment and Border Effects

Charts

  • Create Different Types of Charts/Graphs
  • Add & Removing Titles & Labels
  • Change the Background
  • Change Chart/Graph Type
  • Resize Charts/Graphs
  • Delete Charts/Graphs

Prepare Outputs

  • Worksheet Setup
  • Check and correct
  • Preview and Printing




Recommended Knowledge :

ICDL Module 2 Using the Computer and Managing Files.

Recommended Course(s) :

ICDL Module 2 Using the Computer and Managing Files


Training Materials :

Approved ICDL Courseware


Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.


Credential :

This course prepares the attendees for the ICDL Module 4 exam.

Category :
CERTIFICATES


The Instructor:
Copyright © 2008-2012 - EnterCaps for Design and Development - All rights reserved.