MS Excel 2007 (Level 2 – Advanced) هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel’s uses cover a wide gamut – from simple data entry to complicated financial models and analysis.

This course adds on to the participants’ knowledge of Microsoft Excel. Formulae form an integral part of the course and participants will learn how to use complex functions to model their data and to generate a variety of answers and reports.

Key Benefits

• Learn how to build a pivot table and learn about the uses of a pivot table
• Learn how to do data analysis using Excel

Course Content

• Working with Ranges
• Advanced Functions
• Data Validation
• Database/List Operations
• Data Consolidation
• Pivot Tables
• Data Anaysis
• Auditing Worksheets
• Collaborating

Learning Methodology

Participants will benefit from the hands-on practical sessions during the course.

Who Should Attend

Those who are seeking to further their knowledge of Excel would benefit from this course. Those who need to create spreadsheet models and data analysis are especially encouraged to attend.

A good foundation in Excel is essential for this course. Participants should be familiar with the program and be able to write basic formulae. Having attended an essentials course is advantageous.