Microsoft Excel for Capital Market Operations training centre in Bangladesh


Microsoft Excel for Capital Market Operations


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.


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
Linking Data
Freeze Panes

View Workbook / Worksheets:
View Multiple Workbooks & Worksheets

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

Paste to .doc:
Paste Link

Format Cell:
Numbers to Text
Leading Zeros
Add Text

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

Center on Page
Repeat Specific Row

Protect File:
Password to Open
Password to Modify

Data Filter:
Remove Duplicates

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
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
Index & Choose
Logical Functions:
IF Function, AND Function & OR Function

Data Analysis:
Goal Seek
Data Consolidate

Turn on Developer Tab
Command Button
Record a Macro

Mail Merge
Why Mail Merge
Mail Merge Process
Final Mail Merge

Related Courses

Md. Arshed Ali
  • Friday, July 1, 2022

A proper training with valid explanation can clear the ...

Accounts & Finance
Md. Arshed Ali
  • Friday, July 22, 2022

Join our training sessions from home easily by using your ...

Accounts & Finance
Mohammad Zahid Hossain
  • 22 - 23 Jul 2022 (2 Sessions)

Managers are committed to their financial and ...

Accounts & Finance
Enamul Haque Sujon
  • Friday, July 22, 2022

QuickBooks is an accounting software program used to manage ...

Accounts & Finance
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.

social link fb social link fb social link fb