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

This course covers advanced level features and functions of Excel. Participants will learn how to create nested functions, export/import data, perform what-if analyses, use the Goal Seek and Solver utilities, record and run macros, and use Share Point services.

Learning Outcomes

On successful completion of this course, participants will be able to:

  • Apply advanced functions i.e. Sumifs, Lookups?etc.
  • Create one-input or two-input data tables and What IF tables
  • Add different scenarios using What IF analysis functions
  • Setup pivot tables and view different results
  • Apply auditing features to trace, identify dependent cells and cells with missing dependents
  • Record and run Macros for effective work performance
  • Secure data and deal with various issues related to data security

Target Audience

All Staff

Entry Requirements

MS Excel 2010 - Intermediate 315I

تحديث بتاريخ 08 November, 2015

نبذة عن معهد Bahrain Institute for Banking & Finance

We_They plays a vital role in the training and development of human capital in the Kingdom of Bahrain. Our commitment to excellence has strengthened our position as the top provider of quality education across all major business disciplines. We serve as a partner to numerous world-class institutions; delivering thought leadership, research and advisory, assessment and training in the areas of Accounting and Finance, Academic, Executive Development, Banking, Leadership and Management, Insurance, Islamic Finance and Information Technology; resulting in a complete business solution.

We_They covers a wide spectrum of subject matter, with over 300 different courses offered to the financial and corporate market; tailor-made training solutions based on organisational requirements; specialised programmes taught by leading market specialists; and professional qualifications and degree programmes in partnership with major international organisations.

We_They continues to exceed global benchmarks for many of the qualifications it offers with its affiliates.

Since its inception in 1981, We_They has grown from training 450 applicants a year primarily within the banking industry, to 20,000 drawing participants from all sectors of the economy, and are proud to have qualified over 200,000 learners in the last 3 decades.

Our faculty comprise of market practitioners, academics and qualified senior industry professionals. Their perse backgrounds ensure an enriched participant experience, striking the perfect balance between theory and practice.

We_They has made its mark internationally with clients in Asia, Africa, Europe, USA and the Middle East, well on its way to becoming the global institute of choice.

عرض الجميع دورات Bahrain Institute for Banking & Finance
Are you from Bahrain Institute for Banking & Finance ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Office ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

قيِم هذه الصفحة

لم تجد ما كنت تبحث عنه؟

أو