Microsoft Excel for Capital Market Operations training centre in Bangladesh

New
Get 10% discount

Microsoft Excel for Capital Market Operations

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

Muhammad Arif-ur-Rahman
  • 18 - 30 Jul 2018 (4 sessions)

At this intensive course, you will learn to understand and ...

Accounts
Enamul Haque Sujon
  • 18 Jul - 27 Aug 2018

This advance certificate course is the combination of two ...

Accounts
Dr. Md. Abdur Rouf
  • 19 Jul - 20 Aug 2018

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

Accounts
Md. Arif Khan
  • Friday, July 20, 2018

Procurement is a logistics function and it also plays a ...

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.