Get 20% discount

Microsoft Excel for Capital Market Operations

  • Date : 10 - 23 February 2018
  • Duration : Evening(6:30 PM-9:30 PM)
  • No. of Classes/ Sessions : 4 sessions
  • Class Schedule : Friday and Saturday
  • Total Hours : 12
  • Last Date of Registration : 9 February, 2018
  • 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

Abu Shams Mahmood Arif
  • Friday, January 26, 2018

Finance and Accounting professionals do their financial ...

Accounts
Muhammad Arif-ur-Rahman
  • 27 Jan - 9 Feb 2018

At the end of the course you will be a confident, skilful ...

Accounts
Price 20,000 Tk + VAT
Munir Uddin Ahmed
  • 27 Jan - 9 Mar 2018

SAP is known as the best ERP software available in the ...

Accounts
Enamul Haque Sujon
  • 28 Jan - 27 Feb 2018

Tally is a most powerful, yet very simple and easy, ...

Accounts

Price: Tk. 5,000+VAT

(15% VAT is applicable in every purchase.)

Contact

9140345, 9117179 , 01811 487982, 01926 673098, 01847 069208

certificate@bdjobs.com

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.