تفاصيل الدورة
This course is designed for experienced users of MS Excel who would like to maximise their use of the application through the use of the advanced functionality of MS Excel including advanced data analysis tools including Pivot Tables. We will cover functions such as IF & VLookup / HLookup & will look at automating tasks through the use of Macros.
Objectives
- On completion of this course participants will be proficient in the more advanced functionality of MS Excel including:
- Advanced Data Analysis – Advanced Filtering, Creating Names Ranges, Sub-Totalling feature, Database Function, Pivot Tables
- Recording Macros
- IF, Lookup and other functions
- Goal Seek & Scenario Manager
- Protecting worksheets & workbooks
نبذة عن معهد Irish Computer Society
The ICS provides its members with:
- An independent representative voice
- Independent means of keeping up-to-date
- Resources for professional development
- A network of contacts in the ICT sector
- Europe-wide professional recognition
- Guidance on professional standards.
The ICS also works to advance and promote computer literacy throughout the Irish population by:
- Providing a means for current and potential computer users to achieve certified qualifications
- Encouraging the continuous development and availability of ICT curricula, and the use of appropriate ICT throughout the education system
- Furthering Ireland's economic, educational and cultural participation in the worldwide Information Society.
Are you from Irish Computer Society ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Office ابتداءً من الآن.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Microsoft Excel 2016 Starter Study 36523 EURمدة الدورة التدريبية: 7 Hours
- Office 2010: New Features 1TRAINING20 EUR
145 EURمدة الدورة التدريبية: Upto 8 Hours
