- Duration: 4 Days
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, 2015Course Location
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- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- MS Office 2016 Word for Beginners One EducationBHD 9
BHD 173Duration: Upto 5 Hours - Certificate in Microsoft Office 2016 Essential Global EdulinkBHD 24Duration: Upto 25 Months