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.....


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 ...


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)...


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. ...

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

  • Category: Adobe
    Date: 2012-11-12

  • Category: Adobe
    Date: 2012-11-12

  • Category: Entercaps Traning Center
    Date: 2012-11-11
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
  • Pro .NET Best Practices
    Pro .NET Best Practices
  • Hardening Cisco Routers
    Hardening Cisco Routers
   Mastering Excel 2010


This Package designed for trainees who would like to master Microsoft Excel 2010 basic Features

Mastering Excel 2010
     Professional Group
  Excel 2010 Core   21
  Excel 2010 Advanced   21
Exam # Duration Language Level Type Classroom Code Fees
Excel 2010 Applications 66 Arabic/English Mastering Diploma Classroom Cs286 590 LE
Description :

In this Package, trainees will learn basic features of Microsoft Excel 2010. Trainees will have a systematic guidance through the development of spreadsheets and will learn how to use & create formulas, functions & charts that can help them to calculate & analyze their numeric data, in general, the Package stresses on providing basic understanding of spreadsheet building, and also will learn advanced features of Microsoft Excel 2007. Trainees will have a systematic guidance through the development of spreadsheets and will learn how to use & create Templates, use conditional formatting, functions & pivot charts that can help them to calculate & analyze their numeric data. Trainees will also be able to use MACROS and apply security on spreadsheets in general.

Objectives :
  • Opening & Saving Excel files
  • Edit & format data & sheets
  • Create & Format Tables
  • Use Formulas & Functions
  • Create & Modify Charts in Excel.
  • Adjust Printing settings from Excel.
  • Customize Excel sheet Interface according to his needs.
  • Insert Objects, Photos, and Forms in workbooks.
  • Exchange spreadsheets through E-mail.
  • Import and Export Data between Excel & other office applications.
  • Summarize data using Group  and Outline feature.
  • Summarize Data using PivotTable and PivotChart.
  • Perform various data analysis techniques using Scenario, Data Table, Goal Seek & Solver.
  • Use Lookup & Reference functions effectively to search data.
  • Apply conditional functions on numerical values.
  • Evaluate different types of formulas errors.
  • Apply security and protection concepts on spreadsheets.
  • Protect workbooks using Digital Signature.
  • Share workbooks with workgroups.
  • Record macros modules & assign security level to them.
  • Explain the basic concepts of Visual Basic Editor.

Topics :

Recommended Knowledge :

Microsoft Windows 7 or later versions

Recommended Course(s) :

Windows 7 Core

Training Materials :

EnterCaps Official Courseware

Labs :

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

Credential :

This package is a credit towards Microsoft Office Specialist (MOS)

Category :

The Instructor: