Course details
This course teaches intermediate-level features and functions of Excel. Participants will learn how to work with large worksheets, use 3D formulas, apply validation rules, use Excel?s if and analysis functions.
Learning Outcomes
On successful completion of this course, participants will be able to:
- Apply calculations procedure in Excel
- Arrange workbooks to create a workspace
- Sort and Filter query data using advance tools
- Link and consolidate data
- Protect and secure worksheets and workbooks
- Use intermediate level functions i.e. (IF, Nested IF, Sum IF, Count IF, ?etc.)
- Deal with Setup & Printing issues
- Create name ranges
- Format cells
- Add, move, rename and delete worksheets
- Use special options for large worksheets
Target Audience
All Staff
Entry Requirements
MS Excel 2010 Basic 315B
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
- Microsoft PowerPoint Basics Skill-UpBHD 5Duration: Upto 2 Hours
- Functional Skills IT(8-in-1 Career Guided Bundle) NextGen LearningBHD 20Duration: Upto 20 Hours