Workshop on
Business Excel Mastery
Specially designed for
Entry, Junior and Mid-Level Executives.
Date: 25, 26 September, 04, 05, 11 & 12 October 2020
Media: Zoom/Google meet
Resource Person: Mr. Rashed Mamun, PMP (PMI-USA)
Business consultant and trainer
| Course Coordinator: | Concerned Executive: |
| Md. Arifur Rahman Business Promotion Officer & PS to DG Cell: +880-1911 620 529 E-mail: arifshohel.bd@gmail.com | Mrs. Afsana Akter Business Promotion Officer Cell: +880-1927 715 044 E-mail: dg@localhost |
Contact Address:
Registered Office, Dilkusha Center (Level-9), Suite No-904,
28 Dilkusha C/A, Dhaka-1000. Phone: +880-2-9559112,
Email: dg@localhost , info@bipded.org, mortuzaalimd@yahoo.com
Web: www.bipdedu.org
Introduction:
The Bangladesh Institute for Professional Development (BIPD) is an Insurance Development Regulatory Authority (IDRA) accredited institute, established in 2015. It is incorporated as a legal entity under the Companies Act. The general objective of the BIPD is to promote human capital development through conducting training, research, education and other professional activities.
Vision of BIPD:
To be a world class institute of transforming human resources into human capital and to be a leading center of excellence for professional development.
Mission of BIPD:
- To ensure continuous development of skills of human resources by deploying a dedicated team of professionals.
- To excel in sustainable leadership and management capacity for maximizing enterprise wealth.
Core Values of BIPD:
- We enhance knowledge & Skill.
- We change attitude and mindset.
- We inspire for upholding good corporate governance.
- We follow the best practices to meet organizational needs.
- We strive best to achieve our objectives.
Course Objective:
This set of courses is designed for everyone out there who wants to develop one of the most critical and fundamental digital skills- MS Excel. Almost all the jobs require you to be proficient in this ubiquitous software. Having a mastery level experience on this will give you a competitive advantage and position you way ahead of others. This is also one of the most sought-after digital skill that will help you to navigate through the uncertainties created in the market due to pandemic.
Course details:
- Build a solid understanding Microsoft Excel fundamentals
- Transition from complete beginner to advanced
- Getting proficient in IF, VLOOKUP, INDEX, MATCH
- Learn the most common Excel functions used in the Office
- Maintain large sets of Excel data in a list or table
- Create dynamic reports by mastering one of the most popular tools, Pivot Tables
Methodology:
This course will be a blend of online lecture and PowerPoint presentation along with group and open discussion. The focus would be on procedural knowledge by using the target items in communication. The approach will be communicative and interactive and will involve individual, pair and group work.
Registration:
Registration will start from September 06, 2020. The course will begin from 25 September 2020.
Who Should Attend:
This program is suitable for Entry, Junior and Mid-Level Executives from any sector. This course is also suitable for students & fresher’s.
Course fee:
We are offering a fee (net of vat & tax) for fundamental & intermediate level as per following table:
| Level | Original Price | Discount Price |
| Advanced Level | BDT 3000 | BDT 2000 |
Bank Detail as below:
| Account Holder Name: | Bangladesh Institute for Professional Development Limited |
| Bank Name and Address: | Southeast Bank Limited, Corporate Branch |
| Account Number: | 0013100000798 |
| Bkash Number: | 01944552373 |
| Rocket Number: | 015545462578 |
Last date of registration: September 23, 2020.
Early bird discount 10% if registered by 15-09-2020.
Resource Person:
Mr. Rashed Mamun, PMP (PMI-USA), consultant and trainer:
Mr Mamun is a business professional, consultant and trainer with hands-on experience of managing million dollar projects with a strong focus on ICT, education, energy and social development sector projects in near about 10 countries where he has worked with more than 150 national and international esteemed consultants. His multi-disciplinary cross-cultural experience is extended to international consulting in multiple projects alongside the valued works in project management, business process enhancement, change management etc.
Some of his key clientele are Department of Environment, National Board of Revenue, Asian Development Bank, World Bank, Agency Française de Development, USAID, Ceylon Electricity Board- Sri Lanka. He is also working as a management trainer aiming to enhance capacity of senior leaders to help them thrive in an emerging projectized economy.
He is strongly committed to embed and practically utilize global management and leadership best practices while helping individuals achieve more profound impact on the society for Professional career development.
Award and certificate:
Upon completion of the course, the participants will be awarded with certificate. Certificate giving ceremony will be followed as per new normal.
|
Level |
Course Outline |
Training Details |
|
Advanced Level |
Introduction of advanced level |
12 hrs. of Live Training
A 6-day online course. 2 hours each day
Schedule is yet to be decided
Prerequisite: Topics covered in the Fundamental level or working experience. |
|
Data validation |
||
|
Conditional Logic |
||
|
Lookup function |
||
|
Text Based Function |
||
|
Formula Auditing |
||
|
Data modelling |
||
|
Data protection |
||
|
Recording MACROS |
||
|
Advanced Lookup |
||
|
Creating professional dashboard |
||
|
Final assessment |