Microsoft Excel for Capital Market Operations training centre in Bangladesh

New
EMI EASY PAY

Microsoft Excel for Capital Market Operations

  • Date : 08 - 20 May 2019
  • Duration : Evening(5 pm-8 pm)
  • No. of Classes/ Sessions : 4 Session
  • Class Schedule : Monday & Wednesday
  • Total Hours : 12
  • Last Date of Registration : 7 May, 2019
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

Introduction

Microsoft Excel is most widely used productivity tool in today’s corporate world. Day to day corporate analysis, reporting, tools and applications are prepared with Excel. Capital Market industry requires the highest level of Microsoft Excel proficiency. Various departments like Finance & Accounts, Portfolio Operations, Credit Administration, Research & Analysis, Compliance, Admin & HR, IT & Settlement and Sales & Marketing etc. demand good command on Excel. It will be an advantage for course attendees to learn practical and advanced usages of Excel for their daily activities. Excel allows us to accomplish a task in multiple ways which will be shown to attendees with Pros and Cons of the methods.

Methodology

Practical examples, exercises & case studies with Q&A discussion sessions. The course is designed for practical Excel applications at participants“ works rather than theoretical notes. Presentation slides will be provided after course usage. Participants will go through with relevant examples that they can relate to their daily office works.

Contents of Training:

Various Parts of the XL Window
New Line in a Cell
Merge Cell, Wrap Text
Text Alignment
Format Painter
Hide Gridlines
Hyperlink
Linking Data
Freeze Panes

View Workbook / Worksheets:
View Multiple Workbooks & Worksheets
Workspace

Paste Special:
Skip Blanks
Transpose
Add or Subtract
Copy Visible Cells Only

Paste to .doc:
Embed
Paste Link

Format Cell:
Numbers to Text
Leading Zeros
Add Text

Import Data from Other Source:
From Access
From Web
From Text File

Print:
Center on Page
Repeat Specific Row

Protect File:
Password to Open
Password to Modify

Data Filter:
Filtering
Remove Duplicates
Subtotal

Redistricted Entry:
Data Validation
Prevent Duplicate Entries
Drop-Down List
Dependent Drop-Down List

Pivot Table & Chart: Pivot Table
Pivot Chart

Conditional Formatting:
Highlight Cells Rules
Top/Bottom Rules
Data Bars
Color Scales
Icon Sets
Find Duplicates

Round Functions:
Round, RoundUp & RoundDown
MRound
Even & Odd

Count and Sum Functions:
Count, Countif & Countifs
Sum, Sumif & Sumifs
Count Logical Values
Count Blank/Nonblank Cells

Text Functions:
Join Strings
Partial Strings ( Left , Right , Mid )
Text to Columns
Lower/Upper Case

Lookup Functions: VLookup & HLookup
Match
Index & Choose
Logical Functions:
IF Function, AND Function & OR Function

Data Analysis:
Goal Seek
Data Consolidate

Macro:
Turn on Developer Tab
Command Button
Record a Macro

Mail Merge
Why Mail Merge
Mail Merge Process
Final Mail Merge

Related Courses

Md. Delwar Hossain Bhuiyan
  • 22 - 23 Mar 2019 (2 Days Long)

Practical knowledge in dealing Foreign exchange, ...

Accounts
Price 4,000 Tk + VAT
Md. Jehad Uddin
  • Friday, March 22, 2019

This Whole day Class will help you to prepare Income Tax ...

Accounts
Dr. Md. Abdur Rouf
  • Saturday, March 23, 2019

The purpose of this program is to provide the participants ...

Accounts
Course at Chattogram
Price 2,000 Tk + VAT
Md. Arif Khan
  • Saturday, March 23, 2019

Inventory, Transportation, Warehousing, Packaging and ...

Accounts
People who worked in Capital Market operations related organizations like Merchant Banks, Brokerage Houses, Asset Management Companies etc and people who aspire to pursue their career in related areas are encouraged.

Resource Person

Syed Saniat Ahmmad

Mr. Syed Saniat Ahmmad has been working in the Department of Credit Administration & Compliance as an Assistant Manager in a leading Investment Bank which is a full-fledged merchant bank and a subsidiary of a leading NBFI for 7 years. Before starting his career at NBIF he had work in a local group as an Officer - Admin & HR for about 3 years. His extensive work experience are in Credit Administration, Compliance, Operations, Administration, HR, Customer Services etc.

Before starting his career he has completed his Honors & Master’s degree in Management and MBA in Finance from East-West University.

In addition, Mr. Saniat does provide professional training on Capital Market Compliance, Financial Modeling, Dashboard Reporting, MS Word, MS Excel, MS PowerPoint, MS Outlook, Macros etc in corporate industry for increasing professionals required skills up to advanced level.

Last but not the least Mr. Saniat has gained adequate knowledge & skills by attending many trainings and workshops on Credit Risk Management (CRM), Credit Management & Debt Collection Strategies, Compliance & Associated Issues, Securities Laws of Bangladesh, Anti Money Laundering (AML), Effective Business Communication, Personal Excellence, Management Information System (MIS) etc.

Practical examples, exercises & case studies with Q&A discussion sessions. The course is designed for practical Excel applications at participants“ works rather than theoretical notes. Presentation slides will be provided after course usage. Participants will go through with relevant examples that they can relate to their daily office works.