Course details

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

Updated on 08 November, 2015

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

See all Bahrain Institute for Banking & Finance courses
Are you from Bahrain Institute for Banking & Finance ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or